Dim sqlStr1 As String
sqlStr1 = "Select * From Users"
Dim DS1 As New Data.DataSet()
Dim Conn1 As New SqlClient.SqlConnection("ConnectionString")
Dim DA1 As New Data.SqlClient.SqlDataAdapter(sqlStr1, Conn1)
DA1.Fill(DS1, "UsersInfo")
Conn1.Close()
Label1.Text = DS1.Tables("UsersInfo").Rows(0).Item("UserName")
Dim sqlStr1 As String
sqlStr1 = "Select * From Users Where UserName='Omidak' And Password='myPassword'"
Dim DS1 As New Data.DataSet()
Dim Conn1 As New SqlClient.SqlConnection("ConnectionString")
Dim DA1 As New Data.SqlClient.SqlDataAdapter(sqlStr1, Conn1)
DA1.Fill(DS1, "UsersInfo")
Conn1.Close()
Label1.Text = DS1.Tables("UsersInfo").Rows(0).Item("UserName")
Dim sqlStr1 As String
sqlStr1 = "INSERT INTO Users(UserName, Password) Values('Omidak', 'myPassword')"
Dim DS1 As New Data.DataSet()
Dim Conn1 As New SqlClient.SqlConnection("ConnectionString")
Dim DA1 As New Data.SqlClient.SqlDataAdapter(sqlStr1, Conn1)
DA1.Fill(DS1, "UsersAdded")
Conn1.Close()
Dim sqlStr1 As String
sqlStr1 = "Update Users Set UserName='Omidak2', Password='Password2' Where UserName='Omidak'"
Dim DS1 As New Data.DataSet()
Dim Conn1 As New SqlClient.SqlConnection("ConnectionString")
Dim DA1 As New Data.SqlClient.SqlDataAdapter(sqlStr1, Conn1)
DA1.Fill(DS1, "UsersUpDate")
Conn1.Close()
Dim sqlStr1 As String
sqlStr1 = "Delete From Users Where UserName='Omidak'"
Dim DS1 As New Data.DataSet()
Dim Conn1 As New SqlClient.SqlConnection("ConnectionString")
Dim DA1 As New Data.SqlClient.SqlDataAdapter(sqlStr1, Conn1)
DA1.Fill(DS1, "UsersDeleted")
Conn1.Close()
در سايت asp.net میشه به همه زبانها رو دیدMafia گفت:آقا بسيار بسيار ممنون!
فقط ميشه يه خواهش كنم كه براي
#C هم اين كدهارو بزاري؟