datatypes errors in gridview

See more:

Gridview

Hai,


I have some doubts in gridview during updating.Suppose we use ID column as a primary key in sql server.It means in our gridview coding during updating we write as

cmd.Parameters.Add("@ID",SqlDbType.Int).Value =Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);

and for varchar

cmd.Parameters.Add("@NAME", SqlDbType.VarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;

.

My doubt is if we are using salary column in sql server database we have to use money.How can we do this coding in gridview during updation part.And also plz tell me for datetime datatype.