public partial class Form1 : Form { SqlConnection con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CMS;Data Source=KOUSHIK"); SqlDataAdapter da; SqlCommand cmd; DateTime dt = System.DateTime.Now; public Form1() { InitializeComponent(); } private void btnGenerate_Click(object sender, EventArgs e) { cmd = new SqlCommand(); da = new SqlDataAdapter(); cmd.CommandText = "select Accessory_No,Book_Title,Book_Price,Book_Author,Book_Publisher,Date_of_Purchase,Available,Issued,Remaining from BookDetails1"; da.SelectCommand = cmd; cmd.Connection = con; da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); ReportDocument rptc = new ReportDocument(); rptc.Load("D:\\CMS\\BookDetailReport\\BookDetailReport\\BookDetailedReport2.rpt"); rptc.SetDataSource(ds); crystalReportViewer1.ReportSource = rptc; } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { }
cmd.CommandText = "select Accessory_No,Book_Title,Book_Price,Book_Author,Book_Publisher,Date_of_Purchase,Available,Issued,Remaining from BookDetails1 where Column='"+comboBox1.selectedValue.toString()+"'";
if (comboBox1.SelectedValue==null) { MessageBox.Show("Please select a value"); comboBox1.Focus(); return; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)