datasource change?
Posted: Wed Mar 02, 2011 4:48 am
hai..
i try change my datasource but it still exeture old query, i use mysql provider
this my code on my program:
may you help me?
thanks
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