column 'member_channel_name' does not belong to table

[Jassim Rahma]

Hi, Why I am getting the above error for this line:

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

here is my stored procedure:

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

[Brij]

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

[jkirkerx]

So you get the error "Hi" Never seen that error before. That's a new one for me.