exploit344
asked on
insert gridview values into database
i wanna save gridview values to database..
my gridview contains nothing i mean no textbox ,label..
the code i am using it saves the values but save like.."System.Web.UI.WebCo ntrols.Gri dViewRowCo llection" in database column...
now how do i save gridview rows
my gridview contains nothing i mean no textbox ,label..
the code i am using it saves the values but save like.."System.Web.UI.WebCo
now how do i save gridview rows
foreach(GridViewRow row in GridView1.Rows)
{
if(row.RowType==DataControlRowType.DataRow)
{
cmd = new SqlCommand("insert into t1(first,second)values(@first,@second)", con);
cmd.Parameters.AddWithValue("@first",GridView1.Rows[0].ToString());
cmd.Parameters.AddWithValue("@second", GridView1.Rows[1].ToString());
cmd.ExecuteNonQuery();
}
}
2.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER