How to create button in form from sql table values?

Question

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

Rafnas T P · Answer

hi, to create buttons dynamically you can try below code int top = 50; int left = 50; for ( int i = 0; 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

Nitin Sontakke · Answer

@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 Jadav · Answer

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 Pandya · Answer

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.

Nitin Sontakke · Answer

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.

Rafnas T P · Answer

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 Bibic · Answer

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 { 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 Gangwar · Answer

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 P · Answer

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 { 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 Bibic · Answer

Nitin Sontakke I am find notepad file, see logic , but where and how to create automatic creation button?

Goran Bibic · Answer

Hiten Pandya Where to put this code?

Goran Bibic · Answer

Bhavesh Jadav Where to put this code? I want to try

Hiten Pandya · Answer

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.

Goran Bibic · Answer

Windows Forms