Web Forms

Re: DataSet column values

ThaDu — Tue, 07 Oct 2008 08:55:52 GMT

You can use as shown below:

txtRow0Col0.Text = dsAppData.Tables[0].Rows[0][0].ToString();

txtRow0Col1.Text = dsAppData.Tables[0].Rows[0][1].ToString();

txtRow1Col3.Text = dsAppData.Tables[0].Rows[1][3].ToString();

Re: DataSet column values

mhatrerupesh — Tue, 04 Dec 2007 13:51:48 GMT

How do i add logical table created (on the fly in the stored procedure, say @DisplayOutput) to DataAdapter ? plz help.........

THanks in advance

Re: DataSet column values

wallaceoc — Tue, 07 Sep 2004 13:17:57 GMT

Legend!!

Re: DataSet column values

kiddu1 — Tue, 07 Sep 2004 11:46:22 GMT

after you fill the dataset you must declare a datarow

dim dr as new datarow
dr = dataset.tables(0).rows(0)

and after that you use it like this:

label1.text = dr("column_name1").ToString()
label2.text = dr("column_name2").ToString()
....

and here you are.

HTH
Kiddu

Re: DataSet column values

wallaceoc — Tue, 07 Sep 2004 08:30:09 GMT

Another point that might help is when I try to write the name of the table as follows:



Response.Write(dsAppData.Tables[0].TableName.ToString());

The word "Table" is outputted on the screen. Anbody have any ideas?

The code I use to fill the DataSet is as follows:



string strAppDetailsQry = "Select A.AppID, A.AppName, A.GripsID";


strAppDetailsQry += " from Application A, FAQ F";


strAppDetailsQry += " where F.AppID = A.AppID";	


strAppDetailsQry += " AND F.FAQID = " + Int32.Parse(FAQID.Text);


SqlCommand appDetailsCmd = new SqlCommand(strAppDetailsQry, conn);





...


...





try


{


	conn.Open();


	dataAdapter = new SqlDataAdapter(strAppDetailsQry, conn);


	dsAppData = new DataSet();


	dataAdapter.Fill(dsAppData);


....


...


}


...

This is really bugging me so please help!

Regards,

Wallace

Re: DataSet column values

wallaceoc — Tue, 07 Sep 2004 07:05:40 GMT

Sorry but does anybody have any idea on this one?

Thanks,

Wallace

DataSet column values

wallaceoc — Mon, 06 Sep 2004 13:55:47 GMT

I'm using a DataSet to retrive data from a Database and access the values of the columsn returned. I then want to set the Text of various labels to the values of the columns. To do this I use to code below



appID.Text = dsAppData.Tables[0].Columns[0].ToString();


appName.Text = dsAppData.Tables[0].Columns[1].ToString();


gripsID.Text = dsAppData.Tables[0].Columns[2].ToString();

The problem is that it sets the text of the labels to the column names and not the values. Am I using the wrong code?

Thanks,

Wallace