Form Population from another Form [Newbie Question]

Paul Chambers

Hello All. First thank you for reading. I am trying to learn c# and due to unemployment am scouring the internet for free resources to do so. I have come across videos and ebook's and now this website. after beginning my debut programme (a simple address book) I'm stuck... I have managed to create a very nice UI (easy in VS08) and a database. on the first form it lists the names in the database in a listbox. When a name is double clicked it opens a dialog box instance of a details page. I have managed to grab the ID from the name clicked and throw it at the details form, The 2nd form takes this ID and displays it in a text box, But all the other components of the form show details of another entry in the table... I am using ADO.net, TableAdapters, BindingSource and Datasets. I have very limited understanding of these, but I thought Binding source was meant to update all fields to represent the same record (row, entry) ? So my question is, What am I missing to make this happen? ~Ore P.S For somereason all formatting I try and acheive in this forum is futile. It might be my browser settings. I have code I was going to post but since my formatting is buggered it would have just complicated things.

5 Replies

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

Gautam Baruah17y ago
Accepted answer
Hi Paul, still your question as well as codes are not clear. As per my understanding you are able to get the value from listbox to the second form. so now based on this id (if it's the primary key column for that particular table) you have to run one more query, like -
string sql="select * from tableName where id='"+id+"'"
sqlconnection cn=new sqlconnection(your ConnectionString)
SqlCommand cmd=new Sqlcommand(sql,cn);
cn.open()

SqlDataReader reader=cmd.ExecuteReader();
if(reader.reader())
{
textBox1=reader["id"].toString()
textBox2=reader["address"].toString();
// more values
}
reader.close();
cn.close();
Like that you have to get the value from your database table. I am not mentioning the codes in details. I dont know if I am able to guide you or not. Plz let me know if this was your problem.
Gautam Baruah17y ago
my pleasure, I could help you.
Paul Chambers17y ago
thank you, this seems to be the answer. Sorry about the post formatting. It really is annoying! ~Ore
Paul Chambers17y ago
Thank you Gautam for your reply. As mentioned I seem to be having problems with formatting on this site. I will attempt to improvise and put in the code. =========================================================================================================================================================================== I have the following Code================================================================================================================================================== [Code] ___operativesdetails opdf = new operativesdetails();int opID = (int)opListBox.SelectedValue; =========================================================================================================================================================================== ___Database1DataSet.OperativeRow operative = database1DataSet.Operative.FindByOperativeID(opID); =========================================================================================================================================================================== ___opdf.OperativeID = opID; =========================================================================================================================================================================== ___opdf.Name = operative.Name; =========================================================================================================================================================================== ___DialogResult result = opdf.ShowDialog(); [/Code] =========================================================================================================================================================================== on the form "operativesdetails" =========================================================================================================================================================================== ___operativeIDTextBox.Text = OperativeID.ToString(); =========================================================================================================================================================================== which adds the ID taken from the selected item in the listbox of the first form and adds it to the "operativeid" text box. But the rest of the details form, I.E. Name, Address, Post Code, ect are all from a different record in the database. What I would like for the details for to take this information form the record the "opertiveid" is from....
Gautam Baruah17y ago
Hey Paul, I found very difficult to understand your problem. could you plz describe in details. why dont you copy your code in notepad and try to paste?
As per my understanding you are trying to display values in textboxes using sqldataadapter, if so then try SqlDataReader. SqlDataTable and DataSet are used to display values in control blocks like gridview or datagrid. I dont know if I am giving you correct direction or not. Plz tell me your problem in details.I will be really very happy to help you out.