SELECT Query

[markmagill]

Guys within C# ASP.Net I am trying to generated a Select Query as follows
where @Email is obtained from a text box.

What should I be doing next to obtain the results from the query?

SqlDataSource SQLDataSourceUsersDB = new SqlDataSource();

SQLDataSourceUsersDB.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

SQLDataSourceUsersDB.SelectCommandType = SqlDataSourceCommandType.Text;

SQLDataSourceUsersDB.SelectCommand = "SELECT * FROM Users WHERE Email = @Email";

SQLDataSourceUsersDB.SelectParameters.Add("Email", txtEmail.Text.ToString());

[JamieHowarth0]

Hi Mark,

Welcome to TheScripts Developer Network!

I moved your post to the .NET Forum (although users in the ASP Forum can still see the link to your post, as they may be able to answer it, but your question is primarily regarding a .NET environment).

You may want to read the FAQ for some general guidelines on questions, answers and the forums in general.

For future reference, you can use ['code] [/'code] tags to encapsulate any computer code that you want to show us. Our forum system will then recognise that particular section of text as code, and even add line numbers so experts and other users can anaylse your code and make appropriate suggestions.

For VB.NET (which it looks like you're using) the format is:

'Your VB.NET code here...

Once again, welcome to TSDN!

Cheers,

medicineworker

[dip_developer]

Guys within C# ASP.Net I am trying to generated a Select Query as follows
where @Email is obtained from a text box.

What should I be doing next to obtain the results from the query?

SqlDataSource SQLDataSourceUsersDB = new SqlDataSource();

SQLDataSourceUsersDB.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

SQLDataSourceUsersDB.SelectCommandType = SqlDataSourceCommandType.Text;

SQLDataSourceUsersDB.SelectCommand = "SELECT * FROM Users WHERE Email = @Email";

SQLDataSourceUsersDB.SelectParameters.Add("Email", txtEmail.Text.ToString());

construct a DataAdapter(say da) with the connection and query string.......with this Adapter fill a Dataset(say ds)......this dataset will contain all the records...

 da = new SqlDataAdapter(mySqlQuery, myConnection); 
ds = new DataSet();
da.Fill(ds, Tablename);