Pomoc oko Dataet u MySql-u 5.7.21 i C#

Radomi Mihajlovic

Zainteresovan član
Poruka
104
Vec nekoliko dana mucim se kako da u DataSet-u prikazem podatke iz tabele. Kada ne stavim uslov u WHERE prikaze mi kompletnu tabelu, ali meni treba samo deo koji se odnosi na to da je brnaloga (broj naloga za knjizenje) izmedju snalog1 i snalog2.

myConnectionString = pwput;
MySqlConnectionconpara = new MySql.Data.MySqlClient.MySqlConnection();
conpara.ConnectionString = myConnec DataSetionString;
try
{
conpara.Open();
if (conpara.State == ConnectionState.Open)
{
string snalog1 = wnalog1.ToString();
string snalog2 = wnalog2.ToString();
stringnupita = "SELECT godina=wgodina AND brnaloga>= snalog1 AND brnaloga<= snalog2 FROM glavnaknjiga WHERE godina=wgodina AND brnaloga>= snalog1
AND brnaloga<= snalog2";
MySqlCommandcmdnal = new MySqlCommand(nupita, conpara);
cmdnal.Parameters.AddWithValue("@godina", wgodina);
MySqlDataAdapte radda = new MySqlDataAdapter(cmdnal);
MySqlCommandBuildercbb = new MySqlCommandBuilder(adda);
dataGridView1.Columns[0].Width = 2;
DataSet dsd = new DataSet();
adda.Fill(dsd, "glavnaknjiga");
conpara.Close();

if (dsd != null)
{
dataGridView1.DataSource = dsd;
dataGridView1.DataMember = "glavnaknjiga";
Font = new System.Drawing.Font("Arial Unicode", 7);
dataGridView1.Font = Font;

dataGridView1.Columns[0].Width = 2;
dataGridView1.Columns[1].Width = 2;
dataGridView1.Columns[2].Width = 50;
dataGridView1.Columns[3].Width = 65;
dataGridView1.Columns[4].Width = 55;
dataGridView1.Columns[5].Width = 60;
dataGridView1.Columns[6].Width = 60;
dataGridView1.Columns[7].Width = 150;
dataGridView1.Columns[8].Width = 65;
dataGridView1.Columns[9].Width = 65;
dataGridView1.Columns[10].Width = 65;
dataGridView1.Columns[11].Width = 70;
dataGridView1.Columns[12].Width = 50;
dataGridView1.Columns[13].Width = 80;
dataGridView1.Columns[14].Width = 80;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToOrderColumns = true;
dataGridView1.AllowUserToResizeColumns = true;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.MultiSelect = true;
dataGridView1.AllowUserToResizeRows = false;

dataGridView1.Columns[2].HeaderText = "NALOG";
dataGridView1.Columns[3].HeaderText = "DATUM NALOGA";
dataGridView1.Columns[4].HeaderText = "DOKUMENA";
dataGridView1.Columns[5].HeaderText = "KONTO";
dataGridView1.Columns[6].HeaderText = " O P I S S T A V K E ";
dataGridView1.Columns[7].HeaderText = "DATUM DOK.";
dataGridView1.Columns[8].HeaderText = "D P O ";
dataGridView1.Columns[9].HeaderText = "ROK PLAC.";
dataGridView1.Columns[10].HeaderText = "VEZA DOKUMENAT";
dataGridView1.Columns[11].HeaderText = "MES.TR.";
dataGridView1.Columns[12].HeaderText = " DUGUJE ";
dataGridView1.Columns[12].DefaultCellStyle.Format = ("#,##0.00");
dataGridView1.Columns[12].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[13].HeaderText = "POTRAŽUJE";
dataGridView1.Columns[13].DefaultCellStyle.Format = ("#,##0.00");
dataGridView1.Columns[13].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[14].HeaderText = "K/D";
dataGridView1.Columns["id-radgk"].Visible = false;
dataGridView1.Columns["godgk"].Visible = false;
dataGridView1.Columns["sifraoperatera"].Visible = false;
dataGridView1.Columns["komintent"].Visible = false;
}
}
 

Back
Top