我想通过从asp.net中的数据库中选择日期来获取数据 [英] i want to get the data by selecting date from database in asp.net

问题描述

我使用了日历扩展器控件来显示日期，现在每当光标移到应该显示数据库信息的日期时，我就需要按选定的日期显示信息.

i used calender extender control to display date and now i need to show the information by selected date whenever cursor moves into date that should display information from the database.

推荐答案

FStdate = Convert.ToDateTime(Session["Financial-StartDate"].ToString());
          
           txtstartDate.Text = Convert.ToString(FStdate.ToString(CalendarExtender1.Format

));

希望对您有帮助

));

Hop this help you

私有子Button1_Click(ByVal发送者为System.Object，ByVal e为System.EventArgs)处理Button1.Click
昏暗的connetionString作为字符串
昏暗的sqlCnn作为SqlConnection
昏暗的sqlCmd作为SqlCommand
昏暗的适配器作为新的SqlDataAdapter
将Dim ds用作新数据集
Dim i As Integer
昏暗的SQL作为字符串

connetionString =数据源=服务器名称；初始目录=数据库名称；用户ID =用户名称密码=密码"
sql =从表中选择*，其中datecolumn =" + txtDate.Text

sqlCnn =新建SqlConnection(connetionString)
sqlCnn.Open()
sqlCmd =新的SqlCommand(sql，sqlCnn)
adapter.SelectCommand = sqlCmd
adapter.Fill(ds)
对于i = 0到ds.Tables(0).Rows.Count-1
ds.Tables(0).Rows(i).Item(1))
下一个
adapter.Dispose()
sqlCmd.Dispose()
sqlCnn.Close()

结束Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim sqlCnn As SqlConnection
Dim sqlCmd As SqlCommand
Dim adapter As New SqlDataAdapter
Dim ds As New DataSet
Dim i As Integer
Dim sql As String

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserNamePassword=Password"
sql = "Select * from table where datecolumn="+ txtDate.Text

sqlCnn = New SqlConnection(connetionString)
sqlCnn.Open()
sqlCmd = New SqlCommand(sql, sqlCnn)
adapter.SelectCommand = sqlCmd
adapter.Fill(ds)
For i = 0 To ds.Tables(0).Rows.Count - 1
ds.Tables(0).Rows(i).Item(1))
Next
adapter.Dispose()
sqlCmd.Dispose()
sqlCnn.Close()

End Sub

这篇关于我想通过从asp.net中的数据库中选择日期来获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！