Hello, I am currently working on a project which will run in an environment, where the size of the database is very limited. That's why I thought about relying in some parts entirely on xml files (and datasets) as an DB replacement. I.E.: DataSet myDataSetToRead = new DataSet...more >>

Is it possible to install SQL Server 2005 Express on a machine that restricts installs by using ClickOnce? For example, I can't install new applications on my machine at work unless I use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in my applications and move away ...more >>

Oct 20, 2007 01:00pm Hi all When you create an Ajax enabled web site, the application creates the default page with a "Script Manager". I created a Master Page. I then created a "Home" page with reference to this master page. As I wanted this Home Page to come first I added the foll...more >>

Hi all, I want to obtain column properties using C# and the System.Data namespace. Using DbDataReader.GetSchemaTable() or DataAdapter.Columns I only retrieve properties like DataColumn.MaxLength or DataColumn.AllowDbNull in a correct fashion. But if I want properties like DefaultValue or cert...more >>

I'm using DataSet.ReadXML method to populate the dataset with data from XML file. If one of the values contains apostrophe (for instance: It's something) then an error occures: System.Xml.XmlException: Invalid character in the given encoding. Is this a bug or what? I wouldn't want to parse an...more >>

Hi, I'm fairly new to ado.net and I'm not sure I'm doing this in the best way... I retrieve two tables from two different databases and place them in a dataset. Both tables have a column which relates them. The relation type is one to many. I use a custom procedure to "merge" the two tabl...more >>

Please disregard my previous post for the same problem. the posting was incomplete. I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the follo...more >>

I have a DataSet with 3 tables. I need to be able to filter the parent table and get all records from the 3rd level table that correspond with it. I have relations set up between the parent and first child and also the first child and it's child tables. However, when I filter the top level tab...more >>

I created a stored procedure called AddOrder which does an 'insert' statement. It appeared in the Server Explorer of Visual Studio. Then I dragged it to the Dataset Designer. This makes a QueriesTableAdapter, which I do find in the diagram when I "Edit Dataset in Designer". The problem is tha...more >>

Hello. I'm changing my code which copies data from memory to a SQL Server from using a data adapter's update method to using the writeToServer method of the SQLBulkCopy object. The update method of the data adapter worked fine, but I expect the SQLBulkCopy to perform better. The probl...more >>

How come there is no dbType='Image' available in the data adaptor parameter types? Please find the atta -- test...more >>

Hi I wonder if you can help me. I've got an asp.net (version 1.1) intranet application that connects across a network to an access backend db. The backend db is on a directory where everyone (including the ASP.Net account) has full access (not sure if that's the right way to go about things...more >>

Hi all, I'm building a Web Service to INSERT records into an Oracle DB. For this I'm using a DataSet (.xsd) with a QueriesTableAdapter, to call a stored procedure for inserts in the Oracle DB. The connection string is stored in a configuration file (Web.Config) like so: <connectionStrings> ...more >>

Hi, We have a huge table having around 29579242 Rows.The table is huge and there is no clustered index on the table. There are a couple of non-clustered indexes. We have started experiencing these errors. We increased the command timeout to 120 (2 minutes) but the error isstill occuring on...more >>

I need to add a UTF32 xml file to an XML datatype (basically I want = unicode characters in there) is it possible? When I do=20 SqlParameter x =3D new SqlParameter("@xmlX", SqlDbType.Xml); (i = tried Text or Ntext in vain !!) testclass t =3D new testclass(); t.Age =3D 32; t.Fir...more >>

Hello. Can anyone help with this one? I've written an app that queries data on two linked servers (sql server 2000). The stored procedure runs fine when I 'exec' it in management studio, but it times out when launched from VB2005. The funny thing is it worked last week - I'm just not sure wh...more >>

I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter correspon...more >>

I've done some googling on this one, but I'm not sure how to phrase the search. Any help is greatly appreciated. The problem is I have an xml file coming from a non-.Net source that I'm trying to load into a strongly typed DataSet. I've created the schema and then the DataSet from there. He...more >>

Hi, We do ADO.NEt programming only on the time-to time basis, so we don't have the real deep experience in this matter. Every where in MSDN or other documentation I can read that DataTable/DataSet is designated to keeping disconnected data from a database. So far, so good. But I have nev...more >>

Maybe it's FAQ, please point me to the Internet link if it's so. Do we have any way to disable this warning (below) in VS2005 when we do the code analysis? Microsoft.Naming : 'Id' is an abbreviation and therefore is not subject to acronym casing guidelines. Correct the capitalization of 'ID'...more >>

Hi, I have a DataTable object and need a subset of the rows at runtime so I perform a DataTable.Select on it to retrieve an array of DataRows. I am using this over the DataView/Filter approach as it performs slighltly better in my application. The problem is that the returned DataRow array ...more >>