ASP.NET

string connectionString1 = @"Data Source='local\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='MASTER'";
         
            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
            OleDbConnection con=new OleDbConnection(connectionString);
            using (OleDbCommand dcmd = new OleDbCommand("SELECT Fname FROM [Sheet1$]",con))
                {
                    try
                    {
                        con.Open();

                        using (OleDbDataReader dreader = dcmd.ExecuteReader())
                        {
                            DataRow myNewRow;
                            DataRow[] drcol ;
                            DataTable dt = new DataTable();
                            dt.Columns.Add("Fname");
                            dt.Columns.Add("Lname");
                            myNewRow=dt.NewRow();
                        
                             while (dreader.Read())
                             {
                                 myNewRow[0] = dreader.GetValue(0).ToString();
                                 myNewRow[1] = "Test123";
                                 dt.Rows.Add(myNewRow);
                                 
                             }
                            drcol = dt.Select();
                            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString1))
                            {
                                bulkCopy.ColumnMappings.Add("Fname", "FirstName");
                                bulkCopy.ColumnMappings.Add("Lname", "LastName");
                                bulkCopy.DestinationTableName = "T_EmpDetail";
                                bulkCopy.BatchSize = 500;
                                bulkCopy.WriteToServer(drcol);
                                
                            }

                        }
                    }
                    finally
                    {
                        con.Close();
                    }
                }

KKK MCA wrote:

is there is any CMS(content management system) tool for this.

KKK MCA wrote:

In this web page there is some text and image(passport size photo), the client need to change the text content and also move the image from left to right, vice versa...

KKK MCA wrote:

Pls give some url's for Atalasoft Imaging editing tool.