private void AddColumnsToDataGridView(string tbname)
{
var reader = servConn.SelectAll(tbname);
for (var k = 0; k < reader.FieldCount; k++)
{
DB_Table.Columns.Add(reader.GetName(k), reader.GetName(k));
}
}
private void Buy_Load(object sender, EventArgs e)
{
var count_goods = servConn.CountRows(tableName);
container = new Container[count_goods];
var readerImages = servConn.SelectAll("FV_Product");
var reader = servConn.SelectAll(tableName);
int i = 0;
while (reader.Read() /*&& readerImages.Read()*/)
{
// var imagePath = readerImages.GetString(1);
container[i].Shell = new Panel()
{
Parent = Panel_Board, Location = new Point(i == 0 ? 15: container[i - 1].Shell.Location.X + container[i - 1].Shell.Size.Width + 15, 17), Name = "Goods_" + i.ToString(), Size = new Size(200, 100), BorderStyle = BorderStyle.FixedSingle
};
container[i].Name = new Label()
{
Parent = container[i].Shell, Location = new Point(10, 10), Size = new Size(185, 23), Name = "Name", Font = new Font("Microsoft Sans Serif", 14), Text = reader.GetString(1)
};
container[i].Price = new Label()
{
Parent = container[i].Shell, Location = new Point(10, 40), Size = new Size(185, 16), Name = "Price_" + i.ToString(), Font = new Font("Microsoft Sans Serif", 12), Text = reader.GetValue(3).ToString() + "$", AutoSize = true
};
container[i].Description = new Label()
{
Parent = container[i].Shell, Location = new Point(10, 70), Size = new Size(184, 64), Name = "Descr_" + i.ToString(), Font = new Font("Microsoft Sans Serif", 11), Text = reader.GetString(4)
};
container[i].Picture = new PictureBox()
{
Parent = container[i].Shell, Location = new Point(14, 14), Name = "Picture_" + i.ToString(), Size = new Size(200, 100), BackColor = Color.Transparent, SizeMode = PictureBoxSizeMode.StretchImage, Cursor = Cursors.Hand
};
container[i].Picture.Click += Furniture_Click;
i++;
}
}
public static void FillDataGridView(SQLServerConnect servConn, DataGridView dgw, string tableName)
{
dgw.Rows.Clear();
dgw.Columns.Clear();
int count = servConn.CountRows(tableName);
bool create = true;
var reader = servConn.SelectAll(tableName);
if (count == 0)
{
for (var k = 0; k < reader.FieldCount; k++)
{
dgw.Columns.Add(reader.GetName(k), reader.GetName(k));
}
}
for (var i = 0; i < count; i++)
{
reader.Read();
if (create)
{
for (var k = 0; k < reader.FieldCount; k++)
{
dgw.Columns.Add(reader.GetName(k), reader.GetName(k));
}
create = false;
}
dgw.Rows.Add();
for (var j = 0; j < reader.FieldCount; j++)
{
dgw.Rows[i].Cells[j].Value = reader.GetValue(j);
dgw.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
}
}
