private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
if (saveFileDialog1.Filter.IndexOf("Word") > 0)
{
CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, saveFileDialog1.FileName);
}
if (saveFileDialog1.Filter.IndexOf("Excel") > 0)
{
CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, saveFileDialog1.FileName);
}
}
public ActionResult GenerateReport6()
{
DB50Entities db = new DB50Entities();
var c = db.Report11();
CrystalReport11 r = new CrystalReport11();
r.Load();
Stream s = r.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
try
{
OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=products.mdb");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT ID, ProductName, ProductDescription, ProductPrice FROM Products", connection);
// fill dataset
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
connection.Close();
// add virtual column into the result table
dataSet.Tables[0].Columns.Add(new DataColumn("BarcodeImage", typeof(byte[])));
// create barcode object
Barcode barcode = new Barcode(SymbologyType.Code128);
barcode.DrawCaption = false;
// Fill BarcodeImage column with generated barcode image bytes
foreach (DataRow row in dataSet.Tables[0].Rows)
{
// set barcode value
barcode.Value = Convert.ToString(row["ID"]);
// retrieve generated image bytes
byte[] barcodeBytes = barcode.GetImageBytesWMF();
// fill virtual column with generated image bytes
row["BarcodeImage"] = barcodeBytes;
}
// set filled DataSet as report's data source
CrystalReport11.SetDataSource(dataSet.Tables[0]);
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
connection = new SqlConnection(@"Data Source=SANG-LAPTOP\SQLEXPRESS;Initial Catalog=QLSINHVIEN4;Integrated Security=True");
dataAdapter = new SqlDataAdapter("SELECT * FROM KHOA", connection);
dtKhoa = new DataTable();
dataAdapter.Fill(dtKhoa);
dataAdapter.SelectCommand.CommandText = "SELECT SINHVIEN.MaLop, SINHVIEN.NgaySinh, SINHVIEN.HoTen, SINHVIEN.MaSV, LOP.MaLop AS Expr1, KHOA.MaKhoa, KHOA.TenKhoa"
+ " FROM SINHVIEN INNER JOIN"
+ " LOP ON SINHVIEN.MaLop = LOP.MaLop INNER JOIN"
+ " KHOA ON LOP.MaKhoa = KHOA.MaKhoa";
dtSinhVien = new DataTable();
dataAdapter.Fill(dtSinhVien);
cbbKhoa.DataSource = dtKhoa;
cbbKhoa.DisplayMember = "TenKhoa";
cbbKhoa.ValueMember = "MaKhoa";
cbbKhoa.SelectedIndex = -1;
CrystalReport11.SetDataSource(dtSinhVien);
crvDSSV.ReportSource = CrystalReport11;
}
public Form1()
{
InitializeComponent();
try
{
// MODIFY THE CONNECTION STRING WITH YOUR SERVER CONNECTION INFO!!!
const string connectionString = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=master;Integrated Security=true;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
// Create a database for demonstration purposes
///////////////////////////////////////////////////////////////////////////////////////
Object o = ExecuteQueryScalar(connection, "SELECT DB_ID('example_db')");
// if 'example_db' does not exist, create it
if (o == null || o is DBNull)
{
// Create empty database
ExecuteQueryWithoutResult(connection, "CREATE DATABASE example_db");
// Switch to created database
ExecuteQueryWithoutResult(connection, "USE example_db");
// Create a table
ExecuteQueryWithoutResult(connection, "CREATE TABLE Products ([Product ID] int, [Product Name] nvarchar(100), [Product Description] nvarchar(255))");
// Fill the table with data
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(1, 'Spreadsheet Tools', 'Convert XLS, XLSX, CSV, ODS spreadsheet into HTML, PDF, XLS, XLSX, CSV formats WITHOUT EXCEL installed')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(2, 'Watermarking PRO', 'Professional tool to protect images: multiple watermarks, custom position for watermarks, image effects, EXIF and IPTC macros for text and more')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(3, 'Watermarking', 'Protect copyrights for your images with professional looking watermarks with this easy to use tool')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(4, 'PPT To Video Scout', 'converts PowerPoint presentations (PPT, PPTX) into AVI,MPEG,WMV, FLV (flash video) video movies with sound')");
}
// Create a datataset from query.
// Query result columns must conform to field names we used in the report designer
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT [Product ID], [Product Name], [Product Description] FROM example_db.dbo.Products", connection);
// fill dataset
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
// don't forget to close the connection
connection.Close();
// add virtual column into the result table
dataSet.Tables[0].Columns.Add(new DataColumn("BarCode", typeof(byte[])));
// create barcode object
Barcode bc = new Barcode(SymbologyType.Code39);
bc.DrawCaption = false;
foreach (DataRow row in dataSet.Tables[0].Rows)
{
// set barcode value
bc.Value = (Convert.ToString(row["Product ID"]));
// retrieve generated image bytes
byte[] barcodeBytes = bc.GetImageBytesWMF();
// fill virtual column with generated image bytes
row["BarCode"] = barcodeBytes;
}
// set report datasource
CrystalReport11.SetDataSource(dataSet.Tables[0]);
}
}
catch (Exception ex)
{
Trace.WriteLine("Error: " + ex.Message);
}
}
private void FrmMain_OnPassTestNumber(string TestNumber)
{
TestData = TestNumber;
string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
string path = (System.IO.Path.GetDirectoryName(executable));
AppDomain.CurrentDomain.SetData("Data Directory", path);
dsReport ds = new dsReport();
string test = "SELECT * FROM tblTest WHERE TestNumber = @testnumber";
string excitation = "SELECT * FROM tblExcitation WHERE TestNumber = @testnumber";
string ipf = "SELECT * FROM tblIPF WHERE TestNumber = @testnumber";
string bushing = "SELECT * FROM tblBushing WHERE TestNumber = @testnumber";
string ttr = "SELECT * FROM tblTTR WHERE TestNumber = @testnumber";
string winding = "SELECT * FROM tblWinding WHERE TestNumber = @testnumber";
string dielectric = "SELECT * FROM tblDielectric WHERE TestNumber = @testnumber";
string oilpf = "SELECT * FROM tblOilPF WHERE TestNumber = @testnumber";
try
{
using (SqlConnection con = new SqlConnection(constring))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(test, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Test"]);
}
}
using (SqlCommand cmd = new SqlCommand(excitation, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Excitation"]);
}
}
using (SqlCommand cmd = new SqlCommand(ipf, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["IPF"]);
}
}
using (SqlCommand cmd = new SqlCommand(bushing, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Bushing"]);
}
}
using (SqlCommand cmd = new SqlCommand(ttr, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["TTR"]);
}
}
using (SqlCommand cmd = new SqlCommand(winding, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Winding"]);
}
}
using (SqlCommand cmd = new SqlCommand(dielectric, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Dielectric"]);
}
}
using (SqlCommand cmd = new SqlCommand(oilpf, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["OilPF"]);
}
}
con.Close();
}
CrystalReport11.SetDataSource(ds);
crystalReportViewer1.ReportSource = CrystalReport11;
crystalReportViewer1.Refresh();
}
finally
{
frmMain.OnPassTestNumber -= FrmMain_OnPassTestNumber;
}
}
public CReport(IQueryable shkafs)
{
InitializeComponent();
CrystalReport11.SetDataSource(shkafs);
//CrystalReport11.SetDataSource(DataBaseAccess.db.Shkafs);
}
private void btnXuatReport_Click(object sender, EventArgs e)
{
dtSinhVien.DefaultView.RowFilter = "MaKhoa= '" + cbbKhoa.SelectedValue.ToString() + "'";
CrystalReport11.SetDataSource(dtSinhVien.DefaultView);
crvDSSV.ReportSource = CrystalReport11;
}
