Dotnet Blog

Cannot find one or more components:Please reinstall the application

2011-07-27T23:03:00.000-07:00

Today morning i just started my Visual Studio 2008. At that time i got a message like Cannot find one or more components:Please reinstall the application.I was not change anything in Visual Sutio 2008.What i thought may be i did not properly shutdown that's why some file may be corrupted. So only am getting the message like this. But after that i googled half an hour.Many people are facing the same error. At last i got the solution.

Found the link in.

http://social.msdn.microsoft.com/forums/en-US/vssetup/thread/76713427-0daa-4907-a017-633ad258a5af with the title "Cannot find one or more components" Error When Executing Visual Studio 2008.

I looked in my Explorer C:\WINDOWS\WinSxS\x86_Microsoft.VC90.ATL_1fc8b3b9a1e18e3b_9.0.21022.8_x-ww_312cf0e9. The DLL atl90.dll was modified.

and may be it cause of windows auto update.

So i copied atl90.dll from my other machine and saved.After opening the Visual Studio it was working fine.

How to maintain the password textbox text after postback

2011-07-25T03:27:00.000-07:00

How to maintain the password textbox text after postback

In Asp.net the password textbox will not remain the value after postback so for that we can use this steps
to maintain the values.

The Coding As follows.

In the design page

<asp:textbox onprerender="txtPassword_PreRender" id="txtPassword" text="abcd" maxlength="25" cssclass="TextBox" width="150px" runat="server" textmode="Password"></asp:textbox>

<asp:button onclick="btnSubmit_Click" id="btnSubmit" runat="server" text="Submit"/>

In the Code behind page

protected void txtPassword_PreRender(object sender, EventArgs e)
{
txtPassword.Attributes["value"] = txtPassword.Text;
}

protected void btnSubmit_Click(object sender, EventArgs e)
{

}

Dynamic LinkButton Controls in Asp.Net

2011-06-29T03:14:00.000-07:00

Dynamic LinkButton in Asp.Net c#

In this article am going to explain how to create and add dynamic table with Dynamic LinkButton.

In the design page, we just add how many controls we need and where it should be placed. These controls are static and having the data what we gave. In some cases we have to dynamically get data from the database and create dynamic controls for the data.

Difference between static and dynamic?
Static -> we can mention how many things we need.
Dynamic ->we cannot mention it generates depends upon the requirements.

Creating Dynamic LinkButton in Asp.Net is very simple. After creating the dynamic controls just add the controls in a PlaceHolder or Panel control.

Step 1: In the Design Page just create a panel named "pnlDynamic".

Step 2: Add the namespace in the code behind.

using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;

Step 3: Create an object for HtmlTable.

HtmlTable tblDynamic = new HtmlTable();

Step 4: In the Page_Load event, just call the dynamically creating control method BindEmployeeData(); Call the method outside the IsPostBack() method. Because our dynamic controls should recreate each and every time when a postback call.

protected void Page_Load(object sender, EventArgs e)
  {
    If(!IsPostBack())
    {                  
    }
    BindEmployeeData ();
  }

Step 5: Method for creating the dynamic LinkButton control depends on the database data.

