Hi vs2005 beta2. I have created a sql server data file from within vs. Is there any way to import existing access tables & data into the sql server datafile? I have tried installed sql server 2004 developer from msdn but did not see any enterprise manager type tools that come with sql serve...more >>

In VB6, if you clone a recordset you get a ptr to the same recordset with 2 different cursor positions. If the original recodser had 100 records then the clone had 100 records. This doesn't seem to be the case in .Net datasets. It appears that clones only copy the schema. how can I get a cop...more >>

I have a dataset with a currencymanager. On My MoveNext button click I want to show each fields value in that datarow. It seems like it should be very simple but I can't figure this out.... -Lou 'Create a DB Dim custDS As DataSet = New DataSet("CustomerOrders") 'Create a Table Dim...more >>

Hi ! I created a Dataset class based on a XML schema using the wizards of VB.Net. up to now everything is clear. I would like to add/delete/edit data in it using a dialog box showing the fields of one of its row. Therefore I need to pass this row as a parameter to the dialog box. Quite...more >>

How do i navigate a datse?? 'Create a DB Dim custDS As DataSet = New DataSet("CustomerOrders") 'Create a Table Dim ordersTable As DataTable = custDS.Tables.Add("Orders") Dim myDataView As DataView 'Add columns(Fields) Dim pkCol As DataColumn = ordersTable.Columns.Add("OrderID", ...more >>

How do you do a MoveNext, movePrevious,MoveFirst etc in VB.Net with Datasets??? ...more >>

Hi I want to add a commanf button to a vb.net data grid for a windows application. Is this possible? thanks jonathan =============== Jonathan Crawford 01273 440018 07799 068570 fax 01273 380221 jc@jcrawford.co.uk =============== ...more >>

From: chris_hughes4@hotmail.com (Chris Hughes) Newsgroups: microsoft.public.dotnet.datatools Subject: Data Source Help Needed! Date: 26 Oct 2004 04:33:14 -0700 Hi I am trying to do a walkthrough on Visual Studio 2005 Beta 1. The Walkthrough in question is: Displaying Formatted Data in Web...more >>

From: "=?Utf-8?B?WlM=?=" <ZS@discussions.microsoft.com> Subject: URGENT ..Please Help Date: Wed, 13 Oct 2004 11:19:02 -0700 Newsgroups: microsoft.public.dotnet.datatools Hi, I'm new to the VB.net environment. We are currenty converting a MATHLAB project into a .NET application. I want to ...more >>

From: =?Utf-8?B?QmlsbCBCcmlua3dvcnRo?= <BillBrinkworth@discussions.microsoft.com> Subject: vb.net 2003: displaying multiple records Date: Fri, 8 Apr 2005 17:19:03 -0700 Newsgroups: microsoft.public.dotnet.datatools it's would be simple in Access, but seems to be harder in VB. I want to e...more >>

I have the function below that calls a stored procedure and returns the result. The stored procedure basically moves product from one place to another. This does not return any error message, but it is not working either. I stepped through the code and took the values and called the stored p...more >>

I've got 2 different web pages, both updating the same SQL database. One is for the Technician and one is for the Manager. The technician's update page works fine but the Manager's update page doesn't. They are both the same..as far as I can tell... --------------------- This code works fi...more >>

I need to be able to read a row of SQL data into variables instead of filling a datagrid. Are there any good examples on how to do this? I want to be able to edit the data and then update the row based on @@Identity. Thanks. ...more >>

Hi, In VB .NET, I am using the DataSet WriteXml method to create a XML file to send over the Internet. This XML file has to comply to an external schema on which I have no control. My problem is that the WriteXml method leaves attributes with empty values (eg: adr_2="") which are not allowe...more >>

Hi We have an access app (both front & back ends are in access) that runs over win server networks. There are now more and more users who would like to take away a copy of app with them, work offline, and when they come back expect the client copy to sync (both ways) with the server copy. Seem...more >>

Hi! I have existing web apps that was developed under ASP. I use form authentication by querying to a database if the user is allowed to use the application. I have read that ASP.NET is much easier to manage this kind of security. Can you help me with this? Me ...more >>

Hi Everyone, I have a database table that have 4 field( C1, C2, M1, M2) on my form i have two combo box ComboC and ComboM C1 C2 M1 M2 1 Sales 1 Monthly Terms 1 ...more >>

I've read numerous articles and surfed the newsgroups for how people are managing their ADO.NET connections. What I've seen is 50% say keep the connection open and close at some later time to avoid potential problems of rapid open/close situations. The others 50% say close the connection as ...more >>

Hi, I should use XML to synchronize the data from different (VB.NET) applications, and I was just wondering which Overloads of these functions ( ReadXmlSchema, ReadXml and WriteXml) goes the fastest? I don't think the ReadXMLSchema would give a lot of difference, but maybe the overlaods of Re...more >>

