Dynamically create Weblinks in which we can set title, image, LinkButton text and url using C# in ASP.Net

Hi micah,

I have created sample code which full-fill your requirement.So please refer the code carefully.

HTML

<form id="form1" runat="server">
<div>
    <table border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                Enter Title:
                <asp:TextBox ID="txtTitle" Placeholder="Enter your Title " runat="server" />
            </td>
            <td>
                EnterURL:
                <asp:TextBox ID="txtUrl" Placeholder="Enter your URL " runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Image:
                <asp:FileUpload ID="FileUpload1" runat="server"></asp:FileUpload>
            </td>
        </tr>
        <tr>
            <td>
                <asp:DropDownList ID="ddlCategory" runat="server">
                    <asp:ListItem Value="0" Text="Select" />
                    <asp:ListItem Value="buy" Text="buy Now" />
                    <asp:ListItem Value="Read" Text="Read Now" />
                    <asp:ListItem Value="Register" Text="Register Now" />
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Button ID="btnAdd" OnClick="OnAdd" Text="Add" runat="server" />
            </td>
        </tr>
    </table>
</div>
<br />
<br />
<asp:datalist id="DlAdverties" runat="server" xmlns:asp="#unknown">
    <headertemplate>
        <table border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td>
                </td>
            </tr>
    </headertemplate>
    <itemtemplate>
        <tr>
            <td>
                <asp:Image ImageUrl='<%#Eval("Image") %>' runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                <asp:hyperlink id="HyperLink1" runat="server" navigateurl='<%# Eval("URL") %>' text='<%# Eval("Category") %>' />
            </td>
        </tr>
    </itemtemplate>
    <footertemplate>
        </table>
    </footertemplate>
</asp:datalist>
</form>

C#

private string constring = ConfigurationManager.ConnectionStrings["constring"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.GetData();
    }
}

private void GetData()
{
    SqlConnection con = new SqlConnection(constring);
    SqlCommand cmd = new SqlCommand("SELECT * FROM WebLink", con);
    DataTable dt = new DataTable();
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    sda.Fill(dt);
    if (dt.Rows.Count > 0)
    {
        DlAdverties.DataSource = dt;
        DlAdverties.DataBind();
    }
}

protected void OnAdd(object sender, EventArgs e)
{
    string imagename = FileUpload1.PostedFile.FileName;
    FileUpload1.SaveAs(Server.MapPath("Image/" + imagename));
    SqlConnection con = new SqlConnection(constring);
    SqlCommand cmd = new SqlCommand("INSERT INTO WebLink values(@Title,@URL,@Image,@Category)", con);
    cmd.Parameters.AddWithValue("@Title", txtTitle.Text.Trim());
    cmd.Parameters.AddWithValue("@URL", txtUrl.Text.Trim());
    cmd.Parameters.AddWithValue("@Image", "Image/" + imagename);
    cmd.Parameters.AddWithValue("@Category", ddlCategory.SelectedValue.Trim());
    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
    this.GetData();
}

SQL

CREATE  TABLE WebLink(
 Id INT IDENTITY  PRIMARY KEY NOT NULL
,Title VARCHAR(100)
,URL VARCHAR(100)
,[Image] NVARCHAR(50)
,Category VARCHAR(50)  
);

Screenshot