Multi table - insert through datatable.

thenndral

Hi,

I'm using C# 2008
DB - oracle11G

Actually i'm trying to insert data into multiple table. first insert statement works well, but 2nd insert statement not working and error also not coming.what and where goes wrong. please help.

here i give the code. could you give me some guidance.

private void btnSave_Click(object sender, EventArgs e)
{
connectionString = "User Id=tom;Password=pwd4tom;Data Source=remote_oracle";
cn = new OracleConnection(connectionString);
OracleDataAdapter editAdapter ;
OracleCommand insertCmd;
insertCmd = new OracleCommand();
insertCmd.CommandText = "INSERT INTO CUSTOMERS (CUSTOMERID, COMPANYNAME, CONTACTNAME, COUNTRY) values(:CUSTOMERID, :COMPANYNAME, :CONTACTNAME, :COUNTRY)";

insertCmd.Parameters.Add("CUSTOMERID", OracleDbType.Varchar2, 10, "CUSTOMERID");

insertCmd.Parameters.Add("COMPANYNAME", OracleDbType.Varchar2, 10, "COMPANYNAME");

insertCmd.Parameters.Add("CONTACTNAME", OracleDbType.Varchar2, 10, "CONTACTNAME");

insertCmd.Parameters.Add("COUNTRY", OracleDbType.Varchar2, 10, "COUNTRY");

insertCmd.Connection = cn;
editAdapter = new OracleDataAdapter();
editAdapter.InsertCommand = insertCmd
editAdapter.TableMappings.Add("Table", "CUSTOMERS");
editAdapter.TableMappings["Table"].ColumnMappings.Add("CUSTOMERID", "CUSTOMERID");
editAdapter.TableMappings["Table"].ColumnMappings.Add("COMPANYNAME", "COMPANYNAME");
editAdapter.TableMappings["Table"].ColumnMappings.Add("CONTACTNAME", "CONTACTNAME");
editAdapter.TableMappings["Table"].ColumnMappings.Add("COUNTRY", "COUNTRY");
editAdapter.Update(empTbl); /// this table data save perfectly
//CUST_DETAILS.CD_ID, CUST_DETAILS.CUST_ID, CUST_DETAILS.CUST_CELL, CUST_DETAILS.CUST_NAME
insertCmd.CommandText = "INSERT INTO CUST_DETAILS (CD_ID, CUST_ID, CUST_CELL, CUST_NAME) values(:CD_ID, :CUST_ID, :CUST_CELL, :CUST_NAME)";
insertCmd.Parameters.Add("CD_ID", OracleDbType.Varchar2, 10, "CD_ID");

insertCmd.Parameters.Add("CUST_ID", OracleDbType.Varchar2, 10, "CUST_ID");

insertCmd.Parameters.Add("CUST_CELL", OracleDbType.Varchar2, 10, "CUST_CELL");

insertCmd.Parameters.Add("CUST_NAME", OracleDbType.Varchar2, 10, "CUST_NAME");

insertCmd.Connection = cn;
editAdapter = new OracleDataAdapter();
editAdapter.InsertCommand = insertCmd;
editAdapter.TableMappings.Add("Table1", "CUST_DETAILS");
editAdapter.TableMappings["Table1"].ColumnMappings.Add("CD_ID", "CD_ID");
editAdapter.TableMappings["Table1"].ColumnMappings.Add("CUST_ID", "CUST_ID");
editAdapter.TableMappings["Table1"].ColumnMappings.Add("CUST_CELL", "CUST_CELL");
editAdapter.TableMappings["Table1"].ColumnMappings.Add("CUST_NAME", "CUST_NAME");
editAdapter.Update(empTbl); // no error but not save in table.
}
thanks,
thenndral.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

thenndral15y ago
Hi Javeed,

thanks for your reply.

editAdapter.Update(empTbl); /// this table data save perfectly
editAdapter.Update(empTbl); // no error but not save in table.

then, how to use the code. Really I don't know how to code.

I tried in many ways but no luck.
1. two insert query in same command text.
2. separate insert query under one button
3. use try and catch - throw any error or not.[but didn't throw any error in 2insert query]
4. write all Sql statements under one button [insert, update,delete]
Is there any other ways?
can you give me some code guidance.

thanks in advance,
thenndral.
0
thenndral15y ago
hi,
thanks for your reply.

I will write code for update in another button.
In the above code, Ist insert query is working and second not working.
I tried in many ways but no luck.
1. two insert query in same command text.
2. separate insert query under one button
3. use try and catch - throw any error or not.[but didn't throw any error in 2insert query]
4. write all Sql statements under one button [insert, update,delete]
Is there any other ways?

could you tell me please where goes wrong? please give me some code guidance.

thanks in advance,
thenndral
0
Suthish Nair15y ago
Why not combine both Insert statement separated by a ";" and execute. Put a try-catch for finding the error.
0
Javeed M Shaikh15y ago
Hi Thenndral,

is it cause you are using the same table in both the Adapter.Update, see in your code:

editAdapter.Update(empTbl); /// this table data save perfectly
editAdapter.Update(empTbl); // no error but not save in table.

Please do not forget to mark "Accepted Answer".
0