Programmiererforum

var c = new OleDbConnection(@"blahba");

c.Open();

var q = new OleDbCommand(@"
SELECT *
FROM @table
WHERE created = @creation
", c);

q.Parameters.AddRange(new[]{
new OleDbParameter{
ParameterName = "@creation",
Value = "2007-05-13",
OleDbType = OleDbType.Date,
},
new OleDbParameter{
ParameterName = "@table",
Value = "table",
OleDbType = OleDbType.IUnknown,
}
});

// ... ?

Wie kann ich eine Zeichenfolge mit der SQL -Abfrage erhalten, sobald Parameter in C# mit OLEDB eingefügt werden? < /p>
Hier ist mein Code: < /p>
[code]var c = new OleDbConnection(@"blahba");

c.Open();

var q = new OleDbCommand(@"
SELECT *
FROM @table
WHERE created = @creation
", c);

q.Parameters.AddRange(new[]{
new OleDbParameter{
ParameterName = "@creation",
Value = "2007-05-13",
OleDbType = OleDbType.Date,
},
new OleDbParameter{
ParameterName = "@table",
Value = "table",
OleDbType = OleDbType.IUnknown,
}
});

// ... ?
[/code]