DataAdapter (sqlceh, con); DataSet dsmarka=new DataSet (); DataSet dsmodel=new DataSet (); DataSet dsceh=new DataSet (); con. Open (); datamarka. Fill (dsmarka, «marka»); datamodel. Fill (dsmodel, «model»); dataceh. Fill (dsceh, «ceh»); con. Close (); dataGridView5. DataSource=dsmarka; dataGridView5. DataMember=«marka»; dataGridView6. DataSource=dsmodel; dataGridView6. DataMember=«model»; dataGridView7. DataSource=dsceh; dataGridView7. DataMember=«ceh»; for (int i=0; i lt; dataGridView5. RowCount - 1; i ++)
{s;=Convert. ToString (dataGridView5 [0, i] .Value); comboBox2. Items. Add (s);
} (int i=0; i lt; dataGridView6. RowCount - 1; i ++)
{s;=Convert. ToString (dataGridView6 [0, i] .Value); comboBox3. Items. Add (s);
} (int i=0; i lt; dataGridView7. RowCount - 1; i ++)
{s;=Convert. ToString (dataGridView7 [0, i] .Value); comboBox4. Items. Add (s);
}. SelectedItem=Convert. ToString (dataGridView2 [3, 0] .Value); comboBox3. SelectedItem=Convert. ToString (dataGridView2 [4, 0] .Value); comboBox4. SelectedItem=Convert. ToString (dataGridView2 [8, 0] .Value); (sotrudnik.load == 1)
{(comboBox5. Text == «Списаний»)
{. Enabled=false;}
}
}
{. active=13; String sql=«SELECT naim_oborud FROM dbo.naim_oborud»; inv=«SELECT inv_nom FROM dbo.oborud»; con=new SqlConnection (connectionstring); SqlDataAdapter data=new SqlDataAdapter (sql, con); dataadapter=new SqlDataAdapter (inv, con); DataSet ds=new DataSet (); DataSet ds2=new DataSet (); con. Open () ;. Fill (ds, «naim_oborud») ;. Fill (ds2, «oborud») ;. Close () ;. DataSource=ds ;. DataMember=«naim_oborud»; (int i=0; i lt; dataGridView1. RowCount - 1; i ++)
{s;=Convert. ToString (dataGridView1 [0, i] .Value) ;. Items. Add (s);
}. DataSource=ds2 ;. DataMember=«oborud»;. Inventar=new string [dataGridView3. RowCount]; (int i=0; i lt; dataGridView3. RowCount - 1; i ++)
{. inventar [i]=Convert. ToString (dataGridView3 [0, i] .Value);
} sqlceh=«SELECT * FROM dbo.ceh»; dataceh=new SqlDataAdapter (sqlceh, con); DataSet dsceh=new DataSet (); con. Open (); dataceh. Fill (dsceh, «ceh»); con. Close (); dataGridView7. DataSource=dsceh; dataGridView7. DataMember=«ceh»; for (int i=0; i lt; dataGridView7. RowCount - 1; i ++)
{s;=Convert. ToString (dataGridView7 [0, i] .Value); comboBox4. Items. Add (s);
}. SelectedText=«У роботі»;
}
}
void button1_Click (object sender, EventArgs e)
{tumbler=0; perem;=(textBox1. Text); (int i=0; i lt; dataGridView3. RowCount - 1; i ++)
{(perem == Convert. ToString (dataGridView3 [0, i] .Value))
{tumbler=90;}
} (Data.tumbler == 15)
} (textBox1. Text == «» || textBox2. Text == «» || comboBox1. Text =="")
{. Show («Перевірте правильність заповнення полів»);
}
{. active=0; [] t=new string [3]; if (dateTimePicker1. Value. Day lt;=9) {t [0]=«0»; t [0] +=Convert. ToString (dateTimePicker1. Value. Day);} {t [0]=Convert. ToString (dateTimePicker1. Value. Day);} (dateTimePicker1. Value. Month lt;=9) {t [1]=«0»; t [1] +=Convert. ToString (dateTimePicker1. Value. Month);} {t [1]=Convert. ToString (dateTimePicker1. Value. Month);} [2]=Convert. ToString (dateTimePicker1. Value. Year); time1;=Convert. ToString (t [2]); time1 +=Convert. ToString (t [1]); time1 +=Convert. ToString (t [0]); (dateTimePicker2. Value. Day lt;=9) {t [0]=«0»; t [0] +=Convert. ToString (dateTimePicker2. Value. Day);} {t [0]=Convert. ToString (dateTimePicker2. Value. Day);} (dateTimePicker2. Value. Month lt;=9) {t [1]=«0»; t [1] +=Convert. ToString (dateTimePicker2. Value. Month);} {t [1]=Convert. ToString (dateTimePicker2. Value. Month);} [2]=Convert. ToString (dateTimePicker2. Value. Year); time0;=Convert. ToString (t [2]); time0 +=Convert. ToString (t [1]); time0 +=Convert. ToString (t [0]); string connectionstring=server.name; String sql=null; String sqlup=null; SqlConnection con=new SqlConnection (connectionstring); SqlDataAdapter data=new SqlDataAdapter (sql, con); DataSet ds=new DataSet (); SqlDataAdapter adapter=new SqlDataAdapter (); dataGridView2 [0, 0] .Value=textBox1. Text; [1, 0] .Value=textBox2. Text; dataGridView2 [2, 0] .Value=comboBox1. Text; dataGridView2 [3, 0] .Value=comboBox2. Text; dataGridView2 [4, 0] .Value=comboBox3. Text; connetionString=null; SqlConnection connection; connetionString=server.name; connection=new SqlConnection (connetionString); if (comboBox5. Text == «Списаний»)
{= «update oborud set inv_nom=» + dataGridView2 [0, 0] .Value + « raquo ;, zav_nom=» + dataGridView2 [1, 0] .Value + « raquo ;, naim_oborud= laquo ; »+ dataGridView2 [2, 0] .Value +« raquo ;, marka= »+ dataGridView2 [3, 0] .Value +« raquo ;, model= »+ dataGridView2 [4, 0] .Value + « ra...
