about Update Button

[steven2u]

hi, now i'm doing change password form but i try a lot of sample already but still can't work , who can show me the example.

this is my code can u check for me thank you!!!





Imports System.Data.SqlClient

Public Class Form2
Inherits System.Windows.Forms.Form

Dim cn As New SqlConnection
Dim da As New SqlDataAdapter
Dim cm As New SqlCommand
Dim ds As New DataSet
Dim dsEmp As New DataSet
Dim cmEmp As New SqlCommand
Dim SQLstr As String
Dim RowNo As Integer = 0

Dim i As Integer
Dim cm1 As CurrencyManager
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

cn.ConnectionString = "data source=(local);integrated security=SSPI;initial catalog=videosystem;"
cn.Open()


cmEmp.Connection = cn
cmEmp.CommandText = "select * from Employees"

da.SelectCommand = cmEmp
da.Fill(dsEmp, "Employees")

cm.Connection = cn
ds.Clear()

SQLstr = "select * from Employees where UserName ='" & str & "'"
cm.CommandText = SQLstr
da.SelectCommand = cm
da.Fill(ds, "Pass")

cm1 = Me.BindingContext(ds, "Pass")


RefreshData()

Dim i As Integer

da.Fill(ds, "Employees")
da.SelectCommand.CommandText = "select * from Employees where UserName= '" & TextBox1.Text & "'"


da.UpdateCommand = New Data.SqlClient.SqlCommand




End Sub
Sub RefreshData()


TextBox1.Text = ds.Tables("Pass").Rows(cm1.Position)(0)
TextBox2.Text = ds.Tables("Pass").Rows(cm1.Position)(1)
TextBox2.Focus()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


da.UpdateCommand.Connection = cn
da.UpdateCommand.CommandText = "update Employees set Password = '" & TextBox2.Text & "'"

Try
da.UpdateCommand.ExecuteNonQuery()
ds.Clear()
da.Fill(ds, "Employees")

Catch Ex As Exception
End Try
cn.Close()
Me.Close()

End Class

[mendhak]

da.UpdateCommand.CommandText = "update Employees set Password = '" & TextBox2.Text & "'"

Are you sure you want to set everyone's password to the same thing?

[steven2u]

hi i'm new i dot net
no i don't want the every one same password ,
if i want different for every 1 so what are the coding i need !!!

i think this way may work direct use sql update statement but now i still find the coding ...

can u show me the coding ? thank you

[mendhak]

Just add a WHERE username = .... like in your first SQL query there.

[steven2u]

hi i'm try already but the problem now is in the sql database table still a old data won't be change and when execute the form will display the right 1 but database table won't be change.

when i add username = textbox2.text then all is not working but no display error.

[mendhak]

Originally posted by steven2u
hi i'm try already but the problem now is in the sql database table still a old data won't be change and when execute the form will display the right 1 but database table won't be change.

when i add username = textbox2.text then all is not working but no display error.

I'm sorry, but HUH?

Can you rephrase that and try explaining again?

[maged]

well i think the real challenge is to understand his words first

LOL