Connect multiple textbox to the database in WinApp

Fuhans Puji Saputra

Here is my case:
I have created 2 form which is login form, which username textbox already connected to the database and it is successfully.
When user login, it direct to the second form, and in the second form, there are multiple textbox that i have created using Array List, and it has shown.

Here is my problem:
I want to connect the textboxes in second form to the database, but it shown nothing when i run the program, i already trace the code which is the error, and the error is on when OleDBDataReader is reading, i dunno what's wrong with my code, in login form it run perfectly, but in the second form, there is an error.

Here is the link image for Login Form:https://www.dropbox.com/s/5q8pyztqy7ejupy/Capture.PNG

Here is the link image for Second Form:
https://www.dropbox.com/s/khsvh5bf1dc4c8u/Capture_2.PNG

Here is the link code for Second Form:
https://www.dropbox.com/s/rval228qyo2mwbj/Code%20for%20Second%20Form_2.docx

For the Second Form, in the column of code, it supposed to shown the autocomplete like at the Login Form.

Thank you.

17 Replies

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

Iftikar Hussain13y ago
Accepted answer
try like this

OleDbCommand cmd = new OleDbCommand("SELECT DISTINCT Code FROM [Data] ORDER BY [Code] ASC", conn);
dReader = cmd.ExecuteReader();
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

while (dReader.Read())
{
namesCollection.Add(dReader["Code"].ToString());
}

dReader.Close();

don't use break

Regards,
Iftikar
Fuhans Puji Saputra13y ago
alright.
Thank you sir for your time.

Sincerely,
Fuhans
Iftikar Hussain13y ago
for the auto complete only, try my previous post.

Regards,
Iftikar
Fuhans Puji Saputra13y ago
i mean, it is working.
But, the autocomplete that is not working.

Correct me if i am wrong sir:
for the "Code", it is "number", not "text".
So, it is not working if i write the code "dReader["Code"].ToString()" instead of "dReader.GetInt32(0)"?
Iftikar Hussain13y ago
what is happening? did you try like this

string connectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\Archives\Projects\Program\Sell System\Sell System\App_Data\db1.accdb;Persist Security Info=False;");

OleDbDataReader dReader;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT DISTINCT Code]FROM [Data] ORDER BY [Code] ASC", conn);
dReader = cmd.ExecuteReader();
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

while (dReader.Read())
{
namesCollection.Add(dReader["Code"].ToString());
}
dReader.Close();

//****TextBox for Code****
for (int y = 0; y <= 16; y++)
{
TextBox textBox = new TextBox();
textBox.Size = new Size(100, 50);
textBox.Location = new Point(25, 50 + (y * 25));
textBox.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox.AutoCompleteCustomSource = codesCollection;
Controls.Add(textBox);
}
conn.Close();

Regards,
Iftikar
Fuhans Puji Saputra13y ago
No sir, it is not working.
Fuhans Puji Saputra13y ago
Hi Iftikar Hussain,

Here is the complete code "Sell System.rar"
Iftikar Hussain13y ago
can you share the complete code?

Regards,
Iftikar
Fuhans Puji Saputra13y ago
I already put the break below the line "codesCollection.Add(dReader.GetString(0));"
and still nothing happened, the error still same, at close bracket on:

while (dReader.Read())
{
codesCollection.Add(dReader.GetString(0));
}
dReader.Close();
Iftikar Hussain13y ago
can you put the break point in below line and check

while (dReader.Read())
{
codesCollection.Add(dReader.GetString(0));
}
dReader.Close();

Regards,
Iftikar
Fuhans Puji Saputra13y ago
Hi Mr Iftikar Hussain,

I already try what are you suggest, but still there is an error.
The error is on close bracket in:

while (drReader.Read())
{
codesCollection.Add(dReader.GetString(0));
} <-- Here i trace on it by clicking the red dot, but nothing shown up (means there is an error right?), in Login Form i trace same thing what i did in Second Form, and the close bracket shown up, so there no error.
om prakash13y ago
Hi,
I am not sure why your using collection of collection of textbox. You can just do like this

string connectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\Archives\Projects\Program\Sell System\Sell System\App_Data\db1.accdb;Persist Security Info=False;");

OleDbDataReader dReader;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT DISTINCT [Code] FROM [Data] ORDER BY [Code] ASC", conn);
dReader = cmd.ExecuteReader();
AutoCompleteStringCollection codesCollection = new AutoCompleteStringCollection();

while (dReader.Read())
{
codesCollection.Add(dReader.GetString(0));
}
dReader.Close();

//****TextBox for Code****
for (int y = 0; y <= 16; y++)
{
TextBox textBox = new TextBox();
textBox.Size = new Size(100, 50);
textBox.Location = new Point(25, 50 + (y * 25));
textBox.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox.AutoCompleteCustomSource = codesCollection;
Controls.Add(textBox);
}
conn.Close();
Iftikar Hussain13y ago
Hi,
I am not sure why your using collection of collection of textbox. You can just do like this

string connectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\Archives\Projects\Program\Sell System\Sell System\App_Data\db1.accdb;Persist Security Info=False;");

OleDbDataReader dReader;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT DISTINCT [Code] FROM [Data] ORDER BY [Code] ASC", conn);
dReader = cmd.ExecuteReader();
AutoCompleteStringCollection codesCollection = new AutoCompleteStringCollection();

while (dReader.Read())
{
codesCollection.Add(dReader.GetString(0));
}
dReader.Close();

//****TextBox for Code****
for (int y = 0; y <= 16; y++)
{
TextBox textBox = new TextBox();
textBox.Size = new Size(100, 50);
textBox.Location = new Point(25, 50 + (y * 25));
textBox.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox.AutoCompleteCustomSource = codesCollection;
Controls.Add(textBox);
}
conn.Close();

Regards.
Iftikar
Fuhans Puji Saputra13y ago
what do you mean by corrupt?
and i already attach the files.rar, everything are inside it.
Please look at it.

Thank you
Vijay13y ago
Mr. Om Prakash don post like dis any more. we already warn you . if u know the answer just answer. otherwise u just visit n go man....
Fuhans Puji Saputra13y ago
Thanks for reply.
But one question, why do i need to use datawriter on each textbox to connect it to the database?
i don't use datawriter on the textbox, only use datareader, and it went perfectly.
But that's for Login Form only, but for Second Form, i had problem to connect multiple textboxes to the database.
Please click the link that i have given in the question.

Thank you
om prakash13y ago
first use data writer and then data reader

Thanks
Prakash