Hi!, I have the following code for my Dataview which doesn't work: Any suggestions... Dim dv As DataView dv = New DataView With dv .Table = TestTable .AllowDelete = True .AllowEdit = True .AllowNew = True .RowFilter = "Column1 = Select Column from AnotherTable" 'I hav...more >>

I have a table of product orders. It contains a row for "platform" and I need to return how many times each platform is listed in the DB Example data for platform could be: XBOX XBOX XBOX PLAYSTATION PLAYSTATION GAMECUBE PLAYSTATION I'd like the data to be returned as XBOX - 3 PLAY...more >>

Hi, How do you maintain sessions (that contain data) in ASP.NET applications? 1) In memory on the web-server? in this case how do you handle multiple requests from the same session which may be routed to different machines via a load balancer? 2) Is this database? If so, do you have to f...more >>

A few months ago, a good friend of mine starting using LLBL gen to generate data access code. He's are very hard core ADO.NET developer so I was kind of surprised when he told me he really liked it. I decided to give the whole ORM thing a try and found that it was surprisingly good. However, LL...more >>

Hello everyone, I have a question about SQL connection strings. I have a VB.NET application where the user enters in a name and password into 2 text boxes: txtName and txtPass, respectively. I have 2 variables that takes any input from txtName and txtPass and puts them into two variables: s...more >>

I have a stored procedure that is hanging when executed from VB.NET. If I "exec spName parms" from query profiler, it zips right along. When calling the DataAdapter.Fill method, it will hang, and errors out with the error "Timeout has expired". The stored proc is as follows: ALTER PROCEDU...more >>

I'm using the OleDBDataAdapter and a Typed dataset in a databound form in C#. The database is Access and the table contains a date/time field. The database data already exists and the date field has both a date and a time (e.g. 4/1/2004 12:47:29 AM). If I include the date field when I configu...more >>

How i know the size of "resultset"? OleDbCommand cmdPerson = new OleDbCommand("{call PackPerson_JamesTest.allPerson_JamesTest({resultset 4, ssn, fname, lname})}", cnOra); ...more >>

How do I prevent an apostrophe or double quote copied from Word and pasted into a textbox on my webform from being converted to upside down question marks in my database? I set the content type of the page with <meta http-equiv="content-type" content="text/html; charset=UTF-8"> - but this do...more >>

I am writing an Image to SQL and can use the code below to accomplish the streaming. However, I need to write an Image that exists in memory. I don't want to save it to disk just to re-load and stream it. Suggestions? Use MemoryStream() somehow? Dim fs As FileStream = New FileStream(fileNam...more >>

and returning the xml to the requesting web page, how do you insert the XML declaration? ds.EnforceConstraints = False Response.ContentType = "text/xml" ds.WriteXml(Response.OutputStream, XmlWriteMode.IgnoreSchema) I would like to add <?xml version="1.0" ?> to the top of the response...more >>

Why doesnt DataTable have a HasChanges method (DataSet does)? I assume I can write one easily but i dont see why there is none. Also I dont understand why there is no event on DataSet for HasChangesChanges ...more >>

hi, i dont't know if it can be done, i want to write and read a xml file from a client side. I 've done this code: ------------------------------------- Dim ds As DataSet ds=filldata() ds.WriteXml("c:\data.xml") ...... ...... ds.ReadXml("c:\data.xml") ------------------------------------...more >>

Hi, I have a DB-table 'AirplaneTypes' that has to 2 fields that form the primary key : 'at_name' and 'at_model' both in the DB defined as type : char 15 MyWinform client : void Form_Load(...) { // m_dsAirplaneTypes1 is the DataSet DataTable myTable = m_dsAirpla...more >>

Hey Group, Sorry but i`ve been searching everywhere for this even went out and bought a ADO book and still carn`t find what im looking for:( I have the following code for my postion changed: Private Sub objdsAccess_PositionChanged() If Me.BindingContext(objdsAccess, "Users").Position ...more >>

Hi, When i try to connect to oracle from my vb.net application i am getting following error "Unable to find entry point named OCIEnvCreate in Dll oci.dll" I tried to connect using Microsoft .Net Data Provider for oracle. The connection string is "Server=pcname;uid=username;pwd=password;" ...more >>

(This is a repost, I got in trouble for not posting it here first.) What is the most efficient way to perform a filter on a DataTable and then have a new DataTable with only the rows matching the filter? The only thing I can think of is the following: 1. dataTableNew = dataTableOld....more >>

Does anyone know how or have an example of Reading & Writing Blobs using stored procedures? I need to use stored procedures to eliminate granting user access rights to tables. Thanks Bob...more >>

I have a dataset that I have used the .FillSchema method to add an empty copy of the underlying structure of an Access table. I use an OledbCommandBuilder to generate the INSERT, UPDATE, statements I then add quite a few records to the empty datatable within the dataset. This works fine But whe...more >>

Hello! I'm trying to write a VB.NET program that connects to a AS/400 Server. I've tried almost everything, but it will not connect. I've tried to set up a DSN using the Client Access ODBC-driver (v8.00.04.08) but with no result. I've also tried a DSN-less connection. From VB.NET i'm using o...more >>

Hi My english is not perfect... I create a simple form by the Data Form Wizard. In last window of Data Form Wizard I chose display style "Single record in individual controls". After compilng the code my application works fine. Next I add a DataGrid control to my form generated by the Data Form...more >>

What would cause the xml in this example to fail when loaded into a dataset Changing the childnode '<a>' under 'node2' to something else fixes the problem, but I really need to understand why this happens, although the two '<a>'s are under different nodes <Body - <node1><a>1</a><b>2</b></node1 ...more >>