alen332
چهارشنبه 20 مرداد 1389, 10:10 صبح
با سلام خدمت دوستان من با CristalReport Viewer و دستورات Sql گزارشات تهيه مي كنم .مشكلي كه دارم اينه كه اگر طبق عكس ضميمه فقط بخواهم گزارش بين دو تاريخ داشته باشم شرط دستور IF در اين خط
if (maskedTextBox1.Text== "" && maskedTextBox2.Text== "" && comboBox1.Text == "")
چي بنويسم تا دستور SQL مرتبطش اجراء بشه؟ راستي همه كد رو هم توي زير آوردم
private void button1_Click(object sender, EventArgs e)
{
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
DataSet ds = new DataSet();
if (maskedTextBox1.Text== "" && maskedTextBox2.Text== "" && comboBox1.Text == "")
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition WHERE " +
"Date_B_Input BETWEEN '" + maskedTextBox1.Text + "' AND '" + maskedTextBox2.Text + "'";
}
else if (maskedTextBox1.Text == " / /" && maskedTextBox2.Text == " / /" && comboBox1.Text == "")
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition ";
}
else
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition WHERE " +
"Date_B_Input BETWEEN '" + maskedTextBox1.Text + "' AND '" + maskedTextBox2.Text + "' AND " +
"Publisher_Name = '" + comboBox1.Text + "'";
}
objDataAdapter.Fill(ds, "All_Condition");
DataView dv = new DataView(ds.Tables["All_Condition"]);
dv.Sort = "B_Isbm";
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(dv);
crystalReportViewer1.ReportSource = cr;
}
if (maskedTextBox1.Text== "" && maskedTextBox2.Text== "" && comboBox1.Text == "")
چي بنويسم تا دستور SQL مرتبطش اجراء بشه؟ راستي همه كد رو هم توي زير آوردم
private void button1_Click(object sender, EventArgs e)
{
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
DataSet ds = new DataSet();
if (maskedTextBox1.Text== "" && maskedTextBox2.Text== "" && comboBox1.Text == "")
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition WHERE " +
"Date_B_Input BETWEEN '" + maskedTextBox1.Text + "' AND '" + maskedTextBox2.Text + "'";
}
else if (maskedTextBox1.Text == " / /" && maskedTextBox2.Text == " / /" && comboBox1.Text == "")
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition ";
}
else
{
objDataAdapter.SelectCommand.CommandText = "SELECT *FROM All_Condition WHERE " +
"Date_B_Input BETWEEN '" + maskedTextBox1.Text + "' AND '" + maskedTextBox2.Text + "' AND " +
"Publisher_Name = '" + comboBox1.Text + "'";
}
objDataAdapter.Fill(ds, "All_Condition");
DataView dv = new DataView(ds.Tables["All_Condition"]);
dv.Sort = "B_Isbm";
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(dv);
crystalReportViewer1.ReportSource = cr;
}