public void BindEmployeeData()
  {
      SqlConnection SqlConn = new SqlConnection("Data Source=localhost;Initial Catalog=mytestDB;User ID=xxxxxxx;Password=zzzzzzzzz");
      SqlDataAdapter SqlDap = new SqlDataAdapter("select * from Employees", SqlConn);
      DataTable objDT = new DataTable();
      SqlDap.Fill(objDT);

      tblDynamic.ID = "tblEmployee";
      tblDynamic.Width = "100%";
      tblDynamic.CellPadding = 3;
      int intRowCount = objDT.Rows.Count;

      if ((intRowCount > 0))
      {
          int sCount = (intRowCount / 2) + 1;
          int intCurrentCount = 0;
          for (int i = 1; i <= sCount; i++)                 {                     HtmlTableRow tblRowDef = new HtmlTableRow();                                          tblRowDef.Align = "left";                                          if ((intRowCount > intCurrentCount))
              {
                  for (int l = 1; l <= 2; l++)                         {                             if ((intRowCount > intCurrentCount))
                      {
                          HtmlTableCell tblCellDef = new HtmlTableCell();
                          tblCellDef.ID = "0" + objDT.Rows[intCurrentCount]["EmpName"].ToString();
                          tblCellDef.Width = "400px";
                          LinkButton lnkEmployee = new LinkButton();
                          lnkEmployee.ID = "lnkEmployee0" + objDT.Rows[intCurrentCount]["EmpName"].ToString();
                          lnkEmployee.Text = objDT.Rows[intCurrentCount]["EmpName"].ToString();
                          lnkEmployee.CommandName = objDT.Rows[intCurrentCount]["EmpID"].ToString();
                          lnkEmployee.Font.Bold = true;
                          lnkEmployee.Font.Size = 13;
                          lnkEmployee.Width = 10;
                          lnkEmployee.Click += new EventHandler(lnkEmployeeWhole_Click);
                          tblCellDef.Controls.Add(lnkEmployee);
                          tblRowDef.Controls.Add(tblCellDef);
                          intCurrentCount += 1;
                      }
                  }
              }
              tblDynamic.Controls.Add(tblRowDef);
          }

      }
     pnlDynamic.Controls.Add(tblDynamic);
  }

Step 6: Write the handler to fire the event for the particular link button control

protected void lnkEmployeeWhole_Click(object sender, EventArgs e)
  {
      LinkButton lnkEmployee = (LinkButton)sender;
      Response.Redirect("SomePage.aspx?ID="+lnkEmployee.CommandName);
  }

Dynamic link button will disappear if you put LoadBookData() method within IspostBack() method.

I Hope these Code will help you to understand the Dynamic LinkButton Controls in Asp.Net.

Error Logging in ASP.NET

2011-06-28T06:24:00.000-07:00

Errors may occur during the development. Not only in the Web sites, it is in all the fields. Every coders may know which place the error will come.Some errors can be easily identified and get a solution easily.But some cases we cant identify what error and why this error is coming like this. For an good website we have to maintain the error log in the Application. So we can track the errors easily and fix the issues sooner.

In this blog, we will see how to create a simple error log in our website. We will show an error has been occured message to the user. At the same time,we will log the error in a htm file. The html error file will be created with the name of current date. whenever the error is occurred, It will automatically update with the html file.

Types of errors

Syntax errors-(ex: we missed the semicolon at end of the statement).
Logical error-(ex: Converting a string to int).
Application error-(ex: may be the folder permission does not give to create a new file).

Download the project with full source code.

let us see steps,how to catch errors and log.

Step 1: Create a new folder named Logs and set write permission.

Step 2: Create a new ErrorPage.aspx and in that page write the Error has been occurred during process message in a Label.

Step 3: create a new class named General.cs and add the variables to use in the error log.

private string strDLLName, strErrorIn, strFileName, strFileLocation, strErrorMethodName, strErrorMessage, strLineNo, strException, strLogFormat;

Step 4: write the method GetErrorDetails as a return type void.

