Here is the code that I wrote.
if (btnFilter.Text == "Filter Off")
{ sds1.SelectCommand = "SELECT [DivisiID], [KodeDivisi],
[Deskripsi] FROM [ldc_divi_mst]"; }
else
{ string strWhere = "SELECT [DivisiID], [KodeDivisi], [Deskripsi]
FROM [ldc_divi_mst]";
if (txtKodeDivisi.Text != "")
{ strWhere += "WHERE [KodeDivisi] LIKE @KodeDivisi"; }
if (txtDeskripsi.Text != "")
{ if (txtKodeDivisi.Text != "")
{ strWhere += " AND [Deskripsi] LIKE @Deskripsi"; }
else { strWhere += "WHERE [Deskripsi] LIKE @Deskripsi"; }}
sds1.SelectCommand = strWhere;
sds1.SelectParameters.Clear();
sds1.SelectParameters.Add("KodeDivisi",TypeCode.St ring,
txtKodeDivisi.Text);
sds1.SelectParameters.Add("Deskripsi",TypeCode.Str ing,
txtDeskripsi.Text);
}
sds1.Select(DataSourceSelectArguments.Empty);
gv1.DataBind();
it seems that gv1 (gridview) did not populate the right data and I think it
cause by sds1 (SQLDataSource) that does not populate the right query
(Command) and always look like this
SELECT [DivisiID], [KodeDivisi], [Deskripsi] FROM [ldc_divi_mst]WHERE
[Deskripsi] LIKE @Deskripsi
or like this
SELECT [DivisiID], [KodeDivisi], [Deskripsi] FROM [ldc_divi_mst]WHERE
[KodeDivisi] LIKE @KodeDivisi AND [Deskripsi] LIKE @Deskripsi
I would like to change parameter deskripsi and kodedivisi to a value.
Regards,
Gunawan
"Patrick.O.Ige" <na********@hotmail.comwrote in message
news:ev**************@TK2MSFTNGP02.phx.gbl...
Gun,
pls post some snippet code and please elaborae more
if u want to refresh GridView then call DataBind
grid.Databind()
Patrick
"Gunawan" <jg**********@gmail.comwrote in message
news:eF**************@TK2MSFTNGP03.phx.gbl...
>Hi All,
I have change select command of a sql data source when user clicking a
button
sds1.SelectCommand = "Select DivisionCode, Description FROM DivisionMst
WHERE Description LIKE @Description";
sds1.SelectParameters.Clear();
sds1.SelectParameters.Add("Description",TypeCode. String,
txtDescription.Text);
I have two question.
1. Why @Description didnot change to txtDescription value?
2. How to refresh GridView that bind to sds1 (SQL Data Source)?
TIA
Gun