VS C#2010 MySQL和Crystal报告 [英] VS C# 2010 MySQL and crystal report

问题描述

我正在制作一个程序(Windows应用程序)，我需要将其连接到mysql数据库并生成报告，但无法使它与具有数据集的Crystal Report数据库连接起来有什么想法?

Hi,

I am making a program (windows application) and i need to conect it to mysql database and make a report but a cant make it to connect the database with crystal report with a dataset any idea??

public partial class Form2 : Form { 
private TableLogOnInfo infoEntrada = new TableLogOnInfo(); 
public Form2() { InitializeComponent(); 
} 
private void Form2_Load(object sender, EventArgs e) { confInfoEntrada(); 
CrystalReport1 listaReportes = new CrystalReport1(); 
ReportDocument docReporte = new ReportDocument(); 
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("DataBase", "DataBase");
connBuilder.Add("Data Source", "ipwithdatabasemysql");
connBuilder.Add("User Id", "user");
connBuilder.Add("Password", "pwd"); 
MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString); 
docReporte.Load(@"C:\addresstowhere its located\CrystalReport1.rpt"); 
DataTable tablaDatos = new DataTable(); 
try { 
string cadComando = " "; 
cadComando = "SELECT * FROM table"; connection.Open(); 
MySqlDataAdapter adapDatos = new MySqlDataAdapter(cadComando, connection); 
tablaDatos.Clear(); 
adapDatos.Fill(tablaDatos); 
} 
catch (Exception ex) 
{ MessageBox.Show(ex.Message); 
} 
finally { 
connection.Close(); 
} 
listaReportes.Database.Tables[0].SetDataSource(tablaDatos);
crystalReportViewer1.ReportSource = docReporte; crystalReportViewer1.Zoom(1); 
} private void confInfoEntrada() { 
try { 
infoEntrada.ConnectionInfo.ServerName = "ipwithserver"; 
infoEntrada.ConnectionInfo.UserID = "User"; 
infoEntrada.ConnectionInfo.Password = "pwd"; 
infoEntrada.ConnectionInfo.DatabaseName = "database"; 
} catch (Exception ex) { 
MessageBox.Show(ex.Message); 
} 
} 
} 
} 

推荐答案

此链接将为您提供帮助，
如何使用C#和MySQL创建Crystal报表 [ ^ ]

this link will help you,
How to Create a Crystal Report using C# and MySQL[^]

这篇关于VS C#2010 MySQL和Crystal报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！