syntax of list box in insert query

Question

hello everyone ; what is the syntax of list box in insert querry. i am using c-sharp .

Satyapriya Nayak · Answer

Hi sumaira, Is it working now!.Iam attaching a sample application which i did it.I used Ms-access db which is located in bin folder.Check it out. Thanks

Satyapriya Nayak · Answer

Hi sumaira, Change it in you ADD Button and try this .It will work sure.... private void button_ADD_Click(object sender, EventArgs e) { listBox_selected_services.SelectedIndex = 0; listBox_lab_charges.SelectedIndex = 0; MY_SQL_NEW_QUR.Access("insert into laboratory([laboratoryrecieptid],[patientid],[patientname],[doctorname],[departmentname],[laboratoryselectedservices],[laboratorycharges],[totalcharges])values('" + textBox_laboratory_reciept_id.Text + "','" + textBox_patient_id.Text + "','" + textBox_patient_name.Text + "','" + textBox_doctor_name.Text + "','" + textBox_department_name.Text + "','" + listBox_selected_services.SelectedItem.ToString() + "','" + listBox_lab_charges.SelectedItem.ToString() + "','" + textBox_total_charges.Text + "')" ,connection.My_Get()) ; } Thanks

theLizard · Answer

List boxes do not have a Text property try this for ALL list boxes and Combo boxes listBox_lab_charges.SelectedValue.ToString()

sumaira manzoor hussain khan · Answer

Hi; ok. i have been sent my application to you . thanks

sumaira manzoor hussain khan · Answer

hello ; the error exist in the insert query of laboratory module .

sumaira manzoor hussain khan · Answer

hello ; my application is very heavy .

Satyapriya Nayak · Answer

Hi sumaira, Can you attach your application i want to check it over here in my system. Thanks

sumaira manzoor hussain khan · Answer

hi; i add '"+listBox_selected_services.Text+"' and '"+listBox_lab_charges.Text+"' in my query . but there is not effect. the another thing is , i am using c-sharp express edition and my project is form based. my query generate this type of error . Error 1 'object' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

Satyapriya Nayak · Answer

Hi sumaira, listBox_selected_services.Text change it to '"+listBox_selected_services.Text+"' listBox_lab_charges.Text change it to '"+listBox_lab_charges.Text+"' Change it in your query and test it ...... Thanks

Satyapriya Nayak · Answer

Hi sumaira, The application i wrote is webapplication not windows app.So check it out your app is win or web. Thanks

sumaira manzoor hussain khan · Answer

hello sir; your code generate this type of error . Error 1 'object' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?) D:\hospital management system\hospital management\hospital management\laboratory.cs 58 420 hospital management

sumaira manzoor hussain khan · Answer

hello sir ; i am sending my insert query . the error are occur in the list box syntax. the wrong syntax is in orange color. actually, my problem is syntax of list box in insert query . MY_SQL_NEW_QUR.Access("insert into laboratory([laboratoryrecieptid],[patientid],[patientname],[doctorname],[departmentname],[laboratoryselectedservices],[laboratorycharges],[totalcharges])values('"+textBox_laboratory_reciept_id.Text+"','"+textBox_patient_id.Text+"','"+textBox_patient_name.Text+"','"+textBox_doctor_name.Text+"','"+textBox_department_name.Text+"','"+ l istBox_selected_services.SelectedItem.Text+" ', '"+listBox_lab_charges.SelectedItem.Text+"' ,'"+textBox_total_charges.Text+"')",connection.My_Get());

sumaira manzoor hussain khan · Answer

hello sir; sir, i wrote the listbox1.selecteditem in my code but .Text is missing in my code. it means .Text is not in the library

Satyapriya Nayak · Answer

Hi sumaira, I wonder what you are looking for the solution,first the question iam not very clear.I mean to say that in listbox previously items are bound to it or not if yes i have a solution given below using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); string str; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ListBox1.Items.Add("HR"); ListBox1.Items.Add("IT"); ListBox1.Items.Add("MK"); } } protected void Button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = "insert into emp values('" + TextBox1.Text + "','" + ListBox1.SelectedItem.Text + "')"; cmd = new SqlCommand(str, conn); cmd.ExecuteNonQuery(); conn.Close(); Response.Write("Records Inserted"); clear(); } void clear() { TextBox1.Text = ""; } } Iam attaching a sample program you run it to get the desired output. Thanks If this helps you mark it as Accepted Answer

sumaira manzoor hussain khan · Answer

hello sir; please , you will check my querry . because i apply listbox syntax directly in my code . but my query give error to me. this is my query MY_SQL_NEW_QUR.Access("insert into laboratory([laboratoryrecieptid],[patientid],[patientname],[doctorname],[departmentname],[laboratoryselectedservices],[laboratorycharges],[totalcharges])values('"+textBox_laboratory_reciept_id.Text+"','"+textBox_patient_id.Text+"','"+textBox_patient_name.Text+"','"+textBox_doctor_name.Text+"','"+textBox_department_name.Text+"', listBox_selected_services.Text , listBox_lab_charges.Text ,'"+textBox_total_charges.Text+"')",connection.My_Get());

Koteswararao Mallisetti · Answer

ListBox1.Text it will give the list box selected item textvalue you directly use it in the insert Query