ObjectDataSource.SelectMethod equivalent in SqlDataSource

Question

In ObjectDataSource we have a method called SelectMethod and TypeName in which we can specify a method to select data from.

But what is the equivalent method in SqlDataSource to speicify a method for data to select from. If there is no such method, how can I specify a method to select data like in ObjectDataSource

<asp:ObjectDataSource ID="ObjEmployees" runat="server" 
        SelectMethod="GetEmployees" TypeName="AllowPaging.GetData">
</asp:ObjectDataSource>

SqlConnection connection = new SqlConnection("server=NIPUNA-PC\\SQLEXPRESS; database=KTD; Trusted_Connection=yes;");
    string commandText = "SELECT * FROM [Emp]";
    public DataSet GetEmployees()
    {
        SqlCommand cmd = new SqlCommand(commandText, connection);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);

        return ds;
    }

FiveTools · Accepted Answer · 2011-05-24 12:09:33Z

1

See this: https://web.archive.org/web/20211010104134/https://www.4guysfromrolla.com/articles/112206-1.aspx

the SqlDataSource and ObjectDataSource raise their Selecting events immediately before performing the SQL query or invoking the object method to retrieve data. After the data has been retrieved, the Selected events fires. By creating a Selecting event handler, you can examine and massage the parameters used in selecting data;

You can use these event handlers to specify which method is used by the datasource control.

answered May 24, 2011 at 12:09

FiveTools

6,04816 gold badges65 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nipuna Over a year ago

Thanks for the behind the scene overview and the link. I looking forward to go through the series ASAP....

Bala R · Accepted Answer · 2011-05-24 11:59:03Z

0

In SqlDataSource, it's equivalent is SelectCommand. You can either provide the Select query and set SelectCommandType to Text(default) or use a stored procedure and set SelectCommandType to StoredProcedure

answered May 24, 2011 at 11:59

Bala R

109k23 gold badges203 silver badges212 bronze badges

2 Comments

Nipuna Over a year ago

I know but I want to specify a method as in objectDataSource. (like getEmployee method above) is it possible?

Bala R Over a year ago

Well, They are two different DataSource providers. Objects have methods; with databases, you have to use a sql query or stored procedure.

Brian Mains · Accepted Answer · 2011-05-24 12:09:19Z

0

SQL Data Source executes the SQL inline, so there is no equivalent way of calling a method on an object. You have to use the SeelctCommand to provide the SQL query directly in the UI.

If you are using business components to execute your queries, stick with the ObjectDataSource.

HTH.

answered May 24, 2011 at 12:09

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

1 Comment

Nipuna Over a year ago

Yes after Googling about the difference between SqlDataSourceand the ObjectDataSource, I think I better move on to ObjectDataSource. Thanks!!

Collectives™ on Stack Overflow

ObjectDataSource.SelectMethod equivalent in SqlDataSource

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related