public bool Delete(submitClass c)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
string sql = "DELETE FROM Details WHERE StudentRollNo=@StudentRollNo";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@StudentRollNo", c.StudentRollNo);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(isSuccess);
}
public bool Update(submitClass c)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
string sql = "UPDATE Details SET Institute=@Institute, FirstName=@FirstName, LastName=@LastName, StudentRollNo=@StudentRollNo, DOB=@DOB, Contact=@Contact, EmailID=@EmailID, Address=@Address, Pincode=@Pincode, Landmark=@Landmark WHERE StudentRollNo=@StudentRollNo";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Institute", c.Institute);
cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
cmd.Parameters.AddWithValue("@LastName", c.LastName);
cmd.Parameters.AddWithValue("@StudentRollNo", c.StudentRollNo);
cmd.Parameters.AddWithValue("@DOB", c.DOB);
cmd.Parameters.AddWithValue("@Contact", c.Contact);
cmd.Parameters.AddWithValue("@EmailID", c.EmailID);
cmd.Parameters.AddWithValue("@Address", c.Address);
cmd.Parameters.AddWithValue("@Pincode", c.Pincode);
cmd.Parameters.AddWithValue("@Landmark", c.Landmark);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(isSuccess);
}
public bool Insert(submitClass c)
{
bool isSuccess = false;
SqlConnection con = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO Details(Institute, FirstName, LastName, StudentRollNo, DOB, Contact, EmailID, Address, Pincode, Landmark)VALUES(@Institute, @FirstName, @LastName, @StudentRollNo, @DOB, @Contact, @EmailID, @Address, @Pincode, @Landmark)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Institute", c.Institute);
cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
cmd.Parameters.AddWithValue("@LastName", c.LastName);
cmd.Parameters.AddWithValue("@StudentRollNo", c.StudentRollNo);
cmd.Parameters.AddWithValue("@DOB", c.DOB);
cmd.Parameters.AddWithValue("@Contact", c.Contact);
cmd.Parameters.AddWithValue("@EmailID", c.EmailID);
cmd.Parameters.AddWithValue("@Address", c.Address);
cmd.Parameters.AddWithValue("@Pincode", c.Pincode);
cmd.Parameters.AddWithValue("@Landmark", c.Landmark);
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(isSuccess);
}
