Auto create image inside button from sql table and dimensio?

Goran Bibic

8y781Learn iOS Programming

Create

private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'bssDataSet.roba_usluge' table. You can move, or remove it, as needed.
this.roba_uslugeTableAdapter.Fill(this.bssDataSet.roba_usluge);
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 = 1; i <= count; i++)
// for (int i = 0; i < count; i++)
{
Button button = new Button();
button.Left = left;
button.Top = top;
button.Text = ItemTable.Rows[i-1][0].ToString();
// button.Text = ItemTable.Rows[i][0].ToString();
this.Controls.Add(button);
if (i % 5 == 0)
{
left = 50;
top += button.Height + 2;
}
else
{
left += button.Width + 2;
}
// top += button.Height + 2;
}
}

5 Replies

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

Rafnas T P8y ago
Accepted answer
updated code as follows try this
this.roba_uslugeTableAdapter.Fill(this.bssDataSet.roba_usluge);



SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True");
SqlCommand cmd = new SqlCommand("SELECT Concat(ime, cijena_sa_porezom),data 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 = 1; i <= count; i++)
   // for (int i = 0; i < count; i++)
{
    Button button = new Button();
    button.Left = left;
    button.Top = top;
    button.Text = ItemTable.Rows[i-1][0].ToString();
if(ItemTable.Rows[i - 1][1]!=null)
{
  try
  {
    byte[] _byte = (byte[])ItemTable.Rows[i - 1][1];
    MemoryStream ms = new MemoryStream(_byte);
    button.Image = System.Drawing.Image.FromStream(ms);
   }
   catch{}
  }
   // button.Text = ItemTable.Rows[i][0].ToString();
    this.Controls.Add(button);
    if (i % 5 == 0)
    {
        left = 50;
        top += button.Height + 2;
    }
    else
    {
        left += button.Width + 2;
    }
    // top += button.Height + 2;


}
+2
Rafnas T P8y ago
just remove this line from if condition may because of that

&& ItemTable.Rows[i - 1][1]!=""
+2
Goran Bibic8y ago
Its work, have pictures in button, but I have warning

Warning CS0252

Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'
0
Goran Bibic8y ago
data is column name
In form load error line 40
error {"Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'."}
// TODO: This line of code loads data into the 'bssDataSet.roba_usluge' table. You can move, or remove it, as needed.
this.roba_uslugeTableAdapter.Fill(this.bssDataSet.roba_usluge);



SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True");
SqlCommand cmd = new SqlCommand("SELECT Concat(ime, cijena_sa_porezom),data 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 = 1; i <= count; i++)
   // for (int i = 0; i < count; i++)
{
    Button button = new Button();
    button.Left = left;
    button.Top = top;
    button.Text = ItemTable.Rows[i-1][0].ToString();
   // button.Text = ItemTable.Rows[i][0].ToString();
    this.Controls.Add(button);
    if (i % 5 == 0)
    {
        left = 50;
        top += button.Height + 2;
    }
    else
    {
        left += button.Width + 2;
    }
    // top += button.Height + 2;

    byte[] _byte = (byte[])ItemTable.Rows[i - 1][1];
    MemoryStream ms = new MemoryStream(_byte);
    button.Image = System.Drawing.Image.FromStream(ms);
}
+1
Rafnas T P8y ago
hi,
to get image from sql table write that column name in select statement as shown below
here dataImage is I have given column name, you can change as per your sql table image column name
SqlCommand cmd = new SqlCommand("SELECT Concat(ime, cijena_sa_porezom),dataImage FROM roba_usluge", con);
next inside for loop where you gave button.Text just below that write one more property as shown below
byte[] _byte = (byte[])ItemTable.Rows[i-1][1];
MemoryStream ms = new MemoryStream(_byte);
button.Image = System.Drawing.Image.FromStream(ms);
+2