ASP.NET , CSHARP Code, Examples samples and tutorials

Export DataSet to XML File

2011-12-06T00:57:00.000-08:00

create xml file from a dataset
This code snippet show how to export DataSet to xml file.Here we have taken data from database and fill dataset.We have taken a aspx page and a button there,after clicking the button a xml file will be created at specified location.

 public void CreateXml()  
   {  
     DataSet ds = new DataSet();  
     SqlDataAdapter da = new SqlDataAdapter("usp_GetAddressDetails",con);  
     da.Fill(ds);  
     if (ds.Tables[0].Rows.Count > 0)  
     {  
       GridView1.DataSource = ds;  
       GridView1.DataBind();  
     }  
     StreamWriter objStreamWriter = new StreamWriter("E:\\Santosh\\Practices\\ASP\\XMLFiles\\EmpAddress.xml", false);  
     ds.WriteXml(objStreamWriter);  
     objStreamWriter.Close();  
   }  
   protected void Button1_Click(object sender, EventArgs e)  
   {  
     CreateXml();  
   }

Regards
Santosh Singh

Insert XML data into SQL Server 2008

2011-12-05T04:15:00.000-08:00

Insert XML data into SQL Server database
This article provides basic idea about how to insert xml data into sql server database.
I have given example here how to insert employee address information (EmpAddress.xml) which is an xml file to insert into database.
System.Xml namespace required for manupulation of xml.

XML File


<EmpAddress>
 <Address>
    <EmpCode>E001</EmpCode>
    <City>Mumbai</City>
    <State>Maharashtra</State>
    <Country>India</Country>
 </Address>
 <Address>
    <EmpCode>E002</EmpCode>
    <City>Mumbai</City>
    <State>Maharashtra</State>
    <Country>India</Country>
  </Address>
 <Address>
    <EmpCode>E003</EmpCode>
    <City>Delhi</City>
    <State>Delhi</State>
    <Country>India</Country>
  </Address>

  <Address>
    <EmpCode>E012</EmpCode>
    <City>Surat</City>
    <State>Gujrat</State>
    <Country>India</Country>
  </Address>
</EmpAddress>

 protected void Button1_Click(object sender, EventArgs e)  
 {  
 string EmpCode = null;  
 string City = null;  
 string State = null;  
 string Country = null;  
 string str = null;  
 SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=Test;Integrated Security=True");  
 XmlDocument document = new XmlDocument();  
 document.Load("E:\\Santosh\\EmpAddress.xml");  
 XmlNodeList xmlNodeList = document.SelectNodes("EmpAddress/Address");  
 foreach (XmlNode node in xmlNodeList)  
 {  
 EmpCode = node["EmpCode"].InnerText;  
 City = node["City"].InnerText;  
 State = node["State"].InnerText;  
 Country = node["Country"].InnerText;  
 str = "INSERT INTO AddressDetail (EmpCode,City,State,Country) values ('" + EmpCode + "', '" + City + "','" + State + "','" + Country + "')";  
 SqlCommand cmd = new SqlCommand();  
 cmd = new SqlCommand(str, con);  
 cmd.CommandType = CommandType.Text;  
 con.Open();  
 cmd.ExecuteNonQuery();  
 con.Close();  
 }  
 }

Regards
Santosh

Create PDF from DataTable in Asp.net

2011-03-27T03:18:00.000-07:00

In this article ,i am explaining you how to create pdf file from datatable.i am passing a datatable in this function and code to convert this in pdf file.

I am using iTextSharp you can download it from internet. it is free.
you need to create a simple asp.net page and get data from database.Then pass it to ExportToPDF method.We can set PDF page margins, change page orientation (portrait, landscape), customize headers and footers add page numbers and more.Do some R & D with iTextSharp.

 public void ExportToPdf(DataTable myDataTable)  
   {      
     Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);  
     try  
     {  
       PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);  
       pdfDoc.Open();  
       Chunk c = new Chunk("" + System.Web.HttpContext.Current.Session["CompanyName"] + "", FontFactory.GetFont("Verdana", 11));  
       Paragraph p = new Paragraph();  
       p.Alignment = Element.ALIGN_CENTER;  
       p.Add(c);  
       pdfDoc.Add(p);  
       string clientLogo = System.Web.HttpContext.Current.Session["CompanyName"].ToString();  
       clientLogo = clientLogo.Replace(" ", "");  
       string clogo = clientLogo + ".jpg";  
       string imageFilePath = System.Web.HttpContext.Current.Server.MapPath("../ClientLogo/" + clogo + "");  
       iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath);  
       //Resize image depend upon your need   
       jpg.ScaleToFit(80f, 60f);  
       //Give space before image   
       jpg.SpacingBefore = 0f;  
       //Give some space after the image   
       jpg.SpacingAfter = 1f;  
       jpg.Alignment = Element.HEADER;  
       pdfDoc.Add(jpg);  
       Font font8 = FontFactory.GetFont("ARIAL", 7);  
       DataTable dt = myDataTable;  
       if (dt != null)  
       {  
         //Craete instance of the pdf table and set the number of column in that table  
         PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);  
         PdfPCell PdfPCell = null;  
         for (int rows = 0; rows < dt.Rows.Count; rows++)  
         {  
           for (int column = 0; column < dt.Columns.Count; column++)  
           {  
             PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), font8)));  
             PdfTable.AddCell(PdfPCell);  
           }  
         }  
         //PdfTable.SpacingBefore = 15f; // Give some space after the text or it may overlap the table            
         pdfDoc.Add(PdfTable); // add pdf table to the document   
       }  
       pdfDoc.Close();  
       Response.ContentType = "application/pdf";  
       Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf");  
       System.Web.HttpContext.Current.Response.Write(pdfDoc);  
       Response.Flush();  
       Response.End();  
       //HttpContext.Current.ApplicationInstance.CompleteRequest();  
     }  
     catch (DocumentException de)  
     {  
       System.Web.HttpContext.Current.Response.Write(de.Message);  
     }  
     catch (IOException ioEx)  
     {  
       System.Web.HttpContext.Current.Response.Write(ioEx.Message);  
     }  
     catch (Exception ex)  
     {  
       System.Web.HttpContext.Current.Response.Write(ex.Message);  
     }  
   }

Thanks & Regards
Santosh Singh

Multiple file upload in asp.net

2010-12-29T07:44:00.000-08:00

This code show how to upload multiple file and save to database using asp.net and c#.

 HttpFileCollection hFileCollection = HttpContext.Current.Request.Files;  
     for (int i = 0; i <= hFileCollection.Count; i++)  
     {  
          HttpPostedFile hPostedFile = hFileCollection[i];  
          if (hPostedFile.ContentLength > 0)  
           {  
             Stream fs = hFileCollection[i].InputStream;  
             int ImgLength = hFileCollection[i].ContentLength;  
             string contenttype = hFileCollection[i].ContentType;  
             string filePath = Path.GetFullPath(hFileCollection[i].FileName);  
             string filename = Path.GetFileName(filePath);  
             string extension = Path.GetExtension(hFileCollection[i].FileName).ToLower();  
             byte[] BinaryData = new byte[ImgLength];  
             int n = fs.Read(BinaryData, 0, ImgLength);  
             int DrawingID = objbztDrawingMasterBLL.CreateDrawingMaster(objbztDrawingMasterCls);  
             objbztDrawingMasterCls.DfileName = filename;  
             objbztDrawingMasterCls.FileConetentType = contenttype;  
             objbztDrawingMasterCls.FileData = BinaryData;  
             if (extension == ".doc" || extension == ".docx" || extension == ".xls" || extension == ".xlsx" || extension == ".jpg" || extension == ".png" || extension == ".gif" || extension == ".pdf")  
             {  
               string cmdstr = "INSERT INTO tblDtFiles(DID,DFileName,FileConetentType,FileData) VALUES(" + DID + "," + Convert.ToString(filename) + "," + Convert.ToString(contenttype) + "," + BinaryData + ")";  
               SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, cmdstr);  
             }  
             else  
             {  
               msg.Text = "Uploaded file should be doc/xls/jpg/png/gif/pdf...!";  
             }  
         }  
     }

Thanks & Regards
Santosh Singh

Rounded off total income

2010-10-21T06:20:00.001-07:00

Rounded off total income

       Int32 roundedAmt;  
       Int32 torounded = Convert.ToInt32(lblTotalIncome.Text);  
       int lastdigit = torounded % 10;  
       if (lastdigit >= 5)  
       {  
         roundedAmt = torounded - lastdigit + 10;  
       }  
       else  
       {  
         roundedAmt = torounded - lastdigit;  
       }  
       lblRoundedOf.Text = Convert.ToString(roundedAmt);

Thanks & Regards
Santosh

Enable and disable textbox when checked the checkbox

2010-10-11T01:03:00.000-07:00

Here code show how enable and disble textbox when user checked the textbox.
code disble the row which contain the textbox.you can also take only checkbox
to enable and disble not neccessary to disble row.

function showHide()
{

var chkSignature = document.getElementById('ctl00_ContentPlaceHolder1_tabContainer_pnl_chkSign');
var trsign = document.getElementById('ctl00_ContentPlaceHolder1_tabContainer_pnl_trsign');
if(chkSignature.checked)
{
if(trsign != null)
{
trsign.style.display = '';
}
}
else
{
if(trsign != null)
{
trsign.style.display = 'none';
}
}
}

<tr>
<td style="height: 22px; width: 180px;">
</td>
<td align="left" colspan="3" style="height: 22px; text-align: left">
<asp:CheckBox ID="chkSignature" runat="server" Text="Show Signature" onclick="showHide()"/>
</td>
</tr>
<tr id="trsign" runat="server" style="display:none">
<td style="height: 22px; width: 180px;">
</td>
<td align="left" colspan="3" style="height: 22px; text-align: left">
<asp:TextBox ID="txtSignature" runat="server" Width="350px" TextMode="MultiLine" ></asp:TextBox>
</td>
</tr>

Thanks & Regards
Santosh

Thanks & Regards
Santosh

Bind DropDownList using SqlDataReader

2010-10-10T03:23:00.001-07:00

This code pulling out data from a database into a data reader is as follows.

 protected void Page_Load(object sender, EventArgs e)  
 {  
      if (!Page.IsPostBack)  
      {  
        bindDDL();  
      }  
 }  
 Public void bindDDL()  
 {  
      SqlConnection con =new SqlConnection(ConfigurationManager.  
      ConnectionStrings["ConnectionString"].ConnectionString.ToString();)  
      SqlCommand cmd=new SqlCommand();  
      cmd.connection=con;  
      con.open();  
      cmd.commandText="SELECT Citiid,CitiName FROM tableCity";  
      SqlDataReader dr;   
      dr=cmd.ExecuteReader();  
      ddlname.DataSource =dr;  
      ddlname.DataTextField = "CitiName";  
      ddlname.DataValueField = "Citiid";  
      ddlname.DataBind();  
      dr.close();   
      con.close();  
 }

Thanks & Regards
Santosh

Get duplicated record from sql server table

2010-10-09T06:38:00.000-07:00

Here query describes how to find duplicate record from a table in sql server

SELECT User_ID FROM tbl_Member
GROUP BY User_ID
HAVING count( * ) > 1

Thanks & Regards
Santosh Singh

Refresh the aspx page automatically

2010-10-01T00:12:00.000-07:00

This small code refresh the aspx page automatically.
Set the time according to your requirment in content="time in sec".

<head runat="server">
<title>Untitled Page</title>
<meta http-equiv="refresh" content="20" />
</head>

select data from one database and insert into another table

2010-09-30T06:16:00.000-07:00

insert into tblMonthMst
select * from EMPMain.[dbo].[tblMonthMst]

Sql Server query Optimization

2010-09-29T04:19:00.001-07:00

Optimization in Practice

Example 1:
I want to retrieve the name and salary of the employees of the R&D department.

Original:
Query : Select * From Employees
In Program : Add a filter on Dept or use command : if Dept = R&D--

Corrected :
Select Name, Salary From Employees Where Dept = R&D--

In the corrected version, the DB filters data because it filters faster than the program.
Also, you only need the Name and Salary, so only ask for that.
The data that travels on the network will be much smaller, and therefore your performances will improve.

Example 2 (Sorting):

Original:
Select Name, Salary
From Employees
Where Dept = 'R&D'
Order By Salary

Do you need that Order By Clause? Often, people use Order By in development to make sure returned data are ok; remove it if you don't need it.
If you need to sort the data, do it in the query, not in the program.

Example 3:
Original:
For i = 1 to 2000
Call Query : Select salary From Employees Where EmpID = Parameter(i)

Corrected:
Select salary From Employees Where EmpID >= 1 and EmpID <= 2000

The original Query involves a lot of network bandwidth and will make your whole system slow.
You should do as much as possible in the Query or Stored Procedure. Going back and forth is plain stupid.
Although this example seems simple, there are more complex examples on that theme.
Sometimes, the processing is so great that you think it's better to do it in the code but it's probably not.
Sometimes, your Stored Procedure will be better off creating a temporary table, inserting data in it and returning it than going back and forth 10,000 times.
You might have a slower query that saves time on a greater number of records or that saves bandwidth.

Example 4 (Weak Joins):
You have two tables Orders and Customers. Customers can have many orders.

Original:
Select O.ItemPrice, C.Name
From Orders O, Customers C

Corrected:
Select O.ItemPrice, C.Name
From Orders O, Customers C
Where O.CustomerID = C.CustomerID

In that case, the join was not there at all or was not there on all keys. That would return so many records that your query might take hours.
It's a common mistake for beginners.

Corrected 2:
Depending on the DB you use, you will need to specify the Join type you want in different ways.
In SQL Server, the query would need to be corrected to:

Select O.ItemPrice, C.Name
From Orders O INNER JOIN Customers C ON O.CustomerID = C.CustomerID

Choose the good join type (INNER, OUTER, LEFT, ...).
Note that in SQL Server, Microsoft suggests you use the joins like in the Corrected 2 instead of the joins in the Where Clause because it will be more optimized.

Example 5 (Weak Filters):
This is a more complicated example, but it illustrates filtering at its best.
We have two tables -- Products (ProductID, DescID, Price) and Description(DescID, LanguageID, Text). There are 100,000 Products and unfortunately we need them all.
There are 100 languages (LangID = 1 = English). We only want the English descriptions for the products.

We are expecting 100 000 Products (ProductName, Price).

First try:
Select D.Text As ProductName, P.Price
From Products P INNER JOIN Description D On P.DescID = D.DescID
Where D.LangID = 1

That works but it will be really slow because your DB needs to match 100,000 records with 10,000,000 records and then filter that Where LangID = 1.
The solution is to filter On LangID = 1 before joining the tables.

Corrected:
Select D.Text As ProductName, P.Price
From (Select DescID, Text From Description Where D.LangID = 1) D
INNER JOIN Products P On D.DescID = P.DescID

Now, that will be much faster. You should also make that query a Stored Procedure to make it faster.

Example 6 (Views):
Create View v_Employees AS
Select * From Employees

Select * From v_Employees

This is just like running Select * From Employees twice.
You should not use the view in that case.

If you were to always use the data for employees of R&D and would not like to give the rights to everyone on that table because of salaries being confidential,
you could use a view like that:

Create View v_R&DEmployees AS
Select Name, Salary From Employees Where Dept = 1
(Dept 1 is R&D).

You would then give the rights to View v_R&DEmployees to some people and would restrict the rights to Employees table to the DBA only.

That would be a possibly good use of views.

GridView with checkbox

2010-09-18T07:33:00.002-07:00

This article is very simple.Many time developer need to how develop Gridview with checkbox,so we can select single or multiple record to update.
Javascript file

 <script language="javascript" type="text/javascript">  
      function SelectAllCheckboxes(spanChk)  
      {  
           var oItem = spanChk.children;  
           var theBox=(spanChk.type=="checkbox")?spanChk:spanChk.children.item[0];  
           xState=theBox.checked;  
           elm=theBox.form.elements;  
           for(i=0;i if(elm[i].type=="checkbox" && elm[i].id!=theBox.id)  
           {   
                if(elm[i].checked!=xState)  
                elm[i].click();   
           }  
      }  
 </script>

Html code

 <form id="form1" runat="server">  
      <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="CustomerID" Width="366px" CellPadding="4" ForeColor="#333333" GridLines="None">  
           <Columns>  
                <asp:CommandField ShowSelectButton="True" />  
                <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" InsertVisible="False" ReadOnly="True" SortExpression="PersonID" />  
                <asp:BoundField DataField="Fname" HeaderText="Fname" SortExpression="Fname" />  
                <asp:TemplateField HeaderText="Select">  
                     <ItemTemplate>  
                          <asp:CheckBox ID="chkSelect" runat="server" />  
                     </ItemTemplate>  
                     <HeaderTemplate>  
                          <input id="chkAll" onclick="javascript:SelectAllCheckboxes(this);" runat="server" type="checkbox" />  
                     </HeaderTemplate>  
                </asp:TemplateField>  
           </Columns>   
      </asp:GridView>  
      <br />  
      <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Delete" />   
      <asp:Label ID="lblmsg" runat="server" Text="Label" Visible="false"></asp:Label>  
 </form>

.cs code

 public partial class GridWithCheck : System.Web.UI.Page  
 {  
   SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["StrConnect"].ToString());  
   protected void Page_Load(object sender, EventArgs e)  
   {  
     if (!IsPostBack)  
     {  
       BindGridView();  
     }  
   }  
   public void BindGridView()  
   {      
     SqlDataAdapter ad = new SqlDataAdapter("select * from tbl_CustomerDetail order by CustomerID", con);  
     DataSet ds = new DataSet();  
     ad.Fill(ds);  
     GridView1.DataSource = ds;  
     GridView1.DataBind();  
   }  
   protected void Button1_Click(object sender, EventArgs e)  
   {   
     foreach (GridViewRow row in GridView1.Rows)  
     {  
       CheckBox cb = ((CheckBox)(row.FindControl("chkSelect")));  
       if (cb != null && cb.Checked)  
       {   
         int custID = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);  
         string sqlstr = "delete from tbl_CustomerDetail where CustomerID='" + custID + "'";  
         SqlCommand mycmd;  
         mycmd = new SqlCommand(sqlstr, con);  
         con.Open();  
         mycmd.ExecuteNonQuery();  
         Page.RegisterStartupScript("pop", "&lt;script&gt;alert('Row deleted')&lt;/script&gt;");  
         BindGridView();          
       }  
     }   
   }  
  }

Thanks & Regards
Santosh

GridView Bind

2010-09-17T10:32:00.000-07:00

Here code shows how to bind gridview from database.
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bindGridView();
}
}
public void bindGridView()
{
SqlConnection myconnection;
SqlCommand mycmd;
SqlDataAdapter myda;
DataSet ds;
myconnection = new SqlConnection("Data Source=YourServer;Initial Catalog=Test;Integrated Security=True");
myda = new SqlDataAdapter("Select * from tblCustDetail ", myconnection);
ds = new DataSet();
myda.Fill(ds);
gvCust.DataSource = ds;
gvCust.DataBind();
}

Thanks & Regards
Santosh

Sql Server Interview Questions

2010-09-17T08:01:00.000-07:00

1.What are the blocks in stored procedure
2. How do you handle exceptions. Give the syntax for it
3. What is normalization and types of normalization
4. When would you denormalize
5. Difference between a query and strored procedure
6. What is clustered and non-clustered indexes
7. Types of joins
8. How do you get all records from 2 tables. Which join do you use
9. Types of optimization
10. Difference between inline query and stored procedure
11. How do you rate yourrself in oracle and sql server
12. What is E-R diagram
13. Draw E-R diagram for many to many relationship
14. Design databaseraw er diagram for a certain scenario(many author many books)
15. Diff between primary key and unique key
16. What is Normalization
17. Difference between sub query and nested query
18. Indexes in oracle
19. Querry to retrieve record for a many to many relationship
20. Querry to get max and second max in oracle in one querry
21. Write a simple Store procedure and pass parameter to it
22. What are the types of triggers
23. Types of locks in database
24. Types of indexes. What is the default key created when a primary key is created in a table
25. What is clustered, non-clustured and unique index. How many indexes can be created on a table
26. Can we create non-clustured index on a clustered index
27. Types of backups
28. What is INSTEAD OF trigger
29. What is difference between triggers and stored procedures. And advantages of SP over triggers
30. What is DTS and purpose of DTS
31. Write a query to get 2nd maximum salary in an employee table Types of joins.
32. What is currency type in database
33. What are nested triggers
34. What is a heap related to database
35. Types of cursors and explanation each of them
36. Types of cursor locations and explanation on each of them
37. Types of cursor locks and explanation each of them
38 How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records
again connect to database retrieve next 100 }
39. How do you optimize SQL queries

Thanks & Regards
Santosh

Dropdownlist in Gridview

2010-09-16T22:49:00.000-07:00

Here this example show how to bind dropdown list in Gridview control.

protected void GridDegree_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList ddlDegreeType = (DropDownList)e.Row.FindControl("ddlDegreeType");
if (ddlDegreeType != null)
{
ddlDegreeType.DataSource = objDegreeDAL.GetDegree();
ddlDegreeType.DataBind();
ddlDegreeType.SelectedValue = dsDegree.Tables[0].Rows[e.Row.RowIndex]["DegreeId"].ToString();
}
}
}

.aspx page
<asp:TemplateField HeaderText="Degree Type"gt&;
<ItemTemplategt&;
<asp:Label ID="lblDegreeType" runat="server" Text='<%# Bind("[Degree]") %>'gt&;</asp:Labelgt&;
</ItemTemplategt&;
<EditItemTemplategt&;
<asp:DropDownList ID="ddlDegreeType" runat="server" DataTextField="Degree"
DataValueField="Degreeid"gt&;
</asp:DropDownListgt&;
</EditItemTemplategt&;
</asp:TemplateFieldgt&;

Thanks & Regard
Santosh

Create pdf from GridView asp.net with c#

2010-09-15T04:14:00.000-07:00

Here this article show full code for create the pdf file from asp.net GridView.
Some time developer need how to do GridView to pdf .Here i have written the method according to my requirement.You can change according to your requirement and use this.

