Member Avatar for 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

  • 4 Contributors
  • 5 Replies
  • 72 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by nebyas

Recommended Answers

All 5 Replies

Member Avatar for 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 !!!

Member Avatar for ritesh2190

still error is there
End of statement of expected

Member Avatar for 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

Member Avatar for reach_yousuf

Hi,

Hope this will work,

myCommand.CommandText = "update Stutable set password = '" & TextBox2.Text & "'  where rollno = " & TextBox3.Text
Edited by kvprajapati because: Corrected [code] tags.
Member Avatar for nebyas

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

commented: Are you sure this will help OP? -2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.