I come from this question here but I have a different case. I need my result in a DataTable and I have 2 potential methods: public static DataTable SelectDataTable(string query, string ConnectionS...

Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothing(da) Then da.Fill(dt) dt.Select("GroupingID = 0") End If GridView1.DataSource = dt GridView1.DataBind() ...

I'm running into a problem similar to this question here (Display DataType and Size of Column from SQL Server Query Results at Runtime) which has not had a solid solution. I wonder if anyone has ...

I've got a short piece of code that originally created an SqlDataAdapter object over and over. Trying to streamline my calls a little bit, I replaced the SqlDataAdapter with an SqlCommand and move...

How can I use Parameters.AddWithValue with an SqlDataAdapter. Below searching codes. var da = new SqlDataAdapter("SELECT * FROM annotations WHERE annotation LIKE '%"+txtSearch.Text+"%'", _mssqlCon...

When I run my code I get the following exception: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: Execution Timeout Ex...

I want to know which one has the better performance for returning a DataTable. Here for SqlDataReader I use DataTable.Load(dr) Using SqlDataReader: public static DataTable populateUsingDataReader...

I'm confused a lot about connected model and disconnected in entity framework . I was using traditional ADO.net (DataReader for connected model and DataAdapter for disconnected model) and all I kn...

This question seems to be common and I went through this answer already. Unfortunately, my page still isn't being paged. Here's what my code looks like in C#: SqlCommand command = new SqlComman...

Is this the following code healthy? Or I don't need to use the using keyword as the SqlDataAdapter will handle closing the connection? public static DataSet Fetch(string sp, SqlParameter [] prm) {...

I have a table with primarykey in MS SQL 2005, which has a few hundred thousand records. When I query it in Management studio for a record, it brings very quickly but when i use code below to find ...

I'm working with a DAL object that is written in a layout similar to the following code. I simplified a lot of the code code just to show the setup. public class UserDatabase : IDisposable { priv...

everyone I am a student and new to .NET and specially MVC3 development but for one of my project I’ve to work over it and so going through the learning phase Issue and confusion I am facing is rega...

Which one would be better in executing an insert statement for ms-sql database: Sql DataAdapter or SQL Command Object? Which of them would be better, while inserting only one row and while in...

I do not clearly understand how to format the SqlDataAdapter for output variables when working with C# Error Message: Index (zero based) must be greater than or equal to zero and less than the size...