Error please correct

[ritesh2190]

myCommand.CommandText = "update Stutable set password as ('" & TextBox2.Text & "')"" where rollno = " & TextBox3.Text

please can you tell me what is the error in the above statement iam using vb and access database

[reach_yousuf]

myCommand.CommandText = "update Stutable set password as ('" & TextBox2.Text & "')"" where rollno = " & TextBox3.Text

please can you tell me what is the error in the above statement iam using vb and access database

myCommand.CommandText = "update Stutable set password = '" & TextBox2.Text & "'" where rollno = " & TextBox3.Text

Mark as solved if it helps !!!

[ritesh2190]

still error is there
End of statement of expected

[dnanetwork]

SqlCommand comm = new SqlCommand();
        comm.CommandText = "update table set field1=@field1 where no=@no";
        comm.Parameters.AddWithValue("@field1", "pass the parameter value");
        comm.Parameters.AddWithValue("@no", "pass the parameter value");

keep your code organised..
hope that helps

[reach_yousuf]

Hi,

Hope this will work,

myCommand.CommandText = "update Stutable set password = '" & TextBox2.Text & "'  where rollno = " & TextBox3.Text

[nebyas]

"update Stutable set password as ('" & TextBox2.Text & "') where rollno = " & TextBox3.Text