Ms Sql connection error

Comments

• ipong

  March 2018 edited 8:24AM

  code please.... .net core and .net framework use same syntax
  

  string connection = @"....";
  using (SqlConnection cnn = new SqlConnection(connection))
  {
      cnn.Open();
      using (SqlCommand cmd = new SqlCommand("SELECT * FROM Data", cnn))
      {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
              while (dr.Read())
              {
                 ...
              }
          }
      }
  }
  
• Mohamed Gahlan

  March 2018 edited 8:24AM

  I work with entity framework, and this error also happen if connect to sql directly from report designer and pass report file to web report while preview in designer work fine.
• Mohamed Gahlan

  March 2018 edited 8:24AM

  code:
  
  var Model = new WebReport();
  Model.Report.Load("Reports/SQLReport.frx");
  return View(Model);
  
  report file in attachment
• ipong

  March 2018 edited 8:24AM

  are you using mssql connection embedded in frx file? delete it!
• ipong

  March 2018 edited 8:24AM

  are you using mssql connection embedded in frx file? delete it!
  
  remember, report designer uses .net framework, and your web app uses .net standard (core) library
• Mohamed Gahlan

  March 2018 edited 8:24AM

  do you mean Delete all Dictionary childs nodes from frx file or just delete MsSqlDataConnection node and let it's childs?
• ipong

  March 2018 edited March 2018

  just mssql data connection.