Hello, I was succesfull in creating an array string with connection to MS Access that displays data based on the array string word. But now I want to take data from the textbox and store it into the array string. Unfortunately I have not been succesfull.
This is my 1st code for array:
protected void Button1_Click(object sender, EventArgs e)
{
string concat = null;
StringBuilder b = new StringBuilder();
string[] array = new string[2];
array[0] = "Animal";
array[1] = "Eat";
string ConnectString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" + @"D:\\Database1.accdb;";
OleDbConnection objCon;
OleDbCommand objCmd;
string GetSql = string.Empty;
for (int i = 0; i < array.Length; i++)
{
GetSql = "(SELECT * FROM table1 where Word = '" + array[i] &# ...
Go to the complete details ...