public void ConvertDataInPdf(DataTable dtExportInPdf, string reportName, string OtherInfo)
{
try
{
float CompanyNameSize = 11;
float ReportNameSize = 9;
float HeaderTextSize = 7;
float ReportTextSize = 6;

int totalWidth = 0;
int tableWidthPercent = 100;
int[] widths = new int[dtExportInPdf.Columns.Count];

for (int h = 0; h < dtExportInPdf.Columns.Count; h++) //Data table header column width
{
string strWidth = dtExportInPdf.Columns[h].ToString();
widths[h] = strWidth.Length;
}

foreach (DataRow dr in dtExportInPdf.Rows) //Data table column width
{
int[] colItemWidth = new int[dtExportInPdf.Columns.Count];
for (int i = 0; i < dtExportInPdf.Columns.Count; i++) //Data table max item width
{
if (dr[i].ToString().Length > 20)
{
colItemWidth[i] = 20;
}
else if (dr[i].ToString().Length < 3)
{
colItemWidth[i] = 3;
}
else
{
colItemWidth[i] = dr[i].ToString().Length;
}

if (colItemWidth[i] > widths[i])
{
widths[i] = colItemWidth[i];
}
}
}
for (int h = 0; h < dtExportInPdf.Columns.Count; h++)
{
totalWidth += widths[h];
}
Document pdfDoc = null;
if (totalWidth > 0 && totalWidth <= 110)
{
pdfDoc = new Document(PageSize.A4, 20, 20, 20, 20);
}
else if (totalWidth > 110 && totalWidth <= 160)
{
pdfDoc = new Document(PageSize.A4.Rotate(), 20, 20, 20, 20);
}
else if (totalWidth > 160 && totalWidth <= 250)
{
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.LEGAL.Rotate(), 20, 20, 20, 20);

}
else if (totalWidth > 250 && totalWidth <= 300)
{
CompanyNameSize = 9;
ReportNameSize = 7;
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.B1, 20, 20, 20, 20);
}
else if (totalWidth > 300)
{
CompanyNameSize = 9;
ReportNameSize = 7;
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.B1.Rotate(), 20, 20, 20, 20);
}

// Creates a PdfPTable with column count of the table equal to no of columns of the datatable or gridview or gridview datasource.
PdfPTable pdfTable = new PdfPTable(dtExportInPdf.Columns.Count);
pdfTable.WidthPercentage = tableWidthPercent;
pdfTable.HeaderRows = 4; // Sets the first 4 rows of the table as the header rows which will be repeated in all the pages.

#region PDFHeader
PdfPTable headerTable = new PdfPTable(3); // Creates a PdfPTable with 3 columns to hold the header in the exported PDF.
byte[] logo = (byte[])System.Web.HttpContext.Current.Session["Logo"];
iTextSharp.text.Image imgLogo = iTextSharp.text.Image.GetInstance(logo);
imgLogo.ScaleToFit(80f, 40f);//Resize image depend upon your need
imgLogo.SpacingBefore = 0f;//Give space before image
imgLogo.SpacingAfter = 1f;//Give some space after the image
PdfPCell clLogo = new PdfPCell(imgLogo);// Creates a PdfPCell which accepts a phrase as a parameter.
clLogo.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clLogo.HorizontalAlignment = Element.ALIGN_LEFT;// Sets the Horizontal Alignment of the PdfPCell to left.
clLogo.VerticalAlignment = Element.ALIGN_MIDDLE;

// Creates a phrase to hold the application name at the left hand side of the header.
Phrase phApplicationName = new Phrase("" + System.Web.HttpContext.Current.Session["CompanyName"] + "", FontFactory.GetFont("Arial", CompanyNameSize, iTextSharp.text.Font.NORMAL));
PdfPCell clApplicationName = new PdfPCell(phApplicationName);// Creates a PdfPCell which accepts a phrase as a parameter.
clApplicationName.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clApplicationName.HorizontalAlignment = Element.ALIGN_CENTER;// Sets the Horizontal Alignment of the PdfPCell to left.
clApplicationName.VerticalAlignment = Element.ALIGN_MIDDLE;

// Creates a phrase to show the current date at the right hand side of the header.
Phrase phDate = new Phrase(DateTime.Now.Date.ToString("dd/MM/yyyy"), FontFactory.GetFont("Arial", 7, iTextSharp.text.Font.NORMAL));
PdfPCell clDate = new PdfPCell(phDate);// Creates a PdfPCell which accepts the date phrase as a parameter.
clDate.HorizontalAlignment = Element.ALIGN_RIGHT;// Sets the Horizontal Alignment of the PdfPCell to right.
clDate.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clDate.VerticalAlignment = Element.ALIGN_MIDDLE;

headerTable.AddCell(clLogo);
headerTable.AddCell(clApplicationName);// Adds the cell which holds the application name to the headerTable.
headerTable.AddCell(clDate);// Adds the cell which holds the date to the headerTable.
headerTable.DefaultCell.Border = PdfPCell.NO_BORDER;// Sets the border of the headerTable to zero.

// Creates a PdfPCell that accepts the headerTable as a parameter and then adds that cell to the main PdfPTable.
PdfPCell cellHeader = new PdfPCell(headerTable);
cellHeader.VerticalAlignment = Element.ALIGN_TOP;
cellHeader.Border = PdfPCell.NO_BORDER;
cellHeader.Colspan = dtExportInPdf.Columns.Count;// Sets the column span of the header cell to noOfColumns.
pdfTable.AddCell(cellHeader);// Adds the above header cell to the table.
#endregion PDFHeader

//Creates a phrase for a new line.
Phrase phSpace1 = new Phrase("\n");
PdfPCell clSpace1 = new PdfPCell(phSpace1);
clSpace1.Border = PdfPCell.BOTTOM_BORDER;
clSpace1.BorderWidth = 1;
clSpace1.BorderColor = iTextSharp.text.Color.DARK_GRAY;
clSpace1.Colspan = dtExportInPdf.Columns.Count;
pdfTable.AddCell(clSpace1);

// Creates a phrase to hold the report name.
Phrase phHeader = new Phrase("" + reportName + "", FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.NORMAL));
PdfPCell clHeader = new PdfPCell(phHeader);
clHeader.Colspan = dtExportInPdf.Columns.Count;
clHeader.Border = PdfPCell.NO_BORDER;
clHeader.HorizontalAlignment = Element.ALIGN_CENTER;
clHeader.VerticalAlignment = Element.ALIGN_MIDDLE;
clHeader.PaddingTop = 5;
clHeader.PaddingBottom = 2;
pdfTable.AddCell(clHeader);

//Create Phrage to hold other informations
Phrase phOtherInfo = new Phrase(OtherInfo, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
PdfPCell cellOtherInfo = new PdfPCell(phOtherInfo);
cellOtherInfo.Colspan = dtExportInPdf.Columns.Count;
cellOtherInfo.Border = Element.ALIGN_LEFT;
cellOtherInfo.PaddingBottom = 10;
pdfTable.AddCell(cellOtherInfo);

PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
string strFooter = "Copyright © 2010 By Cnergee. Page:";
Phrase phCopyright = new Phrase(strFooter, FontFactory.GetFont(FontFactory.TIMES_ROMAN, 8, iTextSharp.text.Font.NORMAL));
Phrase phPageNo = new Phrase("", FontFactory.GetFont(FontFactory.TIMES_ROMAN, 8, iTextSharp.text.Font.NORMAL));
HeaderFooter footer = new HeaderFooter(phCopyright, phPageNo);
//footer.Alignment = Element.ALIGN_LEFT;
footer.Alignment = Element.ALIGN_RIGHT;
footer.Border = iTextSharp.text.Rectangle.TOP_BORDER;
footer.GrayFill = 10;
pdfDoc.Footer = footer;

pdfDoc.Open();
Font font8 = FontFactory.GetFont("ARIAL Narrow", 7);
if (dtExportInPdf != null)
{
pdfDoc.Header = null;
//Create header for pdf table
string cloName = null;
Phrase ph = null;
for (int i = 0; i < dtExportInPdf.Columns.Count; i++)
{
cloName = dtExportInPdf.Columns[i].ColumnName;
if (dtExportInPdf.Columns.Count > 0)
{
ph = new Phrase(cloName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
else
{
ph = new Phrase(cloName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
pdfTable.AddCell(ph);
}

//Add data into the pdf table
for (int rows = 0; rows < dtExportInPdf.Rows.Count; rows++)
{
ph = null;
PdfPCell pCell = null;
for (int column = 0; column < dtExportInPdf.Columns.Count; column++)
{
ph = new Phrase(dtExportInPdf.Rows[rows][column].ToString(), FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
pCell = new PdfPCell(ph);
if (dtExportInPdf.Columns[column].ColumnName == "SrNo" || dtExportInPdf.Columns[column].ColumnName == "Sr.No." || dtExportInPdf.Columns[column].ColumnName == "Sr. No." || dtExportInPdf.Columns[column].ColumnName == "Code" || dtExportInPdf.Columns[column].ColumnName == "EmpCode" || dtExportInPdf.Columns[column].ColumnName == "EmployeeCode")
{
pCell.HorizontalAlignment = Element.ALIGN_CENTER;
}
else if (dtExportInPdf.Columns[column].ColumnName == "Amount")
{
pCell.HorizontalAlignment = Element.ALIGN_RIGHT;
}
else if (dtExportInPdf.Columns[column].ColumnName == "Date" || dtExportInPdf.Columns[column].ColumnName == "From" || dtExportInPdf.Columns[column].ColumnName == "To")
{
pCell.HorizontalAlignment = Element.ALIGN_CENTER;
}
else
{
pCell.HorizontalAlignment = Element.ALIGN_LEFT;
}
pdfTable.AddCell(pCell);
}
pdfTable.SetWidths(widths);
}
pdfTable.SpacingBefore = 15f; // Give some space after the text or it may overlap the table
pdfDoc.Add(pdfTable); // add pdf table to the document
}
pdfDoc.Close();

string pdfFileName = reportName;
reportName = reportName.Replace(" ", "");
System.Web.HttpContext.Current.Response.ContentType = "application/pdf";
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename= " + pdfFileName + ".pdf");
System.Web.HttpContext.Current.Response.Write(pdfDoc);

System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.End();
}
catch (DocumentException de)
{
System.Web.HttpContext.Current.Response.Write(de.Message);
}
catch (IOException ioEx)
{
System.Web.HttpContext.Current.Response.Write(ioEx.Message);
}
catch (Exception ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
}

Thanks & Regards
Santosh Singh

Bind dropdownlist default value

2010-09-11T03:27:00.000-07:00

On RowDataBound
ddlCountry.SelectedValue = Ds.Tables[0].Rows[e.Row.RowIndex]["CountryId"].ToString();

On SelectedIndexChanged
ddlRGroup.SelectedValue = Ds.Tables[0].Rows[0]["RatingId"].ToString();

if (!Page.IsPostBack)
SqlDataReader dr = SqlHelper.ExecuteReader(connectionString, "tblFormula_Select", Convert.ToInt32(ViewState["CKFId"]), "S");
ddlTemp.SelectedValue = dr["TemplateId"].ToString();

Javascript validation for Gridview footer textbox

2010-09-10T22:28:00.000-07:00

Javascript validation for Gridview footer textbox.
Here gridview have footer row that cantain dropdownlist and two textbox.This javascript validate these fields.

function ValidateGrid()
{
ddlNewCountry = document.getElementById('<%=((DropDownList)gv.FooterRow.FindControl("ddlNewCountry")).ClientID%>');
txtNewEmpName = document.getElementById('<%=((TextBox)gv.FooterRow.FindControl("txtNewEmpName")).ClientID %>');
txtNewAge = document.getElementById('<%=((TextBox)gv.FooterRow.FindControl("txtNewAge")).ClientID %>');
if(ddlNewCountry.value == 0)
{
alert("Please Select Country...!");
ddlNewCountry.focus();
return false;
}
if(txtNewEmpName.value == 0)
{
alert("Please Enter Emp name...!");
txtNewEmpName.focus();
return false;
}
if(txtNewAge.value == 0)
{
alert("Please Enter age...!");
txtNewAge.focus();
return false;
}
return true;
}

Javascript validation for Gridview in edit mode

2010-09-10T21:48:00.000-07:00

Javascript validation for Gridview in edit mode.
Here gridview have dropdownlist and two textbox.This javascript validate these fields in edit mode.

function ValidateGridEditMode()
{
var Gid = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer').rows.length;
var i;
for(i=2; i <=Gid; i++)
{
if(i<10)
{
ddlCustLocation = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl0'+i+'_ddlCustLocation');
txtCustCode = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl0'+i+'_txtCustCode');
txtCustName = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl0'+i+'_txtCustName');
}
else
{
ddlCustLocation = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl'+i+'_ddlCustLocation');
txtCustCode = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl'+i+'_txtCustCode');
txtCustName = document.getElementById('ctl00_ContentPlaceHolder1_TabContaner_tabCustomer_gvCustomer_ctl'+i+'_txtCustName');
}

ddlCustLocation != null || txtCustCode != null || txtCustName != null)
{
ddlCustLocation == 0)
{
alert("Please Select Location..");
ddlCustLocation.focus();
return false;
}
else
{
if(txtCustCode.value == 0)
{
alert("Please enter Customer Code..");
txtCustCode.focus();
return false;
}
else
{
if(txtCustName.value == "")
{
alert("Please enter Customer Name ..");
txtCustName.focus();
return false;
}
}
}
}
}
return true;
}

Thanks & Regards
Santosh

GridView control with full feature

2010-09-10T09:43:00.000-07:00

Introduction
This example explains the GridView binding with simple DataSet , and also explains the methods like Add new record, Edit, Update and
Delete function.

Featur of this gridview"
1.This example used three tier architecture.
2.Add new record using footer.
3.Update and delete record.
4.For edit and delete i have used image button for nice look.
5.If table is empty(No record in table) a blank dynamic Gridview display for with Add New buttion.
6.On Click Edit or Add New cursor focus to Textbox.
7.Auto Generated Serial Number In Gridview Control.

I have used property layer but i didnt write here,i think you can implement it according to your logic.

.
aspx page

<asp:GridView ID="GridViewEmpSkill" runat="server" AllowPaging="True" AutoGenerateColumns="False"
PageSize="12" OnPageIndexChanging="GridViewEmpSkill_PageIndexChanging" OnRowDataBound="GridViewEmpSkill_RowDataBound"
TabIndex="2" Width="697px" OnRowCancelingEdit="GridViewEmpSkill_RowCancelingEdit" OnRowEditing="GridViewEmpSkill_RowEditing"
OnRowUpdating="GridViewEmpSkill_RowUpdating" ShowFooter="True" OnRowCommand="GridViewEmpSkill_RowCommand"
OnRowDeleting="GridViewEmpSkill_RowDeleting" DataKeyNames="EmpSkillId">
<Columns>
<asp:TemplateField HeaderText="Sr No">
<ItemTemplate>
<asp:Label ID="lblSrNo" runat="server"></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lblNewSrNo" runat="server"></asp:Label>
</FooterTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpSkillId" Visible="False">
<ItemTemplate>
<asp:Label ID="lblEmpSkillId" runat="server" Text='<%# Bind("EmpSkillId") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpSkill">
<EditItemTemplate>
<asp:TextBox ID="txtEmpSkill" runat="server" Width="493px" BorderColor="White" BorderWidth="0px"
Height="14px" Text='<%# Bind("EmpSkill") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtNewEmpSkill" runat="server" Width="493px" BorderColor="White" BorderWidth="0px"
Height="14px" Visible="false"></asp:TextBox>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblEmpSkill" runat="server" Text='<%# Bind("EmpSkill") %>'></asp:Label>
</ItemTemplate>
<FooterStyle HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Activity">
<ItemTemplate>
<asp:ImageButton ID="imgEdit" runat="server" ImageUrl="~/Image/img_edit.png" CommandName="Edit" ToolTip="Edit" />
<asp:ImageButton ID="imgbtnDelete" runat="server" ImageUrl="~/Image/img_delete.png" ToolTip="Delete"
CommandName="Delete" OnClientClick="return ConfirmDelete();" />
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton ID="imgUpdate" runat="server" CausesValidation="True" CommandName="Update" ToolTip="Update"
ImageUrl="~/Image/update.png" Text="Update" />
<asp:ImageButton ID="imgCancel" runat="server" CausesValidation="False" CommandName="Cancel" ToolTip="Cancel"
ImageUrl="~/Image/cancel.png" Text="Cancel" />
</EditItemTemplate>
<FooterTemplate>
<asp:ImageButton ID="imgNewAdd" runat="server" ImageUrl="~/Image/row_add.png"
CommandName="AddNew" ToolTip="Add New" />
<asp:ImageButton ID="imgbtnNewInsert" runat="server" CausesValidation="True" CommandName="Insert" ToolTip="Save"
ImageUrl="~/Image/add.png" Visible="false" Text="Add" />
<asp:ImageButton ID="imgNewCancel" runat="server" CausesValidation="False" CommandName="Cancel" ToolTip="Cancel"
ImageUrl="~/Image/cancel.png" Visible="false" Text="Cancel" />
</FooterTemplate>
<FooterStyle HorizontalAlign="Center" Width="140px" />
<ItemStyle HorizontalAlign="Center" Width="140px" />
</asp:TemplateField>
</Columns>
</asp:GridView>

===========
.cs page

protected void GridViewEmployeeSkill()
{
try
{
Ds = SkillBLLobj.GetEmpSkillData();
if (Ds.Tables[0].Rows.Count > 0)
{

GridViewEmpSkill.DataSource = Ds;
GridViewEmpSkill.DataBind();

}
else
{
ShowNoResultFound(Ds,GridViewEmpSkill);
SrNoSkill = 1;
}
}
catch (Exception ex)
{
msgEmpSkill.Text = ex.Message;
}
}

protected void GridViewEmpSkill_RowEditing(object sender, GridViewEditEventArgs e)
{
GridViewEmpSkill.EditIndex = e.NewEditIndex;
GridViewEmpSkill();
GridViewEmpSkill.Rows[e.NewEditIndex].FindControl("txtEmpSkill").Focus();
}
protected void GridViewEmpSkill_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridViewEmpSkill.EditIndex = -1;
GridViewSkill();
}
protected void GridViewEmpSkill_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewEmpSkill.PageIndex = e.NewPageIndex;
GridViewSkill();
}
protected void GridViewEmpSkill_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblSrNo = (Label)e.Row.FindControl("lblSrNo");
lblSrNo.Text = SrNo.ToString();
SrNo++;
}
}
protected void GridViewEmpSkill_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
SkillClsobj.SkillId = Convert.ToInt32(((Label)GridViewEmpSkill.Rows[e.RowIndex].FindControl("lblEmpSkillId")).Text);
SkillClsobj.Skill = Convert.ToString(((TextBox)GridViewEmpSkill.Rows[e.RowIndex].FindControl("txtEmpSkill")).Text);

int Update = SkillBLLobj.UpdateEmpSkill(SkillClsobj);
if (Update > 0)
{
msgEmpSkill.Text = "Record Updated Successfully !";
GridViewEmpSkill.EditIndex = -1;
GridViewSkill();
}
}
catch (Exception ex)
{
msgEmpSkill.Text = ex.Message.ToString();
}
}
protected void GridViewEmpSkill_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("AddNew") || e.CommandName.Equals("Insert"))
{
if (e.CommandName.Equals("AddNew"))
{
GridViewEmpSkill.EditIndex = -1;
GridViewSkill();
Label lblNewSrNo = (Label)GridViewEmpSkill.FooterRow.FindControl("lblNewSrNo");
lblNewSrNo.Text = SrNo.ToString();

ImageButton imgNewInsert = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewInsert");
ImageButton imgNewCancel = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewCancel");
ImageButton imgNewAdd = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewAdd");
imgNewInsert.Visible = true;
imgNewCancel.Visible = true;
imgNewAdd.Visible = false;
TextBox txtNewEmpSkill = (TextBox)GridViewEmpSkill.FooterRow.FindControl("txtNewEmpSkill");
txtNewEmpSkill.Visible = true;
txtNewEmpSkill.Focus();
}
}
}
catch(Exception ex)
{
throw ex;
}
try
{
if (e.CommandName.Equals("Insert"))
{
ImageButton imgNewInsert = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewInsert");
ImageButton imgNewCancel = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewCancel");
ImageButton imgNewAdd = (ImageButton)GridViewEmpSkill.FooterRow.FindControl("imgNewAdd");
imgNewInsert.Visible = false;
imgNewCancel.Visible = false;
imgNewAdd.Visible = true;
TextBox txtNewSkill = (TextBox)GridViewEmpSkill.FooterRow.FindControl("txtNewEmpSkill");
txtNewEmpSkill.Visible = true;
txtNewEmpSkill.Focus();

SkillClsobj.Skill = Convert.ToString(((TextBox)GridViewEmpSkill.FooterRow.FindControl("txtNewSkill")).Text);

try
{
if (SkillClsobj.Skill == "")
{
msgEmpSkill.Text = "Pleae Enter !";
}
else
{
int intResult= SkillBLLobj.InsertEmpSkill(SkillClsobj);
if (intResult> 0)
{
msgEmpSkill.Text = "Record Added !";
GridViewEmpSkill.EditIndex = -1;
GridViewSkill();
}
}
}
catch (Exception ee)
{
msgEmpSkill.Text = ee.Message.ToString();
}
finally
{
SkillBLLobj = null;
}
}
}
catch(Exception ex)
{
throw ex;
}
}
protected void GridViewEmpSkill_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
SkillClsobj.SkillId = (int)GridViewEmpSkill.DataKeys[e.RowIndex].Value;
int result = SkillBLLobj.DeleteSkill(SkillClsobj);
if (result > 0)
{
msgEmpSkill.Text = "Record Deleted Successfully !";
GridViewEmpSkill.EditIndex = -1;
GridViewSkill();
}
}
catch (Exception ex)
{
msgEmpSkill.Text = ex.Message.ToString();
}
}
private void ShowNoResultFound(DataSet ds,GridView gv)
{
DataTable dt = (DataTable)ds.Tables[0];
dt.Rows.Add(dt.NewRow());
gv.DataSource = dt;
gv.DataBind();
int TotalColumns = gv.Rows[0].Cells.Count;
gv.Rows[0].Cells.Clear();
gv.Rows[0].Cells.Add(new TableCell());
gv.Rows[0].Height = 0;
gv.Rows[0].Visible = false;
}
======================
business logic layer

