con1.Open(); SqlCommand cmd = new SqlCommand("Select first from TransactionsInfo where name=@name and tid=@tid", con1); cmd.Parameters.AddWithValue("@name", txtName.Text); cmd.Parameters.AddWithValue("@tid", txtId.Text); SqlDataReader rdr = cmd.ExecuteReader(); if (!DBNull.Value.Equals(rdr["first"])) { MessageBox.Show("First payment already exists in database .", "Alert !", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //save }
//check for rows if (rdr.HasRows) { // for reading one row if (rdr.Read()) { if(dr1["first"] != DBNull.Value) { MessageBox.Show("First payment already exists in database .", "Alert !", MessageBoxButtons.OK, MessageBoxIcon.Error); }else { // dr1["first"] has DBNull } } }else { // no rows returned by the reader, show message.... }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)