How I can read database table into a second gui holding a richtextbox.

Hector Agosto 21

private: System::Void btnNotes_Click(System::Object^ sender, System::EventArgs^ e) {  
 MyForm1^ Form1 = gcnew MyForm1(txtRef->Text);  
 Form1->ShowDialog();  
}

I have the reference number showing when the button loads on the second gui from a label, but I need the second gui to display the Notes table from my database in my richtextbox. any help?

Guido Franzke 2,196 Reputation points

2022-08-25T05:49:24.02+00:00
Hello,
normally speaking it's easy to read data from a database.

open database

select from table and put data in a container

output
I would prefer a table control instead of a richtextbox.
To help you with the database, you must give more information: Which database do you use?
Regards, Guido
Hector Agosto 21 Reputation points

2022-08-25T05:58:34.983+00:00

I know how to connect to the DB already, i have done so previously for the Add New button and Update button, where im struggling is adding the data into my richtextbox when the Notes button is pressed.that might be the container or output part that you're talking about. and it needs to be richtextbox because i need to be able to write more notes in the function. i'm using "newtable.new_table".
Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T06:43:23.433+00:00

How did you design the database? Can you provide example you want the data to be displayed in the richtextbox?

newtable.new_table

I didn't find anything about the newtable.new_table database. Is it a database product like Access?
Hector Agosto 21 Reputation points

2022-08-25T06:46:49.783+00:00

I want to get the Notes table to open in the Notes button.
Hector Agosto 21 Reputation points

2022-08-25T06:57:26.063+00:00

it's just a normal database i made.
Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T07:39:44.05+00:00

Try to read the contents of the Notes column by looping and pass it in gcnew MyForm1().
Hector Agosto 21 Reputation points

2022-08-25T08:00:10.98+00:00

I'm not sure how to do that.

Minxin Yu 11,026 Microsoft Vendor

Since I don't know which database you are using, I assume you have read the full table.
Read Notes data :

	for each (DataRow^ row in mTable->Rows)  
	{  
		myAL->Add(row["Notes"]->ToString());//ArrayList  
	}  
     ///////////////////  
private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {  

	 form1 = gcnew MyForm1(myAL);  
		form1->ShowDialog();  
}

The form1 Constructor

	MyForm1(ArrayList^ text)  
	{  
		InitializeComponent();  

		for (int var=0; var< text->Count;var++)  
		{  
			richTextBox1->SelectedText = text[var]->ToString()+"\n";								  
		}  
	}

Guido Franzke 2,196 Reputation points

2022-08-25T08:15:42.45+00:00

I'm sorry, I don't understand your problem. If you can already read from the database, then you know the data of each row and you have a variable for your "Notes" column (normally text).
Since you can update the data in your table, you should also know, how to get the current selected row in your table, so you can get the value in the "Notes" column.
If you don't know how to get and set text in a richtextbox, read the documentation or search for examples, e.g.
cpp-richtextbox-class-examples.html
Hector Agosto 21 Reputation points

2022-08-25T08:31:57.713+00:00

i am recieving an undefined error with mTable and myAL are these supposed to be my database? I'm sorry i dont think i understand where exactly to implement the for statement.
Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T08:38:15.357+00:00
myAL is declared (type ArrayList) in Myform.h and used in myAL->Add(row["Notes"]->ToString());. DataTable stores database tables.
For example:

public ref class MyForm : public System::Windows::Forms::Form { public: ArrayList^ myAL = gcnew ArrayList; DataTable^ mTable=gcnew DataTable;

Accepted answer

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-26T06:26:22.833+00:00
Hi, @Hector Agosto

This is the test example. Click button2 to read data and click button1 to show the Form1.

private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { form1 = gcnew MyForm1(myAL); form1->ShowDialog(); } private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) { String^ connString = "Data Source = (localdb)\\ProjectModels; Initial Catalog = DataBase1; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = False; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"; SqlConnection^ con = gcnew SqlConnection(connString); con->Open(); String^ sqly = "select * from TestTable"; SqlCommand^ sqlCommand = gcnew SqlCommand(sqly, con); SqlDataReader^ reader = sqlCommand->ExecuteReader(); mTable->Load(reader); reader->Close(); con->Close(); for each (DataRow^ row in mTable->Rows) { myAL->Add(row["Notes"]->ToString()); } }

