private void dodajRobuButton_Click(object sender, EventArgs e) { if (robaDGV.SelectedRows.Count > 0 && int.Parse(kolicinaTbox.Text) > 0) { try { connection.Open(); string sqlQuery; sqlQuery = "insert into stavka_primka values (" + int.Parse(robaDGV.CurrentRow.Cells[0].Value.ToString()) + "," + idprimka + "," + int.Parse(kolicinaTbox.Text) + ")"; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); MessageBox.Show("Ta roba već postoji na primci"); } finally { if (connection != null) { connection.Close(); } } } else { MessageBox.Show("Nije odabrana roba"); } }
public void TestNoPrepareNamedParamIn() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(in p1 string, in p2 string) as throw p1; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; NuoDbParameter param1 = new NuoDbParameter(); param1.ParameterName = "p2"; param1.Direction = ParameterDirection.Input; param1.Value = "goodbye"; cmd.Parameters.Add(param1); NuoDbParameter param2 = new NuoDbParameter(); param2.ParameterName = "p1"; param2.Direction = ParameterDirection.Input; param2.Value = "hello"; cmd.Parameters.Add(param2); try { cmd.ExecuteNonQuery(); Assert.Fail(); } catch (Exception e) { Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message); } } }
private void dodajPrimkuButton_Click(object sender, EventArgs e) { if (partneriCbox.SelectedIndex >= 0) { try { connection.Open(); string sqlQuery; sqlQuery = "insert into primka values (default, '" + DateTime.Today.ToString("dd/MM/yyyy") + "', 0, " + idzaposlenik + ", " + idList[partneriCbox.SelectedIndex] + " ); "; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } GetPrimke(); } } else { MessageBox.Show("Nije odabran partner"); } }
private void spremiButton_Click(object sender, EventArgs e) { try { connection.Open(); string sqlQuery; if (idSkladiste == 999) { sqlQuery = "insert into skladiste values (default, '" + nazivTbox.Text + "', '" + adresaTbox.Text + "' );"; } else { sqlQuery = "update skladiste set naziv = '" + nazivTbox.Text + "', adresa = '" + adresaTbox.Text + "' where idskladiste = " + idSkladiste + ";"; } NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } } }
private void otkljucajPrimkuButton_Click(object sender, EventArgs e) { if (primkaDGV.SelectedRows.Count > 0 && int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 1) { try { connection.Open(); string sqlQuery; sqlQuery = "update primka set kontrola = 0 where idprimka = " + int.Parse(primkaDGV.CurrentRow.Cells[0].Value.ToString()) + ""; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } GetPrimke(); } } else if (int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 0) { MessageBox.Show("Primka je već otključana"); } else { MessageBox.Show("Nije odabrana primka"); } }
private void obrisiPartneraButton_Click(object sender, EventArgs e) { if (partneriDGV.SelectedRows.Count > 0) { try { connection.Open(); string sqlQuery; sqlQuery = "delete from poslovni_partner where idposlovni_partner = " + int.Parse(partneriDGV.CurrentRow.Cells[0].Value.ToString()) + ""; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); MessageBox.Show("Poslovni partner se ne može brisati dok se navodi na računima ili primkama"); } finally { if (connection != null) { connection.Close(); } GetPartneri(); } } else { MessageBox.Show("Nije odabran partner"); } }
private void spremiButton_Click(object sender, EventArgs e) { try { connection.Open(); string sqlQuery; if (idPozicija == 999) { sqlQuery = "insert into pozicija values (default, '" + nazivTbox.Text + "', '" + opisTbox.Text + "' " + ", " + razinaTbox.Text + " ); "; } else { sqlQuery = "update pozicija set naziv = '" + nazivTbox.Text + "', opis = '" + opisTbox.Text + "', razina_prava = " + razinaTbox.Text + " where idpozicija = " + idPozicija + ";"; } NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } } }
private void obrisiPozicijuButton_Click(object sender, EventArgs e) { if (pozicijaDGV.SelectedRows.Count > 0) { try { connection.Open(); string sqlQuery; sqlQuery = "delete from pozicija where idpozicija = " + int.Parse(pozicijaDGV.CurrentRow.Cells[0].Value.ToString()) + ""; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); MessageBox.Show("Pozicija se ne može brisati dok se koristi za zaposlenika"); } finally { if (connection != null) { connection.Close(); } GetPozicija(); } } else { MessageBox.Show("Nije odabrana pozicija"); } }
public void TestPrepareParamIn() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(in p1 string) as throw p1; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Prepare(); Assert.IsTrue(cmd.Parameters.Contains("p1")); Assert.AreEqual(ParameterDirection.Input, cmd.Parameters["p1"].Direction); cmd.Parameters["p1"].Value = "hello"; try { cmd.ExecuteNonQuery(); Assert.Fail(); } catch (Exception e) { Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message); } } }
internal static void CreatePersonTable() { using (NuoDbConnection connection = new NuoDbConnection(connectionString)) { connection.Open(); try { DbCommand dropCommand = new NuoDbCommand("drop table Person", connection); dropCommand.ExecuteNonQuery(); } catch (Exception) { // table is allowed to be missing } DbCommand createCommand = new NuoDbCommand("create table Person" + "(" + " Id char(38) not NULL primary key," + " Name String" + ")", connection); createCommand.ExecuteNonQuery(); DbCommand insertCommand = new NuoDbCommand("Insert into Person (Id, Name) Values (?,?)", connection); insertCommand.Prepare(); insertCommand.Parameters[0].Value = new Guid("{F571197E-7A4F-4961-9363-7411EACCA841}"); insertCommand.Parameters[1].Value = "Klaus Müller"; insertCommand.ExecuteNonQuery(); } }
internal static void CreateGameTable() { using (NuoDbConnection connection = new NuoDbConnection(connectionString)) { connection.Open(); try { DbCommand dropCommand = new NuoDbCommand("drop table Game", connection); dropCommand.ExecuteNonQuery(); } catch (Exception) { // table is allowed to be missing } DbCommand createCommand = new NuoDbCommand("create table Game" + "(" + " Id bigint generated always as identity not NULL primary key," + " Date DATE" + ")", connection); createCommand.ExecuteNonQuery(); DbCommand insertCommand = new NuoDbCommand("Insert into Game (Date) Values (?)", connection); insertCommand.Prepare(); insertCommand.Parameters[0].Value = "1970-01-01"; insertCommand.ExecuteNonQuery(); } }
private void izdajRacunButton_Click(object sender, EventArgs e) { if (racuniDGV.SelectedRows.Count > 0 && int.Parse(racuniDGV.CurrentRow.Cells[3].Value.ToString()) == 0) { try { connection.Open(); string sqlQuery; sqlQuery = "update racun set kontrola = 1 where idracun = " + int.Parse(racuniDGV.CurrentRow.Cells[0].Value.ToString()) + ""; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } GetRacuni(); } } else if (int.Parse(racuniDGV.CurrentRow.Cells[3].Value.ToString()) == 1) { MessageBox.Show("Račun je već zaključan"); } else { MessageBox.Show("Nije odabran račun"); } }
private void obrisiStavkubutton_Click(object sender, EventArgs e) { if (primkaDGV.SelectedRows.Count > 0 && int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 0 && stavkaDGV.SelectedRows.Count > 0) { try { connection.Open(); string sqlQuery; sqlQuery = "delete from stavka_primka where primka_idprimka = " + int.Parse(primkaDGV.CurrentRow.Cells[0].Value.ToString()) + " and roba_idroba = " + int.Parse(stavkaDGV.CurrentRow.Cells[0].Value.ToString()) + ""; NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } GetStavke(); } } else if (int.Parse(primkaDGV.CurrentRow.Cells[2].Value.ToString()) == 1) { MessageBox.Show("Primka je zaključana i ne može se mijenjati"); } else { MessageBox.Show("Nije odabrana primka"); } }
public void DB4329() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); Utils.DropTable(connection, "ExpenseTest"); DbCommand createCommand = new NuoDbCommand("Create table ExpenseTest" + "(" + "SourceExpenseId int," + "ExpenseAmount numeric(15,2)" + ")", connection); createCommand.ExecuteNonQuery(); DbCommand insertCommand = new NuoDbCommand("Insert Into ExpenseTest(SourceExpenseId, ExpenseAmount) Values (?,?)", connection); insertCommand.Prepare(); insertCommand.Parameters[0].Value = -1254524; insertCommand.Parameters[1].Value = -135.35; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 100100100; insertCommand.Parameters[1].Value = -1325465.35; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 100100101; insertCommand.Parameters[1].Value = 200000.35; insertCommand.ExecuteNonQuery(); DbCommand selectCommand = new NuoDbCommand("select SourceExpenseId, ExpenseAmount from ExpenseTest", connection); using (DbDataReader reader = selectCommand.ExecuteReader()) { bool hasNext = reader.Read(); Assert.IsTrue(hasNext); Assert.AreEqual(-1254524, reader[0]); Assert.AreEqual(-135.35, reader[1]); hasNext = reader.Read(); Assert.IsTrue(hasNext); Assert.AreEqual(100100100, reader[0]); Assert.AreEqual(-1325465.35, reader[1]); hasNext = reader.Read(); Assert.IsTrue(hasNext); Assert.AreEqual(100100101, reader[0]); Assert.AreEqual(200000.35, reader[1]); } } }
internal static void DropTable(NuoDbConnection cnn, string tableName) { try { DbCommand dropCommand = new NuoDbCommand("drop table " + tableName, cnn); dropCommand.ExecuteNonQuery(); } catch (Exception) { // table is allowed to be missing } }
public void TestNoPrepareAnonymousParamOut() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(out p1 string) as p1='hello'; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); Assert.AreEqual("hello", cmd.Parameters["p1"].Value); } }
public void TestTableValuedArgument() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); try { new NuoDbCommand("create procedure nunit_test(input_data(field1 string, field2 integer), out output_data string) " + " as " + " output_data = ''; " + " for select field1 from input_data; " + " output_data = output_data || field1 || ' '; " + " end_for; " + " end_procedure", connection).ExecuteNonQuery(); } catch (NuoDbSqlException e) { if (e.Code.Code == -1) { // the server doesn't support table valued arguments for procedures return; } else { throw; } } NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Prepare(); DataTable table = new DataTable(); table.Columns.Add("f1", typeof(string)); table.Columns.Add("f2", typeof(int)); DataRow row1 = table.NewRow(); row1[0] = "hello"; row1[1] = 0; table.Rows.Add(row1); DataRow row2 = table.NewRow(); row2[0] = "world!"; row2[1] = 0; table.Rows.Add(row2); cmd.Parameters[0].Value = table; cmd.ExecuteNonQuery(); Assert.AreEqual("hello world! ", cmd.Parameters[1].Value); } }
public void TestPrepareParamInOut() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(inout p1 string) as if(p1='goodbye') p1='hello'; end_if; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Prepare(); Assert.IsTrue(cmd.Parameters.Contains("p1")); Assert.AreEqual(ParameterDirection.InputOutput, cmd.Parameters["p1"].Direction); cmd.Parameters["p1"].Value = "goodbye"; cmd.ExecuteNonQuery(); Assert.AreEqual("hello", cmd.Parameters["p1"].Value); } }
private void spremiButton_Click(object sender, EventArgs e) { decimal jed_cijena; if (decimal.TryParse(jedcijenaTbox.Text, out jed_cijena)) { try { connection.Open(); string sqlQuery; if (idRoba == 999) { sqlQuery = "insert into roba values (default, '" + nazivTbox.Text + "', " + jedcijenaTbox.Text + " " + ", " + 0 + " " + ", '" + opisTbox.Text + "', " + idList[skladisteCbox.SelectedIndex] + " ); "; } else { sqlQuery = "update roba set naziv = '" + nazivTbox.Text + "', jedinicna_cijena = " + jedcijenaTbox.Text + ", opis = '" + opisTbox.Text + "', skladiste_idskladiste = " + idList[skladisteCbox.SelectedIndex] + " where idroba = " + idRoba + ";"; } NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); MessageBox.Show("Nije upisan iznos nije u pravilnom formatu"); } finally { if (connection != null) { connection.Close(); } } } else { MessageBox.Show("Nije upisan iznos nije u pravilnom formatu"); } }
private void spremiButton_Click(object sender, EventArgs e) { double OIB; int telBroj; if (double.TryParse(oibTbox.Text, out OIB) && oibTbox.Text.Length == 11 && int.TryParse(telbrojTbox.Text, out telBroj) && tipCbox.SelectedIndex >= 0) { try { connection.Open(); string sqlQuery; if (idPartner == 0) { sqlQuery = "insert into poslovni_partner values (default, '" + nazivTbox.Text + "', '" + OIB + "' " + ", '" + telBroj + "' " + ", '" + adresaTbox.Text + "' " + ", '" + brojracunaTbox.Text + "', " + idList[tipCbox.SelectedIndex] + " ); "; } else { sqlQuery = "update poslovni_partner set naziv = '" + nazivTbox.Text + "', oib = '" + oibTbox.Text + "', telefonski_broj = '" + telBroj + "', adresa = '" + adresaTbox.Text + "', broj_racuna = '" + brojracunaTbox.Text + "', tip_partnera_idtip_partnera = " + idList[tipCbox.SelectedIndex] + " where idposlovni_partner = " + idPartner + ";"; } NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } } } else { MessageBox.Show("Krivo upisani OIB"); } }
public void TestNoPrepareAnonymousParamIn() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(in p1 string) as throw p1; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("hello"); try { cmd.ExecuteNonQuery(); Assert.Fail(); } catch (Exception e) { Assert.IsTrue(e.Message.EndsWith("hello"), "Expected error: 'hello', received " + e.Message); } } }
public void TestNoPrepareNamedParamOut() { using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString)) { connection.Open(); new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery(); new NuoDbCommand("create procedure nunit_test(out p1 string, out p2 string) as p1='hello'; end_procedure", connection).ExecuteNonQuery(); NuoDbCommand cmd = new NuoDbCommand("nunit_test", connection); cmd.CommandType = CommandType.StoredProcedure; NuoDbParameter param1 = new NuoDbParameter(); param1.ParameterName = "p2"; param1.Direction = ParameterDirection.Output; cmd.Parameters.Add(param1); NuoDbParameter param2 = new NuoDbParameter(); param2.ParameterName = "p1"; param2.Direction = ParameterDirection.Output; cmd.Parameters.Add(param2); cmd.ExecuteNonQuery(); Assert.AreEqual("hello", cmd.Parameters["p1"].Value); } }
private void spremiButton_Click(object sender, EventArgs e) { double OIB; int telBroj; if (double.TryParse(oibTbox.Text, out OIB) && oibTbox.Text.Length == 11 && int.TryParse(telbrojTbox.Text, out telBroj) && pozicijaCbox.SelectedIndex >= 0) { try { connection.Open(); string sqlQuery; if (idZaposlenik == 999) { sqlQuery = "insert into zaposlenik values (default, '" + imeTbox.Text + "', '" + prezimeTbox.Text + "' " + ", '" + telBroj + "' " + ", '" + adresaTbox.Text + "', '" + OIB + "', '" + brojracunaTbox.Text + "', '" + korimeTbox.Text + "', '" + lozinkaTbox.Text + "'," + idList[pozicijaCbox.SelectedIndex] + " ); "; } else { sqlQuery = "update zaposlenik set ime = '" + imeTbox.Text + "', prezime = '" + prezimeTbox.Text + "', telefonski_broj = '" + telBroj + "', adresa = '" + adresaTbox.Text + "', oib = '" + OIB + "', broj_racuna = '" + brojracunaTbox.Text + "', korisnicko_ime = '" + korimeTbox.Text + "', lozinka = '" + lozinkaTbox.Text + "', pozicija_idpozicija = " + idList[pozicijaCbox.SelectedIndex] + " where idzaposlenik = " + idZaposlenik + ";"; } NuoDbCommand command = new NuoDbCommand(sqlQuery, connection); command.ExecuteNonQuery(); MessageBox.Show("Uspješno izvršeno"); } catch (NuoDbSqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (connection != null) { connection.Close(); } } } }
internal static void DropTable(NuoDbConnection cnn, string tableName) { DbCommand dropCommand = new NuoDbCommand("drop table if exists " + tableName, cnn); dropCommand.ExecuteNonQuery(); }
internal static void CreateHockeyTable() { using (NuoDbConnection connection = new NuoDbConnection(connectionString)) { connection.Open(); try { DbCommand dropCommand = new NuoDbCommand("drop table hockey", connection); dropCommand.ExecuteNonQuery(); } catch (Exception) { // table is allowed to be missing } DbCommand createCommand = new NuoDbCommand("create table Hockey" + "(" + " Id bigint not NULL generated always as identity primary key," + " Number Integer," + " Name String," + " Position String," + " Team String" + ")", connection); createCommand.ExecuteNonQuery(); DbCommand insertCommand = new NuoDbCommand("Insert into Hockey (Number, Name, Position, Team) Values (?,?,?,?)", connection); insertCommand.Prepare(); insertCommand.Parameters[0].Value = 37; insertCommand.Parameters[1].Value = "PATRICE BERGERON"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 48; insertCommand.Parameters[1].Value = "CHRIS BOURQUE"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 11; insertCommand.Parameters[1].Value = "GREGORY CAMPBELL"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 18; insertCommand.Parameters[1].Value = "NATHAN HORTON"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 23; insertCommand.Parameters[1].Value = "CHRIS KELLY"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 46; insertCommand.Parameters[1].Value = "DAVID KREJCI"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 17; insertCommand.Parameters[1].Value = "MILAN LUCIC"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 64; insertCommand.Parameters[1].Value = "LANE MACDERMID"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 63; insertCommand.Parameters[1].Value = "BRAD MARCHAND"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 20; insertCommand.Parameters[1].Value = "DANIEL PAILLE"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 49; insertCommand.Parameters[1].Value = "RICH PEVERLEY"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 91; insertCommand.Parameters[1].Value = "MARC SAVARD"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 19; insertCommand.Parameters[1].Value = "TYLER SEGUIN"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 22; insertCommand.Parameters[1].Value = "SHAWN THORNTON"; insertCommand.Parameters[2].Value = "Forward"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 55; insertCommand.Parameters[1].Value = "JOHNNY BOYCHUK"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 33; insertCommand.Parameters[1].Value = "ZDENO CHARA"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 21; insertCommand.Parameters[1].Value = "ANDREW FERENCE"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 27; insertCommand.Parameters[1].Value = "DOUGIE HAMILTON"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 45; insertCommand.Parameters[1].Value = "AARON JOHNSON"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 54; insertCommand.Parameters[1].Value = "ADAM MCQUAID"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 44; insertCommand.Parameters[1].Value = "DENNIS SEIDENBERG"; insertCommand.Parameters[2].Value = "Defense"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 35; insertCommand.Parameters[1].Value = "ANTON KHUDOBIN"; insertCommand.Parameters[2].Value = "Goalie"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 40; insertCommand.Parameters[1].Value = "TUUKKA RASK"; insertCommand.Parameters[2].Value = "Goalie"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); insertCommand.Parameters[0].Value = 1; insertCommand.Parameters[1].Value = "MAX SUMMIT"; insertCommand.Parameters[2].Value = "Fan"; insertCommand.Parameters[3].Value = "Bruins"; insertCommand.ExecuteNonQuery(); } }