private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = null;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
try
{
string Name = row.Cells[1].Value.ToString();
string DOB = row.Cells[2].Value.ToString();
string GradePointAvg = row.Cells[3].Value.ToString();
string Active = row.Cells[4].Value.ToString();
if (Active.Equals("false"))
{
Dbconnection dbconnect = new Dbconnection();
dbconnect.Registration(Name, DOB, GradePointAvg, Active);
MessageBox.Show("inserted sussfully");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
private void savedata_Click(object sender, EventArgs e)
{
db = new Dbconnection();
if (txtname.TextLength == 0 || txtpassword.TextLength == 0 || txtid.TextLength == 0)
{
MessageBox.Show("null values ara not allowd");
}
else
{
try
{
SqlCommand cmd = new SqlCommand("insert into login values('" + txtname.Text + "','" + txtpassword.Text + "'," + txtid.Text + ")", db.con);
db.con.Open();
//String name = Convert.ToString(cmd.ExecuteScalar());
cmd.ExecuteNonQuery();
MessageBox.Show("inserted");
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
finally
{
db.con.Close();
}
}
}
public void loadtable()
{
Dbconnection dbconnect = new Dbconnection();
tablegrid = dbconnect.getAllStudents();
if (tablegrid != null)
{
dataGridView1.DataSource = tablegrid.DefaultView;
}
}
public void insertdata()
{
db = new Dbconnection();
SqlCommand cmd = new SqlCommand("insert into login values('" + name + "','" + password + "'," + id + ")", db.con);
db.con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("inserted");
}
private void update_Click(object sender, EventArgs e)
{
db = new Dbconnection();
SqlCommand cmd = new SqlCommand("update login set userName='******',password='******' where userid = '" + txtid.Text + "' ", db.con);
db.con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("updated");
db.con.Close();
}
private void btndelete_Click(object sender, EventArgs e)
{
db = new Dbconnection();
SqlCommand cmd = new SqlCommand("delete from login where userid = '" + txtid.Text + "' ", db.con);
db.con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("deleted");
db.con.Close();
}
private void btnSearch_Click(object sender, EventArgs e)
{
db = new Dbconnection();
SqlDataAdapter adp = new SqlDataAdapter("select * from login where userid = '" + txtid.Text + "' ", db.con);
db.con.Open();
DataTable dt = new DataTable();
adp.Fill(dt);
dataGridView1.DataSource = dt;
db.con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
db = new Dbconnection();
SqlDataAdapter adp = new SqlDataAdapter("select * from login", db.con);
db.con.Open();
DataTable dt = new DataTable();
adp.Fill(dt);
dataGridView1.DataSource = dt;
db.con.Close();
}