private void button2_Click(object sender, EventArgs e) { string db, sql1; db = "\\chess.mdb"; sql1 = (" SELECT TOP 5 * FROM winerstowplayers order by mintetime ;"); dataGridView2.DataSource = Dbase.SelectFromTable(sql1, db); }
private void exitToolStripMenuItem_Click(object sender, EventArgs e) { timer1.Stop(); timer2.Stop(); string sql1, sql2, sql3, inser1, inser2, inser3, stmatcom, wt, db, winername; int x1, x2, x3, resulttime; Form1 f1 = new Form1(); stmatcom = f1.convertmat(mat); db = "\\chess.mdb"; sql1 = "select max (id_user) from users"; x1 = idselect.selectid(sql1, db); sql2 = "select max (a) from hhh"; x2 = idselect.selectid(sql2, db); inser1 = "INSERT INTO users(id_user,fname,lname,id_game,colorGame,Date_Game,id_gmaecomputer) VALUES (" + x1 + ",'" + fname + "','" + lname + "'," + 0 + "," + colorplay + ",'" + date + "'," + x2 + ")"; Dbase.ChangeTable(inser1, db); inser2 = "insert into hhh(a,b,c,d,e,f,g,h,i,j)values (" + x2 + "," + x1 + ",'" + level + "','" + stmatcom + "','" + label2.Text + "','" + label1.Text + "'," + x2 + ",'" + label5.Text + "','" + lossw + "','" + lossb + "')"; Dbase.SelectFromTable(inser2, db); if (savegame == false) { if (winer == 1) { wt = label2.Text; } else { wt = label1.Text; } resulttime = f1.cnvrtnum(wt); if (winer == 3) { winername = "draw"; } else { if (winer == colorplay) { winername = fname; } else { winername = "Computer"; } } sql3 = "select max (id_winercomputer) from winerstocomputer"; x3 = idselect.selectid(sql3, db); inser3 = "INSERT INTO winerstocomputer(id_winercomputer,id_user,fname,time_winer,id_gmaecomputer,result,minttime) VALUES ('" + x3 + "','" + x1 + "','" + fname + "','" + wt + "','" + x2 + "','" + winername + "','" + resulttime + "')"; Dbase.ChangeTable(inser3, db); } }
public static int selectid(string sql, string db) { int x1; try { x1 = int.Parse(Dbase.SelectFromTable(sql, db).Rows[0][0].ToString()); x1 = x1 + 1; } catch (Exception) { x1 = 0; } return(x1); }
// פונקציה הזות הופכת מערך דו מימדי למחרוזת private void button5_Click(object sender, EventArgs e) { string wt; if (winer == 1) { wt = label9.Text; } else { wt = label7.Text; } string str = "\\chess.accdb"; string sql = "INSERT INTO winerstowplayers(id_winertowplayers,id_user,fname,time_winer,id_gametowplayers,result) VALUES ('" + 12 + "','" + 51 + "','" + fname + "','" + wt + "','" + 2 + "','" + result + "')"; Dbase.ChangeTable(sql, str); }
private void button1_Click(object sender, EventArgs e) { string db = "\\chess.mdb"; string sql = ("Select * from users" + " where fname ='" + textBox1.Text + "';"); dataGridView1.DataSource = Dbase.SelectFromTable(sql, db); if (radioButton1.Checked == true) { playwithcomputer = true; } else if (radioButton2.Checked == true) { playwithcomputer = false; } else { MessageBox.Show("chosse kind of game"); } }
private void exitToolStripMenuItem_Click(object sender, EventArgs e) { timer1.Stop(); timer2.Stop(); int x1, x2, x3, x4, resutmin; string db, sql1, sql2, sql3, inser1, inser2, inser3, stmat, wt, winername; stmat = convertmat(mat); db = "\\chess.mdb"; sql1 = "select max (id_user) from users"; try { x1 = int.Parse(Dbase.SelectFromTable(sql1, db).Rows[0][0].ToString()); x1 = x1 + 1; } catch (Exception) { x1 = 0; } sql2 = "select max (id_gametowply) from gamepp"; try { x2 = int.Parse(Dbase.SelectFromTable(sql2, db).Rows[0][0].ToString()); x2 = x2 + 1; } catch (Exception) { x2 = 0; } inser1 = "INSERT INTO users(id_user,fname,lname,id_game,colorGame,Date_Game,id_gmaecomputer) VALUES (" + x1 + ",'" + fname + "','" + lname + "'," + x2 + "," + colorplay + ",'" + date + "'," + 0 + ")"; Dbase.SelectFromTable(inser1, db); x4 = idselect.selectid(sql1, db); inser2 = "insert into gamepp(id_gametowply,id_user1,matofGame,time_white,time_black,history_of_steps,id_user2,Chess_piecesw,Chess_piecesb)values ('" + x2 + "','" + x1 + "','" + stmat + "','" + label7.Text + "','" + label9.Text + "','" + label5.Text + "','" + 0 + "','" + lossw + "','" + lossb + "')"; Dbase.ChangeTable(inser2, db); if (savegame == false) { sql3 = "select max (id_winertowplayers) from winerstowplayers"; try { x3 = int.Parse(Dbase.SelectFromTable(sql3, db).Rows[0][0].ToString()); x3 = x3 + 1; } catch (Exception) { x3 = 0; } if (winer == 1) { wt = label9.Text; } else { wt = label7.Text; } resutmin = cnvrtnum(wt); if (winer == 3) { winername = "draw"; } else { if (winer == colorplay) { winername = fname; } else { winername = "No" + fname; } } inser3 = "INSERT INTO winerstowplayers(id_winertowplayers,id_user,fname,time_winer,id_gametowplayers,result,mintetime) VALUES ('" + x3 + "','" + x1 + "','" + fname + "','" + wt + "','" + x2 + "','" + winername + "','" + resutmin + "')"; Dbase.ChangeTable(inser3, db); } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { int i = e.RowIndex; int id; string db = "\\chess.mdb"; DataGridViewRow roww = dataGridView1.Rows[i]; colorplay = int.Parse(roww.Cells[4].Value.ToString()); if (playwithcomputer == false) { id = int.Parse(roww.Cells[3].Value.ToString()); } else { id = int.Parse(roww.Cells[6].Value.ToString()); } //label2.Text = id.ToString(); if (playwithcomputer == false) { string sql1 = ("Select * from gamepp" + " where id_gametowply =" + id + ";"); getmat = Dbase.SelectFromTable(sql1, db).Rows[0][2].ToString(); replaymat(getmat); timew = Dbase.SelectFromTable(sql1, db).Rows[0][3].ToString(); timw = timew; timeb = Dbase.SelectFromTable(sql1, db).Rows[0][4].ToString(); timb = timeb; gsteps = Dbase.SelectFromTable(sql1, db).Rows[0][5].ToString(); step2p = gsteps; pacisew = Dbase.SelectFromTable(sql1, db).Rows[0][7].ToString(); setpacess(pacisew, -1); pacieb = Dbase.SelectFromTable(sql1, db).Rows[0][8].ToString(); setpacess(pacieb, 1); putmat.pushmat = reeemat; putmat.check = 1; putmat.pushpace = pac; putmat.checkpace = 1; // label7.Text = ""; // for(int y=0;y<putmat.pushpace.Length;y++) // label7.Text+= putmat.pushpace[y].ToString(); Form1 f1 = new Form1(); f1.Show(); this.Hide(); } else { string sql2 = ("Select * from hhh" + " where a =" + id + ";"); level = Dbase.SelectFromTable(sql2, db).Rows[0][2].ToString(); getmat = Dbase.SelectFromTable(sql2, db).Rows[0][3].ToString(); replaymat(getmat); timew = Dbase.SelectFromTable(sql2, db).Rows[0][4].ToString(); timw = timew; timeb = Dbase.SelectFromTable(sql2, db).Rows[0][5].ToString(); timb = timeb; gsteps = Dbase.SelectFromTable(sql2, db).Rows[0][7].ToString(); step1p = gsteps; pacisew = Dbase.SelectFromTable(sql2, db).Rows[0][8].ToString(); setpacess(pacisew, -1); pacieb = Dbase.SelectFromTable(sql2, db).Rows[0][9].ToString(); setpacess(pacieb, 1); putmat.pushmat = reeemat; putmat.pushpace = pac; putmat.checkpace = 2; if (level == "diffuclt") { putmat.check = 3; Form2 f2 = new Form2(); f2.Show(); this.Hide(); } else { putmat.check = 2; Form8 f8 = new Form8(); f8.Show(); this.Hide(); } } int[,] gg = new int[2, 16]; }