根据日期绑定Datagrid [英] binding Datagrid According to date

问题描述

我需要如何从数据集中获取日期并绑定网格中的值

我的约会日期是2011年1月1日至2011年1月3日.在2011年1月1日的"20"或"n"个数字记录中.
例如

我想要那样的Datagridview

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

如果我单击下一步按钮，它想显示02-01-11 ...像这样

我的代码示例

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

推荐答案

受保护的void Button1_Click(object sender，EventArgs e)
{
conn.Open();

SqlCommand cmd =新的SqlCommand("EXEC SP_CUT_OFF""+ TextBox1.Text +"，""+ TextBox2.Text +""，conn);
cmd.ExecuteNonQuery();

SqlCommand cmd_period =新的SqlCommand(从CUT_OFF中选择周期，其中Day(Cut_Off_Date)= Day(Getdate())AND MONTH(Cut_Off_Date)= MONTH(GETDATE())AND YEAR(Cut_Off_Date)= YEAR(GETDATE())"，conn );
对象周期= cmd_period.ExecuteScalar();
字符串Period_My = Convert.ToString(Period);

SqlDataAdapter da =新的SqlDataAdapter(选择USER_ID，PV_AMOUNT作为二进制，DIRECT_INCENTIVE作为DIRECTREFERRAL，LEVEL_INCENTIVE作为LEVELINCOME，TOTAL_PAY，USER_ST作为ST，USER_TDS作为TDS，可在NETPAYABLE上从CUT_OFF_PAYD支付！" = 0，conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
SqlCommand cmd2 =新的SqlCommand("SELECT SUM(CAST(NETPAYABLE AS FLOAT))FROM CUT_OFF_PAYMENT WHERE PERIOD =""+ Period_My +""，conn);
对象总计= cmd2.ExecuteScalar();
Label2.Text = Convert.ToString(Total);
Label1.Text =已付款"；

conn.Close();
}
}

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();
}
}

这篇关于根据日期绑定Datagrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！