ASP.NET

<br />
using System;<br />
using System.Collections;<br />
using System.Linq;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
using System.Xml.Linq;<br />
using System.Collections.Generic;<br />
using System.Data;<br />
using System.Configuration;<br />
<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.HtmlControls;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
<br />
using System.Data.SqlClient;<br />
<br />
/// <summary><br />
/// Summary description for WebService<br />
/// </summary><br />
[WebService(Namespace = "http://hello.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. <br />
[System.Web.Script.Services.ScriptService]<br />
public class WebService : System.Web.Services.WebService {<br />
<br />
    public WebService () {<br />
<br />
        //Uncomment the following line if using designed components <br />
        //InitializeComponent(); <br />
    }<br />
<br />
<br />
   <br />
<br />
 <br />
[WebMethod]<br />
    public  string[] GetCountry(string country)<br />
    {<br />
<br />
        string query = "SELECT COUNTRY FROM CUSTOMERS WHERE COUNTRY LIKE @Country";<br />
        using (SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\NORTHWND.MDF;Integrated Security=True;User Instance=True"))//"Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\NORTHWIND.MDF;Integrated Security=True;User Instance=True"))<br />
        {<br />
<br />
            SqlDataAdapter adapter = new SqlDataAdapter(query, conn);<br />
            adapter.SelectCommand.Parameters.Add("@Country", SqlDbType.VarChar,15).Value = country + "%";<br />
            DataTable dt = new DataTable();<br />
            adapter.Fill(dt);<br />
            string[] items = new string[dt.Rows.Count];<br />
            int i = 0;<br />
            foreach (DataRow dr in dt.Rows)<br />
            {<br />
                items.SetValue(dr["Country"].ToString(), i);<br />
<br />
                i++;<br />
            }<br />
            return items ;<br />
<br />
<br />
<br />
<br />
        }<br />
    }<br />

Error Message : An exception of type System.Runtime.InteropServices.COMException was raised and caught.<br />
Message: Retrieving the COM class factory for component with CLSID {D5DE8D20-5176-4EF2-8581-7B534D2AC56E} failed due to the following error: 80040154.