Connection with M S Excel using asp.net
Connection with M S Excel file (which is type (.xlsx)) (C#) asp.net
Connection :
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nitin\Desktop\db_sumit.xlsx;Extended Properties=Excel 12.0 Xml");
Select Query :
private void ConnectionExcel()
{
OleDbDataAdapter adp = new OleDbDataAdapter("Select * from [Sheet1$]", conn);
DataTable dt = new DataTable();
adp.Fill(dt);
GridView2.DataSource = dt;
GridView2.DataBind();
}
InsertQuery :
private void Insertwithaccess()
{
int IsCount = 0;
string cmdquery = "Insert into [Sheet1$] ([Name],[Salary],[Position])values('" + txtName.Text.Trim() + "','" + txtSalary.Text.Trim() + "')";
OleDbCommand objOleDbCommand = new OleDbCommand(cmdquery, conn);
conn.Open();
IsCount = objOleDbCommand.ExecuteNonQuery();
conn.Close();
if (IsCount > 0)
{
lblmessage.ForeColor = System.Drawing.Color.Green;
lblmessage.Text = "Data Inserted Successfully.";
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "Data Not Inserted.";
}
}
Connection :
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nitin\Desktop\db_sumit.xlsx;Extended Properties=Excel 12.0 Xml");
Select Query :
private void ConnectionExcel()
{
OleDbDataAdapter adp = new OleDbDataAdapter("Select * from [Sheet1$]", conn);
DataTable dt = new DataTable();
adp.Fill(dt);
GridView2.DataSource = dt;
GridView2.DataBind();
}
InsertQuery :
private void Insertwithaccess()
{
int IsCount = 0;
string cmdquery = "Insert into [Sheet1$] ([Name],[Salary],[Position])values('" + txtName.Text.Trim() + "','" + txtSalary.Text.Trim() + "')";
OleDbCommand objOleDbCommand = new OleDbCommand(cmdquery, conn);
conn.Open();
IsCount = objOleDbCommand.ExecuteNonQuery();
conn.Close();
if (IsCount > 0)
{
lblmessage.ForeColor = System.Drawing.Color.Green;
lblmessage.Text = "Data Inserted Successfully.";
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "Data Not Inserted.";
}
}
Comments
Post a Comment