Hi Vasanth057,
Refer below code for updating multiple columns with values.
C#
int RouteId = 1; // Value for Where Condition.
string[] columnNames = lblColumnName.Text.Split(','); //Your Column Name.
string[] values = "Val1,Val2,Val3".Split(','); // Your Value for Columns.
string query = "UPDATE tbl_route_info SET ";
string column = "";
for (int i = 0; i < columnNames.Length; i++)
{
column += columnNames[i].Trim() + " = '" + values[i].Trim() + "', ";
}
column += column.Remove(column.LastIndexOf(','));
query += column;
query += " where RouteId = " + RouteId;
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}