public class EmpSkillBLL
{
EmpSkillDAL SkillDALobj = new EmpSkillDAL();

public DataSet GetEmpSkillData()
{
try
{
return SkillDALobj.GetEmpSkillData();
}
catch
{
throw;
}
}
public int InsertSkill(EmpSkillCls objSkillCls)
{
try
{
return SkillDALobj.InsertEmpSkill(objSkillCls);
}
catch
{
throw;
}
}
public int UpdateSkill(EmpSkillCls objSkillCls)
{
try
{
return SkillDALobj.UpdateEmpSkill(objSkillCls);
}
catch
{
throw;
}
}
public int DeleteSkill(EmpSkillCls objSkillCls)
{
try
{
return objSkillDAL.DeleteEmpSkill(objSkillCls);
}
catch
{
throw;
}
}
===========
data acess layer

public class EmpSkillDAL
{
SqlConnection conn = new SqlConnection("your connection string");
DataSet Ds = new DataSet();

public DataSet GetEmpSkillData()
{
Ds = SqlHelper.ExecuteDataset(conn, "sp_SelectDelete");
return Ds;
}
public int InsertEmpSkill(EmpSkillCls Emp)
{
try
{
int Insert = SqlHelper.ExecuteNonQuery(conn, "usp_EmpSkillMasterAddEdit", Emp.SkillId, Emp.Skill);
return Insert;
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
public int UpdateEmpSkill(EmpSkillCls emp)
{
try
{
int Result = SqlHelper.ExecuteNonQuery(conn, "usp_EmpSkillMaster_AddEdit", Emp.SkillId, Emp.Skill);
return Result;
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
public int DeleteEmpSkill(EmpSkillCls emp)
{
try
{
int result = SqlHelper.ExecuteNonQuery(conn, "usp_EmpSkillMasterSelect", emp.SkillId);
return result;
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
}

Thank & Regard
Santosh Singh

Onclick Gridview Select button fill all the data to textbox.

2010-09-10T00:49:00.000-07:00

Onclick Gridview Select button fill all the data to textbox.
All the textbox out of gridview.

protected void ImgSelect_Click(object sender, ImageClickEventArgs e)
{
ImageButton aspSender = sender as ImageButton;
Label Id = aspSender.FindControl("lblContId") as Label;
hdnId.Value = Id.Text;
DataSet dsContact = new DataSet();
dsContact = SqlHelper.ExecuteDataset(connectionString, "usp_GetContact", Convert.ToInt32(Id.Text.Trim()), EmpId, "S");
if (dsContact.Tables[0].Rows.Count != 0)
{
txtName.Text = dsContact.Tables[0].Rows[0]["Name"].ToString();
ddlRelation.SelectedValue = dsContact.Tables[0].Rows[0]["RelId"].ToString();
txtAddress.Text = dsContact.Tables[0].Rows[0]["Address"].ToString();
}
}

Join Three Table

2010-09-06T01:34:00.001-07:00

How to join three table
SELECT e.emp_name, d.DeptName
FROM Emp e INNER JOIN DeptName d
ON e.emp_id = d.emp_id JOIN Sal s
ON d.dept_id = s.dept_id

SELECT a.au_lname, a.au_fname, t.title
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id JOIN titles t
ON ta.title_id = t.title_id

select
r.recipe_name,
i.ingredients_list,
p.products_list
from
recipes r,
ingredients i,
products p
where
r.RecipeID = i.IngreRecipeID and
i.IngreProductID = p.ProductID
;

How to Store Multiple Value In Session using asp.net c#

2010-09-06T01:33:00.003-07:00

We can add multiple values by using class entiry or hashtable or arralist:
Here a we will use Hashtable for storing multiple value in session

Hashtable htEmpInfo = new Hashtable();

htEmpInfo.Add("Name", "Santosh");
htEmpInfo.Add("Designation", "SE");
htEmpInfo.Add("Department", "MS");

session["EmpDetails"]=htEmpInfo;

Retrieving the values from the session

Hashtable htEmpInformaiton = (Hashtable)session["EmpDetails"];
lblEmopName.Text=htEmpInformaiton["Name"].ToString();
lblDesignation.Text=htEmpInformaiton["Designation"].ToString();

OnkeyPress attributes in TextBox using JavaScript

2010-09-06T01:31:00.000-07:00

Here code shows how to use onkeypress in TextBox.When user write in textbox a Label show no. of charachter entered in TextBox

 function valid(txt,maxLen,lbl1)  
 {  
      lbl1.innerText=(txt.value.length+1);   
      if(txt.value.length > (maxLen-1))  
      {  
           alert("Entered Text reach at its maximum size..!");  
           return false;  
      }  
 }   
 txtFeedback.Attributes["onkeypress"] = "return valid(this,500," + Label1.ClientID + ")";

Thanks & Regards
Santosh

Gridview RowCommand

2010-09-05T03:26:00.000-07:00

If you hav any button inside Gridview you handle that button under RowCommand like here Gridview have a Insert button inside Grid.

 protected void gvStuDetails_RowCommand(object sender, GridViewCommandEventArgs e)  
 {  
      if (e.CommandName.Equals("Insert"))  
      {   
           objStuCls.StuId = Convert.ToInt32(((DropDownList)gvStuDetails.FooterRow.FindControl("ddlNewStuId")).SelectedValue);  
           objStuCls.StuName = Convert.ToString(((TextBox)gvStuDetails.FooterRow.FindControl("txtNewStuName")).Text);  
           try  
           {   
                int int = objClassMasterBLL.InsertClassMaster(objStuCls);  
                if (int > 0)  
                {  
                     msgText = "Record Added Successfully !";  
                     gvStuDetails.EditIndex = -1;  
                     gvStu();  
                }  
                else  
                {  
                     msg.Text = "This record already exists !";  
                }  
           }  
           catch (Exception ee)  
           {  
                msg.Text = ee.Message.ToString();  
           }   
      }  
 }

Thanks & Regards
Santosh

Insert Images to SqlServer in ASP .NET

2010-09-04T09:48:00.000-07:00

Here I am explaining how insert images into database using asp.net.

 protected void Button1_Click(object sender, EventArgs e)  
 {  
      FileUpload fileUpload1 = ((FileUpload)(this.FindControl("fileUpload1")));  
      if (((fileUpload1.PostedFile == null) || (string.IsNullOrEmpty(fileUpload1.PostedFile.FileName) || (fileUpload1.PostedFile.InputStream == null))))   
      {  
           Label1.Text = "Please Upload Valid picture file";  
           return;  
      }  
      int len = fileUpload1.PostedFile.ContentLength;  
      byte[] pic = new byte[len];  
      fileUpload1.PostedFile.InputStream.Read(pic, 0, len);  
      string extension = System.IO.Path.GetExtension(fileUpload1.PostedFile.FileName).ToLower();  
      string MIMEType = null;  
      switch (extension)  
      {  
           case ".gif":  
           MIMEType = "image/gif";  
           break;  
           case ".jpg":  
           case ".jpeg":  
           case ".jpe":  
           MIMEType = "image/jpeg";  
           break;  
           case ".png":  
           MIMEType = "image/png";  
           break;  
           default:  
           Label1.Text = "Not a Valid file format";  
           return;  
           break;  
      }   
      string fname = txtName.Text;  
      string lname = txtLName.Text;  
      string gender = rdGender.SelectedItem.Text;  
      string age = drpAge.SelectedItem.Text;  
      string state = txtState.Text;   
      SqlConnection myConnection;  
      myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["StrConnectSan"].ToString());   
      SqlCommand myCommand = new SqlCommand("usp_InsertPersonDetail", myConnection);  
      myCommand.CommandType = CommandType.StoredProcedure;  
      myCommand.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = fname;  
      myCommand.Parameters.Add("@LastName", SqlDbType.VarChar, 50).Value = lname;  
      myCommand.Parameters.Add("@GenderID", SqlDbType.VarChar, 50).Value = gender;  
      myCommand.Parameters.Add("@Age", SqlDbType.VarChar, 50).Value = age;  
      myCommand.Parameters.Add("@MCA", SqlDbType.VarChar, 50).Value = str;  
      myCommand.Parameters.Add("@State", SqlDbType.VarChar, 50).Value = state;  
      myCommand.Parameters.Add("@MIMEType", SqlDbType.VarChar, 50).Value = MIMEType;   
      myCommand.Parameters.Add("@ImageData",SqlDbType.Image,16).Value = pic;  
      myCommand.Parameters.Add("@Length", SqlDbType.VarChar, 50).Value = len;  
      myConnection.Open();  
      myCommand.ExecuteNonQuery();  
      myConnection.Close();  
      msg.Text = "Record save successfully";        
 }

Thanks & Regards
Santosh

Validation Groups in ASP.NET 2.0

2010-09-03T04:21:00.000-07:00

Validation groups is a new feature of asp.net 2.0.Validation groups help you to group the controls in a page and you can have separate submit buttons for each group.When you submit a group of values from a group,the validation controls pertaining to that group alone is executed.

Here is a example how to use validation group.
On clicking of Save Button,it should fire the Required Field validator of Name is required fields only. In the same way,on clicking Save Password it should fire
the Required Field validator only for Password is required fields.

For Group1

 <asp:TextBox ID="txtusername" runat="server" ValidationGroup="Group1"></asp:TextBox>  
 <asp:RequiredFieldValidator ID="rfvUname" runat="server" ControlToValidate="txtusername"  
    ErrorMessage="Name is required." ValidationGroup="Group1">*</asp:RequiredFieldValidator>  
 <asp:Button ID="btnSave" runat="server" Text="Save" ValidationGroup="Group1" />

For Group2

 <asp:TextBox ID="txtPassword" runat="server" TextMode="Password" ValidationGroup="Group2></asp:TextBox>  
 <asp:RequiredFieldValidator ID="rfvpass" runat="server" ControlToValidate="txtPassword"  
    ErrorMessage="Password is required." ValidationGroup="Group2">*</asp:RequiredFieldValidator>  
 <asp:Button ID="btnSavePass" runat="server" Text="Save Password" ValidationGroup="Group2" />

Thanks & Regards
Santosh

Dot net interview Questions and Answers

2010-09-02T06:24:00.000-07:00

1. What is a static class?
Ans.A static class is a class which can not be instantiated using the ‘new’ keyword. They also only contain static members,are sealed and have a private constructor.
Static classes are classes that contain only static members.A static class is basically the same as a non-static class, but there is one difference: a static class cannot be instantiated. In other words, you cannot use the new keyword
to create a variable of the class type. Because there is no instance variable, you access the members of a static class by using the class name itself. For example, if you have a static class that is named UtilityClass that has a public method named MethodA, you call the method as shown in the following example:
UtilityClass.MethodA();

A static class can be used as a convenient container for sets of methods that just operate on input parameters and do not have to get or set any internal instance fields. For example, in the .NET Framework Class Library, the static System.Math class contains methods that perform mathematical operations,without any requirement to store or retrieve data that is unique to a particular instance of the Math class. That is, you apply the members of the class by specifying the class name and the method name, as shown in the following example.
public static class TemperatureConverter
{
public static double CelsiusToFahrenheit(string temperatureCelsius)
{
// Convert argument to double for calculations.
double celsius = Double.Parse(temperatureCelsius);
// Convert Celsius to Fahrenheit.
double fahrenheit = (celsius * 9 / 5) + 32;
return fahrenheit;
}
public static double FahrenheitToCelsius(string temperatureFahrenheit)
{
// Convert argument to double for calculations.
double fahrenheit = Double.Parse(temperatureFahrenheit);
// Convert Fahrenheit to Celsius.
double celsius = (fahrenheit - 32) * 5 / 9;
return celsius;
}
}
class TestTemperatureConverter
{
static void Main()
{
Console.WriteLine("Please select the convertor direction");
Console.WriteLine("1. From Celsius to Fahrenheit.");
Console.WriteLine("2. From Fahrenheit to Celsius.");
Console.Write(":");

string selection = Console.ReadLine();
double F, C = 0;
switch (selection)
{
case "1":
Console.Write("Please enter the Celsius temperature: ");
F = TemperatureConverter.CelsiusToFahrenheit(Console.ReadLine());
Console.WriteLine("Temperature in Fahrenheit: {0:F2}", F);
break;
case "2":
Console.Write("Please enter the Fahrenheit temperature: ");
C = TemperatureConverter.FahrenheitToCelsius(Console.ReadLine());
Console.WriteLine("Temperature in Celsius: {0:F2}", C);
break;
default:
Console.WriteLine("Please select a convertor.");
break;
}
// Keep the console window open in debug mode.
Console.WriteLine("Press any key to exit.");
Console.ReadKey();
}
}
/* Example Output:
Please select the convertor direction
1. From Celsius to Fahrenheit.
2. From Fahrenheit to Celsius.
:2
Please enter the Fahrenheit temperature: 20
Temperature in Celsius: -6.67
Press any key to exit.
*/

The following list provides the main features of a static class:
- Contains only static members.
- Cannot be instantiated.
- Is sealed.
- Cannot contain Instance Constructors.
There are few limitations for static classes
- It can only contain static members (members explicitly marked with keyword ‘static’)
- It can not be instantiated
- It is sealed by default (i.e., it can not be inherited)
- It can not contain a constructor (although it may have a static constructor)

The static classes might be useful when we want a class which can not be instantiated or which should only be initiated once (Singleton class).
We may achieve the same functionality by declaring all members in ordinary class as static and making its constructor private. But when using
static classes, compiler ensures that none of the member of its members is non-static (i.e., all members are static).

2. What is static member?
Ans.A non-static class can contain static methods, fields, properties, or events. The static member is callable on a class even when no instance of the class has been created. The static member is always accessed by the class name, not the instance name. Only one copy of a static member exists, regardless of how many instances of the class are created. Static methods and properties cannot access non-static fields and events in their containing type, and they cannot access an instance variable of any object unless it is explicitly passed in a method parameter.

It is more typical to declare a non-static class with some static members, than to declare an entire class as static. Two common uses of static fields are to keep a count of the number of objects that have been instantiated, or to store a value that must be shared among all instances.

Static methods can be overloaded but not overridden, because they belong to the class, and not to any instance of the class.

Although a field cannot be declared as static const, a const field is essentially static in its behavior. It belongs to the type, not to instances of the type. Therefore, const fields can be accessed by using the same ClassName.MemberName notation that is used for static fields. No object instance is required.

C# does not support static local variables (variables that are declared in method scope).

You declare static class members by using the static keyword before the return type of the member, as shown in the following example:

public class Automobile
{
public static int NumberOfWheels = 4;
public static int SizeOfGasTank
{
get
{
return 15;
}
}
public static void Drive() { }
public static event EventType RunOutOfGas;

// Other non-static fields and properties...
}
Static members are initialized before the static member is accessed for the first time and before the static constructor, if there is one, is called. To access a static class member, use the name of the class instead of a variable name to specify the location of the member, as shown in the following example:
Automobile.Drive();
int i = Automobile.NumberOfWheels;

If your class contains static fields, provide a static constructor that initializes them when the class is loaded.

A call to a static method generates a call instruction in Microsoft intermediate language (MSIL), whereas a call to an instance method generates a callvirt instruction, which also checks for a null object references. However, most of the time the performance difference between the two is not significant.

The C# provides a special type of constructor known as static constructor to initialize the static data members when the class is loaded at first. Remember
that, just like any other static member functions, static constructors can't access non-static data members directly.

The name of a static constructor must be the name of the class and even they don't have any return type. The keyword static is used to differentiate the
static constructor from the normal constructors. The static constructor can't take any arguments. That means there is only one form of static constructor,
without any arguments. In other way it is not possible to overload a static constructor.

We can't use any access modifiers along with a static constructor.

// C# static constructor
// Author: rajeshvs@msn.com
using System;
class MyClass
{
public static int x;
public static int y;
static MyClass ()
{
x = 100;
Y = 200;
}
}
class MyClient
{
public static void Main()
{
Console.WriteLine("{0},{1},{2}",MyClass.x,MyClass.y);
}
}

Note that static constructor is called when the class is loaded at the first time. However we can't predict the exact time and order of static constructor
execution. They are called before an instance of the class is created, before a static member is called and before the static constructor of the derived class
is called.

3. What is static function?
Ans.A static function is another term for a static method. It allows you to execute the function without creating an instance of its defining class.
They are similar to global functions. An example of a static function could be: ConvertFromFarenheitToCelsius with a signature as follows:

public static double ConvertFromFarenheitToCelsius (string valToConvert)
{
//add code here
}
Inside a C# class, member functions can also be declared as static. But a static member function can access only other static members. They can access non-static
members only through an instance of the class.

We can invoke a static member only through the name of the class. In C#, static members can't invoked through an object of the class as like in C++ or JAVA.
// C#:static & non-static
// Author: rajeshvs@msn.com
using System;
class MyClass
{
private static int x = 20;
private static int y = 40;
public static void Method()
{
Console.WriteLine("{0},{1}",x,y);
}
}
class MyClient
{
public static void Main()
{
MyClass.Method();
}
}

4. What is static constructor?
Ans.A static constructor has a similar function as a normal constructor i.e. it is automatically called the first time a class is loaded. The differences between
a conventional constructor are that it cannot be overloaded, cannot have any parameters nor have any access modifiers and must be preceded by the
keyword static. In addition, a class with a static constructor may only have static members.

5. How can we inherit a static variable?
6. How can we inherit a static member?
Ans. of 5 & 6
When inheriting static members there is no need to instantiate the defining class using the ‘new’ keyword.

public class MyBaseClass
{
MyBaseClass()
{
}
public static void PrintName()
{
}

}

public class MyDerivedClass : MyBaseClass
{
MyDerivedClass ()
{
}

public void DoSomething()
{
MyBaseClass.GetName();
}

}

7. Can we use a static function with a non-static variable?
Ans.No.
8. How can we access static variable?
Ans.
By employing the use of a static member field as follows:
public class CashSales
{
//declare static member field
private static int maxUnitsAllowed = 50;

//declare method to return maximum number of units allowed

public static int GetMaxUnitsAllowed ()
{
Return maxUnitsAllowed;
}

}
The static field can now be accessed by simply doing CashSales.GetMaxUnitsAllowed(). No need to create an instance of the class.

9. Why main function is static?
Ans.Because it is automatically loaded by the CLR and initialised by the runtime when the class is first loaded. If it wasn’t static an instance of
the class would first need to be created and initialised.

10. How will you load dynamic assembly? How will create assesblies at run time?
Ans.
Load assembly:
By using classes from the System.Reflection namespace.
Assembly x = Assembly.LoadFrom( “LoadMe.dll” );

Create assembly;
Use classes from System.CodeDom.Compiler;

11. What is Reflection?
Ans.The System.Reflection namespace provides us with a series of classes that allow us to interrogate the codebase at run-time and perform functions
such as dynamically load assemblies, return property info e.t.c.

12. If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) in my application?
Ans.The version number is stored in the following format: …. The assembly manifest can then contain a reference to which version number we want to use.

13. How do you create threading in.NET? What is the namespace for that?
Ans.
System.Threading;

//create new thread using the thread class’s constructor

Thread myThread = new Thread(new ThreadStart (someFunction));

14. What do you mean by Serialize and MarshalByRef?
Ans.
Serialization is the act of saving the state of an object so that it can be recreated (i.e deserialized) at a later date.
The MarshalByRef class is part of the System.Runtime.Remoting namespace and enables us to access and use objects that reside in different application
domains. It is the base class for objects that need to communicate across application domains. MarshalByRef objects are accessed directly within their own
application domain by using a proxy to communicate. With MarshalByValue the a copy of the entire object is passed across the application domain

15. What is the difference between Array and LinkedList?
Ans.An array is a collection of the same type. The size of the array is fixed in its declaration.
A linked list is similar to an array but it doesn’t have a limited size.

16. What is Asynchronous call and how it can be implemented using delegates?
Ans.
A synchronous call will wait for a method to complete before program flow is resumed. With an asynchronous call the program flow continues whilst the method executes.

//create object
SomeFunction objFunc = new SomeFunction();

//create delegate
SomeDelegate objDel = new SomeDelegate(objFunc.FunctionA);

//invoke the method asynchronously (use interface IAsyncResult)
IAsyncResult asynchCall = SomeDelegate.Invoke();

17. How to create events for a control? What is custom events? How to create it?
Ans.
An event is a mechanism used in a class that can be used to provide a notification when something interesting happens. (typical evens in a windows application
include: change text in textbox, double click or click a button, select an item in dropdown box).
A custom event is an event created by the user that other developers can use. For example assuming that we have a CashTransaction class and we have a bank
balance property in that class. We may want to set-up an event that provides a notification when the bank balance drops below a certain amount. In order to
produce an event the process would be roughly as follows:
Create the class for the event derived from EventArgs.
Create a delegate with a return type of void.
Create a class containing the method that will activate the event.
Create a class with methods to handle the event.

18. If you want to write your own dot net language, what steps you will you take care?
Ans.We will need to ensure that the high level code is compiled to MSIL (Microsoft intermediate language) so that it can be interpreted by the CLR.

19. Describe the diffeerence between inline and code behind - which is best in a loosely coupled solution?
Ans.
The term ‘code behind’ refers to application code that is not embedded within the ASPX page and is separated out into a separate file which is then referenced
from the ASPX page. Inline code is the traditional ASP architectural model where business logic code was embedded within the ASP page. Separating the business
logic code from the presentation layer offers several advantages:
1) It allows graphic designers and web developers to work on the presentation layer whilst the application developers concentrate on the business logic.
2) The codebehind file is compiled as a single dll increasing the efficiency of the application,
3) The codebehind model offers a true OO development platform,
4) It speeds up development time as it allows developers to fully maximise the features of the .NET framework such as Cahing, ViewState, Session, Smart Navigation etc.
5) Code is much easier to maintain and susceptible for change.
6) The compiler and VS.NET provides much better support for error checking, intellisense and debugging when using the code behind model.

20. How dot net compiled code will become platform independent?
Ans.
The raison d’etre for .NET was to cater for multiples languages on a single windows platform whereas the aim of Java was to be a single language on multiple
platforms. The only way that .NET can be platform independent is if there is a version of the .NET framework installed on the target machine.

21. Without modifying source code if we compile again, will it be generated MSIL again?
Ans.No.

22. How does you handle this COM components developed in other programming languages in.NET?
Ans.
use TlbImp.exe to import the COM types into your .NET project. If no type library for the COM component then use System.Runtime.InteropServices
use RegAsm.exe to call a .NET developed component in a COM application.

23. How CCW (Com Callable Wrapper) and RCW (Runtime Callable Wrappers) works?
Ans.
CCW: When a COM application calls a NET object the CLR creates the CCW as a proxy since the COM application is unable to directly access the .NET object.
RCW: When a .NET application calls a COM object the CLR creates the RCW as a proxy since the .NET application is unable to directly access the .COM object.

24. What are the new thee features of COM+ services, which are not there in COM (MTS)?
Ans.
Role based security.
Neutral apartment threading.
New environment called context which defines the execution environment

25. What are the differences between COM architecture and.NET architecture?
Ans.
.Net architecture has superseded the old COM architecture providing a flexible rapid application development environment which can be used to create windows,
web and console applications and web services. .NET provides a powerful development environment that can be used to create objects in any .NET compliant language.
.NET addresses the previous problems of dll hell with COM by providing strongly named assemblies and side-by-side execution where two assemblies with the same name can run on the same box.

26. Can we copy a COM dll to GAC folder?
Ans.
No. It only stores .NET assemblies.

27. What is Shared and Repeatable Inheritance?
Ans.

28. Can you explain what inheritance is and an example of when you might use it?
Ans.
Inheritance is a fundamental feature of any OO language. It allows us to inherit the members and attributes from a base class to a new derived class. This
leads to increased code reusability and also makes applications easier to develop, maintain and extend as the new derived class can contain new features not
available in the base class whilst at the same time preserving the attributes inherited from the base class.

29. How can you write a class to restrict that only one object of this class can be created (Singleton class)?
Ans.
Use the singleton design pattern.
public sealed class Singleton
{
static readonly Singleton Instance=new Singleton();

static Singleton()
{
}

Singleton()
{
}

public static Singleton Instance
{
get
{
return Instance;
}
}
}

