How do I do this and get a table schema instead:
Oledbcommand cmd
Oledbconnection conn
if (sp.Checked) {
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = target.Text;
conn.Open();
OleDbCommandBuilder.DeriveParameters(cmd);
conn.Close();
MessageBox.Show(cmd.Parameters.Count.ToString());
for (int i=0; i<cmd.Parameters.Count; i++)
myMessage += cmd.Parameters[i].ToString() + "\n";
MessageBox.Show(myMessage);
}
I can't make heads or tails of a DataTable.
thx
md
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!