Simple ASP.NET C# Question

[Validus]

Greetings guys, maybe somebody can help. I am working with C#.

This is what I got:

<%
string MyVar; // define a variable
MyVar = Request.QueryString["MyVar_url"]; // add value
%>

I am trying to grab the MyVar_url value from the URL and asign it to the MyVar varaible. I want to add it to a to this later one...


SelectCommand="SELECT * FROM users WHERE user_id = @ MyVar "


But that is the second step.

Any help would be appreciated.

[Validus]

I think I am mixing run time code with compiled stuff. Umpf!

[woj]

Is this for a school project or something?

[Validus]

It is for me to learn a little ASP.NET C#

[pstation]

old post, but if you're using sql server it would look something like this....

<%
string MyVar = Request.QueryString["MyVar_url"];

...

SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();

SqlCommand cmd = new SqlCommand("SELECT * FROM users WHERE user_id = @MyVar", sqlConn);
cmd.Parameters.Add("@MyVar", SqlDbType.Int).Value = int.Parse(MyVar);
SqlDataReader result = 	cmd.ExecuteReader();

sqlConn.Close();
%>

of course, much needed exception handling is missing, but it should give you a general idea of how it could be done