30. What are virtual destructures?
Ans.
A constructor can not be virtual but a destructor may. Use virtual destructors when you want to implement polymorphic tearing down of an object.

31. What is close method? How its different from Finalize and Dispose?
Ans.
finalise is the process that allows the garbage collector to clean up any unmanaged resources before it is destroyed.
The finalise method can not be called directly; it is automatically called by the CLR. In order to allow more control over the release of unmanaged resources
the .NET framework provides a dispose method which unlike finalise can be called directly by code.
Close method is same as dispose. It was added as a convenience.

32. What is Boxing and UnBoxing?
Ans.
Boxing is the process of converting a value type to a reference type. More specifically it involves encapsulating a copy of the object and moving it from
stack to heap. Unboxing is the reverse process.

33. What is check/uncheck?
Ans.
checked: used to enable overflow checking for arithmetic and conversion functions.
unchecked: used to disable overflow checking for arithmetic and conversion functions

34. What is the use of base keyword? Tell me a practical example for base keyword’s usage?
Ans.
The base keyword is used to access members of the base class from within a derived class:
* Call a method on the base class that has been overridden by another method.
* Specify which base-class constructor should be called when creating instances of the derived class.

A base class access is permitted only in a constructor, an instance method, or an instance property accessor.
It is an error to use the base keyword from within a static method.
Example:In this example, both the base class, Person, and the derived class, Employee, have a method named Getinfo. By using the base keyword,
it is possible to call the Getinfo method on the base class, from within the derived class.
// keywords_base.cs
// Accessing base class members
using System;
public class Person
{
protected string ssn = "444-55-6666";
protected string name = "John L. Malgraine";

public virtual void GetInfo()
{
Console.WriteLine("Name: {0}", name);
Console.WriteLine("SSN: {0}", ssn);
}
}
class Employee: Person
{
public string id = "ABC567EFG";

public override void GetInfo()
{
// Calling the base class GetInfo method:
base.GetInfo();
Console.WriteLine("Employee ID: {0}", id);
}
}

class TestClass {
public static void Main()
{
Employee E = new Employee();
E.GetInfo();
}
}

35. What are the different.NET tools which you used in projects?
Ans:Just read your question once again and thought Interviewer might be asking about the development tool you have used to develop ASP.NET projects.
So your answer can be Visual Studio 2005 or 2008 or 2010 whatever you have used, you may also tell Visual Web Developer or any other tool you might
have used to develop your ASP.NET Projects

Remaining answers coming soon
36. What will do to avoid prior case?
37. What happens when you try to update data in a dataset in.NET while the record is already deleted in SQL Server as backend?
38. What is concurrency? How will you avoid concurrency when dealing with dataset?
39. One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid this problem?
40. How do you merge two datasets into the third dataset in a simple manner?
41. If you are executing these statements in commandObject.Select * from Table1; Select * from Table2? How you will deal result set?
42. How do you sort a dataset.
43. If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
44. What is the use of Parameter object?
45. How to generateXML from a dataset and vice versa?
46. How do you implement locking concept for dataset?
47. How will you do Redo and Undo in TextBox control?
48. How to implement DataGrid in.NET? How would you make a combo-box appear in one column of a DataGrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for DataGrid methods. what is the access specifier used for that methods in the code behind file and why?
49. How can we create Tree control in asp.NET?
50. Write a program in C# to find the angle between the hours and minutes in a clock?
51. Write a program to create a user control with name and surname as data members and login as method and also the code to call it.
52. How can you read 3rd line from a text file?
53. Explain the code behind wors and contrast that using the inline style.
54. Explain different types of HTML, Web and server controls.
55. What are the differences between user control and server control?
56. How server form post-back works?
57. Can the action attribute of a server-side
tag be set to a value and if not how can you possibly pass data from a form page to a subsequent page?
58. How would ASP and ASP.NET apps run at the same time on the same server?
59. What are good ADO.NET object to replace to ADO Recordset object.
60. Explain the differences between Server-side code and Client-side code.
61. What type of code(server or client) is found in a Code-Behind class?
62. Should validation (did the user enter a real date) occur server-side or client-side? Why?
63. What does the EnableViewState property do? Why would I want it on or off?
64. What is the difference between Server.Transfer and response.Redirect? Why?
65. Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced.NET component?
66. Let’s say I have an existing application written using VB6 and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to.NET?
67. If I am developing an application that must accomodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?
68. What are ASP.NET web forms? How is this technology different than what is available though ASP(1.0-3.0)?
69. How does VB.NET achieve polymorphism?
70. How does C# achieve polymorphism?
71. Can you explain what is Inheritance and an example in VB.NET and C# of when you might use it?
72. Describe difference between inline and code-behind?
73. What is loosely coupled solution in.NET?
74. What is diffgram?
75. Where would you use an iHTTPModule and what are the limitations of any approach you might take in implementing one?
76. What are the Advantages and DisAdvantages of viewstate?
77. Describe session handling in a webform, how does it work and what are the limitations?
78. How would you get ASP.NET running in Apache web servers? Explain it’s limitations.
79. What is MSIL and why should my developers need an appreciation of it if at all?
80. Which methos do you invoke on the DataAdapter control to load your generated dataset with data?
81. Can you edit data in Repeater control? How?
82. Which template must you provide, in order to display data in a Repeater control?
83. How can you provide an alternating color scheme in a Repeater control?
84. What property must you set, and what method must you call in your code, in order to bind the data from some data source to the repeater control?
85. What base class do all web forms inherit from?
86. What method do you use to explicitly kill a user’s session? How?
87. How do you turn off cookies for one page in your site? Give an example.
88. Which two properties are on every validation control?
89. What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.
90. How do you create a permanent cookie?
91. What tag do you use to add a hyperlink column to the dataGrid?
92. What is the standard you use to wrap up a call to a Web Service?
93. Which method do you use to redirect the user to another page without performing a round trip to the client? How?
94. What is the transport protocol you use to call a Seb Service SOAP?
95. What does WSDL stand for?
96. What property do you have to set to tell the grid which page to go to when using the Pager object?
97. Where on the Internet would you look for Web Services?
98. What tags do you need to add within the asp:datagrid tags to bind columns manually? How?
99. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
100. How is a property designated as read-only?
101. Which control would you use if you needed to make sure the values in two different controls matched?
102.How do you manage session in ASP and ASP.NET
103.How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
104.What are different authentication types. How do you retreive user id in case of windows authentication
105.For a server control, you need to have same properties like color maxlength, size,and allowed character throughout the application. How do you handle this.
106.What is custom control. What is the difference between custom control and user control
107 What is the syntax for datagrid and specifying columns
108. How do you add a javascript function for a link button in a datagrid.
109. Does C# supports multi-dimensional arrays
110 How to transpose rows into columns and columns into rows in a multi-dimensional array
111.What are object oriented concepts
112. How do you create multiple inheritance in C#
113. ADO and ADO.NET differences
114. Features and disadvantages of dataset
115. What is the difference between and ActiveX dll and control
116. How do you perform validations
117. What is reflection and disadvantages of reflection
118. What is boxing and how it is done internally
119 Types of authentications in IIS
120. What are the security issues if we send a query from the application
121. Difference between ByVal and ByRef
122. Disadvantages of COM components
123. How do we invoke queries from the application
124. What is the provider and namespaces being used to access oracle database
125. How do you load XML document and perform validation of the document
126. How do you access elements in XML document
127. What is ODP.NET
128. Types of session management in ASP.NET
129. Difference between datareader and dataset
130. What are the steps in connecting to database
131. How do you register a .NET assembly
132. Usage of web.config
133. About remoting and web services. Difference between them
134. Caching techniques in .NET
135. About CLS and CTS
136. Is overloading possible in web services
137. Difference between .NET and previous version
138. Types of chaching. How to implement caching
139. Features in ASP.NET
140. How do you do validations. Whether client-side or server-side validations are better
141. How do you implement multiple inheritance in .NET
142. Difference between multi-level and multiple inheritance
143. Difference between dataset and datareader
144. What are runtime hosts
145. What is an application domain
146. What is viewstate
147. About CLR, reflection and assemblies
148. Difference between .NET components and COM components
149. What does assemblyinfo.cs consists
150. Types of objects in ASP
151. Difference between VB dll and assemblies in .NET
152. What is machine.config and web.config
153. Tell about WSDL
154. About web methods and its various attributes
155. What is manifest
156. Types of caching
157. What does connection string consists of
158. Where do you store connection string
159. What is the difference between session state and session variables
160. How do you pass session values from one page to another
161. What are WSDL ports
162. What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET
163. What is abstract class
164. What is difference between interface inheritance and class inheritance
165. What are the collection classes
166. Which namespace is used for encryption
167. What are the various authentication mechanisms in ASP.NET
168. What is the difference between authentication and autherization
169. What are the types of threading models
170. How do you send an XML document from client to server
171. How do you create dlls in .NET
172. What is inetermediate language in .NET
173. Write steps of retrieving data using ado.net
174. Call a stored procedure from ado.net and pass parameter to it
175. Different type of validation controls in asp.net
176. Difference between server.Execute and response.redirect What is Response.Flush method
177. How Response.flush works in server.Execute
178. What is the need of clinet side and server side validation
179. Tell About Global.asax
180. What is application variable and when it is initialized
181. Tell About Web.config
182. Can we write one page in c# and other in vb in one application
183. When web.config is called
184. How many web.config a application can have
185. How do you set language in web.cofig
186. Rate yourself in vb and com
187. Whether I have any specific technology in mind to work on
188. About types of indexes in SQL server
189. Difference between writing SQL query and stored procedure
190. About DTS usage
191. How do you optimize Sql queries
192. What is SOAP and why it is required
193. Any disadvantages in Dataset and in reflection
194. Difference between Active Exe and Activex dll
195. Can we make activex dll also ti execute in some process as that of client ? How can we do?
196. Types of compatabilities and explain them
197. Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default
198. What is assembly?
199. Difference between COM and .NET component
200. What is early binding and Late binding. Difference which is better
201. What happens when we instantiate a COM component
202. What happens when we instantiate a .NET component
203. Are you aware of containment and Aggregation
204. What is UUID and GUID what is the size of this ID?
205. About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each
206. What ‘ll u do in early and late binding
207. In early binding will the method invoked on com component will verify it’s existance in the system or not?
208. Difference between dynamic query and static query
209. About performance issues on retrieving records
210. About ADO and its objects
211. What is unmannaged code and will CLR handle this kind of code or not .
212. Garbage collector’s functionality on unmanaged code
213. If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
214. Threading Types.
215. How about the security in Activex DLL and Activex EXE
216. Define .NET architecture
217. Where does ADO.NET and XML web services come in the architecture
218. What is MSIL code
219. Types of JIT and what is econo-JIT
220. What is CTS, CLS and CLR
221. Uses of CLR
222. Difference between ASP and ASP.NET
223. What are webservices, its attributes. Where they are available
224. What is UDDI and how to register a web service
225. Without UDDI, is it possible to access a remote web service
226. How a web service is exposed to outside world
227. What is boxing and unboxing
228. What is WSDL and disco file
229. What is web.config and machine.config
230. What is difference between ASP and ASP.NET
231. What is dataset and uses of dataset
232. What does ADO.NET consists of?
233.What are various authentication mechanisms in ASP.NET
234. What do you mean by passport authentication and windows authentication
235. What is an assembly and what does manifest consists
236. What is strong name and what is the purpose of strong name
237. What are various types of assemblies
238. Difference between VB.NET and C#. Which is faster
239. Types of caching
240. How WSDL is stored
241. What is the key feature of ADO.NET compared to ADO
242. How does dataset acts in a disconnected fashion
243. Does the following statement executes successfully:
Response.Write(value of i = + i);
244. What is ODP.NET
245. What are the providers available with VS.NET
246. What is a process
247. What is binding in web service
248. How a proxy is generated for a web service
249. About delegates
250. What are static assemblies and dynamic assemlies. Differences between them
251. Rate yourself in .NET and SQL
252. About 5 processes
253. About current project and your role
254. What is caching and types of caching
255. What does VS.NET contains
256. What is JIT, what are types of JITS and their pupose
257. What is SOAP, UDDI and WSDL
258. What is dataset
259. Types of threading models in VB.net
260. Types of compatability in VB and their usage
261. Difference between CDATA and PCDATA in XML
262. What is Assync in XML api which version of XML parser u worked with
263. Types of ASP objects
264. Difference between application and session
265. What is web application virtual directory
266. Can two web application share a session and application variable
267. If i have a page where i create an instance of a dll and without invoking any method can I send values to next page
268. Diffeernce between Active Exe and /Dll
269. Can the dictionary object be created in client’s ccope?
270. About MTS and it’s purpose
271. About writting a query and SP which is better
272. I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the
clent’s code
273. How do you do multithreading application in VB
274. About Global .asax
275. Connection pooling in MTS
276. If cookies is disabled in clinet browser will session work
277. About XLST
278. How do you attach an XSL to an XML in presenting output
279. What is XML
280. How do you make your site SSL enabled
281. Did you work on IIS adminisdtration
282. About response.buffer and repsonse.flush
283. About dataset and data mining
284. About SOAP
285. Usage of htmlencode and urlencode
286. Usage of server variables
287. How to find the client browser type
288. How do you trap errors in ASP and how do you invoke a component in ASP

Thanks & Regards
Santosh

How to add comma in a int or decimal value

2010-09-01T23:28:00.000-07:00

This code show how to add comma into int or decimal value.Suppose we have a value 33000
and want to display this 33,000.00.

string FirstP = "";
string SecP = "";
string Finalstr = "";
int MyValue = Convert.ToInt32(Projected);
string myStr = MyValue.ToString();
int Length = myStr.Length;
string dc = ".00";

do
{
FirstP = myStr.Substring(0, Length - 3);
SecP = myStr.Substring(Length - 3, 3);
Finalstr = "," + SecP + Finalstr;
myStr = FirstP;
Length = myStr.Length;
}
while (Length > 3);

if (myStr == "")
{
Finalstr = Finalstr.Substring(1, Finalstr.Length);
}
else
{
Finalstr = myStr + Finalstr + dc;
}

lblSalary.Text = Finalstr.ToString();

ASP.NET Validation Controls with example

2010-09-01T22:38:00.000-07:00

Learning Technique for freshers : R3C2

1.RequiredFieldValidation Control
2.RangeValidator Control
3.RegularExpressionValidator Control
4.CompareValidator Control
5.CustomValidator Control

Properties of Validation Controls.

ControlToValidate - Id of control Which you want to validate.
ErrorMessage - Message that will be displayed in the validation summary.
IsValid - Whether or not the control is valid.
Validate - Method to validate the input control and update the IsValid property.
Display - How the error message will display.options are given below
None:Message is never displayed.
Static:Validation message will display in the page layout.
Dynamic:Validation message is dynamically added to the page if validation fails.

Example with code:

1.RequiredFieldValidation:It is simple validation control which checks data is entered or not.

<asp:textbox id="txtEmpName" runat="server"/>
<asp:RequiredFieldValidator id="rfvtxtbox" runat="server" ControlToValidate="txtEmpName"
ErrorMessage="* Please enter the employee name" Display="dynamic">*
</asp:RequiredFieldValidator>

2.RangeValidator:It checks to see if a control value is within a valid range or not.

<asp:textbox id="txtDOB" runat="server"/>
<asp:RangeValidator id="rangeVal" runat="server"
ControlToValidate="txtDOB1"
MaximumValue="12/06/2009"
MinimumValue="01/01/1983"
Type="Date"
ErrorMessage="* Please enter the valid date" Display="static">*</asp:RangeValidator>

3.RegularExpressionValidator:It can be used for email validation or any specified string based on pattern matching.

E-mail: <asp:textbox id="txtEmail" runat="server"/>
<asp:RegularExpressionValidator id="revemail" runat="server"
ControlToValidate="txtEmail"
ValidationExpression=".*@.*\..*"
ErrorMessage="* Please enter valid e-mail ."
display="dynamic">*
</asp:RegularExpressionValidator>

4.CompareValidator: It allows you to make comparisons between two form controls and also compare values contained with
these controls to constants that specified by userd.

New Password: <asp:textbox id="txtNewPass" runat="server"/><br />
Confirm Passowrd: <asp:textbox id="txtConfirmPass" runat="server"/><br />
<asp:CompareValidator id="valCompare" runat="server"
ControlToValidate="txtNewPass" ControlToCompare="txtConfirmPass"
Operator="Equals"
ErrorMessage="* New Password and confirm password are not same"
Display="dynamic">*
</asp:CompareValidator>

5.CustomValidator:It allows you to write your own server-side or client-side validations logic and it can be easily applied to your web forms controls.

<asp:CustomValidator ID="cv" runat="server"
ControlToValidate="txtName" ClientValidationFunction="customvalidationr"
ErrorMessage="Please enter correct name"></asp:CustomValidator>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<asp:Button ID="btnSubmit" runat="server" />

Client side javascript

<script type="text/javascript">
function customvalidation(oSrc,args)
{

write your code here
}
</script>

Free Download Software

2010-09-01T22:15:00.000-07:00

