Developer Newsgroups: ADO.NET

Install SQL Server 2005 Express With ClickOnce?

Octavius Khan - 20 Oct 2007 4:30 PM - 2 messages

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 ...

Ajax enabled page

Mike TI - 20 Oct 2007 8:07 AM - 2 messages

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 ...

Obtaining column properties in .NET

schneider - 19 Oct 2007 10:01 AM - 5 messages

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 ...

ReadXML error

vovan - 18 Oct 2007 10:54 PM - 3 messages

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. ...

vs 20028 when??

John - 18 Oct 2007 9:58 PM - 27 messages

Hi When is vs2008 due out? Many Thanks Regards ...

Reading a XLS file with a embeded combo

Ezequiel - 18 Oct 2007 9:56 PM - 1 message

Hi, I´m trying to read a xls file which one colum has a combo to select the value. The value is linked to the cell below the combo, however in certain columns the ado.net returns null value instead of the value selected. ...

Data Type 'Image' is missing from the development environment for

rkbnair - 18 Oct 2007 9:11 PM - 4 messages

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 ...

ComboBox loads slow

0to60 - 18 Oct 2007 5:29 PM - 5 messages

I am noticing that it seems to take windows a long ass time to paint a ComboBox control that has say, 32000 items in its dropdown. Yes, I know that's a lot. However, I have a VB6.0 application that uses DAO to access ...

Filtering DataSet with Multiple Tables

Maspr - 18 Oct 2007 3:14 PM - 2 messages

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 ...

How do I merge tables in ado.net

PO - 18 Oct 2007 1:24 PM - 7 messages

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 ...

QueriesTableAdapter does not appear in toolbox. Why not?

HONOREDANCESTOR - 17 Oct 2007 8:43 PM - 2 messages

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 ...

SQLBulkCopyOptions with Default values

Beth - 17 Oct 2007 3:18 PM - 3 messages

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 ...

dbType 'Image' not available in the data adaptor window for CE

rkbnair - 17 Oct 2007 2:46 PM - 3 messages

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

Cross network Access db connection problem

Julia B - 17 Oct 2007 1:14 PM - 3 messages

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) ...

adapter.Update question ??

calderara - 17 Oct 2007 10:40 AM - 1 message

Dear all, I have an application sQL statement which call an SQL view. The return dataset from the View is bind to a WinForm datagriview control. From this datcontrol, data can be edited and updated. What I woul like to get is that this modification goes back to the View at ...

Stored procedure name in config file?

Gustaf - 17 Oct 2007 9:04 AM - 2 messages

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: ...

Timeout expired on Insert

Sandhya Kumar - 16 Oct 2007 7:22 PM - 8 messages

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 ...

How to Provide Unique Key Values During DataContext.SubmitChanges

Benjamin - 16 Oct 2007 6:38 PM - 1 message

I am using Visual Studio 2008 Beta 2 and investigating various aspects of LINQ. I used the LINQ to SQL designer to derive a new DataContext class with some entity classes, and am overriding the behavior of SubmitChanges and ...

stored procedure times out after 10 minutes

vb4me - 16 Oct 2007 5:25 PM - 3 messages

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. ...

"@p5 : Byte array truncation to a length of 8000."

rkbnair - 16 Oct 2007 4:02 PM - 12 messages

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. ...

UTF32 and XML Datatype

Evan Camilleri - 16 Oct 2007 11:41 AM - 2 messages

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 SqlParameter x = new SqlParameter("@xmlX", SqlDbType.Xml); (i tried Text or Ntext in vain !!) ...

The DataTable / DataSet size

Lubomir - 15 Oct 2007 9:05 PM - 10 messages

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. ...

Microsoft.Naming : 'Id' is an abbreviation and

Just D. - 15 Oct 2007 6:51 PM - 2 messages

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 ...

Simple Type Element of Strongly Typed DataSet MIA

gr8brain - 15 Oct 2007 5:51 PM - 6 messages

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 ...

Memory Leak Caused by Using DataTable.Select

Tristan - 15 Oct 2007 11:49 AM - 13 messages

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 ...

Change Order of Events

Randy - 15 Oct 2007 6:44 AM - 2 messages

Hi, I have an odd issue with the MonthCalendar control. I need to capture certain mouseeventargs, which I can only do in the MouseDown event. I need to pass these arguments to the DateChanged event to make the ...