CrystalReport3 CR
=
new
CrystalReport3();
private void Form2_Load( object sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=localhost;Initial Catalog=GJMY;Integrated Security=True;uid =sa;pwd =sa");
myCon.Open();
StringBuilder sb = new StringBuilder();
//sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
//sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
//sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
//sb.Append("dbo.Products.ProductName ");
//sb.Append("FROM dbo.Customers INNER JOIN ");
//sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
//sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
//sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
//sb.Append("select [ID],[yangbjh],[Ctime],[danwei],[liangssl],[cheqhm],[pingz],[dengji],[chucl],");
//sb.Append("[erba],[jindu],[sezqw],[shuif],[zhoul],[kanf],[kuangwz],[daohl],[bizi],[buwsl],[zhengjml],");
//sb.Append("[suimizl],[qizhoxx],[huangml],[yipzhh],[beizhu],[shenh],[jianny],");
//sb.Append("[qianyang],[kandan] from BaoLiangY");
//sb.Append("");
//sb.Append("");
//sb.Append("");
sb.Append ("select * from BaoLiangY");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "BaoLiangY");
CR.SetDataSource(ds.Tables["BaoLiangY"]);
crystalReportViewer1.ReportSource = CR;
crystalReportViewer1.RefreshReport();
myCon.Close();
}
private void Form2_Load( object sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=localhost;Initial Catalog=GJMY;Integrated Security=True;uid =sa;pwd =sa");
myCon.Open();
StringBuilder sb = new StringBuilder();
//sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
//sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
//sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
//sb.Append("dbo.Products.ProductName ");
//sb.Append("FROM dbo.Customers INNER JOIN ");
//sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
//sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
//sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
//sb.Append("select [ID],[yangbjh],[Ctime],[danwei],[liangssl],[cheqhm],[pingz],[dengji],[chucl],");
//sb.Append("[erba],[jindu],[sezqw],[shuif],[zhoul],[kanf],[kuangwz],[daohl],[bizi],[buwsl],[zhengjml],");
//sb.Append("[suimizl],[qizhoxx],[huangml],[yipzhh],[beizhu],[shenh],[jianny],");
//sb.Append("[qianyang],[kandan] from BaoLiangY");
//sb.Append("");
//sb.Append("");
//sb.Append("");
sb.Append ("select * from BaoLiangY");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "BaoLiangY");
CR.SetDataSource(ds.Tables["BaoLiangY"]);
crystalReportViewer1.ReportSource = CR;
crystalReportViewer1.RefreshReport();
myCon.Close();
}
查询:
private
void
button1_Click(
object
sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=localhost;Initial Catalog=GJMY;Integrated Security=True;uid =sa;pwd =sa");
myCon.Open();
StringBuilder sb = new StringBuilder();
//sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
//sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
//sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
//sb.Append("dbo.Products.ProductName ");
//sb.Append("FROM dbo.Customers INNER JOIN ");
//sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
//sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
//sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
sb.Append("select * from BaoLiangY");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "BaoLiangY");
ds.Tables["BaoLiangY"].DefaultView.RowFilter = "ID=" + textBox1.Text;
CR.SetDataSource(ds.Tables["BaoLiangY"].DefaultView);
crystalReportViewer1.ReportSource = CR;
crystalReportViewer1.RefreshReport();
//OrderCR1.SetDataSource(ds.Tables["BaoLiangY"].DefaultView);
//crystalReportViewer1.ReportSource = OrderCR1;
//crystalReportViewer1.RefreshReport();
myCon.Close();
}
... {
SqlConnection myCon = new SqlConnection("Data Source=localhost;Initial Catalog=GJMY;Integrated Security=True;uid =sa;pwd =sa");
myCon.Open();
StringBuilder sb = new StringBuilder();
//sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
//sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
//sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
//sb.Append("dbo.Products.ProductName ");
//sb.Append("FROM dbo.Customers INNER JOIN ");
//sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
//sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
//sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
sb.Append("select * from BaoLiangY");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "BaoLiangY");
ds.Tables["BaoLiangY"].DefaultView.RowFilter = "ID=" + textBox1.Text;
CR.SetDataSource(ds.Tables["BaoLiangY"].DefaultView);
crystalReportViewer1.ReportSource = CR;
crystalReportViewer1.RefreshReport();
//OrderCR1.SetDataSource(ds.Tables["BaoLiangY"].DefaultView);
//crystalReportViewer1.ReportSource = OrderCR1;
//crystalReportViewer1.RefreshReport();
myCon.Close();
}
另一方法:
private
void
Form1_Load(
object
sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
myCon.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
sb.Append("dbo.Products.ProductName ");
sb.Append("FROM dbo.Customers INNER JOIN ");
sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds,"Orders");
OrderCR1.SetDataSource(ds.Tables["Orders"]);
//crystalReportViewer1.ReportSource = OrderCR1;
crystalReportViewer1.RefreshReport();
myCon.Close();
}
private void btReport_Click( object sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
myCon.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
sb.Append("dbo.Products.ProductName ");
sb.Append("FROM dbo.Customers INNER JOIN ");
sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "Orders");
ds.Tables["Orders"].DefaultView.RowFilter = "OrderID="+tbOrderID.Text;
OrderCR1.SetDataSource(ds.Tables["Orders"].DefaultView);
crystalReportViewer1.RefreshReport();
myCon.Close();
}
... {
SqlConnection myCon = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
myCon.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
sb.Append("dbo.Products.ProductName ");
sb.Append("FROM dbo.Customers INNER JOIN ");
sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds,"Orders");
OrderCR1.SetDataSource(ds.Tables["Orders"]);
//crystalReportViewer1.ReportSource = OrderCR1;
crystalReportViewer1.RefreshReport();
myCon.Close();
}
private void btReport_Click( object sender, EventArgs e)
... {
SqlConnection myCon = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
myCon.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT dbo.Customers.CustomerID, dbo.Customers.CompanyName, ");
sb.Append("dbo.[Order Details].OrderID, dbo.[Order Details].UnitPrice, ");
sb.Append("dbo.[Order Details].Quantity, dbo.[Order Details].Discount, dbo.Orders.OrderDate, ");
sb.Append("dbo.Products.ProductName ");
sb.Append("FROM dbo.Customers INNER JOIN ");
sb.Append("dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN ");
sb.Append("dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN ");
sb.Append("dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID ");
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText = sb.ToString();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = myCom;
DataSet ds = new DataSet();
adapter.Fill(ds, "Orders");
ds.Tables["Orders"].DefaultView.RowFilter = "OrderID="+tbOrderID.Text;
OrderCR1.SetDataSource(ds.Tables["Orders"].DefaultView);
crystalReportViewer1.RefreshReport();
myCon.Close();
}
代码填充
public
LYJNlist()
... {
InitializeComponent();
filldata();
}
public void filldata()
... {
string sql = "Data Source=.;Initial Catalog=GJMY;Integrated Security=True";
SqlConnection conn = new SqlConnection(sql);
conn.Open();
string strSQL = "select yangbjh as 样品筒号,Ctime 时间,danwei 单位 from BaoLiangY";
SqlDataAdapter ads = new SqlDataAdapter(strSQL, conn);
DataSet data = new DataSet();
ads.Fill(data, "BaoLiangY");
dataGridView1.DataSource = data.Tables[0];
this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.Bisque;
this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.dataGridView1.GridColor = Color.BlueViolet;
this.dataGridView1.BorderStyle = BorderStyle.Fixed3D;
dataGridView1.ReadOnly=true;
}
... {
InitializeComponent();
filldata();
}
public void filldata()
... {
string sql = "Data Source=.;Initial Catalog=GJMY;Integrated Security=True";
SqlConnection conn = new SqlConnection(sql);
conn.Open();
string strSQL = "select yangbjh as 样品筒号,Ctime 时间,danwei 单位 from BaoLiangY";
SqlDataAdapter ads = new SqlDataAdapter(strSQL, conn);
DataSet data = new DataSet();
ads.Fill(data, "BaoLiangY");
dataGridView1.DataSource = data.Tables[0];
this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.Bisque;
this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.dataGridView1.GridColor = Color.BlueViolet;
this.dataGridView1.BorderStyle = BorderStyle.Fixed3D;
dataGridView1.ReadOnly=true;
}