Beispiel #1
0
        void PopulateDataGridView()
        {
            string query = "SELECT ta.[Id] as 'AlkatreszId' ,t.Id, t.Azonosito , t.Nev , ta.AlkatreszMennyiseg as 'darab'" +
                           "FROM[erp].[dbo].[TermekAlkatresz] ta  " +
                           "inner join Termek  t on ta.AlkatreszId = t.Id " +
                           "where TermekId = " + CBTermekek.SelectedValue.ToString();

            dgvEmployee.DataSource = DbManagment.SqlDataAdRun(query);
        }
Beispiel #2
0
        private void PopulateDataGridView()
        {
            string query = "SELECT * FROM [RaktarView] where azonosito like '%" + TBAzon.Text + "%' and  nev like '%" + TBNev.Text + "%'";

            dgvEmployee.DataSource = DbManagment.SqlDataAdRun(query);
        }