synchronization of two database in asp.net

 protected void btnCheck_Click(object sender, EventArgs e)
        {
            WebClient client = new WebClient();
            byte[] datasize = null;
            try
            {
                datasize = client.DownloadData("http://www.google.com");
            }
            catch (Exception ex)
            {
            }
            if (datasize != null && datasize.Length > 0)
            {
                var List = DB.tbl_Contact.Where(p => p.IsOnline == false).ToList();
                foreach (Database.tbl_Contact item1 in List)
                {
                    var objtbl_Contact = DB.tbl_Contact.SingleOrDefault(p => p.ID == item1.ID);
                    objtbl_Contact.IsOnline = true;
                    DB.SaveChanges();
                }
                foreach (Database.tbl_Contact item in List)
                {
                    OnlineDB.tbl_Contact objtbl_Contact = new OnlineDB.tbl_Contact();
                    objtbl_Contact.Name = item.Name;
                    objtbl_Contact.Address = item.Address;
                    objtbl_Contact.Description = item.Description;
                    objtbl_Contact.EmailID = item.EmailID;
                    objtbl_Contact.MobileNo = item.MobileNo;
                    objtbl_Contact.City = item.City;
                    objtbl_Contact.State = item.State;
                    objtbl_Contact.CompanyName = item.CompanyName;
                    objtbl_Contact.WebSite = item.WebSite;
                    //if (Image.HasFile)
                    //{
                    //    Image.SaveAs(Server.MapPath("../Gallery/") + Image.FileName);
                    //    objtbl_Contact.Avtar = Image.FileName;
                    //}
                    objtbl_Contact.Remainder = DateTime.Now;
                    objtbl_Contact.IsOnline = true;

                    objtbl_Contact.Deleted = true;
                    objtbl_Contact.DateTime = DateTime.Now;
                    objtbl_Contact.CreatedBy = 1;
                    DB1.tbl_Contact.AddObject(objtbl_Contact);

                    DB1.SaveChanges();
                    lbltxt.ForeColor = System.Drawing.Color.Green;
                    lbltxt.Text = List.Count() + " Records Uploaded Successfully !!";
                    //ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "MyScript", "alert('Uploaded Successfully !!');", true);
                }
            }
            else
            {
                lbltxt.ForeColor = System.Drawing.Color.Red;
                lbltxt.Text = "Internet Connection Not Available.";
            }
        }

Read or Write Connection Strings in Web.Config file using ASP.Net using C#

In this article I will explain with an example, how to read or write Connection Strings in Web.Config file using ASP.Net using C# and VB.Net.

The Connection String will be read and written from the Connection String from the ConnectionStrings section of the Web.Config.

 

 

Adding ConnectionString to the Web.Config file

You need to add the Connection String in the ConnectionStrings section of the Web.Config file in the following way.

<configuration>

    <connectionStrings>

        <add name="ConString" connectionString="Data Source=AyoSoftech-PC\SQL2012;Initial Catalog=Northwind;Integrated Security=true" />

    </connectionStrings>

</configuration>

 

 

Adding System.Configuration reference

The very first thing you need to do is to add reference of the System.Configuration Assembly to the project in the following way.

1. Right click on the project and click Add Reference option from the Context Menu.

 

2. From the Add Reference dialog box, click on .Net Tab and look for System.Configuration assembly. Once you find it simply select and click OK.

 

3. Once the reference is added, it will be shown in the References folder of the Solution Explorer.

 

 

Namespaces

You will need to import the following namespace.

C#

using System.Configuration;

 

 

Reading ConnectionString from Web.Config file in ASP.Net using C# and VB.Net

Once the reference is added, you can read the Connection String value from the Web.Config file in the following way.

C#

string connectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;