i want to get the data by selecting date from database in asp.net

Question

1.00/5 (1 vote)

See more:

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.

Posted 9-Jul-12 23:24pm

amperayani

Add a Solution

Comments

[no name] 10-Jul-12 5:26am

explain briefly
or paste what you done to achive this..

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jeeva G · Answer 1 · 2012-07-09T23:46:00

Solution 1

C#

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

));

Hop this help you

Posted 9-Jul-12 23:46pm

Jeeva G

Comments

amperayani 10-Jul-12 6:28am

i have data on database front end aspx ,codebehind we are using vb.net
...
i have aspx page that contain only label and texbox,calender extender control eg. whenever a person to see on particular past day what he done so he need to put cursor on date that selected date should display what he done on that day. iam using vb.net please tell me vb.net

pradiprenushe · Answer 2 · 2012-07-10T01:09:00

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