Data Set With SQL in C#

Question

2.00/5 (1 vote)

See more:

I Have a Data Set Call SetItemType And It Contain Two Data Table

01) ITEM_GROUP
02) ITEM_TYPE

I Want To add Value from sql Data base To This Data Table
like followings

C#

SetItemType type = new SetItemType();
type.ITEM_GROUP = "SQL Statement";

how to do this ?

Posted 27-May-13 20:20pm

anushikaroshan

Updated 27-May-13 20:52pm

vijay__p

v2

Add a Solution

Comments

Varun Sareen 28-May-13 2:30am

Please give more clarity on this. And be specific, which datatable your are talking about?

Karthik Harve 28-May-13 2:57am

Your question is not clear. elaborate your confusion.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

renish patel · Answer 1 · 2013-05-27T21:14:00

you can use this way...here i mention storeprocedure "sp_test" which returns more then 1 tables then you can used this tables in below way...

C#

public DataTable GetData()
{
	SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConString"].ConnectionString);
	conn.Open();
	SqlCommand cmd = new SqlCommand("sp_test", conn);
	cmd.CommandType = CommandType.StoredProcedure;
	SqlDataAdapter MyDataAdapter = new SqlDataAdapter();
	DataSet DS = new DataSet();
	try
	{
	MyDataAdapter.SelectCommand = cmd;
	MyDataAdapter.Fill(DS);
	if (DS != null && DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
	{
	return DS.Tables[0];
	}
	else
	{
	return null;
	}
	}
	catch (SqlException )
	{
	throw ;
	}
	finally
	{
	if (conn.State == ConnectionState.Open)
	conn.Close();
	
	conn = null;
	}
}

may be this can help you...Thanks if you get your answer then please make as answered...

Basmeh Awad · Answer 2 · 2013-05-27T21:27:00

try this...

C#

try {
	connection.Open();
	command = new SqlCommand(firstSql, connection);
	adapter.SelectCommand = command;
	adapter.Fill(ds, "First Table");

	adapter.SelectCommand.CommandText = secondSql;
	adapter.Fill(ds, "Second Table");

	adapter.Dispose();
	command.Dispose();
	connection.Close();

	//retrieve first table data
	for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) {
		Interaction.MsgBox(ds.Tables[0].Rows[i][0] + "  --  " + ds.Tables[0].Rows[i][1]);
	}
	//retrieve second table data
	for (i = 0; i <= ds.Tables[1].Rows.Count - 1; i++) {
		Interaction.MsgBox(ds.Tables[1].Rows[i][0] + "  --  " + ds.Tables[1].Rows[i][1]);
	}

} 
catch (Exception ex) 
{
	Interaction.MsgBox("");
}

Data Set With SQL in C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0