public void GetErrorDetails(Exception ex)
 {
 strException = ex.StackTrace.Trim().Remove(0, 3);
 string strDllInfo, strLocationInfo;
 if (strException.Contains(":") && strException.Contains(".") && strException.Contains("\\"))
 {
 strDllInfo = strException.Substring(0, strException.IndexOf('('));
 strLocationInfo = strException.Substring(strException.IndexOf(')'), (strException.LastIndexOf(':')) - strException.IndexOf(')')).Remove(0, 5);

 //Get the DLL Name
 strDLLName = strDllInfo.Substring(0, strDllInfo.Substring(0, strDllInfo.LastIndexOf('.')).LastIndexOf('.'));

 //Get the File Type & Name
 string strFileCheck = strLocationInfo.Substring(strLocationInfo.LastIndexOf('\\')).Remove(0, 1);
 string[] arrFileCheck = strFileCheck.Split('.');

 if (arrFileCheck.Length > 2)
 strErrorIn = "Page File";
 else
 strErrorIn = "Class File";
 strFileName = strFileCheck;

 //Get the Error File Location
 strFileLocation = "~\\" + strLocationInfo.Substring(AppDomain.CurrentDomain.BaseDirectory.Length);

 //Get the Error Method Name
 strErrorMethodName = strDllInfo.Substring(strDllInfo.LastIndexOf('.')).Remove(0, 1);

 //Get the Error Meassage
 strErrorMessage = ex.Message;

 //Get the Error Line No.
 strLineNo = strException.Substring(strException.LastIndexOf(':'), (strException.Length - strException.LastIndexOf(':'))).Remove(0, 6);
 }
 else
 {
 strDLLName = "-";
 strFileName = "-";
 strFileLocation = "-";
 strErrorMethodName = ex.ToString();
 strErrorIn = "Application Error";
 strLineNo = "-";
 strErrorMessage = ex.Message;
 }
 //Write the Error In ErroLog File
 WriteError(strDLLName, strErrorIn, strFileName, strFileLocation, strErrorMethodName, strErrorMessage, strLineNo);
 }

Step 5: Write the catched error in the html file

private void WriteError(string strDLLName, string strErrorIn, string strFileName, string strFileLocation, string strErrMethodName, string strErrMessage, string strLineNo)
 {
 bool boolErrLog = true;

 string strbaseDir = AppDomain.CurrentDomain.BaseDirectory;
 string strErrHeader = "<TR bgColor=\"#E6D4A7\"><TD align=center><font size=\"4\">DataBase</font></TD><TD align=center><font size=\"4\">User</font></TD><TD align=center><font size=\"4\">Date</font></TD><TD align=center><font size=\"4\">DLL Name</font></TD><TD align=center><font size=\"4\">Error In<font></TD><TD align=center><font size=\"4\">File Name</font></TD><TD align=center><font size=\"4\">File Location</font></TD><TD align=center><font size=\"4\">Error Method Name</font></TD><TD align=center><font size=\"4\">Error Message</font></TD><TD align=center><font size=\"4\">Error Line No</font></TD></TR>";
 string strTitle = "<h2 align=center>" + "My Website Error Log Information" + "</h2>";
 string strErrorTime = DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Year.ToString();
 string strDBName = "-", strLoginUser = "-";
 string strLogFilePath = strbaseDir + "Logs\\" + "ErrorLog" + "_" + strErrorTime + ".html";

 if (!Directory.Exists(strbaseDir + "Logs\\"))
 {
 Directory.CreateDirectory(strbaseDir + "Logs\\");
 }

 if (File.Exists(strLogFilePath))
 {
 boolErrLog = false;
 }

 StreamWriter sw = new StreamWriter(strLogFilePath, true);

 if (boolErrLog)
 {
 sw.WriteLine(strTitle + "<TABLE rules=\"all\">");
 sw.WriteLine(strErrHeader);
 } 

 if (HttpContext.Current.Session != null)
 {
 if (HttpContext.Current.Session["DATABASE"] != null)
 strDBName = HttpContext.Current.Session["DATABASE"].ToString();
 if (HttpContext.Current.Session["LoginUser"] != null)
 strLoginUser = HttpContext.Current.Session["LoginUser"].ToString();
 }
 strLogFormat = "<TR><TD>" + strDBName + "</TD><TD>" + strLoginUser + "</TD><TD>" + DateTime.Now.ToString() + "</TD><TD>" + strDLLName + "</TD><TD>" + strErrorIn + "</TD><TD>" + strFileName + "</TD><TD align=center>" + strFileLocation + "</TD><TD>" + strErrMethodName + "</TD><TD>" + strErrMessage + "</TD><TD>" + strLineNo + "</TD></TR>";

 sw.WriteLine(strLogFormat);
 sw.Close();
 }

