public void AddGame(string Aht, string note, string sol, string end)
{
string SQL_String =
"INSERT INTO Gold_Games_Table (Authors, Note, Solution, EndMessage)" +
"VALUES(@Aht, @note, @sol, @end)";
OleDbCommand comm = new OleDbCommand(SQL_String, conn);
OleDbParameter param1 = new OleDbParameter("@Aht", OleDbType.Char, 50);
param1.Value = Aht;
OleDbParameter param2 = new OleDbParameter("@note", OleDbType.Char, 50);
param2.Value = note;
OleDbParameter param3 = new OleDbParameter("@sol", OleDbType.Char, 360);
param3.Value = sol;
OleDbParameter param4 = new OleDbParameter("@end", OleDbType.Char, 50);
param4.Value = end;
comm.Parameters.Add(param1);
comm.Parameters.Add(param2);
comm.Parameters.Add(param3);
comm.Parameters.Add(param4);
conn.Open();
comm.Prepare();
int rows = comm.ExecuteNonQuery();
conn.Close();
}
public void AddSolution(string temp,
string name, decimal val)
{
string SQL_String =
"INSERT INTO Problems_Desposition_Table (Name, Desposition, Steps)" +
"VALUES( @name , @temp , @val)";
OleDbCommand comm = new OleDbCommand(SQL_String, conn);
OleDbParameter param1 = new OleDbParameter("@name", OleDbType.Char, 50);
param1.Value = name;
OleDbParameter param2 = new OleDbParameter("@temp", OleDbType.Char, 100);
param2.Value = temp;
OleDbParameter param3 = new OleDbParameter("@val", OleDbType.SmallInt, 0);
param3.Value = val;
comm.Parameters.Add(param1);
comm.Parameters.Add(param2);
comm.Parameters.Add(param3);
conn.Open();
comm.Prepare();
int rows = comm.ExecuteNonQuery();
conn.Close();
}
string SQL_String =
"INSERT INTO Gold_Games_Table (Authors, Note, Solution, EndMessage)" +
"VALUES (?, ?, ?, ?)";
OleDbCommand comm = new OleDbCommand(SQL_String, conn);
OleDbParameter param1 = new OleDbParameter("@Aht", OleDbType.Char, 50);
param1.Value = Aht;
OleDbParameter param2 = new OleDbParameter("@note", OleDbType.Char, 50);
param2.Value = note;
OleDbParameter param3 = new OleDbParameter("@sol", OleDbType.VarChar, 360);
param3.Value = sol;
OleDbParameter param4 = new OleDbParameter("@end", OleDbType.Char, 50);
param4.Value = end;
comm.Parameters.Add(param1);
comm.Parameters.Add(param2);
comm.Parameters.Add(param3);
comm.Parameters.Add(param4);
try
{
conn.Open();
comm.Prepare();
int rows = comm.ExecuteNonQuery();
}
finally { conn.Close(); }
}
finally { conn.Close(); }
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.