how to extract data of a particular month from database and display data in gridview in asp .net?

Question

0.00/5 (No votes)

See more:

Hello..... I've created a database in which i have saved some data along with date. Now i want to extract data from database of a particular month by selecting Calender and to display data in gridview in asp.net. Please solve my problem. My code is as of follows:

private SqlConnection cn = new SqlConnection("User Id=sa;Password=12345;Database=Satyam;Server=CHIKLU-PC");
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        cn.Open();
        try
        {
            SqlCommand cm = new SqlCommand("SELECT * FROM empreport WHERE ename='" + TextBox1.Text + "' and indate='" +Calender1.SelectedDate.Month.ToShortDateString()+ "'", cn);
            SqlDataAdapter da = new SqlDataAdapter(cm);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
        }
        cn.Close();

Posted 6-Feb-13 5:43am

Chiklu.Soumya

Updated 6-Feb-13 5:47am

Richard C Bishop

v2

Add a Solution

Comments

Richard C Bishop 6-Feb-13 11:48am

Are you receiving any exceptions? Where does the code stop when you are debugging?

Chiklu.Soumya 6-Feb-13 11:55am

It doesn't showing any exception. It's working only when a specific date is selected.(Calender1.SelectedDate.ToShortDateString)i'm using this code. But I want it in month and don't know how to do it.

Richard C Bishop 6-Feb-13 12:08pm

I would just use "Calendar1.SelectedDate.Month.ToString()". Try that and see what happens.

Chiklu.Soumya 6-Feb-13 12:26pm

No. Error. But gridview doesn't showing any data.

Richard C Bishop 6-Feb-13 12:42pm

If you are not getting any error, than your query is not returning anything. What datatype is the field "indate" in your query?

Chiklu.Soumya 6-Feb-13 12:56pm

datetime

Chiklu.Soumya 6-Feb-13 13:23pm

Is it possible to extract data from a table of a particular month by selecting any date(of that month) in calender and to display them in a gridview(table doesn't have a month column and it has column of datetime where only dates are saved.).So is it possible to get month from those dates.
Ex: CREATE TABLE Sales(productname varchar(50),quantity int,saledate datetime)
Insert: Nokia,10,02/07/2011. Can I select month from the specified date from table?

Chiklu.Soumya 6-Feb-13 13:26pm

Is it possible to extract a month from specific date from datebase?

Richard C Bishop 6-Feb-13 14:16pm

Yes, if I understand correctly. Change your query to this: "SELECT * FROM empreport WHERE ename='" + TextBox1.Text + "' and indate like '%" + Calender1.SelectedDate.Month.ToString() + "%'".

1 solution

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)

Sandeep Mewara · Answer 1 · 2013-02-06T06:44:00

You need to write query to get data for a given month. Try something like following:

SQL

SELECT 
   * 
FROM
   empreport
WHERE
   MONTH(myDateColumn) = @SelectedMonthParam

Refer: MSDN: MONTH (Transact-SQL)[^]
NOTE 1: Make sure datatypes match. It returns integer , so pass integer from frontend.
NOTE 2: MONTH returns the same value as DATEPART (month, date).

BTW, the way you have implemented ADO.NET is open for SQL Injection. Read about protecting from SQL Injection here: SQL Injection Mitigation: Using Parameterized Queries[^]