update query
-
hii..... i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA. i hav written following code but still its not updatin..can u help me..plz do help string str = "UPDATE ManageAboutJA SET Description=@Descrip"; SqlCommand cmd = new SqlCommand(str,conn); conn.Open(); cmd.Parameters.Add("@Descrip",TextBox2.Text); cmd.ExecuteNonQuery(); conn.Close(); thanks...
-
hii..... i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA. i hav written following code but still its not updatin..can u help me..plz do help string str = "UPDATE ManageAboutJA SET Description=@Descrip"; SqlCommand cmd = new SqlCommand(str,conn); conn.Open(); cmd.Parameters.Add("@Descrip",TextBox2.Text); cmd.ExecuteNonQuery(); conn.Close(); thanks...
-
UPDATE ManageAboutJA SET Description=@Descrip where emailcolumname='email'
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.
-
hii..... i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA. i hav written following code but still its not updatin..can u help me..plz do help string str = "UPDATE ManageAboutJA SET Description=@Descrip"; SqlCommand cmd = new SqlCommand(str,conn); conn.Open(); cmd.Parameters.Add("@Descrip",TextBox2.Text); cmd.ExecuteNonQuery(); conn.Close(); thanks...
Good Day pariofshona This is the most Dangerous Statement
UPDATE ManageAboutJA SET Description=@Descrip
This will update all the Records in the table, anyway its thats what you want Cool. PLease give us more info , why do you say its not updating, ofcause you dont see results in your db. Please more
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
hii..... i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA. i hav written following code but still its not updatin..can u help me..plz do help string str = "UPDATE ManageAboutJA SET Description=@Descrip"; SqlCommand cmd = new SqlCommand(str,conn); conn.Open(); cmd.Parameters.Add("@Descrip",TextBox2.Text); cmd.ExecuteNonQuery(); conn.Close(); thanks...