ASP.NET Discussion Boards

Hi,

Why I am getting the above error for this line:

C#

TitleLabel.Text = data_table.Rows[0]["post_category_name"].ToString() + " - " + data_table.Rows[0]["member_channel_name"].ToString();

here is my stored procedure:

SQL

BEGIN
		SELECT DISTINCT
		post_category.post_category_guid,
		post_category.post_category_name,
		web_members.web_member_guid,
		member_channels.member_channel_address,
		member_channels.member_channel_name
		FROM
		post_category
		INNER JOIN member_posts ON member_posts.member_post_category = post_category.post_category_id
		INNER JOIN member_channels ON member_posts.member_channel_id = member_channels.member_channel_id
		INNER JOIN web_members ON member_channels.web_member_id = web_members.web_member_id
		WHERE member_channels.member_channel_address = param_web_address;

END

Technology News @ www.JassimRahma.com

As per your code, it does not seem issue here. I'll advise you first run your Proc and see whether it is running and resturning data correclty.
Then you debug your code and check the datatable in immidiate window and see it in visualiser what columns are available in datatable.

Cheers!!
Brij
Microsoft MVP ASP.NET/IIS
Visit my Blog: http://brijbhushan.net

So you get the error "Hi"

Never seen that error before. That's a new one for me.