i try change my datasource but it still exeture old query, i use mysql provider
this my code on my program:
Code: Select all
string il1 = String.Format("CALL getbyDate(\'{0}\',\'{1}\',\'{2}\')", Keyword, Date1, Date2);
string il2 = String.Format("CALL getbyDateIdCom(\'{0}\',\'{1}\',\'{2}\',{3})", Keyword, Date1, Date2, IdCom);
string cSql = IdCom == 0 ? il1 : il2;
StiMySqlSource source = Report.Dictionary.DataSources["dsHeader"] as StiMySqlSource;
source.SqlCommand = cSql;
thanks