Simple SQL

[Jim McGivney]

In ASP 2.0

I have an access database, with a table named comments whose primary key is
an integer field named ID, and two string fields names Comment1 and
Comment2.

I am trying to use a QueryStringPara meter to update my table. This all
should be simple SQL, but I am having a problem.

If possible please suggest some code to help me with this C# code-behind.

When I run

int FileIDNum = 2;
QueryStringPara meter queryStr = new QueryStringPara meter("ID", "FileIDNum" );
AccessDataSourc e1.SelectParame ters.Add(queryS tr);
AccessDataSourc e1.UpdateComman d = "UPDATE Comments SET Comment1='Billy ',
Comment2='Bob' WHERE ID=?";
AccessDataSourc e1.Update();

I get the following error message:

Server Error in '/XML_2' Application.
No value given for one or more required parameters.

I also get a message that FileIDNum has been initialized, but is not used.

Thanks in advance for you help,
Jim

[Patrick.O.Ige]

Try using this sample below
Hope that helps
Patrick

<asp:AccessData Source id="ProductsSou rce" Runat="Server"
DataFile="../Databases/eCommerce.mdb"

SelectCommand=" SELECT * FROM Products"

UpdateCommand=" UPDATE Products SET ItemType=@ItemT ype,
ItemDescription =@ItemDescripti on
WHERE ItemNumber=@Ite mNumber"
/>

<asp:AccessData Source id="TypeSource " Runat="Server"
DataFile="../Databases/eCommerce.mdb"
SelectCommand=" SELECT DISTINCT ItemType FROM Products ORDER BY ItemType"/>
"Jim McGivney" <mc****@no-spam.sbcglobal. net> wrote in message
news:eX******** *****@TK2MSFTNG P14.phx.gbl...

In ASP 2.0

I have an access database, with a table named comments whose primary key is an integer field named ID, and two string fields names Comment1 and
Comment2.

I am trying to use a QueryStringPara meter to update my table. This all
should be simple SQL, but I am having a problem.

If possible please suggest some code to help me with this C# code-behind.

When I run

int FileIDNum = 2;
QueryStringPara meter queryStr = new QueryStringPara meter("ID", "FileIDNum" ); AccessDataSourc e1.SelectParame ters.Add(queryS tr);
AccessDataSourc e1.UpdateComman d = "UPDATE Comments SET Comment1='Billy ',
Comment2='Bob' WHERE ID=?";
AccessDataSourc e1.Update();

I get the following error message:

Server Error in '/XML_2' Application.
No value given for one or more required parameters.

I also get a message that FileIDNum has been initialized, but is not used.

Thanks in advance for you help,
Jim

[Hans Kesting]

> In ASP 2.0

I have an access database, with a table named comments whose primary key is
an integer field named ID, and two string fields names Comment1 and Comment2.

I am trying to use a QueryStringPara meter to update my table. This all
should be simple SQL, but I am having a problem.

If possible please suggest some code to help me with this C# code-behind.

When I run

int FileIDNum = 2;
QueryStringPara meter queryStr = new QueryStringPara meter("ID", "FileIDNum" );
Are you sure you need the quotes around "FileIDNum" ? It looks to me
like you are defining a parameter named "ID" with the string value
"FileIDNum" ! Try: new QueryStringPara meter("ID", FileIDNum);

Hans Kesting
AccessDataSourc e1.SelectParame ters.Add(queryS tr);
AccessDataSourc e1.UpdateComman d = "UPDATE Comments SET Comment1='Billy ',
Comment2='Bob' WHERE ID=?";
AccessDataSourc e1.Update();

I get the following error message:

Server Error in '/XML_2' Application.
No value given for one or more required parameters.

I also get a message that FileIDNum has been initialized, but is not used.

Thanks in advance for you help,
Jim