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:
<Columns>
<asp:HyperLinkColumn Target="_self" DataNavigateUrlField="TeamBilling"
DataTextField="TeamBilling" HeaderText="Billing"
DataTextFormatString="{0:c}"></asp:HyperLinkColumn>
</Columns>
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);
myparam.Value="../Dash_Board/DashBoard.aspx?,Name{0}";
myCommand.Parameters.Add(myparam);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
dgis.DataSource=ds;
dgis.EditItemIndex = -1;
dgis.DataBind();
}
dgis: this is the datagrid that where user inserts data.
dgbilling: this is the hyperlinkcolumn.
Thanks.
