472,122 Members | 1,467 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,122 software developers and data experts.

Using HyperlinkColumn!

Hi all,
I have this big problem with hyperlinks I would appriciate any help please.
My web site has two datagrids on the same page. And one has a list of names of the users which are in a HyperlinkColumn. The second datagrid is for inserting data, and when a user inserts data I used 'Windows Authentication' for names in one column called Name.
Now this is how it's supposed to work: When any user want to see data about a particular user it's a matter of selecting his name and the data Writen by the selected user should be the only ones to be shown.
I got some examples on Google but they all seem not to be working. When a user is selected the URL changes instead of the particular rows in the datagrid to be selected. For example the original url is "http://localhost/Dash_Board/DashBoard.aspx" and if I select user Claude the URL change into "http://localhost/Dash_Board/Claude" and get an error The page cannot be found. Why would this be happening?
My code looks like this:
HTML part:
<asp:HyperLinkColumn Target="_self" DataNavigateUrlField="TeamBilling" DataTextField="TeamBilling" HeaderText="Billing" DataTextFormatString="{0:c}"></asp:HyperLinkColumn>
and code behind:
private void dgbilling_SelectedIndexChanged(object sender, System.EventArgs e)
SqlCommand myCommand = new SqlCommand("select * from dbo.DashBoard where Name = @Billing",con);
SqlParameter myparam = new SqlParameter("@Billing",SqlDbType.Text);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dgis.EditItemIndex = -1;
dgis: this is the datagrid that where user inserts data.
dgbilling: this is the hyperlinkcolumn.
May 11 '07 #1
0 1239

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.