Real Life Example for 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 [ Sheet...

Connection with M S Access file (which is type (.accdb)) (C#) asp.net 1. Add namespace. Ans: using System.Data.OleDb; ------ end 2. add Connection. Ans: private void Connection()     {         OleDbConnection con = new OleDbConnection ( @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source = C:\Users\nitin\Desktop\db_testing.accdb;" );         OleDbDataAdapter adp = new OleDbDataAdapter ( "Select*from table1" , con);         DataTable dt = new DataTable ();         adp.Fill(dt);         GridView1.DataSource = dt;         GridView1.DataBind();     } ------ end   Inserting :     private void Insertwithaccess()     {         int IsCount = 0;   ...

How to "Change column name" in Sql server 2008 Ans : 1.  sp_rename 'Tbl_Enquiry.[old_column_name]','New_column_name'  (select this line and run (f5)) 2. sp_RENAME 'Table_First . Name', ' NameChange ' , 'COLUMN'.

  How To Get IP Address (c#) using asp.net _______________________________ start _______________________________               string address = string .Empty;         address = Dns .GetHostName();         IPAddress [] localip = Dns .GetHostAddresses( Dns .GetHostName());         foreach ( IPAddress hostIP in localip)         {             address = hostIP.ToString();         } _______________________________ end _______________________________  result : address : XXX.XXX.X.XX