select string for oleDB

[Doug]

Hi

I posted an hour ago from a different pc - about calling a form from another
form.

now i am having trouble passing the value from a text box (called
tb.entryData), from the form called input.cs (referenced as an object as
input simple=new input();) to my select string.

My code is below

private void btnSimple_Click(object sender, EventArgs e)

{

lbCustomers.Text = "";

input simple = new input();

simple.Show();

// simple has a text box and a button. The text box is called tb.entryData
and its value is passed to a public string called inputs

// i would like the value passed into the commandString to use as a querie.

string commandString = "SELECT vars.label, vars.file, vars.wave, vars.name
FROM vars where var.label like '%' + simple.inputs";

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\hilda helpa - confidentialised.mde";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString,
connectionString);
DataSet DataSet = new DataSet();

try

{

DataAdapter.Fill(DataSet, "vars");

}

catch (Exception ex)

{

MessageBox.Show("Error: " + ex);

return;

}

DataTable dataTable = DataSet.Tables[0];

foreach (DataRow dataRow in dataTable.Rows)

{

lbCustomers.Items.Add(dataRow["file"] + " " + dataRow["name"]+ " " +
dataRow["label"] +" " + dataRow["wave"]);

}

}

Any assistance appreciated.

Doug

[WhiteWizard]

It would be helpful to know what error you are getting, but I think you are
going to need a couple of more parameters in your connection string: Initial
catalog(aka Database), and I think Access makes you use UserId (aka UID), and
Password (aka PWD). If not those two parameters you'll need something like
Integrated Security=SSPI.

And by the way yes I KNOW it's not a good idea to pass UID/PWD. ;)

HTH

WhiteWizard
aka Gandalf
MCSD.NET, MCAD, MCT
"Doug" wrote:

Hi

I posted an hour ago from a different pc - about calling a form from another
form.

now i am having trouble passing the value from a text box (called
tb.entryData), from the form called input.cs (referenced as an object as
input simple=new input();) to my select string.

My code is below

private void btnSimple_Click(object sender, EventArgs e)

{

lbCustomers.Text = "";

input simple = new input();

simple.Show();

// simple has a text box and a button. The text box is called tb.entryData
and its value is passed to a public string called inputs

// i would like the value passed into the commandString to use as a querie.

string commandString = "SELECT vars.label, vars.file, vars.wave, vars.name
FROM vars where var.label like '%' + simple.inputs";

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\hilda helpa - confidentialised.mde";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString,
connectionString);
DataSet DataSet = new DataSet();

try

{

DataAdapter.Fill(DataSet, "vars");

}

catch (Exception ex)

{

MessageBox.Show("Error: " + ex);

return;

}

DataTable dataTable = DataSet.Tables[0];

foreach (DataRow dataRow in dataTable.Rows)

{

lbCustomers.Items.Add(dataRow["file"] + " " + dataRow["name"]+ " " +
dataRow["label"] +" " + dataRow["wave"]);

}

}

Any assistance appreciated.

Doug

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What error exactly are you getting?

Are you sure that is the correct connection string? Try this site:
http://www.connectionstrings.com/ you will find a connection string to
almost all data sources

Also note that your code is prone to Injection Attacks :
http://en.wikipedia.org/wiki/SQL_injection_attack
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Doug" <qu********@hotmail.comwrote in message
news:44***********************@news.optusnet.com.a u...

Hi

I posted an hour ago from a different pc - about calling a form from
another form.

now i am having trouble passing the value from a text box (called
tb.entryData), from the form called input.cs (referenced as an object as
input simple=new input();) to my select string.

My code is below

private void btnSimple_Click(object sender, EventArgs e)

{

lbCustomers.Text = "";

input simple = new input();

simple.Show();

// simple has a text box and a button. The text box is called
tb.entryData and its value is passed to a public string called inputs

// i would like the value passed into the commandString to use as a
querie.

string commandString = "SELECT vars.label, vars.file, vars.wave, vars.name
FROM vars where var.label like '%' + simple.inputs";

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\hilda helpa - confidentialised.mde";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString,
connectionString);
DataSet DataSet = new DataSet();

try

{

DataAdapter.Fill(DataSet, "vars");

}

catch (Exception ex)

{

MessageBox.Show("Error: " + ex);

return;

}

DataTable dataTable = DataSet.Tables[0];

foreach (DataRow dataRow in dataTable.Rows)

{

lbCustomers.Items.Add(dataRow["file"] + " " + dataRow["name"]+ " " +
dataRow["label"] +" " + dataRow["wave"]);

}

}

Any assistance appreciated.

Doug

[Doug]

The other parameters are not required as i can run this without the where
clause.

I just like to know how to pass the parameter from a text box to the select
string.

Doug
"WhiteWizard" <Wh*********@discussions.microsoft.comwrote in message
news:8F**********************************@microsof t.com...

It would be helpful to know what error you are getting, but I think you
are
going to need a couple of more parameters in your connection string:
Initial
catalog(aka Database), and I think Access makes you use UserId (aka UID),
and
Password (aka PWD). If not those two parameters you'll need something
like
Integrated Security=SSPI.

And by the way yes I KNOW it's not a good idea to pass UID/PWD. ;)

HTH

WhiteWizard
aka Gandalf
MCSD.NET, MCAD, MCT
"Doug" wrote:

>Hi

I posted an hour ago from a different pc - about calling a form from
another
form.

now i am having trouble passing the value from a text box (called
tb.entryData), from the form called input.cs (referenced as an object as
input simple=new input();) to my select string.

My code is below

private void btnSimple_Click(object sender, EventArgs e)

{

lbCustomers.Text = "";

input simple = new input();

simple.Show();

// simple has a text box and a button. The text box is called
tb.entryData
and its value is passed to a public string called inputs

// i would like the value passed into the commandString to use as a
querie.

string commandString = "SELECT vars.label, vars.file, vars.wave,
vars.name
FROM vars where var.label like '%' + simple.inputs";

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\hilda helpa - confidentialised.mde";

OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString,
connectionString);
DataSet DataSet = new DataSet();

try

{

DataAdapter.Fill(DataSet, "vars");

}

catch (Exception ex)

{

MessageBox.Show("Error: " + ex);

return;

}

DataTable dataTable = DataSet.Tables[0];

foreach (DataRow dataRow in dataTable.Rows)

{

lbCustomers.Items.Add(dataRow["file"] + " " + dataRow["name"]+ " " +
dataRow["label"] +" " + dataRow["wave"]);

}

}

Any assistance appreciated.

Doug