Hi, I'm converting an existing Access application to vb.net 2003. The application allows users to select a number of tables from an ODBC data source, and nominate names for each table to use in a local access table. When they press the button, it deletes any local tables that exist and r...more >>

I have a application that connects to an access database. I need to insert an item into one of the tables and immeditely retrieve the value from the autonumber field so that I can use that value into a record in another table. I've tried using a simple INSERT command followed by a querie t...more >>

I have to take a downloaded CSV and based on data in certain lines, I have to put the data into a SQL Database. I also have to compare it to some information in another SQL table, and if it matches, set a bit flag to on... My question: is there a way in VB .net 2003 to open a CSV into a D...more >>

Does anyone know how to rename an Access table in VB.Net with OleDb. For instance, this does NOT work: cn = New OleDbConnection(ConnectionString) cn.Open() sql = "ALTER TABLE Test1 RENAME Test2" cmd = New OleDbCommand(sql, cn) cmd.ExecuteNonQuery() Thanks, Tommy ...more >>

Hi! I have installed VB.Net 2003 on my computer and develop a simple web application. I want to publish the project that I made to our production server. How can I publish a web application? regards, Me ...more >>

Visual Basic 2005 has many new and improved language features, including generic types, operator overloading, compiler warnings, partial classes, mixed access properties, unsigned data types, and more. Join members of the Visual Basic team (Paul Vick, Amanda Silver, Alexandre Moura, Corneliu ...more >>

I'm developing an app with .NET and connecting to my Paradox DB via ODBC and OLEDB SQL commands/readers. I'm having trouble trying to read a BYTE type field and I can't seem to read the encrypted data inside it. I'm passing the field data from a BYTE from a Paradox source into a BYTE field type...more >>

Hi, I have an application that has a "Data Access Class" and "User Interface Class". It is for receiving Purchase Order data from one system and pushing processed transactions to another system. The system generally works quite well. Currently the User interface calls for a refresh of data...more >>

Is this possible? On ASP, I just inser application mime before I display on screen. How about on ASP.NET? ...more >>

Hi All I wish to load a HTML page into the webroswer control and display it on a form. I am using the "navigate2" function to load the file into the webpage. The html file is storted in the bin folder of the visual basic soloution. I have used a full file path e.g. "c:\web\bin\file.html" ...more >>

I use the following code to open up a form. ------------------------------------------------------- If fImage Is Nothing Then fImage =3D New frmImage End If fImage.Show() ------------------------------------------------------- It works the first time, but when the form i...more >>

Is it possible to bind the datagrid with more than one datatable In my application there are two tables which has got a parent child relationship, what i need is to show the record of the parent and its related record in the child in the same row Thanking in Advance ------------------------------...more >>

Hi! I have created a sample datagrid that can update data on a database. Please help me solve the problem, I have attached both aspx and code behind (aspx.vb): ______________________ datagrid.aspx <%@ Page Language="vb" AutoEventWireup="false" Codebehind="DataGrid.aspx.vb" Inherits="v...more >>

Hi all... I'm trying to retrieve a SQLXML query using VB.NET. When I programmed in VB 6.0, I used Stream object to accomplish this which was trivial. I cannot do the same thing in VB.NET. Here the most similar object is the OleDbDataReader. I have the following method, ¿is it correct what ...more >>

i've a web page that loads the entire cust record tbl to simulate a auto fill during data entry this works great when tot cust recs < 1500, going over the 1500 numbers the conescute page loads take several seconds. that is the user must wait few seconds before the next page appears and the...more >>

Experts: I'm trying to find a way to display rows of data as they are created in a form object, but DatGrid appears to need a database or ADO connection of some sort to fill this role. The data will always be 'read only', so edit mode not needed. My data is not coming from a database, but r...more >>

I keep receiving an SQL error. Not everytime but frequently. Does anyone know what to problem could be? This is the error i recieve: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and ...more >>

Has anyone done this yet? I know it is easily done in Paradox, but I would like to do it in VB.Net. Can anyone point me in the right direction? Thanks, Rog ...more >>

Hi! I use OleDbDataAdapter to create connection and when I select "Generate Dataset from that, I receive an error message saying : "There was problems generating <project>.Dataset1. To resolve this problem, build the project, fix any errors, and then generate the dataset again." I have do...more >>

Hi, I am trying to write a program as part of some coursework. I have two list boxes. The selection in one will use the selection in another. Plus there is a calculate button that will calculate a result. Where does the sub for the list box selection go? before or after the sub for the butt...more >>

Lately we've seen a number of developers asking (begging) MS to do something about a better lightweight datastore. Mostly the words are "a Jet replacement" because supposedly MS depreciated Jet recently but more because the longtime tradition is to believe that Jet is beneath us all, even tho...more >>