Product sales form

Question

I want to create a windows form which is related to the medical. i have 5 fields in the form product codeproduct namepricequentitytotal 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.

Ramesh Palanivel · 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 ); } } }

Yuvi Sharma · Answer

Thank you so much Sir.

Yuvi Sharma · Answer

sir i don't have Teamviewer i'm using anydesk

Ramesh Palanivel · Answer

Hi Yuvi Share your error screen shot!...

Ramesh Palanivel · Answer

HI Yuvi Can you share your team viewer details? I will help you!..

Yuvi Sharma · Answer

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) { } } }

Yuvi Sharma · Answer

keyboard events

Ramesh Palanivel · Answer

Hi Yuvi Kindly confirm which option you going to perform button or keyboard event

Yuvi Sharma · Answer

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 Palanivel · Answer

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....