Step 6: How to call this method in our website

in codebehind events, (ex. button click)

try
 {
 throw new Exception("dotnetpgm Exception");
 }
 catch (Exception ex)
 {
 General objGeneral = new General();
 objGeneral.GetErrorDetails(ex);
 Response.Redirect("ErrorPage.aspx");
 }

Step 7: for catching the Application errors add the code in Global.asax

you can create Global.asax by add new item in the website

protected void Application_Error(object sender, EventArgs e)
 {
 General objGeneral = new General();
 Exception objErr = Server.GetLastError().GetBaseException();
 objGeneral.GetErrorDetails(objErr);
 }

Download the project with full source code.

Build and run the application to log the 'dotnetpgm' exception in the error log file.
you will see it will redirect to ErrorPage.aspx page. But when you get an Application error It just log the error in background.

In this blog, we saw about how to add the simple error logging method in our website. Error Logging will be very useful to detect errors and helps our website to fix the issues.

Image uploading in Asp.net

2010-01-30T05:50:00.000-08:00

Image uploading using Asp.net to MS sql server by c# is very easier.Here i will show how to convert an image to binary data and reduce the image size and then upload the binary data to MS sql server.

Create the Database structure

In the database we have to declare the image id, image name and image binary data.

name type
imageId int identity not null
imageName varchar(100)
imageBinaryData image

if we declare the imageBinaryData as image means.we can convert our image to binary data and the upload to the sql server is easier.

In the New Web Form page drag and drop the Fileupload control and name it as FileUpload and a button control as btnSubmit.

Write the logic for file upload and resize the image in .cs file

use the Name space on the top of the namespace declaration.


using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Text;

then declare the sql connection before the page load event.

SqlConnection Conn = new SqlConnection(“server=.;database=sample;Integrated Security=True”);


in the button click event
//Check the file upload is having some data.
if (FileUpload.FileName != “”)
{
System.Drawing.Image image = System.Drawing.Image.FromStream(FileUpload.PostedFile.InputStream);
int imgHeight, imgWidth;
imgHeight = 130;
imgWidth = 150;

///….
}

I attached the sample Image upload File with this.
Download

Captcha validation in Asp.net 2.0

2010-01-07T10:10:00.000-08:00

Captcha validation in Asp.net 2.0.

Before Entering to topic first we must understand about the validation.Why most of the sites are validating the data's we entered.Like we gave a name with numeric values and special characters like.So these things are really wrong information by mistake wrongly typed.In email id most of the websites how they validate means they see the email id contains '@' followed with some words and having '.' symbol. So we have to give the informations correctly.

Ok, Let us come to the Topic.
most of the web sites having the Captcha validation to their sites.

What is a Captcha code?

Captcha code contains a char and integer values with mixed mode. It is used for validating this code was really typed by the human.

How to create our own captcha code in Asp.net 2.0

First create an image button in a Asp.net web page and in the imageurl give the capthanew.aspx. like this,


<asp:imagebutton id="ImageButton1" runat="server" width="105px" height="35px" imageurl="~/capthanew.aspx">

<asp:TextBox ID="txtcaptha" runat="server" Width="105px" MaxLength="6" CssClass="txtbx2"></asp:TextBox>

<asp:Button ID="btnSubmit" Text="Submit" runat="server" OnClick="btnSubmit_Click" />

give a text box to enter the captcha text and also a button.

download the capthanew.aspx file from here Download

save the file in your website folder.

In aspx.cs file go to the btnSubmit_Click event to write the validation to check the user given code and captcha code are same.


if (Page.IsValid && (txtcaptha.Text.ToString() != Session["RandomStr"].ToString()))
            {
                Response.Write("Captcha code was wrong.");
            }

This is the implementation of a captcha code if you want to generate the code dynamically means just give a linkbutton near to the Captcha imagebutton and give the path to capthanew.aspx this will give a dynamic code whenever you reload the page by linkbutton.

