Can a single button be used to insert data into multiple table?

Question

0.00/5 (No votes)

See more:

I have been working on a bookstore management project. I have 5 different categories of book and 5 different tables for them.. So i have this data entry page created with textboxes for data and dropdown list-box for selecting the category/table name:

<tr><td style="text-align: left;color:blue; font-size:30px; font-family:Maiandra GD ">CATEGORY :</td><td> <asp:DropDownList ID="DropDownList1" CssClass="txt2" runat="server">
    <asp:ListItem>Academic & Professional</asp:ListItem>
    <asp:ListItem>Children Books</asp:ListItem>
    <asp:ListItem>College Books</asp:ListItem>
    <asp:ListItem>Entrance Books</asp:ListItem>
    <asp:ListItem>Literature & Fiction</asp:ListItem>
    </asp:DropDownList></td></tr>

So i need help as to how using a single button i can insert into multiple tables?? The table should be chosen as per the selection in the dropdownlistbox..
The table names are same as the listitem

Suppose i select Entrance books then the data must be inserted into the Entrance books table.

Here's the common table structure for all the tables--

name varchar(20) not null primary key,
aurthor varchar(20),
price int,
details varchar(1000)

Thanks

Posted 26-May-13 22:28pm

Swayam231

Add a Solution

Comments

Arun Vasu 27-May-13 4:31am

use stored procedure to achieve this.

Jignesh Khant 27-May-13 4:32am

Yes you can use if else statement like this:
if(DropDownList1.SelectedValue="Academic & Professional")
{
//insert code
}
else
{
// insert code
}

Swayam231 27-May-13 4:36am

i have thought about that but it will require separate insert statements for each selection!!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar Sultan · Accepted Answer · 2013-05-26T22:37:00

Pass table name as parameter and use your stored procedure like this:

SQL

Create Procedure InsertData
(
@tablename varchar(50)
)
AS
BEGIN
--Check Conditions

if @tablename = 'Academic & Professional'
BEGIN
--fire insert query for table 'Academic & Professional'
END

if @tablename = 'Children Books'
BEGIN
--fire insert query for table 'Children Books'
END


--check for all the tables
END

Abhinav S · Accepted Answer · 2013-05-26T22:30:00

Solution 1

You can execute a stored procedure or multiple sets of insert queries on button click.
You can put them in a transaction to rollback any dependent inserts.

Posted 26-May-13 22:30pm

Abhinav S

Comments

Swayam231 27-May-13 4:32am

Can you be little more detailed??

Swayam231 27-May-13 4:40am

Here's my sample insert statement for inserting into single table:

SqlConnection cn = new SqlConnection();
cn.ConnectionString = //connection string
cn.Open();
string st="Insert into entrance books values("+textbox1.text+"","+textbox2.text+","+textbox3.text+","+textbox4.text+")";
sqlcommand cmd= new sqlcommand(st,cn);
cmd.executenonquey;

Abhinav S 27-May-13 4:48am

Something like
string st=Query1)"; sqlcommand cmd= new sqlcommand(st,cn); cmd.executenonquey;

string st=Query2; sqlcommand cmd= new sqlcommand(st,cn); cmd.executenonquey;

And so on.

Or you could use a stored procedure.
By the way, you should not directly pass in parameters in query.

Swayam231 27-May-13 4:50am

okk thanks for helping!