Dynamically pass colums name to Update Query using C# in ASP.Net

Question

I have a column name which is like in thi formatColumn1Column2Column3 I want to update same values to these columns

AnandM · Accepted Answer

Hi  Vasanth057Refer below code for updating multiple columns with valuesCint RouteId  1  Value for Where Conditionstring columnNames  lblColumnNameTextSplit3939 Your Column Namestring values  34Val1Val2Val334Split3939  Your Value for Columnsstring query  34UPDATE tblrouteinfo SET 34string column  3434for int i  0 i lt columnNamesLength i    column  columnNamesiTrim  34  3934  valuesiTrim  3439 34column  columnRemovecolumnLastIndexOf3939query  columnquery  34 where RouteId  34  RouteIdstring constr  ConfigurationManagerConnectionStrings34constr34ConnectionStringusing SqlConnection con  new SqlConnectionconstr    using SqlCommand cmd  new SqlCommandquery            cmdConnection  con        conOpen        cmdExecuteNonQuery        conClose

Dynamically pass colums name to Update Query using C# in ASP.Net

Company

Explore

Follow us

Contact Us