I want to pass a sql parameter from user form to my report class but it is not working and it does not create the report and when I open the report designer tab again after adding ID argument to the report class it refresh the report and delete my components.
What is the problem?
Here is my report class:
public SodoorZemanatName(long ID)
{
InitializeComponent(ID);
}
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Designer generated code
private void InitializeComponent(long ID)
{
this.components = new System.ComponentModel.Container();
DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery();
DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SodoorZemanatName));
this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand();
this.detailBand1 = new DevExpress.XtraReports.UI.DetailBand();
this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand();
this.sqlDataSource2 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
this.topMarginBand1.HeightF = 100F;
this.topMarginBand1.Name = "topMarginBand1";
this.detailBand1.HeightF = 100F;
this.detailBand1.Name = "detailBand1";
this.bottomMarginBand1.HeightF = 100F;
this.bottomMarginBand1.Name = "bottomMarginBand1";
this.sqlDataSource2.ConnectionName = "Context";
this.sqlDataSource2.Name = "sqlDataSource2";
customSqlQuery1.Name = "Query";
queryParameter1.Name = "ID";
queryParameter1.Type = typeof(long);
queryParameter1.ValueInfo = "0";
queryParameter1.Value = ID;
customSqlQuery1.Parameters.Add(queryParameter1);
customSqlQuery1.Sql = "select * from LG_Garanti where ID=@ID";
this.sqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
customSqlQuery1});
this.sqlDataSource2.ResultSchemaSerializable = resources.GetString("sqlDataSource2.ResultSchemaSerializable");
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.topMarginBand1,
this.detailBand1,
this.bottomMarginBand1});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource2});
this.DataSource = this.sqlDataSource2;
this.Version = "15.2";
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
#endregion
And here is my calling:
SodoorZemanatName report = new SodoorZemanatName(1);
ASPxDocumentViewer1.ReportTypeName = "SodoorZemanatName";
ASPxDocumentViewer1.Report = report;