Hi,
I have a simple problem. All I need is a simple program that provides only tableName from Northwind Database.
What SQL Query should I write.
In the following code, I need to provide tableName (so that I can get DataSet object. I need to get a new tableName from
Northwind database at every iteration and pass the tableName to this method.
I need help.......
/****************************************/
private DataSet ReturnDataSet(tableName)
{
DataSet dataSet = null;
string sqlStatement = "select * from " + tableName;
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionInfo))
using (SqlCommand sqlCommand = new SqlCommand(sqlStatement, sqlConnection))
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, tableName);
}
}
catch
{
//Log the exception.
}
return dataSet;
}//End ReturnDataSet
Sanjeev
Loading
GaneshPosted Jan 19, 2007, 5:58 PM
[table_name] from information_schema.tables where table_type = 'BASE TABLE'select
connect to northwind database by proper connection string
run the above query