Adobe acrobat reader (http://okular.kde.org/download.phd)
Adobe pagemaker Scribus(http://www.scribus.net/)
Adobe photoshop CinePaint (http://www.cinepaint.org/)
Dream Weaver KompoZer (http://www.kompozer.org)
Fhontografer FontForge (http://fontforge.sourceforge.net/)
Microsoft FrontPage Quanta Plus (http://quanta.kdewebdev.org/)
Microsoft Office OpenOffice (http://openoffice.org/)
Microsoft outlook Express Thunderbird (http://www.mozillamessaging.com/enUS/thunderbird/)
Microsoft Project kplato (http://koffice.org/kplato/)
MSN Messenger Pidgin (http://pidgin.im)
Nero Burning Rom X-CD-Roast (http://www.xcdroast.org/)
Winamp auidence (http://audacious-media-player.org/Main_Page)
Window Media player KPlayer (http://kplayer.sourceforge.net/)
VLC Player (http://www.videolan.org/vlc/)
Winzip (http://www.7-zip.org)

General HR questions

2010-09-01T09:10:00.000-07:00

1. Tell about yourself and job
2. Tell about current project
3. What are sequence diagrams, collaboration diagrams and difference between them
4. What is your role in the current project and what kinds of responsibilites you are handling
5. What is the team size and how do you ensure quality of code
6. What is the S/W model used in the project. What are the optimization techniques used. Give examples.
7. What are the SDLC phases you have invloved
8. About educational background
9. About work experience
10. About area of work
11. Current salary, why are looking for a change and about notice period About company strength, verticals, clients, domains etc.
12. Rate yourself in different areas of .NET and SQL
13. About procsses followed
14. Notice period
15. Appraisal process
16. About effort estimation
17. Whether salary negotiable
18. Why are looking for a change
19. How fo you appraise a person
20. Do you think CMM process takes time
21. About peer reviews
22. About educational background, work experience, and area of work

Thanks & Regards
Santosh

Project related questions

2010-09-01T09:08:00.000-07:00

1.Tell about your current project
2. Tell about your role
3. What is the toughest situation you faced in the development
4. How often you communicate with the client
5. For what purposes, you communicate with the client
6. What is the process followed
7. Explain complete process followed for the development
8. What is the life cycle model used for the development
9. How do communicate with team members
10. How do you say you are having excellent team management skills
11. If your client gives a change and asks for early delivery. How will you manage.
12.How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
13. What is the stage when code is delivered to the client and he is testing it.
14. What are the different phases of SDLC
15. How do you handle change requests
16. How do you perform impact analysis
17. How do you write unit test cases.
18. About current project architecture

Thanks & Regards
Santosh

Errors and solution

2010-09-01T05:25:00.000-07:00

Errors and their solutions:

1.The IListSource does not contain any data sources:
Sol:parameter mismatch does not match from stored procedure which you passing from .net

2.Procedure or Function 'genInstituteMaster_SelectDelete' expects parameter '@Select', which was not supplied.
Sol: Parameter mismatch check in c# code passing parameter.

3.No overload for method 'GetInstitute' takes '3' arguments
Sol: check your calling mathod parameter not match.

4.Parameter count does not match Parameter Value count.
Sol: Check parameter both .net and sp

5.A field or property with the name 'CountryName' was not found on the selected data source.
Sol: In grid you have field but in not table

4.EXECUTE permission denied on object 'usp_login', database 'Database', schema 'dbo'
Please check your database user roles.
It's necessary the database user to be owner.
What you should instead do, is grant the user the following Roles:

- aspnet_Membership_FullAccess
- aspnet_Roles_FullAccess
- etc. depending on what features you have enabled/installed into this database

Do this by using Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express

1. Connect to the database you are working with
2. Open Databases
3. Open the database you are working with
4. Open Security
5. Open Users
6. Double-click the user who is accessing the database
7. In the list of Owned Schemas, check off the roles indicated above

5.A network-related or instance-specific error occurred while establishing a connection to SQL Server
Things to check:
1. Make sure your database engine is configured to accept remote connections
Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
Click on Surface Area Configuration for Services and Connections
Select the instance that is having a problem > Database Engine > Remote Connections
Enable local and remote connections
Restart instance

2. Check the SQL Server service account
If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this
first before proceeding
3. If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings in your ASweb P.NET application
Usually the format needed to specify the database server is machinename\instancename
Check your connection string as well

Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=60;Connect Timeout=30? providerName=System.Data.SqlClient/>

4.You may need to create an exception on the firewall for the SQL Server instance and port you are using
Start > Run > Firewall.cpl
Click on exceptions tab
Add the sqlservr.exe (typically located in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.x\MSSQL\Binn), and port (default is 1433)
Check your connection string as well
5. If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings
6. Check SQLBrowser; check that it is running. You may also need to create an exception in your firewall for SQLBrowser.
7. Check that you have connectivity to the SQL Server. Note what you are using to connect: machine name, domain name or IP address? Use
this when checking connectivity. For example if you are using myserver
Start > Run > cmd
netstat -ano| findstr 1433
telnet myserver 1433
ping -a myserver

8.CS1061: 'System.Web.UI.WebControls.TextBox' does not contain a definition for 'Value' and no extension method 'Value' accepting a first argument
of type 'System.Web.UI.WebControls.TextBox' could be found (are you missing a using directive or an assembly reference?)
Sol:You have take a textbox control in page but assign textbox.value in cs code. Use Textbox.Text
9.DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Company'.
Sol: Check the GridView columns and select query which you are using for bind GridView.Columns should be same in both place

Thanks & Regards
Santosh

How to handle OnActiveTabChanged event of AJAX Tab control

2010-09-01T05:09:00.001-07:00

This Articles explian how to handle ActiveTabChanged Event of AJAX TabControl in asp.net.

ActiveTabIndex="0" BorderStyle="None" Width="742px" BorderWidth="0" OnActiveTabChanged="tbcRatingMaster_ActiveTabChanged"
AutoPostBack="True">

protected void tbcRatingMaster_ActiveTabChanged(object sender, EventArgs e)
{
if (tbcRatingMaster.ActiveTabIndex == 0)
{
//AddGrpBind();
btnSaveRG.Text = "Save";
txtGroup.Text = "";
txtGroup.Text = "";
}
if (tbcRatingMaster.ActiveTabIndex == 1)
{
txtItem.Text = "";
}
if (tbcRatingMaster.ActiveTabIndex == 2)
{
rbtnType.SelectedValue = "P";
gvRating.Visible = false;
txtItem.Text = "";
txtGroup.Text = "";
}
}

Thanks & Regards
Santosh Singh

Page Life Cycle of an ASP.NET

2010-09-01T03:01:00.000-07:00

The life cycle starts when a user requests a web page through his/her browser. The Web server than process the page through a sequence of steps before response is sent back to the user's browser. The steps are as:

1. Page Request
2. Start
3. Page Initialization
4. Load
5. Validation
6. PostBack Event Handling
7. Render
8. Unload

Page Request
The page request occurs before the page life cycle begins. When a user requests the page, ASP.NET determines whether the page needs to be parsed and compiled (therefore beginning the life of a page), or whether a cached version of the page can be sent in response without running the page.

Start
In the start step, page properties such as Request and Response are set. At this stage, the page also determines whether the request is a postback or a new request and sets the IsPostBack property. Additionally, during the start step, the page's UICulture property is set.

Page Initialization
During page initialization, controls on the page are available and each control's UniqueID are generated but not their properties. Any themes are also applied to the page.

Developers have access to the Init, InitComplete and PreLoad methods in this stage. The methods are as follows:

* Init: This event is raised after all controls have been initialized and any skin settings have been applied. This event is used to read or initialize control properties.
* InitComplete: The Page object raises this event. This event is used for processing tasks that require completion of all initialization.
* PreLoad: Use this event if you need to perform processing on your page or control before the Load event. After the Page raises this event, it loads view state for itself and all controls, and then processes any postback data included with the Request instance.

Load
During load, if the current request is a postback, control properties are loaded with information recovered from view state and control state. The OnLoad event method is fired during this stage.
This is where you will want to set properties for all of the server controls on your page, request query strings, and establish database connections.

Validation
During validation, the Validate method of all validator controls is called, which sets the IsValid property of individual validator controls and of the page.

PostBack Event Handling
If the request is a postback, any event handlers are called. The event handling for server controls occurs during this stage.

Render
During rendering, view state is saved to the page and then the page calls on each control to contribute its rendered output to the OutputStream of the page's Response property. Render is not really an event. The HTML of the page and all controls are sent to the browser for rendering.

Unload
Unload is called when the page has been fully rendered, sent to the client, and is ready to be discarded. At this point, page properties such as Response and Request are unloaded and any cleanup is performed. The cleanup includes routines such as closing database connections and file streams, or, event logging and other tasks.

Conclusion
When a Web page is requested, the server creates objects associated with the page and all of its child controls objects and uses these to render the page to the browser. Once the final stage is complete, the web server destroys these objects, to free up resource to handle additional request.

Insert record in database using stored procedure in asp.net

2010-09-01T01:19:00.000-07:00

In this article am explaining very simpe thing insert record in database using stored procedure,that will very help full for entry level programmer.

web.config

 <connectionStrings>  
      <add name="conString" connectionString="Data Source=.\SQLEXPRESS; database=Northwind;Integrated Security=true"/>:  
 </connectionStrings>

Used Stored procedure
CREATE PROCEDURE [dbo].[AddUser]
(
@FName varchar(50),
@LName varchar(50),
@DateOfBirth datetime,
@City varchar(50),
@State varchar(50)
)
AS
BEGIN

SET NOCOUNT ON;
INSERT INTO UserDetails (FName, LName, DateOfBirth, City, State)
VALUES (@FName, @LName, @DateOfBirth, @City, @State)
END

C# code

 String ConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;  
 SqlConnection con = new SqlConnection(ConnString);  
 SqlCommand cmd = new SqlCommand();  
 cmd.CommandType = CommandType.StoredProcedure;  
 cmd.CommandText = "AddUser";  
 cmd.Parameters.Add("@FName",SqlDbType.VarChar).Value = txtFName.Text.Trim();  
 cmd.Parameters.Add("@LName", SqlDbType.VarChar).Value = txtLName.Text.Trim();  
 cmd.Parameters.Add("@DateOfBirth", SqlDbType.DateTime).Value = txtDOB.Text.Trim();  
 cmd.Parameters.Add("@City", SqlDbType.VarChar).Value = txtCity.Text.Trim();  
 cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = txtState.Text.Trim();  
 cmd.Connection = con;  
 try  
 {  
      con.Open();  
      cmd.ExecuteNonQuery();  
      lblMessage.Text = "Record inserted successfully";  
 }  
 catch (Exception ex)  
 {  
      throw ex;  
 }  
 finally  
 {  
      con.Close();  
      con.Dispose();  
 }

Website Deployment

2010-08-31T05:38:00.001-07:00

Internet Information Services is used to make your computer a web server. If we want to have a web server for developing dynamic website or want to publish
website on our own server then we install the IIS.Internet Information Server (IIS) is a World Wide Web server, a Gopher server and an FTP server all rolled
into one. IIS means that you can publish WWW pages.
If you want to your web application accessible to any other pc in intranet or internet you need to IIS.

Below are steps for deployment:
1.Right click your website and click on Publish website.All compiles files are ready for deployment.
2.Create a backup for database whichever you are using and restore it on production server.
3.Go to server using ftp or filezila copy all compiles file on server.
4.Open Webconfig and change the connection string according to your Database name and server.
5.Create a virtual directory for this website.
6.Your website is ready.
7.Test website http://192.163.0.234(ServerName)/VDName/Login.aspx

Thanks & Regards
Santosh

Difference Between .net framework 2.0,3.0 and 3.5

2010-08-31T02:30:00.000-07:00

NET framework 2.0:

It brings a lot of evolution in class of the framework and refactor control including the support of

Generics
Anonymous methods
Partial class
Nullable type
The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more
Full 64-bit support for both the x64 and the IA64 hardware platforms
New personalization features for ASP.NET, such as support for themes, skins and webparts.
.NET Micro Framework

.NET framework 3.0:

Also called WinFX,includes a new set of managed code APIs that are an integral part of Windows Vista and Windows Server 2008 operating systems and provides

Windows Communication Foundation (WCF), formerly called Indigo; a service-oriented messaging system which allows programs to interoperate locally or remotely similar to web services.
Windows Presentation Foundation (WPF), formerly called Avalon; a new user interface subsystem and API based on XML and vector graphics, which uses 3D computer graphics hardware and Direct3D technologies.
Windows Workflow Foundation (WF) allows for building of task automation and integrated transactions using workflows.
Windows CardSpace, formerly called InfoCard; a software component which securely stores a person's digital identities and provides a unified interface for choosing the identity for a particular transaction, such as logging in to a website

.NET framework 3.5:

It implement Linq evolution in language. So we have the folowing evolution in class:

Linq for SQL, XML, Dataset, Object
Addin system
p2p base class
Active directory
ASP.NET Ajax
Anonymous types with static type inference
Paging support for ADO.NET
ADO.NET synchronization API to synchronize local caches and server side datastores
Asynchronous network I/O API
Support for HTTP pipelining and syndication feeds.
New System.CodeDom namespace.

String Manupulation

2010-08-29T04:47:00.000-07:00

i have a string like "a,b,c. upto n values"..
Show this string like
a,
b,
C

Sol
string str = "a,b,c";
string[] arr = str.Split(',');
foreach (string s in arr)
{
Response.Write(s + ",
");
}

GridView Edit:on clicking edit a new page should be open where user can update data

2010-08-28T05:09:00.000-07:00

On clicking edit in GridView a new page should be open where user can update data. In this article i am explaining how to update record using GridView.When User Click edit button in GridView new page will be open where user can update record.in second page i have just find the data not wrriten the code for update.
Here also i have written code for delete record in GridView and if GridView has no record show message no record found.

public void GridViewBind()
{
using (SqlConnection conn = new SqlConnection(conStr))
{
DataSet ds = SqlHelper.ExecuteDataset(conn, "LeaveMaster_Select");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
protected void ImgDelete_Click(object sender, ImageClickEventArgs e)
{
ImageButton img = (ImageButton)sender;
Label Leave = img.FindControl("Label1") as Label;
using (SqlConnection conn = new SqlConnection(conStr))
{
conn.Open();
using (SqlTransaction t = conn.BeginTransaction())
{
try
{
exceptionMessage.Text = SqlHelper.ExecuteScalar(t, "LeaveMaster_Delete", Leave.Text, "", 'D').ToString();
t.Commit();
GridViewBind();
}
catch
{
t.Rollback();
}
}
conn.Close();
}
}
protected void ImgbtnDetails_Click(object sender, ImageClickEventArgs e)
{
//Selecting a Record from Grid For Updation..
ImageButton aspSender = sender as ImageButton;
Label lblId = aspSender.FindControl("lblLeaveID") as Label;
Response.Redirect("~/LeaveDetails.aspx?Id=" + lblId.Text + "");
}

===========
2nd page

if (Request.QueryString["Id"] != null)
{

Id = Convert.ToInt32(Request.QueryString["Id"].ToString());
string str = "SELECT LeaveCode, LeaveDesc, LeaveId FROM LeaveMaster WHERE (LeaveId = "+Id+")";
DataTable dt1 = SqlHelper.ExecuteDataset(conStr, CommandType.Text, str).Tables[0];
txtCode.Text = dt1.Rows[0]["LeaveCode"].ToString();
txtCode.Enabled = false;
txtShortName.Text = dt1.Rows[0]["LeaveDesc"].ToString();
txtShortName.Enabled = false;
}

aspx Page

<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="LeaveId"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
Width="700px"
PageSize="10" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" >
<Columns>
<asp:TemplateField HeaderText="LeaveId" InsertVisible="False" SortExpression="LeaveId"
Visible="False">
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("LeaveId") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("LeaveId") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="LeaveCode" HeaderText="Leave Code" SortExpression="LeaveCode" />
<asp:BoundField DataField="LeaveShortDesc" HeaderText="Short Desc" SortExpression="LeaveShortDesc" />
<asp:BoundField DataField="LeaveLongDesc" HeaderText="Long Desc" SortExpression="LeaveLongDesc" />
<asp:CommandField ButtonType="Image" HeaderText="Edit" SelectImageUrl="~/Image/img_edit.png"
ShowSelectButton="True">
<ItemStyle HorizontalAlign="Center" />
</asp:CommandField>
<asp:TemplateField HeaderText="Details">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="40px" />
<ItemTemplate>
<asp:ImageButton ID="ImgbtnDetails" runat="server"
OnClick="ImgbtnDetails_Click" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:ImageButton ID="imgbtnDelete" runat="server"
OnClick="ImgDelete_Click" OnClientClick="return ConfirmDelete();" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>No record found !</EmptyDataTemplate>
</asp:GridView>

Thanks & Regards
Santosh

Send mail using asp.net c# code

2010-08-27T09:01:00.000-07:00

Send mail using asp.net c# code
This code describe how to send mail where mail id is stored in database and mail sender detail From,To,are stored in web.config file.Mail body can be customized according to requirement as described in code.

 public void MailSend()  
 {  
      try  
      {  
           string mailToAdd = String.Empty;  
           MailMessage message1 = new MailMessage();  
           string strMail;  
           SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["SqlConnString"]);  
           SqlDataReader dr;  
           conn.Open();  
           SqlCommand cmd = new SqlCommand("usp_MediaRegistration", conn);  
           dr = cmd.ExecuteReader();  
           while (dr.Read())  
           {  
                strMail = (string)dr["emailID"];  
                message1.IsBodyHtml = true;   
                string MailFrom = ConfigurationManager.AppSettings["from"].ToString();  
                message1.From = new MailAddress(MailFrom);  
                message1.To.Add(new MailAddress(strMail).ToString());  
                message1.Subject = "Headline of the press release";  
                if (Request.QueryString["strmail"] == "0")  
                {  
                     message1.Body = "<html><body><table><tr><td>Dear Users,</td></tr><br/>" +  
                     "<tr><td><t/>This is to inform you that ...your message. <br/>" +  
                     "<tr><td><t/>Please click on the link to see details....: <br/>" +  
                     "<tr><td><a href='" + "http://xyz.com/mediapage.aspx?year=" + drlMyyyy.SelectedItem.Value  
                     + "'>" + "http://xyz.com/mediapage.aspx?year=" + drddMyyyy.SelectedItem.Value +  
                     "</a></td></tr><br/>" +  
                     "<tr><td>Thanks & Reagrds,</td></tr>" +  
                     "<tr><td>santosh singh</td></tr> </table></body></html>";  
                }  
           }  
           SmtpClient client = new SmtpClient(ConfigurationManager.AppSettings["SmtpHost"]);  
           client.Send(message1);  
      }  
      catch (Exception ex)  
      {  
           string str1 = string.Format("Message Sending Fail Due To {0}.", ex.Message);  
      }  
 }

Thanks & Regards
Santosh Singh

Resize image in ASP.NET

2010-08-25T02:43:00.000-07:00

In this example i am going to describe how to resize image in ASP.NET before/and upload to ms sql database using C# and Vb.NET.

For this i am using FileUpload control to upload the image in datbase after resizing.
I am also displaying the Image in Gridviw after uploading to database.

 public partial class _Default : System.Web.UI.Page   
 {  
      protected void Page_Load(object sender, EventArgs e)  
      {  
      }  
      protected void btnUpload_Click(object sender, EventArgs e)  
      {  
           string strImageName = txtName.Text.ToString();  
           if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")  
           {  
                string strExtension = System.IO.Path.GetExtension(FileUpload1.FileName);  
                if ((strExtension.ToUpper() == ".JPG") | (strExtension.ToUpper() == ".GIF"))  
                {  
                     // Resize Image Before Uploading to DataBase  
                     System.Drawing.Image imageToBeResized = System.Drawing.Image.FromStream(FileUpload1.PostedFile.InputStream);  
                     int imageHeight = imageToBeResized.Height;  
                     int imageWidth = imageToBeResized.Width;  
                     int maxHeight = 240;  
                     int maxWidth = 320;  
                     imageHeight = (imageHeight * maxWidth) / imageWidth;  
                     imageWidth = maxWidth;  
                     if (imageHeight > maxHeight)  
                     {  
                          imageWidth = (imageWidth * maxHeight) / imageHeight;  
                          imageHeight = maxHeight;  
                     }  
                     Bitmap bitmap = new Bitmap(imageToBeResized, imageWidth, imageHeight);  
                     System.IO.MemoryStream stream = new MemoryStream();  
                     bitmap.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);  
                     stream.Position = 0;  
                     byte[] image = new byte[stream.Length + 1];  
                     stream.Read(image, 0, image.Length);  
                     // Create SQL Connection   
                     SqlConnection con = new SqlConnection();  
                     con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;  
                     // Create SQL Command   
                     SqlCommand cmd = new SqlCommand();  
                     cmd.CommandText = "INSERT INTO Images(ImageName,Image) VALUES (@ImageName,@Image)";  
                     cmd.CommandType = CommandType.Text;  
                     cmd.Connection = con;  
                     SqlParameter ImageName = new SqlParameter("@ImageName", SqlDbType.VarChar, 50);  
                     ImageName.Value = strImageName.ToString();  
                     cmd.Parameters.Add(ImageName);  
                     SqlParameter UploadedImage = new SqlParameter("@Image", SqlDbType.Image, image.Length);  
                     UploadedImage.Value = image;  
                     cmd.Parameters.Add(UploadedImage);  
                     con.Open();  
                     int result = cmd.ExecuteNonQuery();  
                     con.Close();  
                     if (result > 0)  
                     lblMessage.Text = "File Uploaded";  
                     GridView1.DataBind();  
                }  
           }  
      }  
 }

aspx code

 <form id="form1" runat="server">  
      <div>  
      <asp:TextBox ID="txtName" runat="server"></asp:TextBox>  
      <asp:FileUpload ID="FileUpload1" runat="server" /><br />  
      <br />  
      <asp:Button ID="btnUpload" runat="server" OnClick="btnUpload_Click" Text="Upload" />  
      <asp:Label ID="lblMessage" runat="server"</asp:Label>  
      <asp:GridView ID="GridView1" runat="server"     AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">  
           <Columns>  
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />  
                <asp:BoundField DataField="ImageName" HeaderText="ImageName" SortExpression="ImageName" />  
                <asp:TemplateField HeaderText="Image">  
                     <ItemTemplate>  
                          <asp:Image ID="Image1" runat="server" ImageUrl='<%# "Handler.ashx?ID=" + Eval("ID")%>'/>  
                     </ItemTemplate>  
                </asp:TemplateField>  
           </Columns>  
      </asp:GridView>  
      <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [ID], [ImageName], [Image]   
         FROM [Images]">  
   </asp:SqlDataSource>  
 </form>

Thanks & Regards
Santosh

ViewState And Session example

2010-08-24T00:30:00.002-07:00

Hi,

View state is used for store data at page level,you cant access View state data to another page.
Session state is used for store data and you can access anywhere in your website.
Session state is state specific information per client basis.

Example is given below.

View State:

 protected void btnSubmit_Click(object sender, EventArgs e)  
 {   
      ViewState["DataScorceName"] = datasource;  
      ViewState["ClientName"] = txtCustomer.Text;  
 }  
 //Retrieve viewstate information  
 txtCname.Text = ViewState["ClientName"]  
 Store information in Session State:  
 Session["EmpName"] = txtUser.Text;  
 //Retrieve session value in 2nd page  
 lblEmp.Text = Session["UserName"].ToString();

Thanks & Regards
Santosh Singh

How to create connection string dynamically

2010-08-24T00:30:00.001-07:00

Here i am using viewstate to create connection string at run time.

 protected void btnSubmit_Click(object sender, EventArgs e)  
 {   
      ViewState["DataScorceName"] = datasource;  
      ViewState["Customer"] = txtCustomer.Text;  
 }  
 public void MyFunction()  
 {   
      string sqlConnectionString = "Persist Security Info=True;User ID=sa;Password=Sa;Initial Catalog=" + DBName + ";Data Source='" + ViewState["DataScorceName"] + "'";  
 }

How to reverse a string

2010-08-24T00:29:00.003-07:00

 char [] myArray = txtName.Text.ToCharArray();  
 Array.Reverse( myArray );  
 string strReversed = new string( myArray );  
 lblName.Text = strReversed;

how to use Sql server Function

2010-08-24T00:29:00.001-07:00

Sql server Function With Arguments

here it is simple example how to use function n sql server.
1.Create function
2.use this function where required.

CREATE FUNCTION AddTwoNumber(@Num1 Decimal(6,2),
@Num2 Decimal(6,2))
RETURNS Decimal(6,2)
BEGIN
DECLARE @Result Decimal(6,2)
SET @Result = @Num1 + @Num2
RETURN @Result
END;
GO

PRINT MyDbName.dbo.AddTwoNumber(100, 200);

Sp for Creating db

2010-08-24T00:28:00.003-07:00

Stored procedure for creating database.
When you want to create database at run time using c# .net here is stored procedure execute this and pass database name as parameter.

Create proc [dbo].[usp_Database]
(
@dbName varchar(50)
)
as

IF NOT EXISTS (SELECT 'True' FROM INFORMATION_SCHEMA.SCHEMATA WHERE CATALOG_NAME = @dbName)
-- DROP DATABASE ' + @dbName + '

DECLARE @device_directory NVARCHAR(520)
SELECT @device_directory = SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
FROM sys.database_files
WHERE (name = N'master')

EXECUTE (N'CREATE DATABASE ' + @dbName + '
ON
(NAME = ' + @dbName + ',
FILENAME = ''' + @device_directory + '' + @dbName + '.mdf'',
SIZE = 50MB,
MAXSIZE = 125MB,
FILEGROWTH = 10MB)
LOG ON
(NAME = ''NorthwindBulkLog'',
FILENAME = ''' + @device_directory + '' + @dbName + '.ldf'',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB)')

SetFocus to TextBox in GridView control

2010-08-24T00:28:00.001-07:00

How to set focus in a GridView

Set Focus to TextBox in GridView when click on Edit Some time we have requirement to set focus in gridview,so here i am describing to how to this.
Drag and drop a gridview and bind it according to below code.

 protected void GridViewBind()  
 {  
      try  
      {  
           Ds = obBLLclass.GetData();  
           if (Ds.Tables[0].Rows.Count > 0)  
           {  
                gridview.DataSource = Ds;  
                gridview.DataBind();  
           }   
      }  
      catch (Exception ex)  
      {  
           Message.Text = ex.Message;  
      }  
 }  
 protected void gridview_RowEditing(object sender, GridViewEditEventArgs e)  
 {  
      gridview.EditIndex = e.NewEditIndex;  
      GridViewBind();  
      gridview.Rows[e.NewEditIndex].FindControl("txtname").Focus();  
 }  
 protected void gridview_PageIndexChanging(object sender, GridViewPageEventArgs e)  
 {  
      gridview.PageIndex = e.NewPageIndex;  
      GridViewBind();  
 }

Thanks & Regards
Santosh Singh

How to insert excel file into sql database in ASP.NET

2010-08-24T00:25:00.002-07:00

Import EXCEL sheet data to SQL Database table in ASP.NET
Here I will explain how to read excel file data and insert into in sql server database.

 protected void btnupload_Click(object sender, EventArgs e)   
 {  
      String excelConnectionString1;   
      String fname = sendupload.PostedFile.FileName;   
      if (sendupload.PostedFile.FileName.EndsWith(".xls"))   
      {   
           String excelsheet;   
           sendupload.SaveAs(Server.MapPath("~/Image/" + sendupload.FileName));   
           if (sendupload.PostedFile.FileName.EndsWith(".xls"))   
           {  
                excelConnectionString1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/ExcelFiles/" + sendupload.FileName) + ";Extended Properties=Excel 8.0";   
                OleDbConnection myEcelConnection1 = new OleDbConnection(excelConnectionString1);   
                myEcelConnection1.Open();   
                if (txtsheet.Text.Length == 0)   
                {   
                     lblmsg.Text = "Please Write File Name";   
                }   
                else   
                {   
                     excelsheet = "[" + txtsheet.Text + "$" + "]";   
                     string sheet = "Select * from [" + txtsheet.Text + "$" + "]";   
                     OleDbCommand cmd1 = new OleDbCommand(sheet, myEcelConnection1);   
                     cmd1.CommandType = CommandType.Text;   
                     OleDbDataAdapter myAdapter1 = new OleDbDataAdapter(cmd1);   
                     DataSet myDataSet1 = new DataSet();   
                     myAdapter1.Fill(myDataSet1);   
                     int a = myDataSet1.Tables[0].Rows.Count - 1;   
                     string name;   
                     string id;   
                     string cls;   
                     string num;   
                     for (int i = 0; i <= a; i++)   
                     {   
                          name = myDataSet1.Tables[0].Rows[i].ItemArray[0].ToString();   
                          id = myDataSet1.Tables[0].Rows[i].ItemArray[1].ToString();   
                          cls = myDataSet1.Tables[0].Rows[i].ItemArray[2].ToString();   
                          num = myDataSet1.Tables[0].Rows[i].ItemArray[3].ToString();  
                          SqlConnection con = new SqlConnection(constr);   
                          con.Open();   
                          SqlCommand command = new SqlCommand("Insert into StudentDetails(StudentName,CivilIdNumber,Class,StudentID)values(@valname,@valids,@valcls,@valnum)", con);   
                          command.Parameters.Add("@valname", SqlDbType.VarChar, 50).Value = name;   
                          command.Parameters.Add("@valids", SqlDbType.VarChar, 50).Value = id;   
                          command.Parameters.Add("@valcls", SqlDbType.VarChar, 50).Value = cls;   
                          command.Parameters.Add("@valnum", SqlDbType.VarChar, 50).Value = num;   
                          command.CommandType = CommandType.Text;   
                          SqlDataAdapter da = new SqlDataAdapter(command);   
                          DataSet ds = new DataSet();   
                          da.Fill(ds);   
                          con.Close();  
                     }   
                }   
           }   
      }   
 }

.aspx page

 <table width="100%">   
      <tr>   
           <td colspan="3"> <span style="font-family: Segoe UI"> File Upload</span> </td>   
      </tr>   
      <tr>   
           <td colspan="3">   
           <asp:FileUpload ID="sendupload" runat="server" /> </td>   
      </tr>   
      <tr>   
           <td colspan="3">   
           <span style="font-family: Segoe UI"> Sheet Name: </span>   
           <asp:TextBox ID="txtsheet" runat="server"> </asp:TextBox>   
           <asp:Label ID="lblmsg" runat="server"> </asp:Label>   
           </td>   
      </tr>   
      <tr>   
           <td> <asp:Button ID="btnupload" runat="server" Text="Upload" OnClick="btnupload_Click" /> </td>   
      </tr>   
 </table>

Thanks & Regards
Santosh

Open Popup Wnidow With QueryString asp.net C#

2010-08-24T00:23:00.001-07:00

How to open pop window using asp.net c#.
Here code descibes how to open popup window with passing a query string in popup page.

string popup = "<script language='javascript'>" + "window.open('poppage.aspx?data=" + HttpUtility.UrlEncode(qs.ToString()) + "','CustomPopUp', " + "'fullscreen=no,height=330,width=350,top=250,left=250,scrollbars=yes, dependant = yes, alwaysRaised = yes, menubar=no,resizable=no')" + "</script>";
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "PopupScript", popup,false);

If you want only popup message code is given below.
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(),"MyMessage","alert('Please enter!')", true);

Thanks & Regards
Santosh

Nested GridView in asp.net

2010-08-24T00:22:00.004-07:00

Gridview within another gridview

this exmaple show how we can nest gridview within gridview for disply related data from database.Gridview can be nested in other Gridview control to display the related data of any item retrieved from database using C# code.

Steps:
1. Drag & drop a gridview in to the page.
2. Add a new template column to this gridview.
3. Place another gridview inside this template column.

<asp:GridView ID="GridView2" runat="server" EnableTheming="False" PageSize="15" Width="700px"
OnPageIndexChanging="GridView2_PageIndexChanging" OnRowDataBound="GridView2_RowDataBound"
AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="Employee Details">
<ItemTemplate>
<table>
<tr>
<td>
Company Name </td>
<td>
:</td>
<td colspan="4">
<asp:Label ID="lblCompany" runat="server" Text='<%# Bind("Company") %>'></asp:Label></td>
</tr>
<tr>
<td>
Date</td>
<td>
:</td>
<td colspan="4">
<asp:Label ID="lblDate" runat="server">
</tr>
<tr>
<td colspan="6">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" EnableTheming="False"
PageSize="10" Width="100%" OnPageIndexChanging="GridView1_PageIndexChanging"
OnRowDataBound="GridView1_RowDataBound" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="User Name" HeaderText="Name">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="LoanName" HeaderText="Loan">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="Show Name" HeaderText="Payroll Month">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="PDate" HeaderText="Paid Date">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="OpeningBalance" HeaderText="Open Date">
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>
<asp:BoundField DataField="PaidAmount" HeaderText="Amt. Paid">
<ItemStyle HorizontalAlign="Right" >
</asp:BoundField>
</Columns>
<RowStyle CssClass="reporttext" />
<EmptyDataTemplate>
<strong><span style="font-size: 10pt;">No Records....!</span> </strong>
</EmptyDataTemplate>
<PagerStyle CssClass="reportheader" />
<HeaderStyle CssClass="reportheader" Width="80px" />
<AlternatingRowStyle CssClass="reporttext" />
</asp:GridView>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

.cs code
protected void FirstGridBind()
{
DataTable dt1DataTable = new DataTable();
dt1.Columns.Add("CompanyName");
DataRow drDataRow = dt1DataTable.NewRow();
if (ddlCompany.SelectedValue != "0")
{
drDataRow["CompanyName"] = ddlCompany.SelectedItem.Text;
}
else
{
drDataRow["CompanyName"] = "All Companies";
}
dt1DataTable.Rows.Add(drDataRow);
GridView2.DataSource = dt1DataTable;
GridView2.DataBind();
}
protected void SecondGridBind()
{
foreach (GridViewRow row in GridView2.Rows)
{
Label lblDate = row.FindControl("lblDate") as Label;
if (txtFromDate.Text.Trim() != "" && txtToDate.Text.Trim() != "")
{
lblDate.Text = txtFromDate.Text.Trim() + " - " + txtToDate.Text.Trim();
}
else
{
lblDate.Text = "All Dates";
}
GridView GridView1 = row.FindControl("GridView1") as GridView;

string str = @"SELECT You query;

if (ddlCompany.SelectedValue != "0")
{
str += " AND (hrdEmployeeMaster.CompanyId = " + Convert.ToInt32(ddlCompany.SelectedValue) + ")";
}
DataTable dt = SqlHelper.ExecuteDataset(connString, CommandType.Text, str).Tables[0];
Session["myDataTable"] = dt;
GridView1.DataSource = dt;
GridView1.DataBind();
if (GridView1.Rows.Count > 0)
{
lbExport.Visible = true;
}
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (GridView2.Rows.Count > 0)
{
GridView GridView1 = GridView2.Rows[0].FindControl("GridView1") as GridView;
e.Row.Cells[0].Text = Convert.ToString(GridView1.PageIndex * GridView1.PageSize + SrNo);
SrNo++;
}
}
}

Thanks & Regards
Santosh

JavaScript for textbox should be numeric

2010-08-24T00:22:00.001-07:00

JavaScript for textbox should be numeric

This example show validate a textbox value is numeric.When you enter a non nemeric value
in textbox popup message will display.
<asp:TextBox ID="txtMinExperience" onKeyUp="benumeric();" runat="server" MaxLength="50" TabIndex="4"
Width="50px">0</asp:TextBox>

<script language="javascript" type="text/javascript">
function benumeric()
{
var txtMin=document.getElementById('<%=txtMinExperience.ClientID%>');
if(isNaN(txtMin.value)== true)
{
alert("This Field Should Be Numeric.");
txtMin.focus();
txtMin.value="";
return false;
}
return true;
}
</script>

Thanks & Regards
Santosh

JavaScript validation for dropdownlist

2010-08-24T00:21:00.003-07:00

This example show how dropdownlist should be selected using javascript.

function validate()
{
var ddlCountry = document.getElementById('<%=ddlParameter.ClientID%>');
if(ddlCountry.value==0)
{
alert("Not Selected..!");
ddlParameter.focus();
return false;
}
return true;
}
Thanks & Regards
Santosh Singh

JavaScript form Validation in asp.net

2010-08-24T00:21:00.001-07:00

This simple code show how to do simple client side validation using javascript

Create a form with following:

1. Emp Name : <asp:TextBox ID="txtEmpName" />
2. Email : <asp:TextBox ID="txtEmailAdd" />
3. URL : <asp:TextBox ID="txturl" />
4. Zip : <asp:TextBox ID="txtZip" />

<asp:Button ID="btnAdd" OnClientClick=" return form_validate()" runat="server" Text="Submit" />

Write this javascript to your aspx page

<script language="javascript" type="text/javascript">
function form_validate()
{
if (document.getElementById("<%=txtEmpName.ClientID%>").value=="")
{
alert("Please enter the name");
document.getElementById("<%=txtEmpName.ClientID%>").focus();
return false;
}
if(document.getElementById("<txtEmailAdd.ClientID %>").value=="")
{
alert("Email id can not be blank");
document.getElementById("<%=txtEmailAdd.ClientID %>").focus();
return false;
}
var mailPattern = /^(\".*\"|[A-Za-z]\w*)@(\[\d{1,3}(\.\d{1,3}){3}]|[A-Za-z]\w*(\.[A-Za-z]\w*)+)$/;
var mailid=document.getElementById("<%=txtEmailAdd.ClientID %>").value;
var matchArr = mailid.match(mailPattern);
if (matchArr == null)
{
alert("Your email is incorrect.");
document.getElementById("<%=txtEmailAdd.ClientID %>").focus();
return false;
}
if(document.getElementById("<%=txturl.ClientID %>").value=="")
{
alert("Please enter URL");
document.getElementById("<%=txturl.ClientID %>").value="http://"
document.getElementById("<%=txturl.ClientID %>").focus();
return false;
}
var Url="^[A-Za-z]+://[A-Za-z0-9-_]+\\.[A-Za-z0-9-_%&\?\/.=]+$"
var tempURL=document.getElementById("<%=txturl.ClientID%>").value;
var matchURL=tempURL.match(Url);
if(matchURL==null)
{
alert("URL incorrect try again||");
document.getElementById("<%=txturl.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=txtZIP.ClientID%>").value=="")
{
alert("Zip Code not correct");
document.getElementById("<%=txtZIP.ClientID%>").focus();
return false;
}
var digits="0123456789";
var temp;
for (var i=0;i {
temp=document.getElementById("<%=txtZIP.ClientID%>").value.substring(i,i+1);
if (digits.indexOf(temp)==-1)
{
alert("Please enter correct zip code");
document.getElementById("<%=txtZIP.ClientID%>").focus();
return false;
}
}
return true;
}
</script>

Thanks & Regards
Santosh

HyperLinkink in Gridview

2010-08-24T00:19:00.003-07:00

Hyperlink column in Gridview
Here i am describing very simple code for how to use Hyperlink column in Gridview

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
Height="1px" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound"
Width="700px">
<Columns>
<asp:BoundField DataField="Designation" HeaderText="Designation">
</asp:BoundField>
<asp:BoundField DataField="ContactNo" HeaderText="Contact No.">
<ItemStyle Width="100px" />
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:HyperLinkField DataNavigateUrlFields="CandidateAppId" DataNavigateUrlFormatString="~/Salary/frmsalary.aspx?Id={0}"
HeaderText="Attach" Text="View">
<ItemStyle HorizontalAlign="Center" Width="50px" />
<HeaderStyle Width="50px" />
</asp:HyperLinkField>
<asp:TemplateField HeaderText="View">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
<HeaderStyle HorizontalAlign="Center" Width="50px" />
<ItemTemplate>
<asp:ImageButton ID="ImageView" runat="server" ImageUrl="~/Image/img.png"
OnClick="ImageView_Click" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
<HeaderStyle Width="50px" />
<ItemTemplate>
<asp:ImageButton ID="ImgDelete" runat="server" ImageUrl="~/Image/img.png"
OnClick="ImgDelete_Click" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

Thank & Regards
Santosh

How To Use Ajax

2010-08-24T00:19:00.001-07:00

Hi....
you can start with vs2008..
1.just download ajaxcontrolkit.dll
2.copy this dll in your bin folder.
3.add reference by right click on your website brouwse and add ajaxcontrolkit.dll
4.add a new tab in your tolbox right click on toolbox add new tab and load aajax controll from bin folder.
5.now can find all ajax control in your tolbox ready for use.

GridView ScrollBar

2010-08-24T00:18:00.001-07:00

How to make scrollable gridview.

<div style="overflow-y: scroll; height: 200px">
<asp:GridView ID="GridView1" runat="server" Font-Size="12px" BackColor="#FFFFFF"
GridLines="Both" CellPadding="4" Width="560">
<HeaderStyle BackColor="#EDEDED" Height="26px" />
</asp:GridView>
</div>

Thanks & Regards
Santosh

Add new row using GridView footer column

2010-08-24T00:16:00.001-07:00

Adding new record in database from Gridview footer row

Abstract:
Here we will discuss about to add new recored in database using Gridview footer column.
Just drag and drop a gridview in your page and follow the below code.This code in three tier application
so i am writing here only front end code.

<asp:GridView ID="gvStudentDetail" runat="server" DataKeyNames="StudentDetailId" AllowPaging="True" PageSize="12"
AutoGenerateColumns="False" OnPageIndexChanging="gvStudentDetail_PageIndexChanging"
OnRowDataBound="gvStudentDetail_RowDataBound" TabIndex="2" Width="697px" OnRowCancelingEdit="gvStudentDetail_RowCancelingEdit"
OnRowEditing="gvStudentDetail_RowEditing" OnRowUpdating="gvStudentDetail_RowUpdating"
ShowFooter="True" OnRowCommand="gvStudentDetail_RowCommand" OnRowDeleting="gvStudentDetail_RowDeleting">
<Columns>
<asp:TemplateField HeaderText="Sr. No">
<ItemTemplate>
<asp:Label ID="lblSrNo" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="StudentDetailId" Visible="False">
<ItemTemplate>
<asp:Label ID="lblStudentDetailId" runat="server" Text='<%# Bind("StudentDetailId") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lblFooterStudentDetailId" runat="server"></asp:Label>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="StudentDetail">
<ItemTemplate>
<asp:Label ID="lblStudentDetail" runat="server" Text='<%# Bind("StudentDetail") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtStudentDetail" runat="server" Text='<%# Bind("StudentDetail") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtNewStudentDetail" runat="server" Visible="false"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit">
<ItemTemplate>
<asp:ImageButton ID="ImgYes" runat="server" ImageUrl="~/Image/image_edit.png" CommandName="Edit" />
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
ImageUrl="~/Image/imageupdate.png" Text="Update" />
<asp:ImageButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
ImageUrl="~/Image/imagecancel.png" Text="Cancel" />
</EditItemTemplate>
<FooterTemplate>
<asp:ImageButton ID="ButtonAdd" runat="server" ImageUrl="~/Image/imagerow_add.png" CommandName="AddNew"
ToolTip="Add New Record" />
<asp:ImageButton ID="lbtnAdd" runat="server" CausesValidation="True" CommandName="Add"
ImageUrl="~/Image/imageadd.png" Visible="false" Text="Add" />
<asp:ImageButton ID="lbtnCancel" runat="server" CausesValidation="False" CommandName="Cancel"
ImageUrl="~/Image/imagecancel.png" Visible="false" Text="Cancel" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:ImageButton ID="ImgDelete" runat="server" ImageUrl="~/Image/image_delete.png"
CommandName="Delete" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

----------------------------------------------------------------------------------------
protected void GridViewStudentDetail()
{
try
{
Ds = objStudentDetailBLL.GetData();
if (Ds.Tables[0].Rows.Count > 0)
{
gvStudentDetail.DataSource = Ds;
gvStudentDetail.DataBind();
}
else
{
ShowNoResultFound(Ds.Tables[0], gvStudentDetail);
}
}
catch (Exception ex)
{
exceptionMessage.Text = ex.Message;
}
}
protected void gvStudentDetail_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblSrNo = (Label)e.Row.FindControl("lblSrNo");
lblSrNo.Text = SrNo.ToString();
SrNo++;
}
}
protected void gvStudentDetail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvStudentDetail.PageIndex = e.NewPageIndex;
GridViewStudentDetail();
}
protected void gvStudentDetail_RowEditing(object sender, GridViewEditEventArgs e)
{
StudentDetail.EditIndex = e.NewEditIndex;
GridViewStudentDetail();
}
protected void gvStudentDetail_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

objStudentDetail.StudentDetailId = Convert.ToInt32(((Label)gvStudentDetail.Rows[e.RowIndex].FindControl("lblStudentDetailId")).Text);
objStudentDetail.StudentDetail = Convert.ToString(((TextBox)gvStudentDetail.Rows[e.RowIndex].FindControl("txtStudentDetail")).Text);
try
{
int intResultUpdate = objStudentDetailBLL.Update(objStudentDetailDetail);
if (intResultUpdate > 0)
{
exception.Text = "Record Updated Successfully !";
gvStudentDetail.EditIndex = -1;
GridViewStudentDetail();
}
}
catch (Exception ee)
{
exception.Text = ee.Message.ToString();
}
finally
{
objStudentDetailBLL = null;
}

}
protected void gvStudentDetail_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvStudentDetail.EditIndex = -1;
GridViewStudentDetail();
}
protected void gvStudentDetail_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
objStudentDetail.StudentDetailId = (int)gvStudentDetail.DataKeys[e.RowIndex].Value;
int result = objStudentDetailBLL.Delete(objStudentDetailDetail);
if (result > 0)
{
exception.Text = "Record Deleted Successfully !";
gvStudentDetail.EditIndex = -1;
GridViewStudentDetail();
}
}
catch(Exception ex)
{
exceptionText = ex.Message.ToString();

}
}
protected void gvStudentDetail_RowCommand(object sender, GridViewCommandEventArgs e)
{
ImageButton lbtnAdd = (ImageButton)gvStudentDetail.FooterRow.FindControl("lbtnAdd");
ImageButton lbtnCancel = (ImageButton)gvStudentDetail.FooterRow.FindControl("lbtnCancel");
ImageButton ButtonAdd = (ImageButton)gvStudentDetail.FooterRow.FindControl("ButtonAdd");
ButtonAdd.Visible = false;

TextBox txtNewStudentDetail= (TextBox)gvStudentDetail.FooterRow.FindControl("txtNewStudentDetail");
txtNewStudentDetail.Visible = true;
lbtnCancel.Visible = true;
lbtnAdd.Visible = true;

objStudentDetailDetail.StudentDetail = Convert.ToString(((TextBox)gvStudentDetailFooterRow.FindControl("txtNewStudentDetail")).Text);

if (e.CommandName.Equals("Add"))
{
try
{
if (objStudentDetailDetail.StudentDetail == "")
{
exceptionText = "Please Enter the StudentDetail!!";
}
else
{
int intResultUpdate = objStudentDetailBLL.Insert(objStudentDetail);
if (intResultUpdate > 0)
{
exception.Text = "Record Added Successfully !";
StudentDetail.EditIndex = -1;
GridViewStudentDetail();
}
}
}
catch (Exception ee)
{
exceptionMessage.Text = ee.Message.ToString();
}
finally
{
objStudentDetailBLL = null;
}
}
}

AJAX Accordian Example

2010-08-23T23:04:00.001-07:00

<ajaxToolkit:Accordion ID="acdContactInfo" runat="server" SelectedIndex="0" FadeTransitions="true"
TransitionDuration="300" HeaderCssClass="accordHeader" ContentCssClass="accordionContent"
HeaderSelectedCssClass="accordHeaderSelected">
<Panes>
<ajaxToolkit:AccordionPane ID="empfirstAdd" runat="server" Width="100%">
<Header>>
First Address </Header>
<Content>
<table>
<tr>
<td colspan="4" style="text-align: left; height: 22px;">
<strong><span style="color: #999999">Present Address Details</span></strong>
</td>
<td style="width: 137px; text-align: left; height: 22px;">
</td>
<td style="text-align: left; height: 22px; width: 10px;">
</td>
<td style="width: 10px; height: 22px; text-align: left">
</td>
<td style="width: 187px; text-align: left; height: 22px;">
</td>
</tr>
<tr>
<td style="width: 204px; text-align: right; vertical-align: middle;" valign="top">
<strong>Address</strong>
</td>
<td style="width: 3px" valign="top">
<span style="color: #ff3333">*</span>
</td>
<td style="width: 3px" valign="top">
:
</td>
<td rowspan="3" style="width: 133px; text-align: left" valign="top">
<asp:TextBox ID="txtFAddress" runat="server" Height="53px" MaxLength="200"
TextMode="MultiLine" Width="200px"></asp:TextBox>
</td>
<td style="width: 137px; text-align: right; vertical-align: middle; height: 19px;"
valign="to">
<strong>Country</strong>
</td>
<td style="width: 10px; text-align: center; vertical-align: middle;" valign="top">
<span style="color: #ff3333">*</span>
</td>
<td style="vertical-align: middle; width: 10px; text-align: center" valign="top">
:
</td>
<td style="width: 187px; text-align: left" valign="top">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack="True" DataTextField="CountryName"
DataValueField="CountryId" Height="20px" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged"
Width="144px">
<asp:ListItem Text="<Select Country>" Value="0"></asp:ListItem>
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
</td>
</tr>
<tr>
<td style="width: 204px; text-align: left" valign="top">
</td>
<td style="width: 3px" valign="top">
</td>
<td style="width: 3px" valign="top">

</td>
<td style="width: 137px; text-align: right; vertical-align: middle; height: 19px;"
valign="top">
<strong>State</strong>
</td>
<td style="width: 10px; text-align: center; vertical-align: middle;" valign="top">
<span style="color: #ff3333">*</span>
</td>
<td style="vertical-align: middle; width: 10px; text-align: center" valign="top">
:
</td>
<td style="width: 187px; text-align: left" valign="top">
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="True" DataTextField="StateName"
DataValueField="StateId" Height="20px" OnSelectedIndexChanged="ddlState_SelectedIndexChanged"
Width="144px">
<asp:ListItem Text="<Select State>" Value="0"></asp:ListItem>
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
</td>
</tr>
<tr>
<td style="width: 204px; text-align: left; height: 19px;" valign="top">
</td>
<td style="width: 3px; height: 19px;" valign="top">
</td>
<td style="width: 3px; height: 19px;" valign="top">

</td>
<td style="width: 137px; text-align: right; vertical-align: middle; height: 19px;"
valign="top">
<strong>City</strong>
</td>
<td style="width: 10px; text-align: center; vertical-align: middle; height: 19px;"
valign="top">
<span style="color: #ff3333">*</span>
</td>
<td style="vertical-align: middle; width: 10px; height: 19px; text-align: center"
valign="top">
:
</td>
<td style="width: 200px; text-align: left; height: 19px;" valign="top">
<asp:DropDownList ID="ddlCity" runat="server" DataTextField="CityName" DataValueField="CityId"
Height="20px" Width="150px">
</asp:DropDownList>
</td>
</tr>
</table>
</Content>
</ajaxToolkit:AccordionPane>
<ajaxToolkit:AccordionPane ID="AccPaneEmpSecAdd" runat="server" Width="100%">
<Header>
Second Add</Header>
<Content>
<table>
<tr>
<td align="left" style="width: 204px; height: 16px; vertical-align: middle; text-align: right;">
<strong>Name</strong>
</td>
<td style="height: 16px; width: 2px;">
<span style="color: #ff3333">*</span>
</td>
<td style="width: 3px; height: 16px">
:
</td>
<td style="color: #000000; height: 24px" align="left">
<asp:TextBox ID="txtContName" runat="server" MaxLength="50" Width="188px"></asp:TextBox>
</td>
<td style="height: 19px; text-align: right; vertical-align: middle;">
<strong>Relation</strong>
</td>
<td style="width: 10px; height: 16px; text-align: left">
<span style="color: #ff3333">*</span>
</td>
<td style="width: 10px; height: 16px; text-align: left">
:
</td>
<td align="left" style="color: #000000; height: 24px">
<asp:DropDownList ID="ddlRelation" runat="server" Width="144px" DataTextField="Relation"
DataValueField="RelationId" Height="20px">
</asp:DropDownList>
</td>
<td style="width: 24px">
</td>
</tr>
</table>
</Content>
</ajaxToolkit:AccordionPane>
</Panes>
</ajaxToolkit:Accordion>

Thanks & Regards
Santosh

Simple GridView Bind code

2010-08-23T05:53:00.001-07:00

<asp:GridView ID="GridView1" runat="server"
AllowPaging="True"
AutoGenerateColumns="False"
OnPageIndexChanging="GridView1_PageIndexChanging"
OnRowDataBound="GridView1_RowDataBound"
PageSize="10"
Width="733px"
TabIndex="2";>
<Columns;>
<asp:BoundField HeaderText="Sr. No";>
<ItemStyle HorizontalAlign="Center" /;>
</asp:BoundField;>
<asp:TemplateField HeaderText="CityId" Visible="False";>
<EditItemTemplate;>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CityId") %>'></asp:TextBox;>
</EditItemTemplate;>
<ItemTemplate;>
<asp:Label ID="lblCityId" runat="server" Text='<%# Bind("CityId") %;>';></asp:Label;>
</ItemTemplate;>
</asp:TemplateField;>
<asp:BoundField DataField="CountryName" HeaderText="Country" /;>
<asp:BoundField DataField="StateName" HeaderText="State" /;>
</Columns;>

CS code...
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[0].Text = Convert.ToString(GridView1.PageIndex * GridView1.PageSize + SrNo);
SrNo++;
}
}
public void GridViewBind()
{
SqlConnection conn = new SqlConnection(connectionString);
Ds = SqlHelper.ExecuteDataset(myconn, "usp_CityMaster");
GridView1.DataSource = Ds;
GridView1.DataBind();
}
protected void gv_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
CityBind();
}

Thanks & Regards
Santosh Singh

GridView find control

2010-08-23T05:52:00.002-07:00

protected void ddlQty_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent;
DropDownList ddlQty = (DropDownList)gr.FindControl("ddlQty");
if (ddlQty != null)
{

Label lblPrice = (Label)gr.FindControl("lblPrice");
Label lblOriginalPrice = (Label)gr.FindControl("lblOriginalPrice");
int price = Convert.ToInt32(lblOriginalPrice.Text);
int NewPrice = price * Convert.ToInt16(ddlQty.SelectedValue);
lblPrice.Text = Convert.ToString(NewPrice);

}
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent;
DropDownList ddlQty = (DropDownList)gr.FindControl("ddlQty");
if (ddlQty != null)
{

Label lblPrice = (Label)gr.FindControl("lblPrice");
Label lblOriginalPrice = (Label)gr.FindControl("lblOriginalPrice");
int price = Convert.ToInt32(lblOriginalPrice.Text);
int NewPrice = price * Convert.ToInt16(ddlQty.SelectedValue);
lblPrice.Text = Convert.ToString(NewPrice);
}
}
Thanks & Regards
Santosh Singh

Enable textbox in gridview on click checkbox

2010-08-23T05:51:00.003-07:00

JavaScript

function callonclick(obj)
{

var sdt = obj.split("_");
var chkDeny=document.getElementById('ctl00_ContentPlaceHolder1_gv_'+sdt[3]+'_chkDeny');
var txtReason=document.getElementById('ctl00_ContentPlaceHolder1_gv_'+sdt[3]+'_txtReason');
if(chkDeny.checked)
{
txtReason.value="";
txtReason.disabled =false;
}
else
{
txtReason.value="Enter Reason";
txtReason.disabled =true;

}
}

On Aspx page

<asp:TemplateField HeaderText="Deny">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:CheckBox ID="chkDeny" runat="server" onclick="callonclick(this.id);" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="30px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Reason">
<EditItemTemplate>
<asp:TextBox ID="txtsan" runat="server" TextMode="MultiLine" Width="80px"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<table>
<tr>
<td valign="top">
</td>
<td>
<asp:TextBox ID="txtReason" runat="server" Height="40px" TextMode="MultiLine" Width="250px" Enabled="false">Enter Reason</asp:TextBox></td>
</tr>
</table>
<span style="font-size: 7pt"></span>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
==========================
Nother way Using cs code..

javascript

function StatusGridTextBox(txtReason)
{
document.getElementById(txtReason).disabled = !document.getElementById(txtReason).disabled;
}

on cs code

protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
{

if ((e.Row.RowType == DataControlRowType.DataRow))
{
((CheckBox)e.Row.FindControl("chkDeny")).Attributes.Add("onclick", "javascript:StatusGridTextBox('" + ((TextBox)e.Row.FindControl("txtReason")).ClientID + "')");
}

}

Thanks & Regards
Santosh

Deployment

2010-08-23T05:51:00.001-07:00

1.Right click your website and click on Publish website.All compiles files are ready for deployment.
2.Create a backup for database whichever you are using and restore it on production server.
3.Go to server using ftp or filezila copy all compiles file on server.
4.Open Webconfig and change the connection string according to your Database name and server.
5.Create a virtual directory for this website.
6.Your website is ready.
7.Test website http://192.163.0.234(ServerName)/VDName/Login.aspx

DataReader

2010-08-23T05:49:00.001-07:00

A DataReader is a read-only forward-only way of reading data. It is quiet fast when compared to fetching data using a DataSet.
Some important point:
Read-only access
Supports a single table based on a single SQL query of one database
Connected mode
Bind to a single control
Forward-only scanning of data
Faster access to data
Lightweight object with very little overhead
Must be manually coded

Code Sample:
SqlConnection myconn = new SqlConnection(connString);
SqlCommand mycomm = new SqlCommand("select * from emp", myconn);
mycomm.Connection.Open();
SqlDataReader dr =
mycomm.ExecuteReader(CommandBehavior.CloseConnection);
while(dr.Read())
{
Console.WriteLined(r.GetString(0));
}
dr.Close();
myconn.Close();

Thanks & Regards
Santosh

CSS For FieldSet control in asp.net

2010-08-23T05:47:00.003-07:00

.fldset
{
border: solid 1px #A8A8A8;
background-color:#FCFCFC;
display:inline;
}
.fldsetlegend
{
font-size:11px;
background-color: #56458C;
color:#FCFCFC;
font-weight:bold;
font-variant:small-caps;
padding: 0px 8px 2px 8px;
margin: 2px 0px 10px 0px;
}

Thanks & Regards
Santosh

CSS For AJAX Tab

2010-08-23T05:47:00.001-07:00

.AJAXTab_Theme .tab_header
{
font-family:"Helvetica Neue", Arial, Sans-Serif;
background:url(/PNG/Light-menu.png) repeat-x bottom;
height:20PX ;
font-size:12px;
display:block;
}
.AJAXTab_Theme .tab_header .tab_outer
{
background:url(/Images/Tab/tab.png) no-repeat left top;
border-color:#222;
color:#222;
padding-left:10px;
margin-right:3px;
}
.AJAXTab_Theme .tab_header .ajax__tab_inner
{
background:url(PNG/Dark-menu.png) no-repeat right top;
border-color:#666;
color:#0067CA;
font:bold 10pt verdana;
padding:3px 10px 2px 0px;
}
.AJAXTab_Theme .ajax__tab_hover .ajax__tab_inner
{
color:#B80200;
font:bold 10pt verdana;
}
.AJAXTab_Theme .ajax__tab_active .tab_outer
{
background:url(PNG/Dark-menu.png) no-repeat 0pt -40px;
border-bottom-color:#ffffff;
}
.AJAXTab_Theme .tab_active .tab_inner
{
background:url(PNG/Dark-menu.png) no-repeat right -40px;
color:#B80200;
font:bold 10pt verdana;
border-color:#333
}
.AJAXTab_Theme .tab_body
{
font-family:verdana,tahoma,helvetica;
font-size:10pt;
padding:8px;
background-color:#ffffff;
border:solid 1px #d7d7d7;
border-top-width:0;
}

Thank & Regards
Santosh

Create pdf from datatable

2010-08-23T05:46:00.001-07:00

How to create pdf from datatable in asp.net c#.
Solution is given below.

public void ExportToPdf(DataTable myDataTable)
{
Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);
try
{
PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
pdfDoc.Open();
Chunk c = new Chunk("" + System.Web.HttpContext.Current.Session["CompanyName"] + "", FontFactory.GetFont("Verdana", 11));
Paragraph p = new Paragraph();
p.Alignment = Element.ALIGN_CENTER;
p.Add(c);
pdfDoc.Add(p);

string clientLogo = System.Web.HttpContext.Current.Session["CompanyName"].ToString();
clientLogo = clientLogo.Replace(" ", "");
string clogo = clientLogo + ".jpg";

string imageFilePath = System.Web.HttpContext.Current.Server.MapPath("../ClientLogo/" + clogo + "");
iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath);
//Resize image depend upon your need
jpg.ScaleToFit(80f, 60f);
//Give space before image
jpg.SpacingBefore = 0f;
//Give some space after the image
jpg.SpacingAfter = 1f;
jpg.Alignment = Element.HEADER;
pdfDoc.Add(jpg);

Font font8 = FontFactory.GetFont("ARIAL", 7);
DataTable dt = myDataTable;
if (dt != null)
{
//Craete instance of the pdf table and set the number of column in that table
PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);
PdfPCell PdfPCell = null;

for (int rows = 0; rows < dt.Rows.Count; rows++)
{
for (int column = 0; column < dt.Columns.Count; column++)
{
PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), font8)));
PdfTable.AddCell(PdfPCell);
}
}
//PdfTable.SpacingBefore = 15f; // Give some space after the text or it may overlap the table
pdfDoc.Add(PdfTable); // add pdf table to the document
}
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf");
System.Web.HttpContext.Current.Response.Write(pdfDoc);

Response.Flush();
Response.End();
//HttpContext.Current.ApplicationInstance.CompleteRequest();
}
catch (DocumentException de)
{
System.Web.HttpContext.Current.Response.Write(de.Message);
}
catch (IOException ioEx)
{
System.Web.HttpContext.Current.Response.Write(ioEx.Message);
}
catch (Exception ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
}

