Hi sirAs you can see in below picture i am saving Urllink in table I just want to use saved Url in below hyperlink with NavigateUrl how to achieve it ltaspHyperLink CssClass34fbico34 NavigateUrl3434 ID34HyperLink134 runat34server34gt ltaspHyperLinkgt I am retrieving data on page load by below methodprotected void PageLoadobject sender EventArgs e SqlConnection con new SqlConnectionConfigurationManagerConnectionStringsConn

Here I have created sample code that will help you outHTML ltdivgt ltaspHyperLink ID34HyperLink134 NavigateUrl3434 runat34server34gtltaspHyperLinkgtltdivgtCprotected void PageLoadobject sender EventArgs e if thisIsPostBack DataTable dt new DataTable dtColumnsAdd34UrlId34 typeofint dtColumnsAdd34Url34 typeofstring dtColumnsAdd34UrlTitle34 typeofstring dtRowsAdd1 34httpwwwaspforumsnet34 34aspforums34 HyperLink1Text dtRows034UrlTitle34ToString HyperLink1NavigateUrl dtRows034url34ToString I hope this help you

Retrieve Url from database to Hyperlink using C# in ASP.Net

firoz198...

SOLVED CLOSED ACTIVE ANSWERED
User: firoz1986
Posted: on Jul 20, 2016 02:03 AM
Forum: Data Controls
Answer: 1
Views: 9373
Sample Code: Download

Hi sir,

As you can see in below picture i am saving Url(link) in table.

I just want to use saved Url in below hyperlink with 'NavigateUrl' how to achieve it!

    <asp:HyperLink  CssClass="fb_ico" NavigateUrl="" ID="HyperLink1" runat="server"> </asp:HyperLink>

I am retrieving data on page load by below method.

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        SqlDataAdapter da = new SqlDataAdapter("select * from MasterInfo", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "MasterInfo");    

        HyperLink1.Text = ds.Tables["MasterInfo"].Rows[0][4].ToString();
        
        Label1.Text = ds.Tables["MasterInfo"].Rows[0][1].ToString();
        Label2.Text = ds.Tables["MasterInfo"].Rows[0][2].ToString();
        Label3.Text = ds.Tables["MasterInfo"].Rows[0][3].ToString();

        Label4.Text = ds.Tables["MasterInfo"].Rows[0][4].ToString();
       
        
    }

Regards

firoz

Download FREE API for Word, Excel and PDF in ASP.Net

Indresh

0 1

Reply
ANSWER
User: Indresh
Replied: on Jul 20, 2016 02:40 AM
Report

Here, I have created sample code that will help you out

HTML

<div>
    <asp:HyperLink ID="HyperLink1" NavigateUrl="" runat="server"></asp:HyperLink>
</div>

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("UrlId", typeof(int));
        dt.Columns.Add("Url", typeof(string));
        dt.Columns.Add("UrlTitle", typeof(string));
        dt.Rows.Add(1, "http://www.aspforums.net", "aspforums");
        HyperLink1.Text = dt.Rows[0]["UrlTitle"].ToString();
        HyperLink1.NavigateUrl = dt.Rows[0]["url"].ToString();
    }
}

I hope this help you

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Retrieve Url from database to Hyperlink using C# in ASP.Net

Company

Explore

Follow us

Contact Us