| Author: Giribabu 10 May 2008 | Member Level: Gold | Rating:  Points: 2 |
dsPersonel = new DataSet();
dsPersonel = GetDataSetFromAdapter(dsPersonel, "Dsn=IKAY","SELECT * FROM PERSONEL") ;
dataGridView1.DataSource = dsPersonel.Tables[0];
}
public DataSet GetDataSetFromAdapter(DataSet dataSet, string connectionString, string queryString)
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
OdbcDataAdapter adapter = new OdbcDataAdapter(queryString, connection);
// Open the connection and fill the DataSet.
try
{
connection.Open();
adapter.Fill(dataSet);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
// The connection is automatically closed when the
// code exits the using block.
}
return dataSet;
}
}
|
| Author: Giribabu 10 May 2008 | Member Level: Gold | Rating: Points: 2 |
fetching record from paradox db
-----------------------------------
dsPersonel = new DataSet();
dsPersonel = GetDataSetFromAdapter(dsPersonel, "Dsn=IKAY","SELECT * FROM PERSONEL") ;
dataGridView1.DataSource = dsPersonel.Tables[0];
}
public DataSet GetDataSetFromAdapter(DataSet dataSet, string connectionString, string queryString)
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
OdbcDataAdapter adapter = new OdbcDataAdapter(queryString, connection);
// Open the connection and fill the DataSet.
try
{
connection.Open();
adapter.Fill(dataSet);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
// The connection is automatically closed when the
// code exits the using block.
}
return dataSet;
}
}
|
| Author: karthekeyan 11 May 2008 | Member Level: Diamond | Rating: Points: 2 |
support.codegear.com/article/35523 -
|