//public static dataset getdatafromhash(string command)
public static DataSet GetDataForQueries(string command)
{
//string connStr = m_ConnectionString;//.Substring(pos, m_ConnectionString.Length -pos - 1 );
//string connStr = @"Data Source=PC-500772\SQLEXPRESS;initial catalog=test1;user id=sa;password=1212;multipleactiveresultsets=True;App=EntityFramework"Provider=SQLOLEDB";//in shyam pc, the connection is:@"Data Source=EC2AMAZ-FJGKIU7\SQLEXPRESS;Initial Catalog=NituritNew;Persist Security Info=True;User ID=sa;Password=3Frtgh2; Provider=SQLOLEDB;";
DataSet dataSet = new DataSet();
//int pos = m_ConnectionString.IndexOf("DSN");
string connStr = m_ConnectionString + "Provider=" + provider + ";";
using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(connStr))
{
string queryString = command;
OleDbDataAdapter adapter = new OleDbDataAdapter(queryString, connection);
connection.Open();
try
{
//adapter.SelectCommand.CommandTimeout = 999999999;
File.AppendAllText(@"C:\Carmel\logs\logUpload.txt", "before adapter.Fill ::Date : " + DateTime.Now.ToString() + "Query name: " + command + Environment.NewLine);
adapter.Fill(dataSet);
File.AppendAllText(@"C:\Carmel\logs\logUpload.txt", "after adapter.Fill" + Environment.NewLine);
}
catch (Exception ex)
{
File.AppendAllText(@"C:\Carmel\logs\logUpload.txt", "Error happened while open connection to db" + Environment.NewLine + "commend: " + queryString + Environment.NewLine + "conString: " + connStr + Environment.NewLine + "conn: " + connection.ToString() + Environment.NewLine + "ex: " + ex + Environment.NewLine);
EventManager.WriteEventErrorMessage("Error happened while open connection to db", ex);
}
connection.Close();
}
return(dataSet);
}
