arun kumar

arun kumar

  • NA
  • 13
  • 0

Search value problem in c#

May 8 2012 12:59 PM

Hello sir,

I have a problem in search values in ms access datebase searching date wise

search a values is date wise ex: 4/1/2012 to 4/30/2012 but it's shows some datavalues are missing i attached the screen short below the word document

but i  searched value is ex: 4/1/2012 to 5/1/2012 it's correctly  view of month wise full data values

Kindly please reffer my word doc with clear screen short

my search button code is


 private void button1_Click(object sender, EventArgs e)
        {
           
           
            double sum1 = 0, sum2 = 0, netbal = 0;
            int j = 0;
            //string str = "select * from purmonth where purchasedate between ('" + textBox2.Text + "')and ('" + textBox3.Text + "') and cusid = ('" + comboBox1 .Text  + "') or paiddate between ('" + textBox4.Text + "') and ('" + textBox5.Text + "') and cusid = ('" + comboBox1 .Text  + "')";
            string str = "select * from SalesMonth where SaleDate between ('" + dateTimePicker1.Text + "')and ('" + dateTimePicker2.Text + "') and SalecustomerID = ('" + comboBox1.Text + "') or PaidDate between ('" + dateTimePicker3.Text + "') and ('" + dateTimePicker4.Text + "') and  SalecustomerID = ('" + comboBox1.Text + "')";
            com = new OleDbCommand(str, con);

            DataSet vds = new DataSet();
            OleDbDataAdapter vda = new OleDbDataAdapter(com);
            vda.Fill(vds, "res");

            dataGridView1.DataSource = vds.Tables["res"];
            for (int i = 0; i < dataGridView1.Rows.Count; ++i)
            {

                sum1 += Convert.ToInt32(dataGridView1.Rows[i].Cells[9].Value);
            }

            for (int i = 0; i < dataGridView1.Rows.Count; ++i)
            {
                sum2 += Convert.ToInt32(dataGridView1.Rows[i].Cells[8].Value);
            }


            j = dataGridView1.Rows.Count - 1;
            dataGridView1.Rows[j].Cells[9].Value = sum1.ToString("n");
            dataGridView1.Rows[j].Cells[8].Value = sum2.ToString("n");
            netbal = sum1 - sum2;
            dataGridView1.Rows[j].Cells[10].Value = netbal.ToString("n");
            dataGridView1.Rows[j].Cells[5].Value = "TOTAL";
            vda.Dispose();
            com.Dispose();

i have attached the code with screen short

kindly help me

thinking you



Attachment: hello sir.rar

Answers (1)