This is the scenario: We store files, e.g. relatively large documents (10-300MB), in blobs in our MSSQL database.
I have this piece of code: SqlConnection conn; string strconString = System.Configuration.ConfigurationManager.ConnectionS开发者_开发技巧trings[\"SQLCONN\"].ToString();
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
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
I want to fill DataTable using DataReader. I have created object like this SqlDataReader dr = cmd.ExecuteReader();
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.
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();
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
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.
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