Actually how this captcha code works means, we just create a random numbers and characters and create a bitmap image and render these two things. We can give our own color also.

Happy code for Captcha. download the capthanew.aspx file from here Download

Basic Syntax in c# Language

2010-01-04T09:08:00.000-08:00

A variable is a location in the memory that has a name and contains a value. Variable means the value can be changed. A variable name may contains ‘_’ (underscore) followed by a sequence of letters, digits(0-9), or underscores. The first character in a variable name cannot be a digit

//Variable Declaration
[data_type] [variable_name]=[value];

//Data types are two types.
Value types:- The values are directly containing the data.
Char, int and float are value types

Example:

int a = 10; // 'a' is a variable that contains the values 10.
char c=’S’; // 'c' is a character variable that contains the value 'S'.
float f=10.22; // 'f' is a float variable that contains the value 10.22

Reference types:- The reference types do not maintain the data but they contain reference to the variables.
String is a reference types

Example:

string siteName= "dotnetpgm.blogspot.com"; //string is a set of character.

Looping statements in c#

1. The for loop
2. The while loop
3. The do...while loop

The for loop structure is used to execute a block of statements for a specific number of times.

//for loop for 5 times iteration

int index = 0;
for ( int index = 0; index < 5; index++ )
{
Response.WriteLine(index);
}

//for each is used for array of collection
string[] str = new string[]{ "dotnetblog", "dotnetpgm", "c#" }; //split the string by string by string

foreach(string c in str)
{ Response.WriteLine(c);
}

//while is used to check if the condition is true

int index = 0;
while ( index < 5 )
{
Response.WriteLine(index); ++index;
}

//do while is used to execute the code and then check the condition(only difference between with while)
int index = 0;
do
{
Response.WriteLine ( index );
index++;
}
while ( index < 5 );

Using Conditional Constructs Conditional is used for decision making. The going path is right means we will go if wrong means we will stop there and analyse and then go in the right path. Like this

//the value is true
bool value=true;
if(value)
{
Response.WriteLine("Yes the value is True");
}
else
{
Response.WriteLine("No the value is False");
}

//switch is used for more conditions but one condition will execute
int index=3;
switch(index)
{
case 1:
Response.WriteLine("Index value is "+index);
break;
case 2:
Response.WriteLine("Index value is "+index);
break; case 3: Response.WriteLine("Index value is "+index);
break;
} //the break will quit if the condition execute.

How to send email in Asp.net c#

2009-09-22T00:24:00.000-07:00

How to send email in Asp.net using c#. In Asp.net 2.0,email sending is very easy.In our websites we send a feedback,contact us,registration welcome,Forgot password, news letter etc. to the users mail.By using the Asp.net classes.
we can access to send the email.The Simple Mail Transfer Protocol(SMTP) server is used for deliver the mail
using the System.Net.Mail namespace.

In System.Net.Mail namespace having two sub classes MailMessage and SmptClient.

MailMessage contains the properties From,To,Subject,Body etc.

SmtpClient send the Mailmessage data to the SMTP server.

The SMTP server Store the emails in a queue.It sends the mail one after another.

The steps to send email:-
1.use the namespace.

using System;
using System.Net.Mail;
using System.Text;

2.use the MailMessage to send the mail with SMTP Connection Settings.

MailMessage mailmsg = new MailMessage("yourfromemail@yourdomain.in", "yourtoemail@domain.com");
SmtpClient smtpmail = new SmtpClient();

mailmsg.Subject = "Account information Verified";
StringBuilder bodyMessage= new StringBuilder();

