Last post Apr 08, 2019 09:46 AM by Jenifer Jiang
Apr 06, 2019 12:04 PM|callykalpana|LINK
Apr 08, 2019 09:46 AM|Jenifer Jiang|LINK
I actually created a data table to store each cells 15 fields information and trying to use stored procedure to insert it into the database. Is this the right approach,
Yes, you could use stored procedure.
In my opinion, I suggest that you could just use different SQL statement to insert the data to the datebase you want.
string testvalue = (gridview1.FindControl("yourcontrolid") as Label).Text;
string query = "insert into table_name values(" +testvalue+ ")";