passing a variable from asp to asp.net

[Vincent Jones]

in index.asp, i'm passing the this variable:
<a href="Description.aspx?Painting=<%=RS2("Painting") %>">Painting</a>

void Page_Load(Object sender, EventArgs e)
{
SqlConnection myConnection = new
SqlConnection("server=111.111.111.111;uid=;pwd=;da tabase=mdMuseumStore");
SqlDataAdapter myCommand = new SqlDataAdapter("Select Painting,
Artist, Title, Description from tbManetPaintings Where Painting =
'"Request.QueryString["Painting"]"'", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "tbManetPaintings");
MyRepeater.DataSource =
ds.Tables["tbManetPaintings"].DefaultView;
MyRepeater.DataBind();
}

I always get
CS1026: ) expected

[Kirk Graves]

You have a simple concatenation error...
Make a very small change.
------------------------
SqlDataAdapter myCommand = new SqlDataAdapter("Select Painting,"
+ " Artist, Title, Description from tbManetPaintings Where Painting = '"
+ Request.QueryString["Painting"] + "'", myConnection);
------------------------
or, even better, use a command and parameter (easier to read, safer)
------------------------
SqlCommand cmd = new SqlCommand("Select Painting,"
+ " Artist, Title, Description from tbManetPaintings Where Painting =
@Painting", myConnection);
cmd.Parameters.Add("@Painting",Request.QueryString["Painting"]);
SqlDataAdapter myCommand = new SqlDataAdapter(cmd);
--------------------------

Kirk Graves
KRGIT Software

"Vincent Jones" <vn****@hotmail.com> wrote in message
news:ba**************************@posting.google.c om...

in index.asp, i'm passing the this variable:
<a href="Description.aspx?Painting=<%=RS2("Painting") %>">Painting</a>

void Page_Load(Object sender, EventArgs e)
{
SqlConnection myConnection = new
SqlConnection("server=111.111.111.111;uid=;pwd=;da tabase=mdMuseumStore");
SqlDataAdapter myCommand = new SqlDataAdapter("Select Painting,
Artist, Title, Description from tbManetPaintings Where Painting =
'"Request.QueryString["Painting"]"'", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "tbManetPaintings");
MyRepeater.DataSource =
ds.Tables["tbManetPaintings"].DefaultView;
MyRepeater.DataBind();
}

I always get
CS1026: ) expected

[Kirk Graves]

You have a simple concatenation error...
Make a very small change.
------------------------
SqlDataAdapter myCommand = new SqlDataAdapter("Select Painting,"
+ " Artist, Title, Description from tbManetPaintings Where Painting = '"
+ Request.QueryString["Painting"] + "'", myConnection);
------------------------
or, even better, use a command and parameter (easier to read, safer)
------------------------
SqlCommand cmd = new SqlCommand("Select Painting,"
+ " Artist, Title, Description from tbManetPaintings Where Painting =
@Painting", myConnection);
cmd.Parameters.Add("@Painting",Request.QueryString["Painting"]);
SqlDataAdapter myCommand = new SqlDataAdapter(cmd);
--------------------------

Kirk Graves
KRGIT Software

"Vincent Jones" <vn****@hotmail.com> wrote in message
news:ba**************************@posting.google.c om...

in index.asp, i'm passing the this variable:
<a href="Description.aspx?Painting=<%=RS2("Painting") %>">Painting</a>

void Page_Load(Object sender, EventArgs e)
{
SqlConnection myConnection = new
SqlConnection("server=111.111.111.111;uid=;pwd=;da tabase=mdMuseumStore");
SqlDataAdapter myCommand = new SqlDataAdapter("Select Painting,
Artist, Title, Description from tbManetPaintings Where Painting =
'"Request.QueryString["Painting"]"'", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "tbManetPaintings");
MyRepeater.DataSource =
ds.Tables["tbManetPaintings"].DefaultView;
MyRepeater.DataBind();
}

I always get
CS1026: ) expected

[Emanuel]

Try thi

SqlConnection myConnection = new SqlConnection("server=111.111.111.111;uid=;pwd=;da tabase=mdMuseumStore")
HttpRequest hr = new HttpRequest("1", "2", "3")
SqlDataAdapter myCommand = new SqlDataAdapter
"Select Painting, Artist, Title, Description from tbManetPaintings Where Painting ='" + hr.QueryString["Painting"] + "'", myConnection)
DataSet ds = new DataSet()
myCommand.Fill(ds, "tbManetPaintings")
MyRepeater.DataSource = ds.Tables["tbManetPaintings"].DefaultView
MyRepeater.DataBind();

[Emanuel]

Try thi

SqlConnection myConnection = new SqlConnection("server=111.111.111.111;uid=;pwd=;da tabase=mdMuseumStore")
HttpRequest hr = new HttpRequest("1", "2", "3")
SqlDataAdapter myCommand = new SqlDataAdapter
"Select Painting, Artist, Title, Description from tbManetPaintings Where Painting ='" + hr.QueryString["Painting"] + "'", myConnection)
DataSet ds = new DataSet()
myCommand.Fill(ds, "tbManetPaintings")
MyRepeater.DataSource = ds.Tables["tbManetPaintings"].DefaultView
MyRepeater.DataBind();