ADO.NET

Hi I am developing an app in vb.net 2008 with sql server 2000 backend. I also need disconnected version of the app for laptop users who would connect off and on with LAN and thereby with the company sql server 2000. I am wondering ...

We do a FOR XML query using SQLXMLReader.ExecuteXMLReader() method. The results is obtained in a XMLReader. We then load XMlDocument using XmlReader as we have to process the XML. When we try to fire a query which returns  huge data, the query executed by ...

Hello, When I build a DataSet with the DataSet Designer (DataSet.xsd) every DataTable has the property "Locale" which is set (I guess) to the current collate of the table of the SQL Server (I'm using MSSQL). I want to build a ...

This is probably a Newbie question, but your response would be appreciated. Using VWD I have a GridView on a page.  The GridView is feed data by accessdatasource1. I can filter the data using:             Parameter Param = new Parameter("Sex"); ...

I wrap two updates from different tableadapters in a transactionscope. They are connected to the same databese. By runing the program I get an error message: Communication with the underlying transaction manager has failed. Error HRESULT E_FAIL has been returned from a call to a COM component. ...

Hello to all, I would like to inserts/delete some records from a table and Update the DataAdapter at the end of all the operations. The problem is that I would like the intermediate changes to be visible in the User Interface (i.e. ...

So, VS2008 is now available ([link]). One thing I'm now wondering about is how much sense LINQ makes. I've been reading of all the advantages of stored procedures: more secure, more efficient, and better organization of code associated with a database. ...

I'm still trying to get a handle on ASP.NET and ADO.NET. Since there is a bit of code involved in executing a procedure, I thought I'd stick it in it's own routine. So I tried the following. I was able to determine this does not work ...

I have a book called "Hitchhiker's Guide to Visual Studio and SQL Server".  It has a chapter on using dataAdapters, and another chapter on using tableAdapters.  The problem is, they seem to overlap in what they can do, and I don't know when I would use one and when I would ...

To run an example from ADOnet 2.0 SBS 2005 edition, I opened a web site from File System (Microsoft Press folder).   I can review the Design and Source tabs; however, running an example program, e.g. Chap 14-Finished, showed the ...

Hi, Please find the requirement below and answer ASAP with updated resume and contact details.... ---------------------------------------------------------------------------------------------------------------------------------------------------------- TPVS Consultant (Transportation Planning and Vehicle Scheduling) Location: Colorado Duration: 4 + Months Rate: Open ********US Citizens only************ We need a very senior and experienced TPVS resource. ...

How could I get a column size from a datareader or a datatable?  We're moving from VB6 where the code looks like this:  rcs.Fields(i).Size (rcs is a recordset). Thank for your help Vanny ...

Hi, I have tried your solution on my project. There are four tables in sql server 2005 express, that form a tree (table1 has foreign key to table2, table2 to table3, and table3 to table4) Firstly, I insert into table4, then table3, table2 and last table1. But when inserting into table1, trouble arise as it stated time out ...

Hi, I have tried your solution on my project. There are four tables in sql server 2005 express, that form a tree (table1 has foreign key to table2, table2 to table3, and table3 to table4) Firstly, I insert into table4, then table3, table2 and last table1. But when inserting into table1, trouble arise as it stated time out ...

I have a databound gridview. How do I skip a row if a certain condition exists?  (In VB.NET) For example...     Protected Sub GridView2_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles ...

I am looking at Linq2Sql in VS2008 and have run into a couple of things : <Short Version>     1 - Linq To Sql designer has problems with multi-level namespace.  View Code generates error "The name SimpleNS.SubNS is not a valid identifier. ...

Dear All, is it possible to extract the DataColumn which is a foreign key of another table. foreach (DataRelation dr in dsIlce.Tables[0].ParentRelations) { Console.WriteLine("123"); console.WriteLine(dr.ParentTable.TableName.ToString()); } prints nothing unfortunately.. thanks in advance ...

Does anyone have a good example of using the Query Object Pattern?  My GetMember() method is going to receive a MemberDataModel object which is basically all the fields in the table.  Any one of the fields could have a ...

Hi I need to start a new win form project and I am wondering if I should choose 2008 at this stage. My questions are following; 1. Is 2008 much different from vs 2005 in terms of skill set to prohibit ...