void ComboBoxFill()
{
string query = "SELECT [Id],[Azonosito] +' '+ Nev as Azon FROM[erp].[dbo].[Termek] where Gyartando = 1";
DataSet ds = DbManagment.SqlDataSetCreate(query, "Termek");
CBTermekek.DisplayMember = "Azon";
CBTermekek.ValueMember = "Id";
CBTermekek.DataSource = ds.Tables["Termek"];
}
void ComboBoxFill()
{
// using (SqlConnection sqlCon = new SqlConnection(connectionString))
//{
string query = "SELECT [Id],[Azonosito] +' '+ Nev as Azon FROM[erp].[dbo].[Termek] where id = " + AlkatreszId;
if (Beszuras)
{
query = "SELECT [Id],[Azonosito] +' '+ Nev as Azon FROM[erp].[dbo].[Termek] where id != " + TermekId;
}
// SqlDataAdapter da = new SqlDataAdapter(query, sqlCon);
// sqlCon.Open();
DataSet ds = DbManagment.SqlDataSetCreate(query, "Termek");// new DataSet();
// da.Fill(ds, "Termek");
CBTermekek.DisplayMember = "Azon";
CBTermekek.ValueMember = "Id";
CBTermekek.DataSource = ds.Tables["Termek"];
// }
// public static DataSet SqlDataSetCreate(string query, string tablename)
}
