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


Similar Messages:

SQL Reporting :: Joined Tables - Concatenate Rows Into Single Row?

Feb 13, 2010

Im having a go at doing a report for my asp.net application. I have 2 tables, one which lists a loan we have given to a customer, and another table which lists repayments against the loans.

I want to display each loan and how much is outstanding against it. My problem is that each loan is repeated in the table for each repayment against it. So when i try to sum up the loans awarded to a customer, if they only have one loan and have made 3 repayments against it, it sums up the amount awarded against each record.

eg, if i award a customer a loan of 200, and they make 3 repayments of 50, 3 records appear in the table. The amount awarded is repeated against each repayment, and when i total a customers loan amounts, it totals 3 x 200.

I have put the details into the grouping row, where it is grouped by loan_id, displaying the toal of repayments instead of each repayment. This stops it repeating in the table, but when i total the amount awarded field it still calculates 3 x 200.

I tried calculating the total on the report item after grouping but you cannot calculate on a report item.

Is there a way to stop the table from repeating the amount awarded against each repayment? Or even a way in the SQL statement of the dataset to make it display a total of repayments rather than each repayment. Cant see how to calculate a total repaid as i would need to pass a Loan_id in as a parameter.

View 3 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

Create Multiple RadioButtonLists From A Single Table In SQL Server Using C#?

Nov 11, 2010

I would like to use ASP.net, C# and SQL to display a list of games with radio buttons like below (the x is the radio). One team can be selected for each game.

game 1: x team 4 x team 2
game 2: x team 6 x team 1
game 3: x team 5 x team 3

The game list is stored in a table in an SQL database. So far, I can pull all teams into one big RadioButtonList. I cannot figure out how to create multiple RadioButtonList controls from this single table of games. Does anyone know how this can be accomplished - or reference to an example / tutorial that accomplishes something like this?

View 1 Replies

Web Forms :: How To Give Multiple Inner Joins To Single Table In SQL Server

Oct 30, 2012

how to give a multiple inner joins to the single table

View 1 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

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

Can Insert Rows To Table A Based On Values In Table B By A Single INSERT Statement

Dec 7, 2010

I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).

View 3 Replies

Concatenate Two Cells Into A Single Cell?

Jun 30, 2010

Query for Concatinate two cells into a single cell

View 9 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

SQL Server :: How To Check (true/false) If Every Single Entry In Table Exists In Other Table

Oct 15, 2010

I have 2 tables:

- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)

How can I check if every salesmen has at least one appointment

Am I on the right way with statement below, though I got syntax problems

[Code]....

View 5 Replies

Web Forms :: Multiple Word Search In A Single Table Column?

Mar 3, 2011

I can easily create a search that will allow a user to input a single word (or a portion of a single word) into a text box that will search a database column.

But what I want is for the user to be able to type two or three words into the textbox and produce results where just one of the words have to match the contents of the columns cell.

I don't need to be able to do a multi column or table search, and I'm using C# and MS Access.

I imagine this question would have been asked more than a couple of times - but I can't find a decent answer.

View 7 Replies

Dynamically Add Multiple Rows To A Table?

Jul 29, 2010

Protected Sub btnAddRow7_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAddRow7.Click
Dim tableRow As New System.Web.UI.WebControls.TableRow
Dim tableCell As New System.Web.UI.WebControls.TableCell
Dim textBox As New System.Web.UI.WebControls.TextBox
tableCell.Controls.Add(textBox)
tableRow.Cells.Add(tableCell)
tbl7.Rows.Add(tableRow)
End Sub

but it only adds one row dynamically. After the first addition, more clicks to the button will not add more rows.

View 3 Replies

Web Forms :: Insert Multiple Value In Single Textbox Comma Separation Into Table?

Sep 7, 2012

 i want to store comma separeted into each column into table.

View 1 Replies

SQL Server :: Delete Objects From Table Using Another Table To Select Rows?

Sep 14, 2010

I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'

I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1

View 4 Replies

Data Controls :: How To Add Dynamic Rows Together With Non-Dynamic To Single GridView Table

Dec 11, 2013

I have a Webform with a TextBox (Static) and 3 TextBox (Dynamic - based on the following article: [URL].... )

How to use this scenario with a single GridView table?

Based on the User input, the GridView might have (1 + 3) columns; (1 + 6) columns; (1 + 9) columns; ...etc.

View 1 Replies

SQL Server :: How To Update Table Value From Another Table With Limit Rows

Jan 20, 2011

I have table a and would like update table a whose values from table b, but not update all rows at table a. Only update record ID in table a match record ID in tableC.

Here is my query

update a
set a.Desc = b.Desc,
a.Value = b.Value
from TableA a, TableB b
where a.name = b.name
and a.ID = b.ID
and a.ID in ( select ID from TableC)

I only have 12 a.ID match TableC, but above query update whole TableA.

How to only update 12 record at TableA from TableB?

View 2 Replies

DataSource Controls :: Update Multiple Rows In Directory Table?

Sep 22, 2010

I'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:

[Code]....

View 2 Replies

DataSource Controls :: Delete Multiple Rows From Database In A Table?

May 1, 2010

I've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.

View 6 Replies

Forms Data Controls :: DetialsView Where Each Row Has Multiple Detail Rows From Another Table?

Sep 22, 2010

I have a <asp:DetailsView> based on a table that has a details table, like so:

DB1 --> TABLE1 --> Customers: ID, name, street, mail

DB1 --> TABLE2 --> SitesToCustomers: CustomerID, SiteID

Problem One: I need my details view to show / edit both values from customer table and SitesToCustomers table, How do i do that?

Problem two: The site name (oppesed to its code that is saved at SitesToCustomers) is found on another DataBase in this table:

DB2 --> TABLE1 --> Sites: ID, SiteName

How can make the data source show site names according to their id's from SitesToCustomers table?

all of the code behind is c#.

View 1 Replies

Forms Data Controls :: How To Store Multiple Rows In A Table From Gridview

Apr 9, 2010

iam using asp.net2.0 with c#

in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.

in my database the table contains

orderid int primary key autoincrement
productname nvarchar
price nvarchar
quantity nvarchar
total nvarchar

when user selects the rows then in database how to store multiple rows in that table field

View 7 Replies

Forms Data Controls :: How To Store Multiple Rows In A Table From Gridview

Apr 9, 2010

iam using asp.net2.0 with c#

in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.

in my database the table contains

orderid int primary key autoincrement
productname nvarchar
price nvarchar
quantity nvarchar
total nvarchar

when user selects the rows then in database how to store multiple rows in that table field

View 3 Replies

Multiple Single-result Sql Server Stored Procedures Or Single Multple-result Stored Procedure?

Aug 9, 2010

Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.

View 4 Replies

DataSource Controls :: Concatenate The Multiple Columns In Linq?

May 8, 2010

how to write that below query in linq

DECLARE @Name varchar(20)

Select @Name = empFirstname+','+empLastName+','+empBankCode From srpEmployee
PRINT @Name

View 7 Replies







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