.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Transfer Data from and to MS-Access, SQL Server, and XML Data Sources

Posted By:Creative13       Posted Date: September 29, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

The Article shows the Transferring of data from one type of Data Source to another type of Data Source.
 

Introduction:

            Generally, Transferring Data From one Type of Data Source to another and vice-versa is required when an application may have to deal with different the data sources at a time.

            The article contains the simplest way to achieve the mentioned aim.

 

 

Requirements:

  •  Three DataGridView Controls to display data.
  • Six Command Buttons to Perform associated actions

 

 

Explanation:

  1. First we have to make some declaration as follows.

                       

#region "Declaration"

                      //For Sql COnnection

SqlConnection SqlCon = new SqlConnection("Integrated Security=True;Initial Catalog=SqlDB;Data Source=.\\SqlExpress");

                      SqlCommand SqlCmd;

 

                      //For OleDb Connection

OleDbConnection OleCon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;   Data Source=..\\..\\AccessDB.mdb;");

          OleDbCommand OleCmd;

 

        //For All DataSources

                    DataSet Dset = new DataSet();   //For XML DataSource

        DataSet Dset1 = new DataSet();  //For OleDb DataSource

        DataSet Dset2 = new DataSet();  //For SQL DataSource

                  DataRow row;

        #endregion

 


  1. After Declaration, Now we make a Procedure named LoadData () to initialize the data from different databases and to display it into respective DataGridView control.

 

    public void LoadData()

    {

           

            //Load the data from MS-Access file to the dataGridView1

  OleDbDataAdapter OleAdapt =

new OleDbDataAdapter("Select * from User_Info Order By   UserID", OleCon);

            OleAdapt.Fill(Dset1, "User_Info");

            dataGridView1.DataSource = Dset1.Tables["User_Info"];

 

 

            //Load the data from SQL file to the dataGridView2

            SqlDataAdapter SqlAdapt =

new SqlDataAdapter("Select * from User_Info Order By UserID", SqlCon);

            SqlAdapt.Fill(Dset2, "User_Info");

            dataGridView2.DataSource = Dset2.Tables["User_Info"];

 

//Load the data from XML file to the dataGridView3

            Dset.ReadXml("..\\..\\XMLData.xml");

            dataGridView3.DataSource = Dset.Tables["UserInfo"];

      

}

 

 

 

  1. Figure 1 shows the data into respective DataGridView at form load

 

Figure 1

 

Figure 2 : Transferring a selected row from MS-Access Data Source to XML Data Source

 


Figure 3 : Transferring a row from XML Data Source to SQL Server Data Source

 

 

    


Figure 4 : Transferring a row from SQL Server Data Source to MS-Access Data Source

 

 

 

 

 

 

  1. To copy a row, first select the row from source DataGridView and click the respective button.

§  Figure 2 shows copying data from MS-Access to XML Data Source

§  Figure 3 shows copying data from XML to SQL Server Data Source

§  Figure 4 shows copying data from SQL Server to MS-Access Data Source

 

  1. We can also do the other operations mentioned in the program similarly as shown in Figure 1/2/3.

 

 

 

Summary:

            In this article, we see the transferring of data from one data source to another in C# Programming. We can also perform other operations on mentioned title such as Moving, Deleting or Inserting the data of single record or may of bulk records also.


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend