C#

Member 6966224 wrote:

including posting the issue to the MS forums hoping MS can help as well

Member 6966224 wrote:

using a query tool

dalila y wrote:

Can anyone tell me how can i retrieve my MS Access database on a webpage by using web service? i need to do this using asp.net in c# language.

I are Troll

dataGridView1.DataSource = ds.Tables[0];//or ds.Tables["YourTableNameHere"];

private void btn1_Click(object sender, EventArgs null){
     dataGridView1.DataSource = MyLogic.MemberBL.GetDataSet().Tables[0];
     //where the GetDataSet() returns the ds from the BussinessLayer;
}

using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
<br />
namespace Library_Project<br />
{<br />
    class memberBL<br />
    {<br />
                    //Book properties<br />
            private String membercode;<br />
            private String name;<br />
            private String family;<br />
            private String shsh;<br />
            private String melicode;<br />
            private String tavalod;<br />
            private String shoghl;<br />
            private String tel;<br />
            private String mobile;<br />
            private String adr;<br />
            private String trkhozv;<br />
<br />
            private memberDA memberData;<br />
<br />
       // BUSINESS LOGIC Member <br />
       public memberBL()            <br />
       {<br />
         <br />
           //Data access layer!<br />
     <br />
           memberData = new memberDA();<br />
<br />
       }<br />
       /// <SUMMARY><br />
       /// Property BookCode (String)<br />
       /// </SUMMARY><br />
       public String DatasetData<br />
       {<br />
           get<br />
           {<br />
               return this.DatasetData;<br />
           }<br />
           set<br />
           {<br />
               this.DatasetData = value;<br />
<br />
<br />
           }<br />
       }<br />
       /// <SUMMARY><br />
       /// Property BookCode (String)<br />
       /// </SUMMARY><br />
       public String Membercode<br />
       {<br />
           get<br />
           {<br />
               return this.membercode;<br />
           }<br />
           set<br />
           {<br />
               this.membercode = value;<br />
<br />
<br />
           }<br />
       }<br />
 <br />
            /// <SUMMARY><br />
            /// Property BooktName (String)<br />
            /// </SUMMARY><br />
            public String Name <br />
            {<br />
      <br />
                  get<br />
                  {<br />
                      return this.name;<br />
                  }<br />
                  set<br />
                  {<br />
                        try<br />
                        {<br />
                            this.name = value;<br />
<br />
                            if (this.name == "")<br />
                              {<br />
                                    throw new Exception(<br />
                                      "لطفا نام عضو را وارد نمایید");<br />
                              }<br />
                        }<br />
                        catch(Exception e)<br />
                        {<br />
                              throw new Exception(e.Message.ToString());<br />
                        }<br />
                  }<br />
            }<br />
 <br />
            /// <SUMMARY><br />
            /// Property ISBN (String)<br />
            /// </SUMMARY><br />
            public String Familly<br />
            {<br />
                  get<br />
                  {<br />
                        return this.family;<br />
                  }<br />
                  set<br />
                  {<br />
                        //could be more checkings here eg revmove ' chars<br />
                        //change to proper case<br />
                        //blah blah<br />
                        this.family = value;<br />
                        if (this.family == "")<br />
                        {<br />
                              throw new Exception("لطفا نام خانوادگی عضو رو وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
<br />
            /// <SUMMARY><br />
            /// Property Nasher (String)<br />
            /// </SUMMARY><br />
            public String Shsh<br />
            {<br />
                  get<br />
                  {<br />
                      return this.shsh;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.shsh = value;<br />
<br />
                      if (this.shsh == "")<br />
                        {<br />
                              throw new Exception("لطفا شماره شناسنامه را وارد نمایید");<br />
                        }<br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property ISBN (String)<br />
            /// </SUMMARY><br />
            public String Melicode<br />
            {<br />
                  get<br />
                  {<br />
                        return this.melicode;<br />
                  }<br />
                  set<br />
                  {<br />
                        //could be more checkings here eg revmove ' chars<br />
                        //change to proper case<br />
                        //blah blah<br />
                        this.melicode = value;<br />
                        if (this.melicode == "")<br />
                        {<br />
                              throw new Exception("لطفا کد ملی عضو رو وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Nasher (String)<br />
            /// </SUMMARY><br />
            public String Tavalod<br />
            {<br />
                  get<br />
                  {<br />
                      return this.tavalod;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.tavalod = value;<br />
<br />
                      if (this.tavalod == "")<br />
                        {<br />
                              throw new Exception("لطفا تاریخ تولد رو وارد نمایید");<br />
                        }<br />
                  }<br />
            }<br />
<br />
 <br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Shoghl<br />
            {<br />
                  get<br />
                  {<br />
                      return this.shoghl;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.shoghl = value;<br />
                      if (this.shoghl == "")<br />
                        {<br />
                              throw new Exception("لطفا شغل رو انتخاب کنید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Tel<br />
            {<br />
                  get<br />
                  {<br />
                      return this.tel;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.tel = value;<br />
                      if (this.tel == "")<br />
                        {<br />
                            throw new Exception("لطفا شماره  تلفن را وارد نمایید ");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Mobile<br />
            {<br />
                  get<br />
                  {<br />
                      return this.mobile;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.mobile = value;<br />
                      if (this.mobile == "")<br />
                        {<br />
                            throw new Exception("لطفا شماره موبایل را وارد نمایید ");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Adr<br />
            {<br />
                  get<br />
                  {<br />
                      return this.adr;<br />
                  }<br />
                  set<br />
                  {<br />
                      this.adr = value;<br />
                      if (this.adr == "")<br />
                        {<br />
                            throw new Exception("لطفا آدرس را وارد نمایید");<br />
                        }<br />
 <br />
                  }<br />
            }<br />
            /// <SUMMARY><br />
            /// Property Mozoe Ketab (String)<br />
            /// </SUMMARY><br />
            public String Trkhozv<br />
            {<br />
                get<br />
                {<br />
                    return this.trkhozv;<br />
                }<br />
                set<br />
                {<br />
                    this.trkhozv = value;<br />
<br />
<br />
                }<br />
            }<br />
            /// <SUMMARY><br />
            /// Function Add new customer. Calls <br />
            /// the function in Data layer.<br />
            /// </SUMMARY><br />
            public void Add()<br />
            {<br />
                  memberData.Add(this);<br />
            }<br />
 <br />
 <br />
            /// <SUMMARY><br />
            /// Function Update customer details. <br />
            /// Calls the function in Data layer.<br />
            /// </SUMMARY><br />
            public void Update()<br />
            {<br />
                memberData.Update(this);<br />
            }<br />
<br />
            /// <SUMMARY><br />
            /// Function View Member details. <br />
            /// Calls the function in Data layer.<br />
            /// </SUMMARY><br />
         <br />
    }<br />
}

using System;
using System.Data.OleDb;
using System.Data;
using System.Text;

namespace Library_Project
{
    class memberDA
    {
        private OleDbConnection cnn;
        //change connection string as per the 
        //folder you unzip the files
        private const string CnnStr = 
          "Provider=Microsoft.Jet.OLEDB.4.0;Data " +
          "Source= D:\\Data\\Library.mdb;"; 
            
        //local variables
        private String strTable="";
        private String strFields="";
        private String strValues="";
        private String insertStr="";
        
        //this needs to be changed based on Books 
        //table fields' Name of the database!
        private const String thisTable = "tblmembers";
        private const String member_code = "membercode";
        private const String member_name = "name";
        private const String member_family = "family";
        private const String member_shsh = "shsh";
        private const String member_melicode = "melicode";
        private const String member_tavalod = "tavalod";
        private const String member_shoghl = "shoghl";
        private const String member_tel = "tel";
        private const String member_mobile = "mobile";
        private const String member_adr = "adr";
        private const String member_trkhozv = "trkhozv";
        private memberBL memberLogic;

        public memberDA()
        {
           
        }

        public memberDA(memberBL member)
       
        {
            // A reference of the business object class
            memberLogic = new memberBL();
        }
        
        //standard dataset function that adds a new customer

        public void Add(memberBL member)
        {

            String str = BuildAddString(member);
            
            OpenCnn();

            //Open command option - cnn parameter is imporant
            OleDbCommand cmd = new OleDbCommand(str,cnn);


            //execute connection
            cmd.ExecuteNonQuery();
            
            // close connection
            CloseCnn();
            
        }
        
        //standard dataset function that updates 
        //details of a customer based on ID
        public void Update(memberBL member)
        {
            OpenCnn();
            
            String selectStr = "UPDATE " + thisTable +
                " set " + member_name + " = '" + member.Name + "'" +
                ", " + member_family + " = '" + member.Familly + "'" +
                ", " + member_shsh + " = '" + member.Shsh + "'" +
                ", " + member_melicode + " = '" + member.Melicode + "'" +
                ", " + member_tavalod + " = '" + member.Tavalod + "'" +
                ", " + member_shoghl + " = '" + member.Shoghl + "'" +
                ", " + member_tel + " = '" + member.Tel + "'" +
                ", " + member_mobile + " = '" + member.Mobile + "'" +
                ", " + member_adr + " = '" + member.Adr + "'" +
                " where member_code = '" + member.Membercode  + "'";

            OleDbCommand cmd = new OleDbCommand(selectStr,cnn);

            cmd.ExecuteNonQuery();
            
            CloseCnn();
        }
        
        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        public DataSet Find(String argStr)
        {
            DataSet ds=null;

            try
            {
                OpenCnn();
            
                String selectStr = "select * from " + thisTable + 
                              " where member_code = '" + argStr + "'";
                OleDbDataAdapter da = 
                       new OleDbDataAdapter(selectStr,cnn);
                ds = new DataSet();
                da.Fill(ds,thisTable);
            
                CloseCnn();

                
            }
            catch(Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }

        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        public DataSet View()
        {
            DataSet ds = null;

            try
            {
                OpenCnn();
                
                String selectStr = "select * from " + thisTable + "'";
                
                OleDbDataAdapter da =new OleDbDataAdapter(selectStr, cnn);
                
                ds = new DataSet();
                
                da.Fill(ds, thisTable);
                
                CloseCnn();
            }
            catch (Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }

        private void OpenCnn()
        {
            // initialise connection
            String cnnStr = CnnStr;
            cnn = new OleDbConnection(cnnStr);
            // open connection
            cnn.Open();
        }

        private void CloseCnn()
        {
            // 5- step five
            cnn.Close();
        }
        
        // just a supporting function that builds 
        // and return the insert string for dataset.
        private String BuildAddString(memberBL member)
        {
            // these are the constants as 
            // set in the top of this module.
            strTable="Insert into " + thisTable;
            strFields = " (" + member_code +
            "," + member_name +
            "," + member_family +
            "," + member_shsh +
            "," + member_melicode +
            "," + member_tavalod +
            "," + member_shoghl +
            "," + member_tel +
            "," + member_mobile +
            "," + member_adr +
            "," + member_trkhozv + ")";
            
            //these are the attributes of the 
            //customer business object.
            strValues = " Values ( '" + member.Membercode +
            "' , '" + member.Name +
            "' , '" + member.Familly +
            "' , '" + member.Shsh +
            "' , '" + member.Melicode +
            "' , '" + member.Tavalod +
            "' , '" + member.Shoghl +
            "' , '" + member.Tel +
            "' , '" + member.Mobile +
            "' , '" + member.Adr +
            "' , '" + member.Trkhozv + "' )";

            insertStr = strTable + strFields + strValues;
            
            return insertStr;
            
        }

    }
}

//in the business layer create a method or property that gets the
//data from the DataLayer. Something like this:
public DataSet GetDatas(){
     return memberData.View();
}

//Now in the UI do something like this
LibraryProject.MemberBL bl = new LibraryProject.MemberBL();

dataGridView1.DataSource = bl.GetDatas().Tables[0];