Thanks & Regards
Santosh

Create autogenerate serial number in Gridview

2010-08-23T05:45:00.002-07:00

Auto Generate Serial Number In Gridview

The Given code auto generate serial number with page index changing.
Generate Dynamic Serial Number in GridView is coommon task for many programmer

Here i explain it in very simple way
1: Drag GridView in you asp.net web page.
2: Go to Gridview properties and Click on Columns than add Template Column.
3:Code is given below

<asp:GridView ID="gv" runat="server" DataKeyNames="Id">
<Columns>
<asp:TemplateField HeaderText="Sr. No">
<ItemTemplate>
<asp:Label ID="lblSrNo" runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpName">
<ItemTemplate>
<asp:Label ID="lblEmpName" runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
</Columns>
</asp:GridView>
.cs code
protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblSrNo = (Label)e.Row.FindControl("lblSrNo");
lblSrNo.Text = SrNo.ToString();
SrNo++;
int pageNum = gv.PageIndex * gv.PageSize + Sr;
e.Row.Cells[1].Text = pageNum.ToString();
}
}

Thanks & Regards
Santosh

How to check Record Exist in table before insert

2010-08-23T05:45:00.001-07:00

Here i am explain you check if record is not exist in database then insert otherwise update the table.

CREATE PROCEDURE [dbo].[uspInst_Addupdate]
(
@InstId int,
@Inst varchar(50),
)
AS
BEGIN
IF @InstId=0
BEGIN
IF NOT EXISTS(SELECT * FROM InstMaster WHERE Inst= @Inst)
INSERT INTO InstMaster(Inst) VALUES(@Inst)
END
ELSE
BEGIN
UPDATE InstMaster
SET Inst= @Inst WHERE (Inst= @Inst)
END
END

