Help DataSet for WebReport

Matheus Vinicios

Help DataSet for WebReport
Code:

protected void Wrp_Usuario_StartReport(object sender, EventArgs e)
{
StringBuilder SqlQuery = new StringBuilder();
SqlCommand MsSql_Command = new SqlCommand();
SqlDataAdapter MsSql_DataAdapter = new SqlDataAdapter();
DataSet MsSql_DataSet = new DataSet();
SqlConnection MsSql_Connection;

string Cnx = "Data Source=10.1.1.10;Initial Catalog=db_univag;Persist Security Info=True;User ID=univagweb2;Password=**********";

SqlQuery.AppendLine(" SELECT TOP 50 ");
SqlQuery.AppendLine(" codigo ");
SqlQuery.AppendLine(" , funcionario ");
SqlQuery.AppendLine(" , nome_completo ");
SqlQuery.AppendLine(" , nome_login ");
SqlQuery.AppendLine(" FROM usuario ");

MsSql_Connection = new SqlConnection(Cnx);
MsSql_Command.Connection = MsSql_Connection;
MsSql_Command.CommandType = CommandType.Text;
MsSql_Command.CommandTimeout = 300;
MsSql_Command.CommandText = SqlQuery.ToString();
MsSql_DataAdapter.SelectCommand = MsSql_Command;
MsSql_DataAdapter.Fill(MsSql_DataSet, "usuario");

MsSql_Connection.Dispose();
MsSql_Connection.Close();

if (MsSql_DataSet.Tables["usuario"].Rows.Count > 0)
{
Report report = Wrp_Usuario.Report;
report.RegisterData(MsSql_DataSet.Tables["usuario"], "usuario");
}

}


Thank you!!
Matheus Vinicios
Cuiab??/MT - Brazil

AlexTZ

Hello,

Everything seems correct. What is your question?

Matheus Vinicios

The WebReport not update when you run the database of this method. Is there a solution?

AlexTZ

I want to look at the report file. Please attach it here or send to tz@fast-report.com.

AlexTZ

Try to change your code ("usuario" -> "Usuario"):

report.RegisterData(MsSql_DataSet.Tables["usuario"], "Usuario");

Matheus Vinicios

AlexTZ, have sent an attachment in your e-mail. 'm On Hold. Thank you for your help.

Matheus Vinicios

AlexTZ, worked out to God. But he can not be the same as the table name of the dataset? Explain me please?
What better product for me to buy? Here the company is education and medium enterprises.
Thank you!

AlexTZ

wrote:

But he can not be the same as the table name of the dataset? Explain me please?

Your report has an embedded datasource with "Usuario" name. This code just replaces the embedded datasource with the new one (from your application).

wrote:

What better product for me to buy?

Since you use ASP.NET, you need FastReport.Net Win+Web, or FastReport.Net Professional (if you need source code).

Matheus Vinicios

What is the difference between Single, Team and Site?

AlexTZ

Single = 1 developer
Team = upto 4 developers
Site = unlimited number of developers in one company