bodyMessage.Append("<br>");
bodyMessage.AppendFormat("Response From your domain name");
bodyMessage.Append("<br>");
bodyMessage.AppendFormat("Your Account has been deleted if you are not activate\n\n");
bodyMessage.Append("<br>");
bodyMessage.AppendFormat("So Please follow the link To Activate Your Account with Us!\n\n");
bodyMessage.Append("Click Here To Activate Your Account");
bodyMessage.AppendFormat("Registered Email:", "yourtoemail@domain.com");
bodyMessage.AppendFormat("Note:- If U Already Activate your account means Please ignore this message");

mailmsg.Body = bodyMessage.ToString();
smtpmail.Host = "smtp.yourdomain.in";
smtpmail.Port = 587;
smtpmail.Send(mailmsg);

the mail will be send to the to address for activating the account information.

mailmsg.Subject is the subject of our mail.

mailmsg.Body contains the bodymsg string values.it attach the bodymsg with subject.

smtp.Host is your smtp server name for eg.

gmail smtp server is "smtp.gmail.com".

smtpmail.port is the port by sending the mail.

smtpmail.Send function is used to concatenate your message,subject and send the mail through the port with the smtp host address.

Happy to send mail.

how to get ip address using asp.net

2009-09-21T01:05:00.000-07:00

How to get Internet protocol address using asp.net.Internet protocol is a communication between the nodes. Internet protocol, which is used to track a system host and used address the location. If we need to identify the user
who are all accessing our website and store the Internet protocol address in our database is very simple and very easier.

This is the way to track the users Internet protocol address.Fetch a client's Internet protocol address as soon as he access our web site in asp.net.
Some of them may use a proxy Internet protocol address. But we can get their Internet protocol address with this simple code.

Here am giving two methods to find the Internet protocol adress.

using System.Net;//Add the Namespace
//Get Visitor IP address method
public string GetVisitorIpAddress()
{
string stringIpAddress;
stringIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (stringIpAddress == null) //may be the HTTP_X_FORWARDED_FOR is null
{
stringIpAddress = Request.ServerVariables["REMOTE_ADDR"];//we can use REMOTE_ADDR
}
return "Visitor IP is "+stringIpAddress;
}

//Get Lan Connected IP address method
public string GetLanIPAddress()
{
//Get the Host Name
string stringHostName = Dns.GetHostName();
//Get The Ip Host Entry
IPHostEntry ipHostEntries = Dns.GetHostEntry(stringHostName);
//Get The Ip Address From The Ip Host Entry Address List
IPAddress[] arrIpAddress = ipHostEntries.AddressList;
return arrIpAddress[arrIpAddress.Length - 1].ToString();
}

//Get The Visitor Ip Address
string strVisitorIpAddress = GetVisitorIpAddress();

//Get The Lan Ip Address
string strLanIpAddress = GetLanIPAddress();

you will get their ip address.

Connection String in Asp.net

2009-07-11T00:13:00.000-07:00

Connection string in asp.net c#.In Asp.net there is an easier way give the Connection String.we can add more than one Connection String in the web.config file.Then we can access these Connection Strings in any of our Pages.This is a simply superb concept in Asp.net. for example,You have two
Connection Strings one for your local server and another one for your live server.You simply add these two Connections in the web.config file and access the first connection in one page and in another page you can use the next connection.

ok, how to save this?

Well,Programming with C# is very easier when compared to other languages.give the coding below in your web.config file,

in configuration section,

add the
<connectionStrings>
<add name="Conn" connectionstring="server=.;database=Northwind;Integrated Security=True;"/>
</connectionStrings>

what is server?
may be the server is your localhost or your web server,if localhost means you just give the '.' or if your server is web server means just give the web server address 'XXX.XX.XXX'.

what is database?
database is the collection of data stored in a system.Its having a unique name.

what is Integrated Security?
if you are working in localhost means you dont need to give your userid and password.you just give the Integrated Security=True.

if you are using a webserver means the connection string will be slightly change,

<connectionStrings>
<add name="Conn" connectionstring="server=XXX.XXX.XX;database=Northwind;uid=yourserveruserid;pwd=yourserverpassword;/>
</connectionStrings>