Thanks & Regards
Santosh

Change GridView RowColor

2010-08-23T05:44:00.001-07:00

How to change gridview row color and use css class.
Below code describe how to call css class at runtime for change the gridview row color.
protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string checkstatus= Convert.ToString(DataBinder.Eval(e.Row.DataItem,"checkstatus"));
if (checkstatus == "Pending")
{
e.Row.Cells[0].BackColor="css class";
}
else
{
e.Row.Cells[0].BackColor="css class";
}
}
}

Thanks & Regards
Santosh

How to change DateFormat

2010-08-23T05:31:00.001-07:00

string[] str = txtIssuedOnVisa.Text.Trim().Split('/');
string strIssuedOn = str[1].ToString() + "/" + str[0].ToString() + "/" + str[2].ToString();

Thanks & Regards
Santosh

Cascading Dropdownlist

2010-08-23T05:30:00.001-07:00

ASPX Page

<asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack="True" DataTextField="CountryName"
DataValueField="CountryId" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged";>
<asp:ListItem Value="0" Text="<Select Country;>";></asp:ListItem;>
</asp:DropDownList;>
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="True" DataTextField="StateName"
DataValueField="StateId" OnSelectedIndexChanged="ddlState_SelectedIndexChanged";>
</asp:DropDownList;>
<asp:DropDownList ID="ddlCity" runat="server" DataTextField="CityName" DataValueField="CityId";>
</asp:DropDownList;>

CS Page

if (!Page.IsPostBack)
{
CountryBind();
}
protected void CountryBind()
{
string sqlQuery = "Select * from Country;

using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, conn);
da.Fill(ds);
ddlCountry.DataSource = ds;
ddlCountry.DataBind();
conn.Close();
}
}
protected void StateBind()
{
string sqlQuery = "SELECT * FROM State " + " WHERE (CountryId = " + Convert.ToInt32(ddlCountry.SelectedValue) + " )";
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, conn);
da.Fill(ds);
ddlState.DataSource = ds;
ddlState.DataBind();
conn.Close();
}
}
protected void CityBind()
{
string sqlQuery = "SELECT * FROM City " + " WHERE (StateId = " + Convert.ToInt32(ddlState.SelectedValue) + " )";
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, conn);
da.Fill(ds);
ddlCity.DataSource = ds;
ddlCity.DataBind();
conn.Close();
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
StateBind();
}
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
CityBind();
}

Thanks & Regards
Santosh Singh

Authentication And Authorization

2010-08-23T05:28:00.000-07:00

Authentication And Authorization
Authentication is the process of identification and validation of a user's credentials. After the identity is authenticated,
a process called authorization determines whether that identity has access to a particular resource.
ASP.NET provides three ways to authenticate a user:
Forms authentication
Windows authentication
Passport authentication

Setting in web.config file given below

Forms authentication
<configuration>
<system.web>
<authentication mode="Forms"/>
<forms name="login"loginUrl="loginPage.aspx" />
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</configuration>

Windows authentication
<authentication mode="Windows"/>
<authorization>
<allow users ="*" />
</authorization>

Passport authentication
<configuration>
<system.web>
<authenticationmode="Passport">
<passportredirectUrl="loginPage.aspx" />
</authentication>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</configuration>

Thanks & Regards
Santosh Singh

Javascript date validation

2010-08-14T03:55:00.000-07:00

When Gridview has no record display empty grid at runtime

2010-08-09T10:06:00.000-07:00

When GridView(Add New Record) has no record display empty Grid at runtime.
Some time when we adding new row in gridview footer column and there is no record in database,so what we can do?
So we can disply message no record found and add new button show for adding new record.
Here is solution display runtime empty gridview.

 private void ShowNoResultFound(DataSet ds,GridView gv)
  {
      DataTable dt = (DataTable)ds.Tables[0];
      dt.Rows.Add(dt.NewRow());
      gv.DataSource = dt;
      gv.DataBind();
      int TotalColumns = gv.Rows[0].Cells.Count;
      gv.Rows[0].Cells.Clear();
      gv.Rows[0].Cells.Add(new TableCell());
      gv.Rows[0].Height = 0;
      gv.Rows[0].Visible = false;
  }

Thanks & Regards
Santosh Singh

Session object in asp.net

2010-08-04T09:29:00.000-07:00

Session object:

Session object is used to store state specific information per client basis. It is specific to particular user.
Session data persists for the duration of user session you can store session's data on web server in different ways.
Session state can be configured using the section in the application's web.config file.

Session state in ASP.NET can be configured in different ways based on various parameters including scalability, maintainability and availability

1.In process mode (in-memory)- State information is stored in memory of web server
2.Out-of-process mode- session state is held in a process called aspnet_state.exe that runs as a windows service.
3.Database mode – session state is maintained on a SQL Server database.

In process mode:
This mode is useful for small applications which can be hosted on a single server. This model is most common and default method to store session specific information. Session data is stored in memory of local web server

Configuration information:

Advantages:
Fastest mode
Simple configuration

Disadvantages:
Session data will be lost if the worker process or application domain recycles
Not ideal for web gardens and web farms

Out-of-process Session mode (state server mode):

This mode is ideal for scalable and highly available applications. Session state is held in a process called aspnet_state.exe that runs as a windows service
which listens on TCP port 42424 by default. You can invoke state service using services MMC snap-in or by running following net command from command line.

Net start aspnet_state

Configuration information:

Advantages:
Supports web farm and web garden configuration
Session data is persisted across application domain recycles. This is achieved by using separate worker process for maintaining state
Disadvantages:
Out-of-process mode provides slower access compared to In process
Requires serializing data

SQL-Backed Session state:
ASP.NET sessions can also be stored in a SQL Server database. Storing sessions in SQL Server offers resilience that can serve sessions to a large web farm that
persists across IIS restarts.
SQL based Session state is configured with aspnet_regsql.exe. This utility is located in .NET Framework's installed directory
C:\\microsoft.net\framework\. Running this utility will create a database which will manage the session state.

Configuration Information:

Advantages:
Supports web farm and web garden configuration
Session state is persisted across application domain recycles and even IIS restarts when session is maintained on different server.

Disadvantages:
Requires serialization of objects

Mode:
This setting supports three options. They are InProc, SQLServer, and State Server

Cookie less:
This setting takes a Boolean value of either true or false to indicate whether the Session is a cookie less one.

Timeout:
This indicates the Session timeout vale in minutes. This is the duration for which a user's session is active. Note that the session timeout is a sliding value;
Default session timeout value is 20 minutes

SqlConnectionString:
This identifies the database connection string that names the database used for mode SQLServer.

Server:
In the out-of-process mode State Server, it names the server that is running the required Windows NT service: aspnet_state.

Port:
This identifies the port number that corresponds to the server setting for mode State Server. Note that a port is an unsigned integer that uniquely identifies
a process running over a network.

You can disable session for a page using EnableSessionState attribute. You can set off session for entire application by setting mode=off in web.config file
to reduce overhead for the entire application.

Thanks & Regards
Santosh Singh

AJAX

2010-08-03T08:33:00.000-07:00

AJAX tab control
Here i describing a simple example how to use tab control in asp.net

.aspx code

< ajaxToolkit:TabPanel ID="tabFirst" runat="server" Width="111px" >
< HeaderTemplate>
First Tab Header name
< /HeaderTemplate>
< ContentTemplate>
< br />
< asp:GridView ID="gvEmpDetail" runat="server" DataKeyNames="EmpId" AllowPaging="True" PageSize="12"
AutoGenerateColumns="False" OnPageIndexChanging="gvEmpDetail_PageIndexChanging"
OnRowDataBound="gvEmpDetail_RowDataBound" TabIndex="2" Width="697px" OnRowCancelingEdit="gvEmpDetail_RowCancelingEdit"
OnRowEditing="gvEmpDetail_RowEditing" OnRowUpdating="gvEmpDetail_RowUpdating"
ShowFooter="True" OnRowCommand="gvEmpDetail_RowCommand" OnRowDeleting="gvEmpDetail_RowDeleting">
< Columns>
< asp:TemplateField HeaderText="Sr. No">
< ItemTemplate>
< asp:Label ID="lblSrNo" runat="server"> </asp:Label>
< /ItemTemplate>
< ItemStyle HorizontalAlign="Center" Width="50px" />
< /asp:TemplateField>
< asp:TemplateField HeaderText="EmpId" Visible="False">
< ItemTemplate>
< asp:Label ID="lblEmpId" runat="server" Text=' <%# Bind("EmpId") %>'> </asp:Label>
< /ItemTemplate>
< FooterTemplate>
< asp:Label ID="lblFooterEmpId" runat="server"> </asp:Label>
< /FooterTemplate>
< /asp:TemplateField>
< asp:TemplateField HeaderText="Emp">
< ItemTemplate>
< asp:Label ID="lblEmp" runat="server" Text=' <%# Bind("Emp") %>'> </asp:Label>
< /ItemTemplate>
< EditItemTemplate>
< asp:TextBox ID="txtEmp" runat="server" Text=' <%# Bind("Emp") %> '> </asp:TextBox>
< /EditItemTemplate>
< FooterTemplate>
< asp:TextBox ID="txtNewEmp" runat="server" Visible="false"> </asp:TextBox>
< /FooterTemplate>
< FooterStyle HorizontalAlign="Left" />
< ItemStyle HorizontalAlign="Left" />
< /asp:TemplateField>
< asp:TemplateField HeaderText="Edit">
< ItemTemplate>
< asp:ImageButton ID="ImgYes" runat="server" ImageUrl="~/Image/img_edit.png" CommandName="Edit" />
< /ItemTemplate>
< EditItemTemplate>
< asp:ImageButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
ImageUrl="~/Image/update.png" Text="Update" />
< asp:ImageButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
ImageUrl="~/Image/cancel.png" Text="Cancel" />
< /EditItemTemplate>
< FooterTemplate>
< asp:ImageButton ID="ButtonAdd" runat="server" ImageUrl="~/Image/row_add.png" CommandName="AddNew"
ToolTip="Add New" />
< asp:ImageButton ID="lbtnAdd" runat="server" CausesValidation="True" CommandName="Add"
ImageUrl="~/Image/add.png" Visible="false" Text="Add" />
< asp:ImageButton ID="lbtnCancel" runat="server" CausesValidation="False" CommandName="Cancel"
ImageUrl="~/Image/cancel.png" Visible="false" Text="Cancel" />
< /FooterTemplate>
< FooterStyle HorizontalAlign="Center" Width="120px" />
< ItemStyle HorizontalAlign="Center" Width="120px" />
< /asp:TemplateField>
< asp:TemplateField HeaderText="Delete">
< ItemTemplate>
< asp:ImageButton ID="ImgDelete" runat="server" ImageUrl="~/Image/img_delete.png"
CommandName="Delete" OnClientClick="return ConfirmDelete();" />
< /ItemTemplate>
< ItemStyle HorizontalAlign="Center" Width="80px" />
< /asp:TemplateField>
< /Columns>
< /asp:GridView>
< asp:Label ID="exceptionMessage" runat="server" ForeColor="Red" Width="498px"> </asp:Label>
< /ContentTemplate>
< /ajaxToolkit:TabPanel>

