如何增加一个BUTTON控件,用于复制DATAGRID中的查询结果
时间:2011-12-18
来源:互联网
Insert page code here
'
Function MyQueryMethod(ByVal JS As String) As System.Data.DataSet
Dim connectionString As String = "server='localhost'; user id='sa'; password=''; Database='pubs'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [C115].[HM] FROM [C115] WHERE ([C115].[JS] = @JS)"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
sqlCommand.Parameters.Add("@JS", System.Data.SqlDbType.[Char]).Value = JS
Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
Sub Button1_Click(sender As Object, e As EventArgs)
DataGrid1.DataSource =MyQueryMethod(CInt(TextBox1.Text))
DataGrid1.DataBind()
End Sub
Sub TextBox2_TextChanged(sender As Object, e As EventArgs)
End Sub
'
Function MyQueryMethod(ByVal JS As String) As System.Data.DataSet
Dim connectionString As String = "server='localhost'; user id='sa'; password=''; Database='pubs'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [C115].[HM] FROM [C115] WHERE ([C115].[JS] = @JS)"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
sqlCommand.Parameters.Add("@JS", System.Data.SqlDbType.[Char]).Value = JS
Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
Sub Button1_Click(sender As Object, e As EventArgs)
DataGrid1.DataSource =MyQueryMethod(CInt(TextBox1.Text))
DataGrid1.DataBind()
End Sub
Sub TextBox2_TextChanged(sender As Object, e As EventArgs)
End Sub
作者: GZFWJ 发布时间: 2011-12-18
DATAGRID中查询出的结果不想用鼠标选中复制,想直接增加一个复制控制,点复制后供其他地方粘贴使用,请各位老兄帮这小忙
作者: GZFWJ 发布时间: 2011-12-18
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28