public bool UpdateData()
{
myChatLineData data=new myChatLineData();
List<SqlParameter> tempAL = new List<SqlParameter>();
SqlParameter tempP;
tempP = new SqlParameter();
tempP.ParameterName = "@ChatLineID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myChatLineID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@UserID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myUserID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@GameRoomID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myGameRoomID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@ChatLineContent";
tempP.Size = 1200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myChatLineContent;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@TimePosted";
tempP.Size = 12;
tempP.SqlDbType = SqlDbType.DateTime;
tempP.Value = myTimePosted;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
data.RunProcedure("csp_UpdateChatLine", tempAL);
return true;
}
public bool InsertData()
{
myChatLineData data=new myChatLineData();
List<SqlParameter> tempAL = new List<SqlParameter>();
SqlParameter tempP;DataSet tempDS;
tempP = new SqlParameter();
tempP.ParameterName = "@UserID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myUserID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@GameRoomID";
tempP.Size = 4;
tempP.SqlDbType = SqlDbType.Int;
tempP.Value = myGameRoomID;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@ChatLineContent";
tempP.Size = 1200;
tempP.SqlDbType = SqlDbType.VarChar;
tempP.Value = myChatLineContent;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempP = new SqlParameter();
tempP.ParameterName = "@TimePosted";
tempP.Size = 12;
tempP.SqlDbType = SqlDbType.DateTime;
tempP.Value = myTimePosted;
tempP.Direction = ParameterDirection.Input;
tempAL.Add(tempP);
tempDS = data.RunProcedure("csp_InsertChatLine", tempAL);
myChatLineID= int.Parse(tempDS.Tables[0].Rows[0][0].ToString());
tempDS.Dispose(); return true;
}
