Web Forms :: Inserting Multiple Rows In A Single SQL Query

Dec 23, 2015

I have a question which is insert multiple rows in a single insert? Is that possible?

For example:

INSERT INTO EMPLOYEE(NAME, AGE)
VALUES
(JAN, 18),
(JEN, 20),
(JIN, 23)
Using C#

I have code, something like I ask but there's an error.

Here's the code

string sql = "INSERT INTO EMPLOYEE(NAME, AGE) VALUES";
for(int i = 0; i < data.length; i++)
{
sql += "(@name" + i.ToString() ", @age" + i.ToString() + "),"
}
sql = sql.Remove(sql.Length - 1);
cmd = SqlCommand(sql, con);
cmd.ExecuteNonQuery;

I got an error of "Fatal error encountered during command execution."

The error goes here

{"Parameter '@name0' must be defined."}

View 1 Replies


Similar Messages:

SQL Server :: Inserting Multiple Records Under The Single Query?

Sep 9, 2010

I have to insert a multiple records under the single table.So i have to execute the command in the frontend for every records.

Inorder to avoid i write the query like this

insert into table1(field1,field2) values('1','Test1'),('2','Test2');

and also i tried

insert into table1(field1,field2)

SELECT "1","Test1"

Union all

SELECT "2","Test2"

But I am getting syntax error.

How to insert a multiple records under the single query?

View 4 Replies

Forms Data Controls :: Inserting Multiple Rows Into Sql?

Mar 9, 2011

I am currently trying to create a web from that takes multiple lines and inserts them in to multiple rows in sql. So basically On the Web form It will have the following info

Store No = "28" Activity = "Bake Cake" Date = "3/3/11"
Store No = "28" Activity = "Eat Cake" Date = "3/6/11"
Store No = "28" Activity = "Sell Lemonade" Date = "2/3/11"
Store No = "28" Activity = "Bake Fudge" Date = "3/30/11"
Store No = "28" Activity = "Eat Cookies" Date = "5/3/11"

Currently I am using this script to insert values into SQL:

[Code]....

View 4 Replies

DataSource Controls :: Inserting Data Into Multiple Tables From A Single Web Form?

Jun 26, 2010

After creating a dataset, which has CRUD statements generated two or more tables, which Data Control should I use that will allow me to insert data into fields into 2 or more tables from a single web form. I'm trying to create a web form that will allow the user to input student information, such as general information, medical information, etc.

View 3 Replies

Web Forms :: Uploading Multiple Files Using Single Insert Query?

Sep 14, 2010

I am facing a situation wherein i have to ask the user for the files to upload and save them as blob in the database. I have a single file upload control on the page and user can add as many files as he wants. When the user browse the file and click add button then the file gets added at some temporary location on the page and later on when the user has specified all the files to upload then I would like to insert all these files using a single insert query in the database.

View 2 Replies

Web Forms :: Dropdownlist Result Set Query Shows Multiple Time How To Set Single

Nov 12, 2010

I Pieces
NA 400

View 7 Replies

C# - Populate The Values Of Multiple Rows In Single Row In Gridview?

Mar 28, 2011

I am trying to populate the values of multiple rows in single row in gridview using c sharp in rowdatabound section of code behind page like:

Col1 Col6

a 1
a 2
a 3
a 4

I have changed this to

Col1 Col6

a 1
2
3
4

Now I want to achieve this?

Col1 Col6

a 1 2 3 4

What wrong with the code below?

if (e.Row.Cells[0].Text == "" && e.Row.Cells[5].Text != "")
{
for (int a = 0; a<GridView1.Rows.Count; a++)
{
string s = GridView1.Rows[a].Cells[5].Text;
GridView1.Rows[e.Row.RowIndex - 1].Cells[5].Text += s;
}
}

What mistake I am making?

Cell[0] is Col1
Cell[5] is Col6

View 1 Replies

SQL Server :: How To Concatenate Multiple Rows Of Single Table

Mar 8, 2011

I've a table where one person teaches multiple classes. It looks like this.

Table1

Id Name Class Subject
----------------------------------------
2 Sam 12 English
2 Sam 10 Maths
2 Sam 10 English
2 Sam 8 History
2 Sam 12 Economics

Here Sam teaches Class 12 - English & Economics, Class 10 - Maths & English, Class 8 - History

I want to display the result like this -

Id Name Class Subject
---------------------------------------------------------------
2 Sam 12 English, Economics
2 Sam 10 Maths, English
2 Sam 8 History

How to concatenate multiple Rows?

View 6 Replies

Forms Data Controls :: How To Return Multiple Rows From A Query

May 18, 2010

I have the below c# method to populate an asp.net frontend control from a linq query. The only valid way I seem to be able to reference the query variable "result" is if I use the attribute "SingleOrDefault" but unfortunately this forces my query to return just the one single set of data for every unique primary key UserId value from my query, where I require the unique data attached to each different UserId value to be returned, how can I achieve this using linq? Note, I am passing the UserId value into my method from a public variable which is also below.

[Code]....

View 4 Replies

SQL Server :: Create Multiple XML Files From A Single Query?

Oct 20, 2010

I'm using this code for creating and xml file out of a SQL2005 table:

[Code]....

Is there a way for me to create multiple xml files, one for every row, going by the primary key column, or do I have to create a separate query for each row?

I would also wondering what is the syntax for transforming this query into a stored procedure

View 2 Replies

Data Controls :: Update Multiple GridView Rows On Single Button Click?

Jun 16, 2015

how can we update all rows without click on update link button,

or can we update all rows of gridview on click single "update" button instead of mutiple for everey row

View 1 Replies

Data Controls :: Merge Multiple GridView Rows And Display As Comma Separated (delimited) In One Single Row