Best regards,

Minxin Yu

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Hector Agosto 21 Reputation points

2022-08-26T21:24:56.16+00:00

I see you have two buttons, im wondering how to do it with just the one button. everything works when i use two buttons. i've set it up just how you've shown me. now i'm trying to make it work with just one button. if i select to open the notes again the information seems to duplicate. any idea how to fix this duplication error?

master chief 76 Reputation points

2022-08-28T02:14:09.147+00:00

Set a flag to prevent duplicate reads.
Sign in to comment

1 additional answer

Hector Agosto 21 Reputation points

2022-08-25T08:58:30.677+00:00
private: System::Void btnNotes_Click(System::Object^ sender, System::EventArgs^ e) { MyForm1^ Form1 = gcnew MyForm1(txtRef->Text, myAL); Form1->ShowDialog(); //MyForm1^form1 = gcnew MyForm1(myAL); //form1->ShowDialog(); }

isnt working .
Please sign in to rate this answer.
Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T09:06:41+00:00

Did the previous code work? you can modify the constructor:
MyForm1(The type of your txtRef->Text txt, ArrayList^ text)

Hector Agosto 21 Reputation points

2022-08-25T09:17:03.583+00:00

MyForm1^ Form1 = gcnew MyForm1(txtRef->Text , ArrayList^Text); Form1->ShowDialog();

im receiving an error with the ArrayList type name is not allowed. im not sure if it works yet because i havent gotten this form loader able to hold two arrays.

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T09:21:28.517+00:00

You need to modify your MyForm1 constructor in MyForm1.h.
Modify the type of your txtRef->Text below

MyForm1(The type of your txtRef->Text txtRef, ArrayList^ text)

Hector Agosto 21 Reputation points

2022-08-25T09:29:19.477+00:00

private: System::Void btnNotes_Click(System::Object^ sender, System::EventArgs^ e) { MyForm1^ Form1 = gcnew MyForm1(txtRef->Text, ArrayList^Text); Form1->ShowDialog(); }

i dont have txtRef inside MyForm1 its a textbox variable inside of MyForm that i pass to a label when i click notes.
im getting a type name is not allowed for ArrayList^Text. sorry this is frustrating. the rest of the code is plugged in, i'm just not sure how to pass this array since i already have one constructor .

Hector Agosto 21 Reputation points

2022-08-25T09:35:30.887+00:00

if i try to use .

MyForm1^ Form1 = gcnew MyForm1(txtRef->Text, myAL); Form1->ShowDialog();

i get Severity Code Description Project File Line Suppression State
Error (active) E0289 no instance of constructor "Project4::MyForm1::MyForm1" matches the argument list Project4 C:\Users\hagos\source\repos\Project4\Project4\MyForm.h 569

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T09:39:01.857+00:00

Use string to receive txtRef->Text. Constructor: MyForm1(String^ txt,ArrayList^ text)

Hector Agosto 21 Reputation points

2022-08-25T09:48:18.053+00:00

i suppose it takes more than just

MyForm1(String^ txt,ArrayList^ text)

because this gave me errors as well.

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T09:49:10.377+00:00

What is your type of txtRef? Can you provide the error message.

Hector Agosto 21 Reputation points

2022-08-25T09:50:34.103+00:00

all i'm trying to do now is add a second constructor to

MyForm1^ Form1 = gcnew MyForm1(txtRef->Text, myAL); Form1->ShowDialog();

Hector Agosto 21 Reputation points

2022-08-25T09:53:38.437+00:00

if i just use myAL it doesnt show my notes that are in the db either.

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-25T09:57:54.753+00:00

Did you read database table into DataTable^ mTable?

Hector Agosto 21 Reputation points

2022-08-25T10:01:26.773+00:00

the

for each (DataRow ^ row in mTable->Rows) { myAL->Add(row["Notes"]->ToString());//ArrayList }

part? i have that in the initialize form part. whats it supposed to look like?

Minxin Yu 11,026 Reputation points Microsoft Vendor

2022-08-26T01:22:34.717+00:00

This part is used to store the contents of Column Notes into an ArrayList. You can put the snippet after reading database into DataTable^ mTable.
Sign in to comment

Share via

How I can read database table into a second gui holding a richtextbox.

1 additional answer