Posted on: 9/13/2012 2:35:11 AM | Views : 297

Hi
This is my cs code 
private void My() { DataTable dt = new DataTable(); foreach (GridViewRow row in Gridview1.Rows) { TextBox box1 = (TextBox)row.FindControl("TextBox11"); TextBox box2 = (TextBox)row.FindControl("TextBox3"); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); con.Open(); SqlCommand cmmd1 = new SqlCommand("Select Rate from Master where Process in ('" + box1.Text + "')", con); SqlDataAdapter ada = new SqlDataAdapter(cmmd1); dt.Clear(); ada.Fill(dt); if (dt.Rows.Count > 0) { string result = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (i == 0) { result = dt.Rows[i]["Rate ...

Go to the complete details ...