Обсуждение: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
Regarding mulitple rows insert in one shot using ADO .net connected to postgres
От
keshav upadhyaya
Дата:
Hi ,
I want to insert multiple Rows in one shot to improve my performance .
From C# code I am using ADO .net to connect to postgres .
Currently i am pasting the code which is not of postgres but in my dev environment similar things i am doing with Postgres.
MySqlConnection mySql = new MySqlConnection();
mySql.CreateConn();
mySql.Command = mySql.Connection.CreateCommand();
mySql.Command.CommandText = "INSERT INTO dbo.table1 (textBox1, textBox2) VALUES (@textBox1, @textBox2)";
mySql.Command.Parameters.Add("@textBox1", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox1"].Value = TextBox1.Text;
mySql.Command.Parameters.Add("@textBox2", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox2"].Value = TextBox2.Text;
mySql.Command.ExecuteNonQuery();
mySql.Command.Dispose();
mySql.Connection.Close();
mySql.CloseConn();
Hi i have hilighted the line in which I wanted to ask doubts .
Currently i am inserting one row in one time and then executing the query .
So with this approach i need to execute it many times for multiple rows insert because of this my database is poor in doing this each time for very large data.
What i want here is to insert multiple rows and then executing it in one time only so that it will be faster.
Please help me out in this regards .
--
Thanks,
Keshav Upadhyaya
I want to insert multiple Rows in one shot to improve my performance .
From C# code I am using ADO .net to connect to postgres .
Currently i am pasting the code which is not of postgres but in my dev environment similar things i am doing with Postgres.
MySqlConnection mySql = new MySqlConnection();
mySql.CreateConn();
mySql.Command = mySql.Connection.CreateCommand();
mySql.Command.CommandText = "INSERT INTO dbo.table1 (textBox1, textBox2) VALUES (@textBox1, @textBox2)";
mySql.Command.Parameters.Add("@textBox1", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox1"].Value = TextBox1.Text;
mySql.Command.Parameters.Add("@textBox2", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox2"].Value = TextBox2.Text;
mySql.Command.ExecuteNonQuery();
mySql.Command.Dispose();
mySql.Connection.Close();
mySql.CloseConn();
Hi i have hilighted the line in which I wanted to ask doubts .
Currently i am inserting one row in one time and then executing the query .
So with this approach i need to execute it many times for multiple rows insert because of this my database is poor in doing this each time for very large data.
What i want here is to insert multiple rows and then executing it in one time only so that it will be faster.
Please help me out in this regards .
--
Thanks,
Keshav Upadhyaya
Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
От
Gurjeet Singh
Дата:
Try the multi-row INSERT syntax:
From the docs:
To insert multiple rows using the multirow VALUES syntax:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
Best regards,
--
Lets call it Postgres
EnterpriseDB http://www.enterprisedb.com
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet
Mail sent from my BlackLaptop device
From the docs:
To insert multiple rows using the multirow VALUES syntax:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
Best regards,
On Thu, Oct 8, 2009 at 12:09 PM, keshav upadhyaya <ukeshav2009@gmail.com> wrote:
Hi ,
I want to insert multiple Rows in one shot to improve my performance .
From C# code I am using ADO .net to connect to postgres .
Currently i am pasting the code which is not of postgres but in my dev environment similar things i am doing with Postgres.
MySqlConnection mySql = new MySqlConnection();
mySql.CreateConn();
mySql.Command = mySql.Connection.CreateCommand();
mySql.Command.CommandText = "INSERT INTO dbo.table1 (textBox1, textBox2) VALUES (@textBox1, @textBox2)";
mySql.Command.Parameters.Add("@textBox1", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox1"].Value = TextBox1.Text;
mySql.Command.Parameters.Add("@textBox2", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox2"].Value = TextBox2.Text;
mySql.Command.ExecuteNonQuery();
mySql.Command.Dispose();
mySql.Connection.Close();
mySql.CloseConn();
Hi i have hilighted the line in which I wanted to ask doubts .
Currently i am inserting one row in one time and then executing the query .
So with this approach i need to execute it many times for multiple rows insert because of this my database is poor in doing this each time for very large data.
What i want here is to insert multiple rows and then executing it in one time only so that it will be faster.
Please help me out in this regards .
--
Thanks,
Keshav Upadhyaya
--
Lets call it Postgres
EnterpriseDB http://www.enterprisedb.com
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet
Mail sent from my BlackLaptop device
Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
От
keshav upadhyaya
Дата:
Hi Gurjeet ,
THanks for ur help , But from ADO .net we have to go through the code which i have written in RED .
If I am using direct sql command then I can do the way u have suggested .
But from the ADO .net i need to get the CommandText and then add the values of each parameter after that
execute Query .
What I want here is I will load the multi row data as parameter and then execute Query only once .
Thanks
keshav
--
Thanks,
Keshav Upadhyaya
THanks for ur help , But from ADO .net we have to go through the code which i have written in RED .
If I am using direct sql command then I can do the way u have suggested .
But from the ADO .net i need to get the CommandText and then add the values of each parameter after that
execute Query .
What I want here is I will load the multi row data as parameter and then execute Query only once .
Thanks
keshav
On Thu, Oct 8, 2009 at 12:32 PM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
Try the multi-row INSERT syntax:
From the docs:
To insert multiple rows using the multirow VALUES syntax:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
Best regards,--On Thu, Oct 8, 2009 at 12:09 PM, keshav upadhyaya <ukeshav2009@gmail.com> wrote:Hi ,
I want to insert multiple Rows in one shot to improve my performance .
From C# code I am using ADO .net to connect to postgres .
Currently i am pasting the code which is not of postgres but in my dev environment similar things i am doing with Postgres.
MySqlConnection mySql = new MySqlConnection();
mySql.CreateConn();
mySql.Command = mySql.Connection.CreateCommand();
mySql.Command.CommandText = "INSERT INTO dbo.table1 (textBox1, textBox2) VALUES (@textBox1, @textBox2)";
mySql.Command.Parameters.Add("@textBox1", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox1"].Value = TextBox1.Text;
mySql.Command.Parameters.Add("@textBox2", SqlDbType.VarChar);
mySql.Command.Parameters["@textBox2"].Value = TextBox2.Text;
mySql.Command.ExecuteNonQuery();
mySql.Command.Dispose();
mySql.Connection.Close();
mySql.CloseConn();
Hi i have hilighted the line in which I wanted to ask doubts .
Currently i am inserting one row in one time and then executing the query .
So with this approach i need to execute it many times for multiple rows insert because of this my database is poor in doing this each time for very large data.
What i want here is to insert multiple rows and then executing it in one time only so that it will be faster.
Please help me out in this regards .
--
Thanks,
Keshav Upadhyaya
Lets call it Postgres
EnterpriseDB http://www.enterprisedb.com
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet
Mail sent from my BlackLaptop device
--
Thanks,
Keshav Upadhyaya