using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.IO;
using System.Web.Services;
using System.Collections.Generic;

public partial class AutoCom : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
    public string[] GetCompletionList(string prefixText, int count, string contextKey)
    {

        OleDbConnection con;
        OleDbCommand cmd;
        List<string> items = new List<string>(count);
        DataSet ds = new DataSet();
        string cmdstr = "select Moderia_Name from Moderia where Moderia_Name LIKE '"+prefixText+ "%'";
        //con = new OleDbConnection(@"Provider=Microsoft.jet.oledb.4.0;Data Source=.\\App_Data\\ResSchools.mdb");
        con = new OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=" + Server.MapPath(".\\App_Data\\ResSchools.mdb") + "");
        cmd = new OleDbCommand(cmdstr, con);
       // cmd.Parameters.AddWithValue("@SearchText", prefixText);
        con.Open();
       OleDbDataAdapter adapter =new OleDbDataAdapter();
        adapter.SelectCommand=new OleDbCommand(cmdstr ,con);
        adapter.Fill(ds);
    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        items.Add(dr["Moderia_Name"].ToString());
    }
    return items.ToArray();
    con.Close();
        //OleDbDataReader myreader;
        //List<string> redata = new List<string>(count);
        //myreader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        //while (myreader.Read())
        //{
        //    redata.Add(myreader["Moderia_Name"].ToString());
            
        //}
        //return redata.ToArray();
        //[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
        //public string[] GetCompletionList(string prefixText, int count, string contextKey)
        //{
        //    count = 10;
        //    string querystring;
        //    OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=" + Server.MapPath(".\\App_Data\\ResSchools.mdb") + "");
        //    querystring = "select School_Name from Schools where School_Name like @prefixText";
        //    OleDbDataAdapter da = new OleDbDataAdapter(querystring, aConnection);
        //    da.SelectCommand.Parameters.Add("@prefixtext", OleDbType.VarChar, 50).Value = prefixText + "%";
        //    DataTable dt = new DataTable();
        //    da.Fill(dt);
        //    string[] items = new string[dt.Rows.Count];
        //    int i = 0;
        //    foreach (DataRow dr in dt.Rows)
        //    {
        //        items.SetValue(dr["Moderia_Name"].ToString(), i);
        //        i++;
        //    }
        //    return items;
        //}
    }
}