sqldatareader
How to make streams from BLOBs available in plain old C# objects when using SqlDataReader?
This is the scenario: We store files, e.g. relatively large documents (10-300MB), in blobs in our MSSQL database.[详细]
2023-01-29 09:55 分类:问答c# closing sqlconnection and sqldatareader or not?
I have this piece of code: SqlConnection conn; string strconString = System.Configuration.ConfigurationManager.ConnectionS开发者_开发技巧trings[\"SQLCONN\"].ToString();[详细]
2023-01-29 04:57 分类:问答Does SqlDataReader have an equivalent to Get*(int index) with a string key?
I\'m trying to use a SqlDataReader (I\'m quite aware of the beauty of Linq, etc, but the application I\'m building is partly a Sql Generator, so Linq doesn\'t fit my needs).Unfortunately, I\'m not sur[详细]
2023-01-24 04:19 分类:问答SqlDataReader [0] is empty
I\'m wanting to display the first row of a SqlDataReader (its the only row/column the database returns) in a text field. I thou开发者_如何学JAVAght this was the correct syntax but i get \'no data\' er[详细]
2023-01-23 03:24 分类:问答How do I fill a DataTable using DataReader
I want to fill DataTable using DataReader. I have created object like this SqlDataReader dr = cmd.ExecuteReader();[详细]
2023-01-23 03:06 分类:问答Converting SQLDataReader to String in VB.Net
I am returning one row from the database, and I want to convert the SQLDataReader to a string format, so I can pass it to my webservice.[详细]
2023-01-22 18:50 分类:问答Read data from SqlDataReader
I have a SQL Server 2008 database and I am working on it in the backend. I am working on asp.net/C# SqlDataReader rdr = cmd.ExecuteReader();[详细]
2023-01-22 03:13 分类:问答Retrieving DropDownList 'value' (C#/ASP.NET)
On my page, whenever a DetailsView is updated, I must audit the changes into a database. On most pages this works perfect, as there were just textboxes - however on a page I am working on right now, w[详细]
2023-01-21 14:00 分类:问答Does boolean.ToString() behave differently between .NET 2.0 & .NET 3.5
I\'ve inherited a piece of code at work and I\'ve just noticed a fairly trivial but bizarre little quirk with it. So maybe someone can save me setting up clean .NET 2.0 Environment to test it out.[详细]
2023-01-16 22:40 分类:问答Is SqlDataReader.GetValue query dependant?
In my code I have a Query like this SELECT id,name FROM people I retrieve datas using a sqldatareader. If I change my query for[详细]
2023-01-16 19:27 分类:问答