[ sparc @ 11.05.2009. 12:46 ] @
Imam grid koji se bazira na sqldatasource. Moze li se i kako menjati selectcommand u sqldatasource kroz vb.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:wesConnectionString %>"
SelectCommand="SELECT [brTrans], [Pred], [BrPrijema], [dPrijema], [VD], [Analit], [brFak], [dFak], [FakIzn],
[Deviza], [FakDevIzn], [Status], [Korisnik], [dPromene]
FROM [Delovodnik] WHERE (([Pred] = @Pred) AND ([dPrijema] = @dPrijema))"
<SelectParameters>
<asp:SessionParameter Name="Pred" SessionField="Pred" Type="String" />
<asp:ControlParameter ControlID="ASPxDateEdit1" Name="dPrijema" Type="DateTime"
PropertyName="Value" />
</SelectParameters>
</asp:SqlDataSource>

Prilikom otvaranja stranice potrebna mi je selekcija samo po prvom parametru. Prilikom izbora datuma treba ukljuciti i drugi parametar.
[ deerbeer @ 11.05.2009. 14:26 ] @
Otprilike ovako u *.vb-u :
Code:

SqlDataSource1.SelectCommand = "SELECT * FROM [Delovodnik] WHERE [brTrans] = @brTrans"


[ sparc @ 12.05.2009. 07:31 ] @
Hvala na odgovru i ideji, ali to nije dovoljno da bi se dinamicki izvrsavao sqldatasource,
mora da se ispostuje kompletan sledeci kod:

Dim strConnection As String
strConnection = System.Configuration.ConfigurationManager.ConnectionStrings("wesConnectionString").ConnectionString
SqlDataSource1.ConnectionString = strConnection
SqlDataSource1.SelectCommand = "SELECT [brTrans], [Pred], [BrPrijema], [dPrijema], [VD], [Analit], [brFak], [dFak], [FakIzn], [Deviza],
[FakDevIzn], [Status], [Korisnik], [dPromene] FROM [Delovodnik] WHERE [Pred] = @Pred ORDER BY brPrijema DESC"
Dim param As Parameter = New Parameter("Pred", TypeCode.String, Session("Pred"))
SqlDataSource1.SelectParameters.Clear()
SqlDataSource1.SelectParameters.Add(param)
grid.DataSourceID = "SqlDataSource1"
grid.DataBind()

jos jednom hvala na odgovoru