< ajaxToolkit:TabPanel ID="tabEmpInfo" runat="server" >
< HeaderTemplate>
Emp Information
< /HeaderTemplate>
< ContentTemplate>
< br />
< asp:GridView ID="gvEmpInfo" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="12"
OnPageIndexChanging="gvEmpInfo_PageIndexChanging" OnRowDataBound="gvEmpInfo_RowDataBound"
TabIndex="2" Width="697px" OnRowCancelingEdit="gvEmpInfo_RowCancelingEdit" OnRowEditing="gvEmpInfo_RowEditing"
OnRowUpdating="gvEmpInfo_RowUpdating" ShowFooter="True" OnRowCommand="gvEmpInfo_RowCommand"
OnRowDeleting="gvEmpInfo_RowDeleting" DataKeyNames="EmpInfoId">
< Columns>
< asp:TemplateField HeaderText="Sr. No">
< ItemTemplate>
< asp:Label ID="lblSrNo" runat="server"> </asp:Label>
< /ItemTemplate>
< ItemStyle HorizontalAlign="Center" Width="50px" />
< /asp:TemplateField>
< /Columns>
< /asp:GridView>
< asp:Label ID="exceptionEmpInfo" runat="server" ForeColor="Red" Width="498px"> 0)
{
gvEmpDetail.DataSource = Ds;
gvEmpDetail.DataBind();
}
else
{
ShowNoResultFound(Ds.Tables[0], gvEmpDetail);
}
}
catch (Exception ex)
{
exceptionMessage.Text = ex.Message;
}
}
protected void GridViewEmpInfo()
{
try
{
Ds = objEmpInfoBLL.GetEmpInfoData();
if (Ds.Tables[0].Rows.Count > 0)
{
gvEmpInfo.DataSource = Ds;
gvEmpInfo.DataBind();
}
else
{
ShowNoResultFound(Ds.Tables[0], gvEmpInfo);
}
}
catch (Exception ex)
{
exceptionEmpInfo.Text = ex.Message;
}
}

Thanks & Regards
Santosh Singh

Gridview custom sorting using asp.net c#

2010-08-02T05:28:00.000-07:00

public partial class _Default : System.Web.UI.Page
{
private const string ASCENDING = " ASC";
private const string DESCENDING = " DESC";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SortGridView(sortExpression, "");
}
}
public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;

return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}
protected void gvCust_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;

if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, DESCENDING);
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, ASCENDING);
}
}
static string sortExpression;
private void SortGridView(string sortExpression, string direction)
{
SqlConnection con;
con = new SqlConnection(ConfigurationManager.ConnectionStrings["StrConnect"].ToString());
con.Open();
SqlDataAdapter oAdapter = new SqlDataAdapter("usp_GetCustDetail", con);
oAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet oDataSet = new DataSet();
oAdapter.Fill(oDataSet);
DataTable dt = oDataSet.Tables[0];
DataView dv = new DataView(dt);
dv.Sort = sortExpression + direction;
gvCust.DataSource = dv;
gvCust.DataBind();
}
}

Thanks & Regards
Santosh

Display all related data in comma separated list sql server

2010-04-30T10:19:00.000-07:00

Concetenate the two fields and display the records with comma separated string in one field.

SELECT p_scrid,
SUBSTRING(
(
SELECT (' ,' + screen_name)
FROM tbl_SCRMst t2
WHERE t1.p_scrid = t2.p_scrid
ORDER BY
p_scrid,
screen_name
FOR XML PATH( '')
),3,1000)
FROM tbl_SCRMst t1
GROUP BY p_scrid

Thanks & Regards
Santosh

Check record exist or not using asp.net and c#

2010-04-03T09:28:00.000-07:00

This code show how to check record exist in database.Method get custid as a parameter and pass to stored procedure that will check record exist or not.

public bool IsCustomerExist(string strCust)
{
//SqlConnection objSqlConnection = null;
SqlCommand objSqlCommand = null;
try
{
//objSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["StrConnect"].ToString());
objSqlCommand = new SqlCommand("usp_CheckCustomerExists", con);
objSqlCommand.CommandType = CommandType.StoredProcedure;
objSqlCommand.Parameters.Add("CustomerID", SqlDbType.Int, 4).Value = Convert.ToInt32(strCust);
con.Open();
SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader();
if (objSqlDataReader.HasRows)
return true;
else
return false;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
}

Thanks & Regards
Santosh

Find Gridview TextBox in client side using javascript

2010-03-30T10:41:00.000-07:00

Here this article show show how we can find gridview textbox which is in Template Field.This code validate the Gridview textbox in edit mode.

function ValidateGridEditMode()
{
var n = document.getElementById('ctl00_ContentPlaceHolder1_tbcLocation_tpnlCountry_gvEmp').rows.length;
var i;
for(i=2; i <=n; i++)
{
if(i<10)
{
txtEmpName=document.getElementById('ctl00_ContentPlaceHolder1_tbcLocation_tpnlCountry_gvEmp_ctl0'+i+'_txtEmpName');
}
else
{
txtEmpName=document.getElementById('ctl00_ContentPlaceHolder1_tbcLocation_tpnlCountry_gvEmp_ctl'+i+'_txtEmpName');
}
if(txtEmpName !=null)
{
if(txtEmpName.value == "")
{
alert("Enter Emp Name...!");
txtEmpName.focus();
return false;
}
}
}
return true;
}

Thanks & Regards
Santosh Singh

Single Stored Procedure for Insert and update record

2010-03-27T03:30:00.000-07:00

It good idea to use a single stored proceude instead of write two stored procedure for insert and update.So i am here explainig how to do this.

here we can check if EnquiryId ==0 then insert otherwise update.

Create PROCEDURE [dbo].[uspEnquiry_AddEdit]
(
@EnquiryId bigint
, @EnquiryNo varchar(20) output
, @ClientId bigint
, @ContactPerson varchar(50)
, @Desig varchar(50)
, @Mobile varchar(15)
, @Phone varchar(50)
, @EmailId varchar(100)

)
AS
DECLARE @Message varchar(100)
IF(@EnquiryId=0)
BEGIN
IF EXISTS(SELECT * FROM Enquiry WHERE EnquiryNo=@EnquiryNo)
SET @Message='Record Exists In Database...!'

ELSE
BEGIN
INSERT INTO Enquiry
(
[EnquiryNo]
,[ClientId]
,[ContactPerson]
,[Desig]
,[Mobile]
,[Phone]
,[EmailId]
)
VALUES
(
@EnquiryNo
,@ClientId
,@ContactPerson
,@Desig
,@Mobile
,@Phone
,@EmailId
)
SELECT @EnquiryId = @@IDENTITY;
END
END
ELSE
BEGIN
UPDATE Enquiry
SET [EnquiryNo] = @EnquiryNo
,[ClientId] = @ClientId
,[ContactPerson] = @ContactPerson
,[Desig] = @Desig
,[Mobile] = @Mobile
,[Phone] = @Phone
,[EmailId] = @EmailId
WHERE EnquiryId = @EnquiryId

END
SELECT @EnquiryId

Thanks & Regards
Santosh Singh

Calculate two textbox value using javascript

2010-01-17T02:53:00.000-08:00

Calculate two textbox value using javascript in ASP.NET
function Calculate()
{
var txtProposalValue = document.getElementById('<%=txtProposalValue.ClientID %>');
var txtProfit = document.getElementById('<%=txtProfit.ClientID %>');
var txtLikelyValue = document.getElementById('<%=txtLikelyValue.ClientID %>');
var LikelyValue =(parseFloat(txtProposalValue.value) + parseFloat(txtProfit.value));
if(txtProfit.value =="")
{
txtLikelyValue.value = "0";
}
else
{
txtLikelyValue.value = LikelyValue;
}
}

Insert record in database using 3-Tier Architecture asp.net

2009-04-24T09:35:00.000-07:00

Insert data in database using 3 Tier Architecture .
In this article i am explaining you how to insert record in database using 3-Tier Architecture.You can create separate project for Business and data access layer or also can keep in App_code folder.

This is aspx.cs code.Here code communicate through Business Layer.

protected void btnSubmit_Click(object sender, EventArgs e)
{
objClientCls.ClName = txtCoName.Text;
objClientCls.AddLine1 = txtAddLine1.Text;
objClientCls.AddLine2 = txtAddLine2.Text;
try
{
if (objClientCls.ClId == 0)
{
string Msg = objClBLL.InsertClMaster(objClientCls);
lblMessage.Text = Msg;
Clear();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
finally
{
objClBLL = null;
}
}

Business Layer Code

public string InsertClMaster(ClMasterCls objClMasterCls)
{
try
{
return objClMasterDAL.Insert(objClMasterCls);
}
catch
{
throw;
}
finally
{
objClMasterDAL = null;
}
}

Data Acess layer code
public string Insert(ClMasterCls objClMasterCls)
{
try
{
conn.Open();
string CreateMsg = Convert.ToString(SqlHelper.ExecuteScalar(conn, "usp_InsertClMaster", objClMasterCls.ClId, objClMasterCls.ClName, objClMasterCls.AddLine1
, objClMasterCls.AddLine2));
return Msg;
}
catch
{
throw;
}
finally
{
conn.Close();
}
}

Thanks & Regards
Santosh Singh

Export Gridview to Excel and PDF file using asp.net and c#

2009-04-16T01:18:00.000-07:00

In this article i am explaining you how to display report using aspx page.Exporting Gridview to excel and PDF report is one of the most common requirement in real world.So i have written this code,you can customize ConvertDataInPdf method according to your requirement.

aspx code.
<asp:GridView ID="GridView1" runat="server" EnableTheming="False" OnRowDataBound="GridView1_RowDataBound"
Width="100%">
<HeaderStyle CssClass="ReportHeader" Width="80px" /
<RowStyle CssClass="ReportText" />
<PagerStyle CssClass="ReportHeader" />
<AlternatingRowStyle CssClass="ReportText" />
<EmptyDataRowStyle CssClass="ReportText" />
<EmptyDataTemplate>
<span style="font-size: 11pt; color: #ff0033"><strong>No Records ........!!</strong></span>
</EmptyDataTemplate>
<Columns>
<asp:BoundField HeaderText="Sr. No." />
</Columns>
</asp:GridView>

.cs code
string conStr = FetchConnection.FetchConnectionString().ToString();
void GridViewEmp()
{
DataSet Ds = new DataSet();
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
string str = "SELECT * from EmployeeTbl"
Ds = SqlHelper.ExecuteDataset(conStr, CommandType.Text, str);
GridView1.DataSource = Ds;
GridView1.DataBind();
}

protected void lbExportInExcel_Click1(object sender, ImageClickEventArgs e)
{
string attachment = "attachment; filename=" + "Emp Report" + ".xls";
Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
reportName.RenderControl(htmlWrite);
rowInfo.RenderControl(htmlWrite);
rowGridView.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}

protected void btnPdf_Click(object sender, ImageClickEventArgs e)
{
PrintAndExport exportDataInPdf = new PrintAndExport();
string reportName = "Employee Loan Report" + " ( " +lbl.Text+ " ) ";
string OtherInfo = "Company Name: " + ddlCompany.SelectedItem.Text + "\t\t\t" + "Emp Status: " + ddlStatus.SelectedItem.Text;
DataTable dt = ExportData();
exportDataInPdf.ConvertDataInPdf(dt, reportName, OtherInfo);
}

public void ConvertDataInPdf(DataTable dtExportInPdf, string reportName, string OtherInfo)
{
try
{
float CompanyNameSize = 11;
float ReportNameSize = 9;
float HeaderTextSize = 7;
float ReportTextSize = 6;

int totalWidth = 0;
int tableWidthPercent = 100;
int[] widths = new int[dtExportInPdf.Columns.Count];

for (int h = 0; h < dtExportInPdf.Columns.Count; h++) //Data table header column width
{
string strWidth = dtExportInPdf.Columns[h].ToString();
widths[h] = strWidth.Length;
}

foreach (DataRow dr in dtExportInPdf.Rows) //Data table column width
{
int[] colItemWidth = new int[dtExportInPdf.Columns.Count];
for (int i = 0; i < dtExportInPdf.Columns.Count; i++) //Data table max item width
{
if (dr[i].ToString().Length > 20)
{
colItemWidth[i] = 20;
}
else if (dr[i].ToString().Length < 3)
{
colItemWidth[i] = 3;
}
else
{
colItemWidth[i] = dr[i].ToString().Length;
}

if (colItemWidth[i] > widths[i])
{
widths[i] = colItemWidth[i];
}
}
}
for (int h = 0; h < dtExportInPdf.Columns.Count; h++)
{
totalWidth += widths[h];
}
Document pdfDoc = null;
if (totalWidth > 0 && totalWidth <= 110)
{
pdfDoc = new Document(PageSize.A4, 20, 20, 20, 20);
}
else if (totalWidth > 110 && totalWidth <= 160)
{
pdfDoc = new Document(PageSize.A4.Rotate(), 20, 20, 20, 20);
}
else if (totalWidth > 160 && totalWidth <= 250)
{
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.LEGAL.Rotate(), 20, 20, 20, 20);

}
else if (totalWidth > 250 && totalWidth <= 300)
{
CompanyNameSize = 9;
ReportNameSize = 7;
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.B1, 20, 20, 20, 20);
}
else if (totalWidth > 300)
{
CompanyNameSize = 9;
ReportNameSize = 7;
HeaderTextSize = 6;
ReportTextSize = 5;
pdfDoc = new Document(PageSize.B1.Rotate(), 20, 20, 20, 20);
}

// Creates a PdfPTable with column count of the table equal to no of columns of the datatable or gridview or gridview datasource.
PdfPTable pdfTable = new PdfPTable(dtExportInPdf.Columns.Count);
pdfTable.WidthPercentage = tableWidthPercent;
pdfTable.HeaderRows = 4; // Sets the first 4 rows of the table as the header rows which will be repeated in all the pages.

#region PDFHeader
PdfPTable headerTable = new PdfPTable(3); // Creates a PdfPTable with 3 columns to hold the header in the exported PDF.
byte[] logo = (byte[])System.Web.HttpContext.Current.Session["Logo"];
iTextSharp.text.Image imgLogo = iTextSharp.text.Image.GetInstance(logo);
imgLogo.ScaleToFit(80f, 40f);//Resize image depend upon your need
imgLogo.SpacingBefore = 0f;//Give space before image
imgLogo.SpacingAfter = 1f;//Give some space after the image
PdfPCell clLogo = new PdfPCell(imgLogo);// Creates a PdfPCell which accepts a phrase as a parameter.
clLogo.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clLogo.HorizontalAlignment = Element.ALIGN_LEFT;// Sets the Horizontal Alignment of the PdfPCell to left.
clLogo.VerticalAlignment = Element.ALIGN_MIDDLE;

// Creates a phrase to hold the application name at the left hand side of the header.
Phrase phApplicationName = new Phrase("" + System.Web.HttpContext.Current.Session["CompanyName"] + "", FontFactory.GetFont("Arial", CompanyNameSize, iTextSharp.text.Font.NORMAL));
PdfPCell clApplicationName = new PdfPCell(phApplicationName);// Creates a PdfPCell which accepts a phrase as a parameter.
clApplicationName.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clApplicationName.HorizontalAlignment = Element.ALIGN_CENTER;// Sets the Horizontal Alignment of the PdfPCell to left.
clApplicationName.VerticalAlignment = Element.ALIGN_MIDDLE;

// Creates a phrase to show the current date at the right hand side of the header.
Phrase phDate = new Phrase(DateTime.Now.Date.ToString("dd/MM/yyyy"), FontFactory.GetFont("Arial", 7, iTextSharp.text.Font.NORMAL));
PdfPCell clDate = new PdfPCell(phDate);// Creates a PdfPCell which accepts the date phrase as a parameter.
clDate.HorizontalAlignment = Element.ALIGN_RIGHT;// Sets the Horizontal Alignment of the PdfPCell to right.
clDate.Border = PdfPCell.NO_BORDER;// Sets the border of the cell to zero.
clDate.VerticalAlignment = Element.ALIGN_MIDDLE;

headerTable.AddCell(clLogo);
headerTable.AddCell(clApplicationName);// Adds the cell which holds the application name to the headerTable.
headerTable.AddCell(clDate);// Adds the cell which holds the date to the headerTable.
headerTable.DefaultCell.Border = PdfPCell.NO_BORDER;// Sets the border of the headerTable to zero.

// Creates a PdfPCell that accepts the headerTable as a parameter and then adds that cell to the main PdfPTable.
PdfPCell cellHeader = new PdfPCell(headerTable);
cellHeader.VerticalAlignment = Element.ALIGN_TOP;
cellHeader.Border = PdfPCell.NO_BORDER;
cellHeader.Colspan = dtExportInPdf.Columns.Count;// Sets the column span of the header cell to noOfColumns.
pdfTable.AddCell(cellHeader);// Adds the above header cell to the table.
#endregion PDFHeader

//Creates a phrase for a new line.
Phrase phSpace1 = new Phrase("\n");
PdfPCell clSpace1 = new PdfPCell(phSpace1);
clSpace1.Border = PdfPCell.BOTTOM_BORDER;
clSpace1.BorderWidth = 1;
clSpace1.BorderColor = iTextSharp.text.Color.DARK_GRAY;
clSpace1.Colspan = dtExportInPdf.Columns.Count;
pdfTable.AddCell(clSpace1);

// Creates a phrase to hold the report name.
Phrase phHeader = new Phrase("" + reportName + "", FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.NORMAL));
PdfPCell clHeader = new PdfPCell(phHeader);
clHeader.Colspan = dtExportInPdf.Columns.Count;
clHeader.Border = PdfPCell.NO_BORDER;
clHeader.HorizontalAlignment = Element.ALIGN_CENTER;
clHeader.VerticalAlignment = Element.ALIGN_MIDDLE;
clHeader.PaddingTop = 5;
clHeader.PaddingBottom = 2;
pdfTable.AddCell(clHeader);

//Create Phrage to hold other informations
Phrase phOtherInfo = new Phrase(OtherInfo, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
PdfPCell cellOtherInfo = new PdfPCell(phOtherInfo);
cellOtherInfo.Colspan = dtExportInPdf.Columns.Count;
cellOtherInfo.Border = Element.ALIGN_LEFT;
cellOtherInfo.PaddingBottom = 10;
pdfTable.AddCell(cellOtherInfo);

PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
string strFooter = "Copyright © 2010 By Cnergee. Page:";
Phrase phCopyright = new Phrase(strFooter, FontFactory.GetFont(FontFactory.TIMES_ROMAN, 8, iTextSharp.text.Font.NORMAL));
Phrase phPageNo = new Phrase("", FontFactory.GetFont(FontFactory.TIMES_ROMAN, 8, iTextSharp.text.Font.NORMAL));
HeaderFooter footer = new HeaderFooter(phCopyright, phPageNo);
//footer.Alignment = Element.ALIGN_LEFT;
footer.Alignment = Element.ALIGN_RIGHT;
footer.Border = iTextSharp.text.Rectangle.TOP_BORDER;
footer.GrayFill = 10;
pdfDoc.Footer = footer;

pdfDoc.Open();
Font font8 = FontFactory.GetFont("ARIAL Narrow", 7);
if (dtExportInPdf != null)
{
pdfDoc.Header = null;
//Create header for pdf table
string cloName = null;
Phrase ph = null;
for (int i = 0; i < dtExportInPdf.Columns.Count; i++)
{
cloName = dtExportInPdf.Columns[i].ColumnName;
if (dtExportInPdf.Columns.Count > 0)
{
ph = new Phrase(cloName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
else
{
ph = new Phrase(cloName, FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
}
pdfTable.AddCell(ph);
}

//Add data into the pdf table
for (int rows = 0; rows < dtExportInPdf.Rows.Count; rows++)
{
ph = null;
PdfPCell pCell = null;
for (int column = 0; column < dtExportInPdf.Columns.Count; column++)
{
ph = new Phrase(dtExportInPdf.Rows[rows][column].ToString(), FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
pCell = new PdfPCell(ph);
if (dtExportInPdf.Columns[column].ColumnName == "SrNo" || dtExportInPdf.Columns[column].ColumnName == "Sr.No." || dtExportInPdf.Columns[column].ColumnName == "Sr. No." || dtExportInPdf.Columns[column].ColumnName == "Code" || dtExportInPdf.Columns[column].ColumnName == "EmpCode" || dtExportInPdf.Columns[column].ColumnName == "EmployeeCode")
{
pCell.HorizontalAlignment = Element.ALIGN_CENTER;
}
else if (dtExportInPdf.Columns[column].ColumnName == "Amount")
{
pCell.HorizontalAlignment = Element.ALIGN_RIGHT;
}
else if (dtExportInPdf.Columns[column].ColumnName == "Date" || dtExportInPdf.Columns[column].ColumnName == "From" || dtExportInPdf.Columns[column].ColumnName == "To")
{
pCell.HorizontalAlignment = Element.ALIGN_CENTER;
}
else
{
pCell.HorizontalAlignment = Element.ALIGN_LEFT;
}
pdfTable.AddCell(pCell);
}
pdfTable.SetWidths(widths);
}
pdfTable.SpacingBefore = 15f; // Give some space after the text or it may overlap the table
pdfDoc.Add(pdfTable); // add pdf table to the document
}
pdfDoc.Close();

string pdfFileName = reportName;
reportName = reportName.Replace(" ", "");
System.Web.HttpContext.Current.Response.ContentType = "application/pdf";
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename= " + pdfFileName + ".pdf");
System.Web.HttpContext.Current.Response.Write(pdfDoc);

System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.End();
}
catch (DocumentException de)
{
System.Web.HttpContext.Current.Response.Write(de.Message);
}
catch (IOException ioEx)
{
System.Web.HttpContext.Current.Response.Write(ioEx.Message);
}
catch (Exception ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
}

public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for the
//specified ASP.NET server control at run time.
}

Thanks & Regards
Santosh

Find tables that contain a certain field in database

2009-04-16T00:46:00.000-07:00

Some times user need to get information about a table field,means how many table contains this field. A table field eg 'xyz' have relationship with many table and you want to see all table.Write below query.

select * from information_schema.columns where column_name = 'xyz'

Thanks & Regards
Santosh