//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); }