public static void StoreGrid(ICAUploadDAO result)
{
string queryString = "INSERT INTO Result (ModuleGrp, PEM, AdmNo, Name, ICA1, ICA2, ICA3, ICA4, ModuleCode) values ('" + @result.ModuleGrp + "','" + @result.PEM + "','" + @result.AdmNo + "','" + @result.Name + "','" + @result.ICA1 + "','" + @result.ICA2 + "','" + @result.ICA3 + "','" + @result.ICA4 + "','" + @result.ModuleCode + "')";
string connectionString = Properties.Settings.Default.DBConnection;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
command.ExecuteNonQuery();
}
}
在插入数据之前,我想检查行是否已经存在,如果已经存在,则更新它。如果有人能够帮助我解决这个问题,我将非常感激,因为我不知道如何处理它。非常感谢。