Solved

Updating a row in a DataSet

Posted on 2008-06-24
2
663 Views
Last Modified: 2013-12-16
Hi
I have 2 DataSets. One, dsComplete, which contains all my data and another, dsSummery, which is empty. Now I want to add rows to dsSummery from dsComplete. In dsComplete "SubjectInComplete"-column has equal values for 3-4 rows, but the other fields in thies rows has other values. I want to make a summery of thies values in dsSummery where "SubjectInComplete" is unique.

Well below is my code so far. I don't get errors, but it's not working as it should - "SubjectInSummery" isn't unique. And also isn't there a better way than using try..catch - I don't fell like is that safe in this case.

Here is what dsComplete could look like...

SubjectInComplete ; Question1 ; Question2
"Math" ; 2 ; 5
"Math" ; 1 ; 3
"Math" ; 4 ; 1
"English" ; 2 ; 1
"English" ; 1 ; 3
"English" ; 2 ; 5
DataSet dsComplete; // Code filling dsComplete not shown here
DataSet dsSummery;
 
String RememberLastOne = "";
 
foreach (DataTable myTable in dsComplete.Tables)
{
	DataView dv = myTable.DefaultView;
	dv.Sort = "SubjectInComplete"; // Sort by this one so that the code can check i current and last row is identical
	
	foreach (DataRow row in myTable.Rows)
	{
		try // Try to edit row
		{
			
			DataRow[] editRow = dsSummery.Tables[0].Select("SubjectInSummery LIKE '%" + RememberLastOne + "%'");
			switch (row["Question1"].ToString())
			{
				case "1": // add value to a field in this row
					editRow[0]["Question1"] = Convert.ToInt32(editRow[0]["Question1"]) + 1;
					break;
				case "2": // add value to a field in this row
					editRow[0]["Question2"] = Convert.ToInt32(editRow[0]["Question2"]) + 1; 
					break;
			}
		}
		catch // If edit failed create new row
		{
			DataRow newRow = dsSummery.Tables[0].NewRow();
			newRow["ID"] = i + 1;
			newRow["SubjectInSummery"] = row["SubjectInComplete"];
			newRow["Question1"] = 0;
			newRow["Question2"] = 0;
			dsSummery.Tables[0].Rows.Add(newRow);
		}
 
		// Remember this row 
		RememberLastOne = row["SubjectInComplete"].ToString();
	}
}

Open in new window

0
Comment
Question by:Balltown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
Balltown earned 0 total points
ID: 21854389
Okay, think I've got it now. I made "SubjectInSummery" the primary key and searched for it.. Se code.
DataSet dsComplete; // Code filling dsComplete not shown here
DataSet dsSummery;
 
// Make SubjectInSummery the primary key
DataColumn[] PriKeyName = { dsSummery.Tables[0].Columns["SubjectInSummery"] };
dsSummery.Tables[0].PrimaryKey = PriKeyName;
 
int i = 0;
 
foreach (DataRow row in dsComplete.Tables[0].Rows)
{
	// Find primary key
	DataRow editRow = dsSummery.Tables[0].Rows.Find(row["FAG"].ToString());
 
	// if primary key is not null you can edit row
	if (editRow != null) {
                        
		switch (row["Question1"].ToString())
		{
			case "1": // add value to a field in this row
				editRow["Question1"] = Convert.ToInt32(editRow[0]["Question1"]) + 1;
				break;
			case "2": // add value to a field in this row
				editRow["Question2"] = Convert.ToInt32(editRow[0]["Question2"]) + 1; 
				break;
		}
	}
	else
	{
		DataRow newRow = dsSummery.Tables[0].NewRow();
		newRow["ID"] = i + 1;
		newRow["SubjectInSummery"] = row["SubjectInComplete"];
		newRow["Question1"] = 0;
		newRow["Question2"] = 0;
		dsSummery.Tables[0].Rows.Add(newRow);
	}
	i++;
}

Open in new window

0
 

Author Comment

by:Balltown
ID: 21854901
Woops... the line
DataRow editRow = dsSummery.Tables[0].Rows.Find(row["FAG"].ToString());

Should read
DataRow editRow = dsSummery.Tables[0].Rows.Find(row["SubjectInComplete"].ToString());

"fag" means "subject" in danish ;-)
0

Featured Post

Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question