Dec 23, 2015

Is there any chance to add more than one grid row in single grid row like this.

<h1> Question</h1>
<table width="100%">
<tr style="background-color:Gray; color:White;">
<td> Name
</td> <td> Product

[Code] .....

View 1 Replies

Forms Data Controls :: Using Multiple Tables Within A Single DataSet And Single SqlDataSource?

May 19, 2010

I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.

While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.

View 4 Replies

DataSource Controls :: Using LINQ To Pull Out A Single Value From A Single Result Row Of A Join Query?

May 25, 2010

For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.

I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.

I have tried to accomplish this using many variations of the following code:

[Code]....

In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.

How can I make this work? I have yet to see an example or article out there to do what I am trying to do.

View 9 Replies

Forms Data Controls :: Inserting Rows From A DetailsView?

Oct 22, 2010

I am having trouble inserting rows from a DetailsView. I am using a profiler, and I can see that 18 parameters are being passed in to my procedure where there should only be 10.

Here is the markup, and it is followed by the query that is sent to my database:

[Code]....

View 2 Replies

DataSource Controls :: Top 10 Rows As Well As Count Of All Rows From Linq To Sql Query

Jun 17, 2010

[Code]....

In above query I want to have top 10 rows as well as count of all rows.

View 3 Replies

Forms Data Controls :: Inserting CheckBox List Values Into Database Rows?

Dec 28, 2010

My problem is this "I have all the tools, VS 2005, 2008, 2010. I have every book, I have SQL server 2005 and 2008" I have all the tools, but I do not know what tool or technology to use when starting out learning all this. I juat do not know what book teaches what I need to do for something like below.

Here is my question:

I created an .ASPX webform that is to "Submit" to a SQL 2005 database. I gave this form to my DBA, and he has made up a Data Model. Now I have to figure out how to write the ASP.NET code so it will submit to the DB. My first issue is not knowing this:

1. "How do I loop through my CheckBox List", and then insert the values checked into a "Database Table" (Each Checkbox value MUST be a seperate row in the table, the DBA does not want a seperate column for each checkbox value)

2. The database is using stored procedures

3. My third issue is this: "I do not know "where" to put the "code". If you do resond to this,

Summary: I just need shown the code on how to "loop through" the CheckBox List on my form, and insert those values into a database table as seperate rows.

View 2 Replies

Forms Data Controls :: Code For Inserting Rows By Button Click On Table Or Grid?

Dec 13, 2010

code for inserting rows by button click on table or grid

View 5 Replies

SQL Server :: Inserting 252 Units Of Data With A Single Button?

Nov 21, 2010

I'm developing a website which requires the user to insert 252 units of data into 252 columns in a SQL table.

I have the following question which I hope anyone here could answer or maybe give me some comment:

Is it going to take a very long time to insert the data after the button is clicked?

How can i make this process faster?

View 9 Replies

Forms Data Controls :: Insert Query Inserting UserName And PageName?

Apr 12, 2010

I am trying to insert UserName and PageName into table using ObjectDataSource but it is not inserting into database.I get these values fine and displayed in a label but not inserted in table.Needs further guidance in the code which is as under:

[Code]....

[Code]....

View 8 Replies

Forms Data Controls :: Concatenate Gridview Rows To Single String

Jan 28, 2010

i need to concatenate the gridview rows to a single string if the gridview count is more than 100 then i need to perform the concatenation as 100 comma seperated and the next has to be carried over to the next string say if the count of gridview is 1000 then i need to concatenate the string as string1= 1to 100(Ex: a,b,c....) then string2=101-200 string3= 201-300... and so on. in case if i had to use String builder for this.. tel me how to proceed with this.

View 2 Replies

Adding Multiple Rows, Displaying Session Rows And Then Doing One Insert?

Apr 14, 2010

I need to produce a from where I can add multiple parts. Each time a user enters a part number, the description should be populated. The user can then click add and this part and description will be shown below. They have the option to add as many parts as they require. Once all parts are added the user fills in some general info eg description and then once a submit button is clicked all part info will be inserted into a table and general info will be inserted into another table with one unique ID.

View 5 Replies

Web Forms :: Insert Value In Two Tables By Single SQL Query

Apr 11, 2012

How can I insert value in two tables by single sql query because if I'm using two sql query it gives problem me on binding data and connection. Like I have 2 table table 1, table 2 ... In table I'm only save id and name and in other table I'm saving id, time1, time2

View 1 Replies

SQL Server Deadlock While Inserting Rows In A Table

Oct 15, 2010

The topic of sql server deadlock has been discussed many times, however, I was unsure that even two simultaneous inserts on a table can end up in a deadlock situation. Scenario: While testing our application (SQL Server 2005 as backend, ASP.net 3.5) we inserted records into a table simultaneously (simplified overview) and that resulted into a deadlock for more than 70% of users.

I could not get a hang of this as how an insert is being deadlock as this is not a case of multiple resources. After a detailed analysis (of reproducing the bug by two users) I found that both the processes were holding a RangeS-S lock on the primary key index of the table and were trying to convert this into RangeI-N lock, that resulted into a deadlock and one transaction being killed.

Question: Can we avoid or reduce these kind of deadlocks as this is not a case of change in order of access of resources? Cant' we force the transaction to get exclusive lock initially so that it blocks the other process and avoid deadlock? What (adverse) effects that may have? Also could some one explain more about RangeI-N lock.

Isolation Level for this was "Serializable".

View 2 Replies

DataSource Controls :: Sql Lock While Inserting Rows?

Jun 10, 2010

What kind of lock will be used on table if there is insert statement made by specifiying value in the insert statement?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved