ASP NET cannot Save or Edit using Model
Question
-
Hy Friends, I have a problem with ASP.Net, Why I cannot save or edit this data? When I Click save or edit, it will show failed
public string kode_dosen, kode_jurusan, nama_dosen, telp, alamat;
SqlConnection myConnection = new SqlConnection();
string flag;
public DataSet ds = new DataSet();
public string insertData()
{
try
{
myConnection.ConnectionString = GlobalVariabel.connString;
myConnection.Open();
string query = "insert into Dosen values(@kode_dosen, @kode_jurusan, @nama_dosen, @telp, @alamat)";
SqlCommand com = new SqlCommand(query, myConnection);
com.Parameters.AddWithValue("@kode_dosen", kode_dosen);
com.Parameters.AddWithValue("@kode_jurusan", kode_jurusan);
com.Parameters.AddWithValue("@nama_dosen", nama_dosen);
com.Parameters.AddWithValue("@telp", telp);
com.Parameters.AddWithValue("@alamat", alamat);
int i = com.ExecuteNonQuery();
if (i > 0)
{
flag = "OK";
}
else
{
flag = "FAIL";
}
}
catch (Exception ex)
{
flag = ex.Message;
}
finally
{
if (myConnection.State == ConnectionState.Open)
{
myConnection.Close();
myConnection = null;
}
}
return flag;
}
Thanks For Your Help
