CODEWITHSUNDEEP
databasevisual-c++c++-cli
djmedic
djmedic

Reputation: 317

Manipulating a database in C++

I apologize if has been asked, and answered somewhere else, but I have been searching like crazy and can't find what I'm looking for.

OleDbConnection^ conn = gcnew OleDbConnection ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Milestone3testdatabase.accdb; Persist Security Info=True");
                 OleDbCommand^ com = gcnew OleDbCommand();
                    com->Connection = conn;
                    com->CommandText = "SELECT *FROM tblcity;";
                    System::Data::DataSet^ ds = gcnew System::Data::DataSet();
                OleDbDataAdapter^ adapt = gcnew OleDbDataAdapter();
                    adapt->SelectCommand = com;
                    adapt->Fill(ds,"why");

                    dataGridView1->DataSource = ds->Tables["why"];

I am trying to figure out how to actually use the data I obtain from the database. I was shown how to put it into a gridview, BUT I don't want a gridview. I want be able to take 1 cell of the table and display it as text.

How do I convert the table into usable data for a C++ forms application?

Upvotes: 1

Views: 326

Answers (1)

t3chb0t
t3chb0t

Reputation: 18626

Either modify your SELECT so that it returns only a single value by using SqlCommand.ExecuteScalar Method or extract the value from your table with the DataTable.Select Method and DataTable.Rows Property 

myDataTable->Rows[rowNumber][columnNumber]

Upvotes: 1

Related Questions