Product sales form

Deepak Sharma

I want to create a windows form which is related to the medical. i have 5 fields in the form

product code,product name,price,quentity,total amout.all the details comes in textbox. when i type the product code in the first textbox all the details wants auto fill in remaning textbox.how i can do this..Please help me with the sample of the code.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi Yuvi,

Try this code,
private void ProductCode_KeyDown(object sender, KeyEventArgs e)
        {
            if(e.KeyCode==Keys.Enter)
            {
                if(textBox1.Text!="")
                {
                    con.Open();
                    SqlCommand cmd=new SqlCommand("select * from Products where Product_Code='"+ProductCode.Text+"'",con)
                    MySqlDataReader sdr=cmd.ExecuteReader();
                    while(sdr.HasRows)
                    {
                        ProductName.Text=sdr.GetString(0);
                        ProductPrize.Text=sdr.GetString(0);
                    }
                    const.Close();
                }
                else
                {
                    MessageBox.Show("Enter some product code");
                }
            }
        }
Deepak Sharma9y ago
Thank you so much Sir.
Deepak Sharma9y ago
sir i don't have Teamviewer
i'm using anydesk
Ramesh Palanivel9y ago
Hi Yuvi,

Share your error screen shot!...
Ramesh Palanivel9y ago
HI Yuvi,

Can you share your team viewer details? I will help you!..
Deepak Sharma9y ago
sir can you check my code what's error in this code.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace InnoventManagement
{
public partial class Employee : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=Management;Integrated Security=True");
AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
SqlCommand cmd;
public Employee()
{
InitializeComponent();
}
private void Employee_Load(object sender, EventArgs e)
{
cmd = new SqlCommand("select EmpName From Admin", con);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
MyCollection.Add(sdr.GetString(0));
}
textBox1.AutoCompleteCustomSource = MyCollection;
textBox2.AutoCompleteCustomSource = MyCollection;
con.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{

}
}
}
Deepak Sharma9y ago
keyboard events
Ramesh Palanivel9y ago
Hi Yuvi,

Kindly confirm which option you going to perform, button or keyboard event
Deepak Sharma9y ago
Sir,
can you help me with sample coding of this.I have tried many code but not working properly.can you give me the examles of the small coding
Ramesh Palanivel9y ago
Hi Yuvi,

Its simple, you have trigger any event to get the details. You can achieve this in two ways,

First one is , create the button near textbox like "Search" button.

Once you entered the textbox value , click the search button. Once you click the search the button it wnat to get hte textbox value and want to search in db. get the searched details using sqldatareader and store the values in appropriate field.

Second one is : Instead of button, you can call the key board event to get the details.

Example : once the user enter the product code in textbox , if user click the enter key you can get the values for entered product code....