what is uid and pwd?
uid is the userID when the sql installation you will give the userid and password.those userid and password will give here.

then,next step how to access this in our .aspx.cs file

add this namespace
using System.Data.Sqlclient

then add this in

SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString.ToString());

con.Open();
is used for connection opening

con.Close();
is used for connection closing.

This is the way of accessing the Connection Strings in all the pages.

Grid view in Asp.Net c#.

2009-02-09T20:39:00.001-08:00

Grid view control in asp.net 2.0 is the replacement of Data grid in asp.net 1.1. Grid view is used to bind the data source. The whole database can be viewed in one gridview with colorful and formatted. We can easily view, edit, update and delete the data from this Grid view control. Default Paging is available in this Grid view control. In Asp.net grid view is a very simple and superb control. It reduce our work and perform good.


//Code for binding the data

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString.ToString());
if (!IsPostBack)
{
BindGridview();
}
}

In Page load event the grid view function will call in not is post back,

What is IsPostBack?
The page load event is called when each and every time the page is loaded. If the page is already loaded and waiting for a result means, that time the page could not load again because its not a fresh page. We already give the data in that page.


public void BindGridview()
{
sqlDataAdapter adap=new sqlDataAdapter("Select * from tablename",con);
DataTable dtcommon=new DataTable();
adap.Fill(dtcommon);
Gridview1.DataSource=dtcommon;
Gridview1.DataBind();
}

//Row editing in Grid view

This is for editing a particular row in grid view, if you click the edit it shows textbox box for all the field in a row.


protected void Gridview1_RowEditing(object sender, GridViewEditEventArgs e)
{
Gridview1.EditIndex = e.NewEditIndex;
BindGridview();
}

//Row updating in grid view

After clicking the edit button it shows textbox for all the field in a row. In that textbox edit the fields you want.


protected void Gridview1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int key=Convert.ToInt32(Gridview1.DataKeys[e.RowIndex].Value);
TextBox txtuname=(TextBox)Gridview1.Rows[e.RowIndex].Cells[0].Controls[0];
TextBox txtpass = (TextBox)Gridview1.Rows[e.RowIndex].Cells[1].Controls[0];
SqlCommand cmd=new SqlCommand("update tblname set username='"+txtuname.Text+"', password='"+txtpass.Text+"' where userid='"+key.ToString()+"'",con);
con.open();
cmd.ExecuteNonQuery();
con.close();
BindGridview();
}

//Row cancel editing in grid view

If the edit is not need means just click the cancel button, it shows the edit button after clicking


protected void Gridview1_RowCancelingEdit(object sender, GridViewEditEventArgs e)
{
Gridview1.EditIndex = -1;
BindGridview();
}

//Row delete in grid view

If you need to delete a particular row just use this code to delete


protected void Gridview1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int key=Convert.ToInt32(Gridview1.DataKeys[e.RowIndex].Value);
SqlCommand cmd=new SqlCommand("delete from where userid='"+key.ToString()+"'",con);
con.open();
cmd.ExecuteNonQuery();
con.close();
BindGridview();
}

//Paging in grid view

The Paging in grid view is an easier way to do the paging, first set the allowpaging property to true and give the page size in gridview.


protected void Gridview1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Gridview1.PageIndex = e.NewPageIndex;
BindGridview();
}

//Gridview on mouse over the colour will differentiate the row

When mouse over on a row it highlight the current row with gray color and mouseout on a row it shows a normal white color.


protected void Gridview1_RowCreated(object sender, GridViewRowEventArgs e)
{
string onmouseoverStyle = "this.style.backgroundColor='gray'";
string onmouseoutStyle = "this.style.backgroundColor='white'";
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowState == DataControlRowState.Alternate)
{
e.Row.Attributes.Add("onmouseover", onmouseoverStyle);
e.Row.Cells[0].ToolTip ="Click Here To see Enquiry Details";
e.Row.Attributes.Add("onmouseout", onmouseoutStyle);
}
}

these are the sample code for gridview.