Unable to insert data into another column based on the unique ID [Answered]RSS

5 replies

Last post Oct 05, 2013 02:02 AM by hans_v

‹ Previous Thread|Next Thread ›

Shortcuts

collo

Member

43 Points

138 Posts

Unable to insert data into another column based on the unique ID

Oct 03, 2013 07:58 AM|collo|LINK

Hello, I am trying to insert new data into an empty column based on the matched unique ID found. There is only one table which contain three columns.

For example, in the 1st row, there are two filled column which contain unique ID and name, this data is stored in 1st source page, the third column is still empty in the same row and the function to add data to this column is in 2nd source page. I cannot combine the source pages as each page have many functions.

I am able to transfer the unique id to the other page but when I am trying to insert the new data based on the unique ID it gives error that says:

Query input must contain at least one table or query.

This is my code to insert new data with existing unique ID from previos source page:

 Sentence:<asp:TextBox runat="server" ID="sentence"></asp:TextBox>
    <asp:Button ID="Button1" runat="server" Text="Click" OnClick="Button1_Click" />

_______________________________________________________________________________________________


string userID;
    string ConnectString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" + @"D:\\Test.accdb;";
    OleDbConnection objCon;
    OleDbCommand objCmd;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        userID = Request.QueryString["Id"];
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
       string SqlString = "Insert Into Table1 (Sentence) Values (@sentence) where UniqueID= @userID";

       using (objCon = new OleDbConnection(ConnectString))
       {
           using(objCmd = new OleDbCommand(SqlString, objCon))
           {
               objCmd.Parameters.AddWithValue("@sentence", sentence.Text);
               objCon.Open();
               objCmd.ExecuteNonQuery();
           }
       }
       
    }

Any ideas, help and suggestions are greatly appreciated, thank you.

anil.india

Participant

1740 Points

453 Posts

Re: Unable to insert data into another column based on the unique ID

Oct 03, 2013 11:11 AM|anil.india|LINK

collo

string SqlString = "Insert Into Table1 (Sentence) Values (@sentence) where UniqueID= @userID";

       using (objCon = new OleDbConnection(ConnectString))
       {
           using(objCmd = new OleDbCommand(SqlString, objCon))
           {
               objCmd.Parameters.AddWithValue("@sentence", sentence.Text);
               objCon.Open();
               objCmd.ExecuteNonQuery();
           }
       }

You are missing @userID parameter

Mark it as Answer, if you feel so. Thanks

CodePattern.net/blog

- Reply
collo
Member

43 Points

138 Posts
Re: Unable to insert data into another column based on the unique ID

Oct 03, 2013 09:29 PM|collo|LINK
should I add something like this??
```
objCmd.Parameters.AddWithValue("@UniqueID", userID);
```
Database insert access
- Reply
hans_v
All-Star

25756 Points

7014 Posts
Re: Unable to insert data into another column based on the unique ID

Oct 04, 2013 07:21 AM|hans_v|LINK
```
string SqlString = "Insert Into Table1 (Sentence) Values (@sentence) where UniqueID= @userID";
```
Take a closer look to your insert statement. the Where Clause doesn't make any sense....
Database insert access
- Reply
collo
Member

43 Points

138 Posts
Re: Unable to insert data into another column based on the unique ID

Oct 04, 2013 10:37 PM|collo|LINK
should I use something like this?
```
select Sentence from Table1 where UniqueID like '%" + Label1.Text + "%'
```
Database insert access
- Reply
hans_v
All-Star

25756 Points

7014 Posts
Re: Unable to insert data into another column based on the unique ID

Oct 05, 2013 02:02 AM|hans_v|LINK
collo
```
should I use something like this?
select Sentence from Table1 where UniqueID like '%" + Label1.Text + "%'
```
This is a SELECT statement, the previous one was an INSERT statement. It's not clear what you are trying to do? Show us your table structure, some sample data and the result you expect?

By the way, The above code is vulnarable to SQL injections. always use parameterized queries:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access
Database insert access

‹ Previous Thread|Next Thread ›