GridView DataSource Query in aspx page

Question

0.00/5 (No votes)

See more:

Hello ,

In default.aspx.cs , i defined a public variable. = my_id

And i can use this variable in my aspx page.

But i can't use in GridView DataSourceQuery.

My gridview's datasource code : ( in aspx )

SQL

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdbConnectionString %>" SelectCommand="SELECT [mus_ad], [marka], [model],  [durum] FROM [servis_kayitlari]  WHERE[kullanici_id] LIKE '<%= my_id ;%>'">
</asp:SqlDataSource>

After this datasource query , gridview comes null. What is the problem in this query ?

Posted 3-Aug-14 7:11am

kozmikadam

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Aug-14 13:39pm

Give a space after WHERE. So, it will be...

SELECT [mus_ad], [marka], [model], [durum] FROM [servis_kayitlari] WHERE [kullanici_id] LIKE '<%= my_id ;%>'

kozmikadam 3-Aug-14 14:03pm

I tried , It isn't work still.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Aug-14 2:51am

Ok.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dilan Shaminda · Accepted Answer · 2014-08-03T09:05:00

Try it like this

SQL

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdbConnectionString %>" SelectCommand="SELECT [mus_ad], [marka], [model],  [durum] FROM [servis_kayitlari]  WHERE[kullanici_id] LIKE @id">
</asp:SqlDataSource>

in code behind pass your my_id value to @id parameter like this

C#

SqlDataSource1.SelectParameters.Add("id", DbType.String, my_id );

Hope this works for you :-)

GridView DataSource Query in aspx page

1 solution

Solution 1

Add your solution here

Preview 0

GridView DataSource Query in aspx page

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us