change database connection from sql datasource to code behind

svibuk

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$appSettings:ConnString%>" SelectCommand="sql query ............."

this is in desgin

and with the above i have

SqlDataSource1.SelectCommand = "sql query ............. " in code behind

but if i have the connection in code behind

how do i execute

SqlDataSource1.SelectCommand == "sql query ............. "

it without any reader or dataset

vinayak

0 1

Can you explain, why are you use sqlDataSource?

Mudassar

0 2

What you want to bind?

vinayak

0 3

if you want to bind data by coding then,

in gridview add Property AutoGenerateColumns="true"

and coding,

SqlDataSource1.SelectCommand == "Select * from tablename";
SqlDataSource1.DataBind();

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html