|
-
Mar 23rd, 2007, 02:50 AM
#5
Thread Starter
Addicted Member
Re: [2005] getting the details of the table using Oracle
hi to all,
thank u for ur kind reply. i have used "desc tablename". but it given the error "ORA-00900 Invalid SQL statement". my code is
oledbcon = new OleDbConnection("Provider=OraOLEDB.Oracle;User Id=" + struname + ";Password=" + strpwd + "");
oledbcon.Open();
oledbcmd = new OleDbCommand("desc " + tablename, oledbcon);
oledbreader = oledbcmd.ExecuteReader();
while (oledbreader.Read())
{
cmbcolumns.Items.Add(oledbreader[0].ToString());
}
oledbreader.Close();
oledbcon.Close();
plz help me to solve the problem.
With thanks and regards
MMary
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|