DOTNET零碎总结 VB.NET修改数据存在多个txtbox时,SQL语句的操作 .

DOTNET零碎总结---VB.NET修改数据存在多个txtbox时,SQL语句的操作 毕业论文 
1. 一个Button1的text为查询和一个DataGridView1,点击查询按钮的代码
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim strConn = "Data Source=192.168.1.110/orcl;User ID=test;Password=orcl"
        Dim dbcmd As OracleCommand
        Dim dt = New DataTable("ds")
        Dim dbConnection As OracleConnection
        Try
            dbConnection = New OracleConnection(strConn)
            dbConnection.Open()
            dbcmd = dbConnection.CreateCommand
            dbcmd.CommandText = "select * from student"
            Dim da As OracleDataAdapter = New OracleDataAdapter(dbcmd)
            da.Fill(dt)
            DataGridView1.DataSource = dt '这时候可以把dt的值直接赋值给DataGridview1控件
        Catch ex As Exception
            MsgBox("查询数据库出错")
        End Try
    End Sub

2.存在两个TextBox1.TextBox2,文本框和一个按钮, Button2,按钮text为修改,点击后的代码
  Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim username, password As String
        Dim temp, temp3 As String
        If Len(TextBox1.Text.Trim) <> 0 Then
            username = "sname=" + "'" + TextBox1.Text.Trim + "'" + " , "
        Else
            username = ""
        End If
        If Len(TextBox2.Text.Trim) <> 0 Then
            password = "spwd=" + "'" + TextBox2.Text.Trim + "'" + " , "
        Else
            password = ""

[1] [2] 下一页