Define variable from count sql command

Goran Bibic

8y825Learn iOS Programming

Need to define variable count i=count

Becose I need to auto create number of buttons from counter

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(*) FROM roba_usluge";
Int32 count = (Int32)cmd.ExecuteScalar();
int top = 50;
int left = 50;
for (int i = 0; i = count.ToString(); i++)
{
Button button = new Button();
button.Left = left;
button.Top = top;
button.Text = (i + 1).ToString();
this.Controls.Add(button);
top += button.Height + 2;
}

9 Replies

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

Amit Gupta8y ago
Accepted answer
Okay, you need to change your sql query because ciunt(*) will give you the total rows of the table and not the name
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True");
           SqlCommand cmd = new SqlCommand("SELECT Concat(ItemName, price) 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;
           }
       }
Note: ItemName and price in the query will be replaced with your original column name that you have in sql db

The above code is untested, do ex3cute and let me know, if you are getting any undesired result
Goran Bibic8y ago
Thank you...I am posted another question...if you have got time...you can look...

https://www.c-sharpcorner.com/forums/insert-picture-in-datagrid-c-sharp

I need to insert picture in datagrid
Amit Gupta8y ago
Yes, you can do that too, you must have images to show on a button either from db or from a folder.

You can go through the below link that shows for adding image
https://stackoverflow.com/questions/3965694/how-to-resize-a-button-depending-on-its-text

Coming to your question to resuze the button according to the text contained in it, you can use AutoSize priperty. Have a look to the below link that you can play with button properties to suit your needs

https://stackoverflow.com/questions/11483655/icon-inside-of-button

Good Luck
Amit Gupta8y ago
Can you show the screenshot, how buttons are showing.

There are several ways to show the result to user, that depends upon your choice and for which project you are working with
Goran Bibic8y ago
Code work fine
I think result is ok...
becose is button smal dimension...how to setup biger button? Or change dimension?

What did you think about solution...to into button upload picture from same table and Itemname and below button price in label or somesthing?
Goran Bibic8y ago
Button is created from count table items...Table sql is
1. Coca Cola 2,00$
2. Fanta 2,00$
etc...

I want in button 1 text .....coca cola and 2,00$...two values ...table is same like in line 4

I hope you understand me
Amit Gupta8y ago
You are setting the button name as 1, 2, 3 and so on. What do you want, descrive briefly sp that one can understand properly
Goran Bibic8y ago
Amit regards...this cod works now...how to selec t from sql table roba usluge and put in the button Name and price from sql table to button...line 4
private void Form1_Load(object sender, EventArgs e)
       {
           SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True");
           SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM roba_usluge", con);


           con.Open();
           Int32 count = (Int32)cmd.ExecuteScalar();
           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 = (i + 1).ToString();
               this.Controls.Add(button);
               top += button.Height + 2;
           }
       }
Amit Gupta8y ago
What is tge issue?