How to create button in form from sql table values?

Goran Bibic

8y5.3kLearn iOS Programming

If I have value in sql table example

id Name Price

1 Coffie 2.00

2 Tea 1.50

3 Coca Cola 2.00

etc....

When open Form I need to auto create buttons with values

Button1 Coffie 2.00

Button2 Tea 1.50

Button3 Coca Cola 2.00

Or same examples...proposal...

Thank you

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
Accepted answer
hi,
to create buttons dynamically you can try below code
int top = 50;
int left = 50;
for (int i = 0; i < 10; i++)
{
    Button button = new Button();
    button.Left = left;
    button.Top = top;
    button.Text = (i+1).ToString();
    this.Controls.Add(button);
    top += button.Height + 2;
}
here I am looping untill 10 so you can see in form 10 buttons, and I have given name as 1 to 10.
this names and how many buttons that all you can do instead of hardcode looping, loop your datatble, and give name as per datatable name
Rafnas T P8y ago
I need to setup Picture into button and seet dimension for button to composite in 5 button in colum.if have 25 button exp to set 5 column wirh 5 buttons

this is a different qustion please make new one
Goran Bibic8y ago
Code working fine

I need to setup Picture into button and seet dimension for button to composite in 5 button in colum.

if have 25 button exp to set 5 column wirh 5 buttons
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True");
            SqlCommand cmd = new SqlCommand("SELECT Concat(ime, cijena_sa_porezom) FROM roba_usluge", con);

            // Getting all the data to ItemTable
            var da = new SqlDataAdapter(cmd);
            var ItemTable = new DataTable();
            da.Fill(ItemTable);

            con.Open();
            Int32 count = ItemTable.Rows.Count;
            con.Close();

            int top = 50;
            int left = 50;
            for (int i = 0; i < count; i++)
            {
                Button button = new Button();
                button.Left = left;
                button.Top = top;
                button.Text = ItemTable.Rows[i][0].ToString();
                this.Controls.Add(button);
                top += button.Height + 2;
            }
Narendra Gangwar8y ago
you can use GridView or Repeater control for Creating Button for every record in asp.net.
or
in window froms u can use dataGridview control .

if u use mentioned controls then u dont need to generate Button for every record .
if you want the whole code for that then pls reply back i will help you out.
Rafnas T P8y ago
hi,
you can select name and price from database and make button names use full code as below, you have to put this code in Form Load
SqlCommand cmd = new SqlCommand("SELECT Name+' '+ Price FROM products",con);
  SqlDataAdapter da = new SqlDataAdapter(cmd);

  DataTable dt= new DataTable();
  da.Fill(dt)
  int top = 50;
  int left = 50;
  for (int i = 0; i < dt.Rows.Count;i++)
  {
      Button button = new Button();
      button.Left = left;
      button.Top = top;
      button.Text = dt[i][0].ToString();
      this.Controls.Add(button);
      top += button.Height + 2;
  }
Goran Bibic8y ago
Nitin Sontakke

I am find notepad file, see logic , but where and how to create automatic creation button?
Goran Bibic8y ago
Hiten Pandya

Where to put this code?
Goran Bibic8y ago
Bhavesh Jadav

Where to put this code? I want to try
Hiten Pandya8y ago
Hi Goran,

You can get your records in array or arraylist or you can use anything to store your records but the point is after that you can use for loop and then create the button as I gave you in previous reply.
try
{
    //number_of_your_records - The count of your database records.
    for(int i=0;i
    {
        Button btn = new Button();
        btn.ID = "btn_"+i;
      btn.Text = number_of_your_records[i]["Name"].ToString();
        btn.Value = number_of_your_records[i]["Price"].ToString();
       form1.Controls.Add(btn);
    }

}
catch (Exception)
{ }
Also you can get reference links from my previous answer.
Hope it helps you.

Thanks.
Nitin Sontakke8y ago
If you just happen to open the formname.designer.cs file in notepad you will see how Visual Studio creates buttons for you and adds them to the form.

All you have do is use similar logic in your code. That's it. Try it. It's real fun part to do. Dynamically building the form.
Goran Bibic8y ago
Windows Forms
Nitin Sontakke8y ago
@Goran, there are just way too many front-end technologies. In your question, please be very specific about it. Otherwise experts will choose their favourite one and give answers which might be completely useless to you.

Is it Windows Forms, WPF, ASP.NET, ASP.NET MVC, HTML + Ajax, Angular, which one?
Bhavesh Jadav8y ago
Hello Goram,

I have create one example in MVC for you and it's working fine
Example :

step-1 : Controller Page
// Get button data from database
DataTable tbl = GetButtonDataFromDataBase();

string btns = "";

if(tbl != null && tbl.Rows.count > 0)
{
    for(int i= 0 ; i
    {
        btns += " + tbl.Rows[i][Name] + "' value='" + tbl.Rows[i][Price] + "' text='" + tbl.Rows[i][Name] + "'>";
    }
}

// pass string of buttons to view through ViewBag
ViewBag.Buttons = btns;
step-2 : View Page
// add below in view where you want to put all buttons
@Html.Row(ViewBag.Buttons);
I hope it clear your doubts.

Thanks.
Hiten Pandya8y ago
Hi,

There are many ways to do this if you want to do it in Asp.Net that means in your aspx.cs file then you can use the button class and access its properties. See the example below,
protected void Page_Load(object sender, EventArgs e)
{
    try
    {
        Button btn = new Button();
        btn.Text = "Click";
        btn.ID = "btn_click";
        btn.Click += new EventHandler(btnevent_Click);
        btn.OnClientClick = "Hello('" + "a" + "')";

        form1.Controls.Add(btn);
    }
    catch (Exception)
    { }
}

protected void btnevent_Click(object sender, EventArgs e)
{
    try
    {
        //place your code here
        Response.Write("Hello World");
    }
    catch (Exception)
    { }
}
and then in aspx page means in your design file,
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DynamicButtons.aspx.cs" Inherits="ASP.NETFORUMS.DynamicButtons" %>

>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>title>

    <script type="text/javascript">
        function Hello(message) {
            if (message == 'a')
                alert('Apple');
            else if (message == 'o')
                alert('Ornage');
        }
    script>
head>
<body>
    <form id="form1" runat="server">
    <div>

    div>
    form>
body>
html>
And if you want to use jquery then please refer the below links,
http://viralpatel.net/blogs/dynamic-add-textbox-input-button-radio-element-html-javascript/

http://www.encodedna.com/jquery/dynamically-add-textbox-in-jquery-and-save-data-to-sqlserver-using-webmethod.htm

reference links:- https://forums.asp.net/t/1900207.aspx?Creating+buttons+dynamically

Hope it helps you.

Thanks.