请教个位大大时间段查询的问题,是windows应用
有2个textbox, 1个button,按button查询时间段里的数据(比如在textbox1里输入2007-1-1 '不输入的时候是显示本月的第一天 ',textbox2里输入2007-2-2 '不输入的时候是显示当天的日子),在datagrid中显示出来,不是时间段里的信息就不显示在datagrid.我想问下这2个textbox怎么设置,写代码.button查询语句怎么写法.我用的是sql server
[解决办法]
TextBox1.Text = DateTime.Today.ToString( "yyyy-MM-01 ")
TextBox2.Text = DateTime.Today.ToString( "yyyy-MM-dd ")
[解决办法]
Public Class Form1
Dim conn As SqlConnection
Dim da As SqlDataAdapter
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ds As New DataSet
Dim dg As New DataGrid
Dim strConn As String = "Provider=SQLOLEDB;Server=服务器IP;uid=用户名;pwd=密码;database=数据库名 "
conn = New SqlConnection(strConn)
conn.Open()
da = New SqlDataAdapter( "SELECT * FROM 表名 WHERE 日期> = " & Convert.ToDateTime(TextBox1.Text) & " AND " & "日期 <= " & Convert.ToDateTime(TextBox2.Text), conn)
da.Fill(ds)
dg.DataSource = ds
End Sub
End Class
[解决办法]
Imports System.Data.SqlClient
.
.
.
Dim conn As New SqlConnection SqlConnection
.
.
.
没有引用system.data.sqlclient
则Dim conn As New System.Data.SqlClient.SqlConnection
