How to Set Hyperlink href value from Database Using C# in ASP.Net

Hi nedash,

I have created sample code which fullfill your requirement.

HTML

<asp:GridView ID="Gridview1" AutoGenerateColumns="false" runat="server">
    <Columns>
        <asp:TemplateField ItemStyle-Width="24px" ItemStyle-VerticalAlign="Middle" HeaderText="Link">
            <ItemTemplate>
                <a id="HPtemporary" href='<%#Eval("Url")%>'>
                    <%#Eval("UrlTitle")%></a>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

C#

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");
dt.Rows.Add(1, "http://www.aspsnippets.com", "aspSnippets");
Gridview1.DataSource = dt;
Gridview1.DataBind();

hi Indresh

I change code like:

    using (SqlConnection conn1 = General.GetConnection())
            {
                using (SqlCommand _cmd1 = General.GetCommand("DownloadurlToken", conn))
                {
                    conn1.Open();
                    SqlDataReader _drA = _cmd1.ExecuteReader();

                    if (_drA.HasRows)
                    {
                        DataTable dt = new DataTable();
                    dt.Columns.Add("UrlId", _drA["Id"]);
                    dt.Columns.Add("Url",_drA["DownloadToken"]);
                    dt.Columns.Add("UrlTitle", _drA["Title"]);
                    dt.Rows.Add(1, "http://digimaster.ir/downloads/{0}", "aspforums");
                    dt.Rows.Add(1, "http://www.aspsnippets.com", "aspSnippets");
                        GridView1.DataSource = dt;
                        GridView1.DataBind();

                }

but this error happen:

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS1503: Argument 2: cannot convert from 'object' to 'System.Type' Source Error:

Line 518:                    {
Line 519:                        DataTable dt = new DataTable();
Line 520:                    dt.Columns.Add("UrlId", _drA["Id"]);
Line 521:                    dt.Columns.Add("Url",_drA["DownloadToken"]);
Line 522:                    dt.Columns.Add("UrlTitle", _drA["Title"]);

nedash says:

dt.Columns.Add("UrlId", _drA["Id"]);

                dt.Columns.Add("Url",_drA["DownloadToken"]);

                dt.Columns.Add("UrlTitle", _drA["Title"]);

 Replace with the below.

dt.Columns.Add(_drA["Id"].ToString());
dt.Columns.Add(_drA["DownloadToken"].ToString());
dt.Columns.Add( _drA["Title"].ToString());

this is new code:

    private void ShowTemporaryLink()
    {
        using (SqlConnection conn = General.GetConnection())
        {
            using (SqlCommand _cmd = General.GetCommand("DownloadurlToken", conn))
            {
                conn.Open();
                SqlDataReader _drA = _cmd.ExecuteReader();

                if (_drA.HasRows)
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add(_drA["Id"].ToString());
                    dt.Columns.Add(_drA["DownloadToken"].ToString());
                    dt.Columns.Add(_drA["downloadTitle"].ToString());
                    dt.Rows.Add(1, "http://digimaster.ir/downloads/{0}", "aspforums");
                    dt.Rows.Add(1, "http://www.aspsnippets.com", "aspSnippets");
                    GridView2.DataSource = dt;
                    GridView2.DataBind();

                }
            }
        }
    }

but this error happen:

Invalid attempt to read when no data is present.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present. Source Error:

Line 576:                {
Line 577:                    DataTable dt = new DataTable();
Line 578:                    dt.Columns.Add(_drA["Id"].ToString());
Line 579:                    dt.Columns.Add(_drA["DownloadToken"].ToString());
Line 580:                    dt.Columns.Add(_drA["downloadTitle"].ToString());

nedash says:

if (_drA.HasRows)

            {

                DataTable dt = new DataTable();

                dt.Columns.Add(_drA["Id"].ToString());

                dt.Columns.Add(_drA["DownloadToken"].ToString());

                dt.Columns.Add(_drA["downloadTitle"].ToString());

                dt.Rows.Add(1, "http://digimaster.ir/downloads/{0}", "aspforums");

                dt.Rows.Add(1, "http://www.aspsnippets.com", "aspSnippets");

                GridView2.DataSource = dt;

                GridView2.DataBind();

 

            }

 Replace with below code.

DataTable dt = new DataTable();
dt.Columns.Add("UrlId");
dt.Columns.Add("Url");
dt.Columns.Add("UrlTitle");
if (_drA.HasRows)
{    
    while (_drA.Read())
    {
        dt.Rows.Add(_drA["Id"].ToString(), _drA["DownloadToken"].ToString(), _drA["downloadTitle"].ToString());
    }
}
GridView2.DataSource = dt;
GridView2.DataBind();