Direct method from SQL command text to DataSet

by 
public DataSet GetDataSet(string ConnectionString, string SQL)
{
    SqlConnection conn = new SqlConnection(ConnectionString);
    SqlDataAdapter da = new SqlDataAdapter();
    SqlCommand cmd = conn.CreateCommand();
    cmd.CommandText = SQL;
    da.SelectCommand = cmd;
    DataSet ds = new DataSet();

    ///conn.Open();
    da.Fill(ds);
    ///conn.Close();

    return ds;
}

More Related Contents:

  1. How to fill Dataset with multiple tables?
  2. Why is a SQL float different from a C# float
  3. convert sql query into lambda expression [closed]
  4. C# Data Connections Best Practice?
  5. Parsing SQL code in C# [closed]
  6. SQL Express connection string: mdf file location relative to application location
  7. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  8. Query extremely slow in code but fast in SSMS
  9. DateTime format to SQL format using C#
  10. Filter sql based on C# List instead of a filter table
  11. SQLException : String or binary data would be truncated
  12. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  13. C# Version Of SQL LIKE
  14. The C# using statement, SQL, and SqlConnection
  15. C# SqlCommand – cannot use parameters for column names, how to resolve?
  16. Datatable vs Dataset
  17. Application can’t scaffold items
  18. Stored procedure return into DataSet in C# .Net
  19. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  20. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  21. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  22. Anonymous type result from sql query execution entity framework
  23. I got error “The DELETE statement conflicted with the REFERENCE constraint”
  24. problem using Oracle parameters in SELECT IN
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. Database Error: There is no row at position 0
  27. Linq union usage?
  28. Querying data using Entity Framework from dynamically created table
  29. Microsoft.Jet.OLEDB.4.0 Converting Characters
  30. Capturing count from an SQL query

Leave a Comment