private void button1_Click(object sender, EventArgs e)
{
Dbconnection db = new Dbconnection();
db.Connection();
if (txt_UserName.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
try
{
//Create SqlConnection
SqlCommand cmd = new SqlCommand("Select * from admin_master where username=@username and password=@password", db.con);
cmd.Parameters.AddWithValue("@username", txt_UserName.Text);
cmd.Parameters.AddWithValue("@password", txt_Password.Text);
db.con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
db.con.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, than show frmMain form
if (count == 1)
{
string id = ds.Tables[0].Rows[0]["aid"].ToString();
MessageBox.Show("Login Successful!");
this.Hide();
MDIParent1 m = new MDIParent1();
m.Show();
}
else
{
MessageBox.Show("Login Failed!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
Dbconnection db = new Dbconnection();
db.Connection();
using (SqlCommand cmdf = new SqlCommand("truncate table dataset", db.con))
{
db.con.Open();
cmdf.ExecuteNonQuery();
db.con.Close();
}
progressBar1.Visible = true;
progressBar1.ForeColor = Color.Red;
string pathconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "';Extended Properties=\"Excel 12.0 Xml;HDR=NO;IMEX=1;\"";
OleDbConnection conn = new OleDbConnection(pathconn);
conn.Open();
OleDbDataAdapter dataadp = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataTable ds = new DataTable();
conn.Close();
dataadp.Fill(ds);
dataGridView1.DataSource = ds;
progressBar1.Minimum = 0;
progressBar1.Maximum = dataGridView1.Rows.Count - 1;
SqlBulkCopy objbulk = new SqlBulkCopy(db.con);
//assigning Destination table name
objbulk.DestinationTableName = "dataset";
//Mapping Table column
objbulk.ColumnMappings.Add("f2", "Test1");
objbulk.ColumnMappings.Add("f3", "Test2");
objbulk.ColumnMappings.Add("f4", "Test3");
objbulk.ColumnMappings.Add("f5", "Test4");
objbulk.ColumnMappings.Add("f6", "result");
//inserting Datatable Records to DataBase
db.con.Open();
objbulk.WriteToServer(ds);
db.con.Close();
}
