private const string CONNECTSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data source =";
private string dbName;
private string connectString;
public int InsertDatatoDB(string sqlCommandString)
{
int flag = 1;
OleDbConnection myDBObj = new OleDbConnection();
OleDbCommand command;
connectString = CONNECTSTRING + dbName;
try
{
myDBObj.ConnectionString = connectString; // Initialize
myDBObj.Open(); // Open DB
command = new OleDbCommand(sqlCommandString, myDBObj); // Set the command
command.ExecuteNonQuery(); // Create new table
}
catch (Exception ex)
{
flag = 0;
}
finally
{
myDBObj.Close(); // Close it
}
return flag;
}