Skip to main content

How to add new Column in excel File using oledb in .net

Here is the code :-


  OleDbConnection vConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\information.xls;Extended Properties=Excel 12.0");
            vConn.Open();
            try
            {
                String rQLlll = "DROP TABLE NewTempTable ;";
                OleDbCommand mdd = new OleDbCommand(rQLlll, vConn);
                mdd.ExecuteNonQuery();
            }
            catch
            {
            }
            String strSQL = "SELECT NULL as thuluuuuu,* INTO NewTempTable FROM [data$];";
            OleDbCommand cmd = new OleDbCommand(strSQL, vConn);
            cmd.ExecuteNonQuery();
            try
            {
                String strSQLl = "DROP TABLE [data$];";
                OleDbCommand cmdd = new OleDbCommand(strSQLl, vConn);
                cmdd.ExecuteNonQuery();

                String rSQLlll = "DROP TABLE data ;";
                OleDbCommand mddd = new OleDbCommand(rSQLlll, vConn);
                mddd.ExecuteNonQuery();

            }
            catch
            {

            }
            String strSQLll = "SELECT * INTO data FROM [NewTempTable$];";
            OleDbCommand cmddd = new OleDbCommand(strSQLll, vConn);
            cmddd.ExecuteNonQuery();

            try
            {
                String strSQLlll = "DROP TABLE [NewTempTable$] ;";
                OleDbCommand cmdddd = new OleDbCommand(strSQLlll, vConn);
                cmdddd.ExecuteNonQuery();

                String rQLlll = "DROP TABLE NewTempTable ;";
                OleDbCommand mdd = new OleDbCommand(rQLlll, vConn);
                mdd.ExecuteNonQuery();
            }
            catch
            {

            }
            MessageBox.Show("inserted");
            vConn.Close();

Comments

Popular posts from this blog

show image in asp.net form from database

In order to show image from database to webform first add an image control in webpage.   <asp:Image ID="imgStudentImage" runat="server" Height="157px" Width="160px" /> Then add new webform to read image from database for example displayimage.aspx and in code behind model write the following code. public string str = //your string     public SqlConnection conn;     public SqlCommand sql = new SqlCommand();     public SqlDataReader dr;     public string strSQL;     protected void Page_Load(object sender, EventArgs e)     {         conn = new SqlConnection(str);         conn.Open();         long id = Convert.ToInt64(Request.QueryString["mId"]);         strSQL = "";         strSQL = strSQL + " SELECT snap from S...

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {   ...

Snake Xenzia

Hello friends did you remember the GAME you play on nokia 1100 , SNAKE XENZIA .Yeah the same you are thinking ,a snake eating food and go longer and longer till it dies. Why to play it on mobile when it is available on your pc ??? It is made in .net framework 4.0 .Just install the setup and play SNAKE XENZIA . Have Fun !! DOWNLOAD IT   HERE  . Related articles Rattlesnake Dreams "Classsic Snake Game In C"? Resident Evil 6 gamescom demo takes in a giant snake battle Snakes & ladders