protected void btn_insertM_Click(object sender, EventArgs e) { if (tb_Mname.Text.TrimStart().TrimEnd() == "") { lb_msgM.Text = "You are required to fill Material textbox"; } else { con.Open(); cmd.CommandText = "SELECT * FROM Materials WHERE MName=@MName"; cmd.Parameters.AddWithValue("@MName", tb_Mname.Text); reader = cmd.ExecuteReader(); if (reader.Read()) { reader.Close(); lb_msg.Text = "Sorry bro material name already exists!"; } else { reader.Close(); cmd.CommandText = "INSERT INTO Materials (MName,LID,notes) VALUES (@MName3,@LID,@notes3)"; cmd.Parameters.AddWithValue("@MName3", tb_Mname.Text); cmd.Parameters.AddWithValue("@LID", ddl_Lec.SelectedValue); cmd.Parameters.AddWithValue("@notes3", tb_MNotes.Text); cmd.ExecuteNonQuery(); lb_msgM.Text = "The name of the Material is now added to database"; GridView_Materials.DataBind(); } con.Close(); } }
protected void btn_insertM_Click(object sender, EventArgs e) { if (tb_Mname.Text.TrimStart().TrimEnd() == "") { lb_msgM.Text = "Please enter Material information in the field!"; } else { con.Open(); cmd.CommandText = "SELECT Id FROM Materials WHERE MName=@MName"; cmd.Parameters.AddWithValue("@MName", tb_Mname.Text); reader = cmd.ExecuteReader(); if (reader.Read()) { reader.Close(); lb_msgM.Text = " The material you are trying to add has already been added, " + "please add new materials!"; } else { reader.Close(); cmd.CommandText = "INSERT INTO Materials (MName,LID,Notes) VALUES (@MNameP,@LID,@MnotesP)"; cmd.Parameters.AddWithValue("@MNameP", tb_Mname.Text); cmd.Parameters.AddWithValue("@LID", ddl_Lec.SelectedValue); cmd.Parameters.AddWithValue("@MNotesP", tb_MNotes.Text); cmd.ExecuteNonQuery(); lb_msgM.Text = "Material Content added Successfully"; GridView_Materials.DataBind(); } con.Close(); } }