You are wonderful. Every things I think about, you talk about it!!!!! Many thanks to you!!!
@draganatosovic7541
4 жыл бұрын
Man, you're the LEGEND of C# :D
@brettbyrd
6 жыл бұрын
I have learned quite a bit by watching this series. I do have one issue I hope you can help resolve. If I am using this to keep track of employees or products, how can I get it to update the ComboBox when I add/delete/update anything on this form without closing the form and opening it again?
@bilalvanloon7906
6 жыл бұрын
Does someone know how to let the combobox "query" fill in the textboxes when you have the First and Last name in the combobox instead of only the FirstName from the example lesson #10?
@delform1989
8 жыл бұрын
I'm curious how did you make that for the first time. Did it was a book or you search information in forum. Byt the way, really good example ;)
@frallen9787
5 жыл бұрын
TY MY INDIAN/ARAB FRIEND!
@erickhilton2875
10 жыл бұрын
Gracias por todo
@makhosingobe2162
5 жыл бұрын
Thanks for the video. How do I retrieve data from related tables, like student name from student table, students results from reports tables, these tables are linked with student number (primary key in student table and foreign key in results table) ? I have tried, my sql works on msacess but not on C#. Thank you in advance
@luuquangtinh
5 жыл бұрын
Many thanks !!
@mbs2488
7 жыл бұрын
Very Good !
@csianahmed
9 жыл бұрын
please send the link of the video that explains the code you used inside the combo box
8 жыл бұрын
Dual record MARK not work well. See EID 1 and 12
@thehartzhans8785
5 жыл бұрын
Hai Thnx for your informative video's But ..... I don't want to have sql code in my C# code, I want to use a file, on my desktop, witch contains my sql code How can i execute sutch a file in C#
@sagarkawthankar3876
7 жыл бұрын
Whenever I select any item from combo box, corresponding values are not shown in text boxes but when I select another value from combo box, the previous values are displayed. Please help! I have done the exact same thing. Also, when I double click on combo box, studio creates a function private void pickname_SelectionChanged(object sender, SelectionChangedEventArgs e) I changed it to function you have but still same thing is happening!
@jeremythom2414
10 жыл бұрын
Hi, I've been following your videos and so far they are perfect. I finally hit a problem. Using your code for my documents, after I add the four txt_eid.Text = reader ["EID"].ToString(); lines, I can still select everything from the combobox, but it stopped linking to the text boxes. Before I added these lines it would link combobox to textbox, but wouldn't replace it, Thanks for any help.
@Luke-qv2ty
2 жыл бұрын
Its 7 years later, do you know the answer to this question already?
@anthonramos3576
7 жыл бұрын
How about ID ? If I want ID to show from combox and show from textbox ? What I declare ?
@marcstephencorpuz4804
3 жыл бұрын
hi i have followed every line of codes but im getting "System.Data.OleDb.OleDbException: 'Data type mismatch in criteria expression.' " help pls
@ProgrammingKnowledge
10 жыл бұрын
@optc8005
7 жыл бұрын
Please teach me about on how to do this using Databindings!
@educationhub8241
5 жыл бұрын
Error show in access database when I open file " not a valid bookmark , I am working on vb.net and database ms access plzzz solve it important plzzzzz
@tankpigSTS
10 жыл бұрын
Can't get mine to work...give me no errors but just doesn't show the data in the text boxes
@chaoticheaven17
9 жыл бұрын
mine too.. have you found a solution to this problem?
@nehalel-shaboury4495
8 жыл бұрын
+quasar17 I face the same problem... no response. Have you guessed where the problem lies?
@bretthenwood6256
8 жыл бұрын
Hey man, a very late response but I had the same issue, I fixed it by making the combo box only list the first names in form2, then it went fine, as the combobox method only works if it is looking for the first name, not both
@toshiii8646
5 жыл бұрын
Ok it's not appearing in any of my textboxes
@allancaldz
10 жыл бұрын
cant duplicate surname , textbox value of 1 surname = 1
@vladimirblum441
8 жыл бұрын
O-O-ps! I found my mistake in syntax Sorry !
@nehalel-shaboury4495
8 жыл бұрын
That was my code..... but unfortunately there was no response.... Does anyone have an idea where the problem lies? 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.OleDb; namespace LifeCycleEnergyAssessment { public partial class YearlyOperationEnergy : Form { private OleDbConnection connection = new OleDbConnection(); public YearlyOperationEnergy() { InitializeComponent(); connection.ConnectionString @"Provider=Microsoft.ACE.OLEDB.12.0;DataSource=C:\Users\Nehal92\Desktop\Access Database\Primary Energy Conversion Factors.accdb; Persist Security Info=False;"; } private void button2_Click(object sender, EventArgs e) { this.Hide(); DemolitionEnergy DE = new DemolitionEnergy(); DE.Show(); } private void YearlyOperationEnergy_Load(object sender, EventArgs e) { try { connection.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connection; string query = "select * from PrimaryEnergyConversionFactor"; command.CommandText = query; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader["EnergySource"].ToString()); comboBox2.Items.Add(reader["EnergySource"].ToString()); comboBox3.Items.Add(reader["EnergySource"].ToString()); comboBox4.Items.Add(reader["EnergySource"].ToString()); comboBox5.Items.Add(reader["EnergySource"].ToString()); } connection.Close(); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { connection.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connection; string query = "select * from PrimaryEnergyConversionFactor where EnergySource=' " + comboBox1.Text + " ' "; command.CommandText = query; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { textBox18.Text = reader["PrimaryConversionFactor"].ToString(); } connection.Close(); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } } }
Пікірлер: 31