Using HyperlinkColumn!

  • Thread starter Thread starter rcoco
  • Start date Start date
R

rcoco

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.
 
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.
Click to expand...

You forgot about link - DataNavigateUrlFormatString

<asp:HyperLinkColumn Target="_self"
DataNavigateUrlField="TeamBilling"
DataTextField="TeamBilling" HeaderText="Billing"

DataNavigateUrlFormatString="DashBoard.aspx?Name={0}"

DataTextFormatString="{0:c}"></asp:HyperLinkColumn>

and change

myparam.Value="../Dash_Board/DashBoard.aspx?,Name{0}";

to

myparam.Value="../Dash_Board/DashBoard.aspx?Name={0}";

I hope, it will work...

Note, the DataGrid Control (are you ASP.Net 1.0)? has Edit mode, where
the data for the record can be entered and saved without having a
second grid.

Take a look at "VB DataGrid6.aspx"
http://samples.gotdotnet.com/quicks...ms/ctrlref/webctrl/datagrid/doc_datagrid.aspx
 
Thanks Alexey,
Yes there is a difference I don't get the error any more but neighther
do I get the result I want for data to be selected. I still can't get
why when I select data in hyperlink column the data to be selected in
data grid is not selected but the page reacts as if it is being
refreshed.
Thanks
 
Thanks Alexey,
Yes there is a difference I don't get the error any more but neighther
do I get the result I want for data to be selected. I still can't get
why when I select data in hyperlink column the data to be selected in
data grid is not selected but the page reacts as if it is being
refreshed.
Thanks








- Show quoted text -
Click to expand...

Please post a code here, I will have a look
 
Hi Alexey,
This is the code I'm using:
<Columns>
<asp:HyperLinkColumn DataNavigateUrlField="TeamBilling"
DataNavigateUrlFormatString="DashBoard.aspx?Name={0}"
DataTextField="TeamBilling" HeaderText="Billing"
DataTextFormatString="{0:c}"></asp:HyperLinkColumn>
</Columns>
Code behind:
private void dgbilling_ItemCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlCommand myCommand = new SqlCommand("select * from dbo.DashBoard
where Name Like @Billing",con);
SqlParameter myparam = new SqlParameter("@Billing",SqlDbType.Text);
myparam.Value="DashBoard.aspx?={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();
}
Thanks
 
Back
Top