One Problem
-
hi.... i have made two fields in SQL server 2005 named DistrictId smallint and DistrictName varchar(100).In a web application (language C#) i have made a form in which i have made a text box in which user will enter the name of the district which he want to modify.i want a code for the purpose that user will enter the name of district and when he click on the button named MODIFY the district name will be modified.Please help me as soon as possible...........
-
hi.... i have made two fields in SQL server 2005 named DistrictId smallint and DistrictName varchar(100).In a web application (language C#) i have made a form in which i have made a text box in which user will enter the name of the district which he want to modify.i want a code for the purpose that user will enter the name of district and when he click on the button named MODIFY the district name will be modified.Please help me as soon as possible...........
SqlParameter[] myparm = new SqlParameter[2]; myparm[0] = new SqlParameter("@DistrictNewName", this.txtDistricNewName.Text); myparm[1] = new SqlParameter("@DistrictName", this.txtDistricName.Text); String SqlQuery = "UPDATE TableName SET DistrictName = @DistrictNewName WHERE DistrictName = DistrictName"; This should get you started.