How to save the data from grid view to sqlserver?

Hi 

i have pasted sample code .. it may help give you some idea

   foreach (GridViewRow row in urgridname.Rows) 
   {
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["constring"]);
     SqlCommand cmd = new SqlCommand();


//find controls value like below 
string qty = (row.FindControl("txtQty") as TextBox).Text // in case of textbox
 string name = (row.FindControl("txtName") as TextBox).Text

     cmd.CommandText = "INSERT INTO YOUR_TABLE_NAME (NAME, CITY) VALUES ('" name + "','" + qty + "')";


cmd.ExecuteNonQuery();
}