Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

  View Other C# .NET Posts   Ask New Question  Ask New Question With Power Editor

Query problem
vandana sardana posted at Monday, November 02, 2009 7:20 AM

 am developing a windows application, my database is in MS-Access. i have 1 form which have 3 combo box: License Key, Employee Name, Serial Number. I have a table for this form named tblemployeelicense. Now LicenseKey combobox will take the value from tblantivirus(fields used for this form) which has following fields: licenseId, licenseKey. Employee name and serial number will be taken from tblemployee(fields for use ) are : employeeId, employeeName, serialNumber. Now tblemployeelicense has 3 fields: licenseKey, employeeName and serialNumber. I want that this table will get the data from both the tables. Please help me how to write a query for this and how to proceed.
Here i am posting my coding and please help me with the coding:

 public partial class frmemplicense : Form
    {
        public frmemplicense()
        {
            InitializeComponent();
        }
        string licenseKey;
        string employeeName;
        string serialNumber;

        public string pageAction;

        private void frmemplicense_Load(object sender, EventArgs e)
        {
            LoadGrid();
            SetEditState(false);
            ClearFields();
            LoadData();
        }

        private void LoadGrid()
        {
            try
            {
                ConnectionClass l_ConnectionClass = new ConnectionClass();
                DataSet l_employeelicense = l_ConnectionClass.FetchDataInDataSet("SELECT tblantivirus.licenseKey, tblemployeelicense.licenseKey, tblemployeelicense.employeeName, tblemployeelicense.serialNumber, tblemployee.employeeName, tblemployee.serialNumber FROM tblantivirus RIGHT JOIN (tblemployeelicense LEFT JOIN tblemployee ON tblemployeelicense.employeeName = tblemployee.employeeName) ON tblantivirus.licenseKey = tblemployeelicense.licenseKey;");
                dgvemplicense.DataSource = l_employeelicense.Tables[0];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void SetEditState(bool edit)
        {
            btnadd.Enabled = !edit;
            btnclose.Enabled = !edit;
            btndelete.Enabled = !edit;

            dgvemplicense.Enabled = !edit;

            btncancel.Enabled = edit;
            btnsave.Enabled = edit;

            cbemployee.Enabled = edit;
            cblicense.Enabled = edit;
            cbserial.Enabled = edit;        
        }

        private void ClearFields()
        {
            cbemployee.Text = String.Empty;
            cblicense.Text = String.Empty;
            cbserial.Text = String.Empty;
        }

        private void LoadData()
        {
            try
            {
                ConnectionClass l_ConnectionClass = new ConnectionClass();
                DataSet KeyData = l_ConnectionClass.FetchDataInDataSet("select licenseKey from tblantivirus");
                cblicense.ValueMember = "licenseId";
                cblicense.DisplayMember = "licenseKey";
                cblicense.DataSource = KeyData.Tables[0];

                DataSet EmployeeData = l_ConnectionClass.FetchDataInDataSet("select employeeName from tblemployee");
                cbemployee.ValueMember = "employeeId";
                cbemployee.DisplayMember = "employeeName";
                cbemployee.DataSource = EmployeeData.Tables[0];

                DataSet SerialData = l_ConnectionClass.FetchDataInDataSet("select serialNumber from tblemployee");
                cbserial.ValueMember = "employeeId";
                cbserial.DisplayMember = "serialNumber";
                cbserial.DataSource = SerialData.Tables[0];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void btnadd_Click(object sender, EventArgs e)
        {
            pageAction = "ADD";
            ClearFields();
            SetEditState(true);
            cblicense.Focus();
        }

        private void btnsave_Click(object sender, EventArgs e)
        {
            try
            {
                ConnectionClass l_ConnectionClass = new ConnectionClass();
                licenseKey = Convert.ToString(cblicense.SelectedValue);
                employeeName = Convert.ToString(cbemployee.SelectedValue);
                serialNumber = Convert.ToString(cbserial.SelectedValue);

                l_ConnectionClass.SaveEmployeeLicense(licenseKey, employeeName, serialNumber);
                LoadGrid();
                ClearFields();
                cblicense.Focus();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btncancel_Click(object sender, EventArgs e)
        {
            LoadGrid();
            ClearFields();
            SetEditState(false);
        }

        private void btnclose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void dgvemplicense_SelectionChanged(object sender, EventArgs e)
        {
            try
            {
                if (dgvemplicense.SelectedRows.Count > 0)
                {
                    cblicense.SelectedValue = dgvemplicense.CurrentRow.Cells["licenseKey"].Value.ToString();
                    cbemployee.SelectedValue = dgvemplicense.CurrentRow.Cells["employeeName"].Value.ToString();
                    cbserial.SelectedValue = dgvemplicense.CurrentRow.Cells["serialNumber"].Value.ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Please help because i am fully confused what to do.

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0