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.";
        }
    }

Comments

Popular posts from this blog

Tree view in winforms using c#

how to Replace null value with 0 Using C#

Change Visual Studio Code Explorer Size