Private Sub Button1_Click(sender As Object, e As System.EventArgs)具有多个带有相同签名的定义

ら゛糊涂包(备注来意) ら゛糊涂包(备注来意) 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
为什么“Private Sub Button1_Click(sender As Object, e As System.EventArgs)”具有多个带有相同签名的定义。
Imports System.Data.SqlClient '添加引用命名空间
Public Class Tadd
Dim connstr As String = ("Data Source= LAPTOP-IVGA33CA;Initial Catalog=JXGL;Integrated Security=True") '建立连接
Dim conn As New SqlClient.SqlConnection(connstr)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim insertsql As String = "insert into T(t#,tnametssex,tbirthin,titleof,trsection,tel)"
Dim cmd As New SqlClient.SqlCommand(insertsql, conn)
'检查添加的教师号是否存在
Dim sqlstring As String = "select * from T where t#='" & TextBox1.Text & "' "
conn.Open()
Dim com2 As New SqlClient.SqlCommand(sqlstring, conn)
Dim read1 As SqlDataReader = com2.ExecuteReader
If read1.Read() Then
MsgBox("该教师号已存在!", MsgBoxStyle.Information, "提示!")
TextBox1.Text = ""
TextBox2.Text = ""
ComboBox1.Text = "男"
DateTimePicker1.Value = "1965/12/31"
ComboBox2.Text = ""
ComboBox3.Text = ""
TextBox3.Text = ""
ElseIf TextBox1.Text = "" Then
MsgBox("请输入教师号!", MsgBoxStyle.Information, "提示!")
ElseIf TextBox2.Text = "" Then
MsgBox("请输入姓名!", MsgBoxStyle.Information, "提示!")

Else
'添加新教师的信息
conn.Close()
cmd.Parameters.Add("@T#", SqlDbType.VarChar).Value = TextBox1.Text
cmd.Parameters.Add("@tname", SqlDbType.VarChar).Value = TextBox2.Text
cmd.Parameters.Add("@tsex", SqlDbType.VarChar).Value = ComboBox1.Text
cmd.Parameters.Add("@tbirthin", SqlDbType.VarChar).Value = DateTimePicker1.Value
cmd.Parameters.Add("@titleof", SqlDbType.VarChar).Value = ComboBox2.Text
cmd.Parameters.Add("@trsection", SqlDbType.VarChar).Value = ComboBox3.Text
cmd.Parameters.Add("@tel", SqlDbType.VarChar).Value = TextBox3.Text
conn.Open()
cmd.ExecuteNonQuery()
MsgBox("教师信息添加成功!", MsgBoxStyle.Information, "提示!")
End If
TextBox1.Text = ""
TextBox2.Text = ""
ComboBox1.Text = "男"
DateTimePicker1.Value = "1965/12/31"
ComboBox2.Text = ""
ComboBox3.Text = ""
TextBox3.Text = ""
conn.Close()
End Sub

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
Me.Close()
End Sub

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

End Sub
End Class
...全文

相关推荐

关于VB多线程托管

vb.net多线程中跨线程访问控件.建立托管程序。

yisionchen

vb.net 文本浏览FolderBrowserDialog使用方法

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Set the FolderBrowser dialog properties With (FolderBrowserDialog1) .Description = "Select a backup folder" .RootFolder = Environment.SpecialFolder.MyComputer .ShowNewFolderButton = False 'true 表示显示新建文件夹按钮

lixan8672

显示当前时间和日期

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Text = Now End Sub

chenxh

vb+sql学生成绩管理系统

VB与sql设计代码: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click '选择普通用户登录 If Me.RadioButton1.Checked Then Dim str As String str = "data source=PC-201103171305\SQLEXPRESS;database=学生信息库;user id=sa;pwd=" Dim con As New SqlClient.SqlConnection(str) Try con.Open() Catch ex As Exception End Try Dim sql As String = "select * from 普通用户where 用户名='" & TextBox1.Text.ToString().Trim() & "' and 密码='" & TextBox2.Text.ToString().Trim() & " '" Dim cmd As New SqlClient.SqlCommand(sql, con) Dim reader As SqlClient.SqlDataReader Try reader = cmd.ExecuteReader If reader.Read() = True Then Dim 学生成绩管理系统As New 学生信息管理系统 学生成绩管理系统.添加DToolStripMenuItem.Enabled = False 学生成绩管理系统.修改KToolStripMenuItem.Enabled = False 学生成绩管理系统.删除DToolStripMenuItem.Enabled = False 学生成绩管理系统.添加ToolStripMenuItem.Enabled = False 学生成绩管理系统.高级用户信息管理ToolStripMenuItem.Enabled = False 学生成绩管理系统.Show() Me.Hide() Else MsgBox("对不起,用户名或密码错误!重新输入(请正确选择用户类型)", 16, "警告") Me.TextBox1.Text = "" Me.TextBox2.Text = "" TextBox1.Focus() End If Catch ex As Exception End Try End If '选择高级用户登录 If Me.RadioButton2.Checked Then Dim str As String str = "data source=PC-201103171305\SQLEXPRESS;database=学生信息库;user id=sa;pwd=" Dim con As New SqlClient.SqlConnection(str) Try con.Open() Catch ex As Exception End Try Dim sql As String = "select * from 高级用户where 用户名='" & TextBox1.Text.ToString().Trim() & "

mm11122

创建TXT文本并写入及查询以及数据库的写入与查询 交换位置 vb.net

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim path As String path = "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\创建TXT文本并写入及查询\12312\bin\Debug\lio.Txt" '记得自己改路径(绝对路径) Dim strw As New StreamWriter(path, True) 'append为TRUE表示追加 Dim strFull As String = "This is the original text" Dim strOriginal As String = "original" Dim strReplace As String = " modified"

EmicZhang
评论
收藏 已收藏
分享
返回顶部