binding Datagrid According to date

Question

0.00/5 (No votes)

See more:

i need how get date from dataset and bind the value in grid

i have date 1-01-2011 to 1-03-2011 . In 1-01-2011 "20" or "n" number records .
For example

Datagridview i want like that

Date       Value<br />
1-01-2011   1<br />
1-01-2011   2<br />
1-01-2011   3<br />
1-01-2011   4

if i click next button it want to show 02-01-11... like that

my code sample

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                     {

                         string frmdate1 = ds.Tables[0].Rows[i][0].ToString();
                         string tod22 = Convert.ToDateTime(frmdate1).ToString("dd/MM/yyyy", CultureInfo.CreateSpecificCulture("en-US"));
                         string[] spt22 = tod22.Split('/');
                         frmdate = "" + spt22[2].ToString() + "-" + spt22[1].ToString() + "-" + spt22[0].ToString() + "";
                         string sql = "select ldate as Date from " + tablename + " where  ldate= '" + frmdate + "' order by ldate ASC";
                         SQLiteDataAdapter da = new SQLiteDataAdapter(sql, con);
                         DataSet ds = new DataSet();
                         da.Fill(ds);
                         DataView dataView = ds.Tables[0];
                        
                     }

i have place two button next and previous if i click i want show iterative date in grid

Posted 12-Jul-11 23:16pm

karthickjce

Updated 12-Jul-11 23:21pm

Toniyo Jackson

v2

Add a Solution

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)

rajesh50095 · Answer 1 · 2011-07-13T01:23:00

protected void Button1_Click(object sender, EventArgs e)
{
conn.Open();

SqlCommand cmd = new SqlCommand("EXEC SP_CUT_OFF '" + TextBox1.Text + "','"+TextBox2.Text+"'", conn);
cmd.ExecuteNonQuery();

SqlCommand cmd_period = new SqlCommand("Select Period From CUT_OFF Where Day(Cut_Off_Date) = Day(Getdate()) AND MONTH(Cut_Off_Date) = MONTH(GETDATE()) AND YEAR(Cut_Off_Date) = YEAR(GETDATE())", conn);
Object Period = cmd_period.ExecuteScalar();
string Period_My = Convert.ToString(Period);

SqlDataAdapter da = new SqlDataAdapter("SELECT USER_ID,PV_AMOUNT AS BINARY, DIRECT_INCENTIVE AS DIRECTREFERRAL,LEVEL_INCENTIVE AS LEVELINCOME, TOTAL_PAY, USER_ST AS ST, USER_TDS AS TDS, NETPAYABLE FROM CUT_OFF_PAYMENT WHERE PERIOD = '" + Period_My + "' and NETPAYABLE != 0", conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
SqlCommand cmd2 = new SqlCommand("SELECT SUM(CAST(NETPAYABLE AS FLOAT)) FROM CUT_OFF_PAYMENT WHERE PERIOD = '"+Period_My+"'", conn);
Object Total = cmd2.ExecuteScalar();
Label2.Text = Convert.ToString(Total);
Label1.Text = "PAYOUT GENERATED";

conn.Close();
}
}