Hi, I would like to know which technology is the fastest one for reading a MS Access DB. In the past i used a lot of time DAO and I'm used to noz, however, I've read that OleDB is faster tha DAO... so in which way is it fastest ? I tried to used it and what I see it's that it asks more lin...more >>

Is it possible to run a single query that pulls data from multiple tables in multiple databases, perhaps also from multiple SQL Servers? Any input would be appreciated. Thanks! RichardF...more >>

I am attempting to create an application that will pull inventory data from a database. One thing I would also like to do is add a picture box to the window. We have the file path to all the imags stored in the database (ex. "/images/case1.gif" ) How would I bind this image box to the database...more >>

This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C4D6F2.3D1EE0C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi I need some help with Stored Procedures in Access. Can I do them like MS SQL Server? I need to update some data and ...more >>

Sorry for posting a long post, (the code) but, I am having a problem copying one data table to another new table in another Access database that has the same table schema. You will notice that I do not list exact column names etc. because this routine needs to be generic so I can use it to copy...more >>

Hi, I would like to know how can i get the table structure (fields name) from MS access DB ? thanks a lot, Maileen...more >>

Anyone know how to ... make a user control property that shows up in the property pages and allows one to select a value from a set of values ? like a combobox for example ? ...more >>

Try to create a new windows form app named prn and you will get this error --------------------------- Microsoft Development Environment --------------------------- Projects and solutions cannot be named '.' or '..', nor can their names contain any of the following characters: / ? : & ...more >>

this code seems to be causing an error, can anyone help me Dim rstLoad As New ADODB.Recordset rstLoad.Open("SELECT * FROM recept") <------------------ERROR Do Until rstLoad.EOF ListView1.Items.Add(rstLaod.GetRows) rstLoad.MoveNext() Loop rstLoad.Close() ...more >>

I use access file for database. in one table I have column with number (decimal 18,2) type. When I modify data manually it work file. But when I write data using program made in VB.NET (oledbCommand) thought parameter I have problem with decimals. 20,00 work fine but 2,20 writes like 22. Why? Th...more >>

I have a stored procedure with an input parameter declared as numeric(15,2) .... what would be the best way to declare it for an SQL Param, like below? New SqlClient.SqlParameter("@SpclHndCode", SqlDbType.Float, 0) The obvious choices seem to be float, decimal or money...any suggestions on ...more >>

Hi, I can't find info on how to include an executable copy (I guess that's what it should be) of an Access database in the solution's build. The solution contains 1 windows application project. Do I include the .mdb as a file somehow? Should I have created a database project? Appreciate any he...more >>

Hi Guys Could someone be so kind as to look at the following sqlstatement and tell me why i keep getting exceptions?... I'm going crazy... I cant get the syntax down for the datediff function in the sqlStatement. Everything works when I delete the dateDiff Function from the statement ( but no ...more >>

I would like you to help me ... I'm a beginning vb.net programmer and I need an advice ... I'm creating a DB application and I need to read data from the Access table with MS Jet 4.0 into Listview (nead to get 2 columns from the table) and into the treeview (I need to get there the list of tables...more >>

Could any one help? "myDt" is used throughout the project and just only the statement below generate an exception My snippets: Dim myRow As DataRow myRow = myDT.NewRow() myRow .Item("sysitem_id") = 10 myRow .Item("sysitem_name") = "Item 1" myDT.Rows.Add(myRow ) <------------------...more >>

Hello, I am developing a Newsreader in vb.net and i am getting a problem in posting article to newserver for a particular set of newsgroups. i developin g this newsreader using nntp commands.I need vb.net code for posting a article . I getting a problem in defining a article format. Kindly ...more >>

I've got a class as follows, PUBLIC CLASS BaseClass Sub New() End Sub Sub New(byval cName as String) End Sub Sub New(byval cName as String, nAge as Int16) End Sub END CLASS PUBLIC CLASS Person Inherits BaseClass END CLASS ** Coding If suppose i try the following p...more >>

How can I prevent my VB.NET dataset from writing invalid unicode characters when using the WriteXML method? This results in an XML document that will neither validate nor transform. Some of my data is unknown HTML content. I see that the method has replaced the greater-than's and less-than'...more >>

Hey all I'm new to .net trying to update a database with a new calculated values. I keep getting this error. An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Public Function Debit(ByVal iStudentID As Intege...more >>

This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C4CEE2.5DE36190 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, How do you create a snapshot/read only view of the complete data from = Access2003 from a disconnec...more >>

This is driving me nuts. I'm trying to update an Excel spreadsheet using ADO.Net and Oledb in VB.Net. The connection is open, the adapter is connected and the dataset is loaded. Here's the code in question: myDataRow = myDataSet.Tables(0).Rows(RowNum) myDataRow(ColumnCount)...more >>

I would like a data adapter to pull information from Someone answered a question for me on this Newsgroups, a little over a week ago and I was wondering if anyone could clarify for me. I am attempting to use one dataset to do all the data retuned from all my data adapters. I have a data adapte...more >>

Hi there, I've been playing with VB.NET and ADO for a week now and find the different data handling functions very easy and nice. Anyway, I'm afraid that I haven't understood the data binding things correct. I'm using MySQL Connector/.NET to access my database from the application. The q...more >>

Hello, I am developing a Newsreader in vb.net and i am getting a problem in posting article to newserver for a particular set of newsgroups. i developin g this newsreader using nntp commands.I need vb.net code for posting a article . I getting a problem in defining a article format...more >>

Hello, I am developing a Newsreader in vb.net and i am getting a problem in posting article to newserver for a particular set of newsgroups. i developin g this newsreader using nntp commands.I need vb.net code for posting a article . I getting a problem in defining a article format...more >>

can anyone tell me how to retrieve the last data entered in mdb in vb.net ...more >>

I have a Table in a Typed Dataset which contains a Date field called EventDate. I've ensured that the field is defined as Date as opposed to DateTime in the Typed Dataset. When I generate an xml file from an instance of this typed dataset using the ds.WriteXml method, all the dates come out f...more >>

Hello there! I create a dataform using the dataform wizard, and I want to replace a textbox with the masked edit control. I place a masked edit control to my form but there isn't a datasource property !!! If I expand the (Databindings) -> Text property and select "objdsClient - Client.PostalCod...more >>

I'm new to VB.NET. I'm usging an SQL select join in the following way: ---------------- strConn = Application.Get("DB_CONNECTION_STRING") Dim MySQL As String MySQL = "Select * from Users u, Banks b where u.UserID=? and b.BankID = u.BankID" Dim MyConn As New Odbc.OdbcConnection(strConn) D...more >>

My client got Two branches in two different cities. Now, the database server will be placed in City A , the user will input the data in City B. they use the lease or VPN to connect it. I got a problem on 'version control' design, We need to keep each version of the docuement and saved them into ...more >>

I am at a loss as to why my Merge method isn't working. I know the "source" dataset has data, but when I merge it to the "target" dataset it has no rows or data. This should be fairly simple enough but I am drawing a blank. Any help is greatly appreciated. Here is the code (I am not ...more >>

I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that can use the same data. I have gone through all the data connectors in Visual Basic.net and none of the...more >>

Moved up from DAOon VB6 to ADO.Net on VB.Net 2003 Slowly getting there.... but... Old VB6 code: Dim rsRec as Recordset Dim sCRIT as String Scrit = "Field1 = 'TEXT'" rsRec.FindFirst sCRIT If rsREC.NoMAtch then msgbox "Not Found" Exit Sub End If Debug.Print rsRec.AbsoluteP...more >>

Trying to ge to grips with the wat vn.net or rather ado.net qorks in vb..... I have a table in a database which I loaded into a dataset... No rocket science there.... I use SQL to insert a new row into the database table How do I get the dataset to refresh itself with the new table cont...more >>

I have this code DataSet.Tables(0).DefaultView.Sort = "str_CveAlumno,str_CveDato" Dim xValues(1) as Object xValues(0) = sAlumno xValues(1) = sDato iDRow = DataSet.Tables(0).DefaultView.Find(xValues) If iDRow < 0 Then xDataRow = xDataSet.Tables(0).NewRow xDataRow.Item("str_CveMateri...more >>

Hi All, This problem just started today, the combos in question were working fine until now. They continue to populate okay, the contents are simply not visible. I can scroll down and make a selection and it will show up in the text portion, I just can't tell what I'm selecting! Here is the...more >>

I've heard that ODBC is inheritantly slow. Are the other adapters faster than the ODBC one when moving large chunks of data? Or do they all use the same underlying mechanism to transfer data? Essentially, I'm trying to find out which one is the fastest... Thanks ...more >>

Hello, My List Control can show the items as expected. However, when I want to get the selected item text using: txtDeptDesc.Text = lstDepts.SelectedItem.ToString I've just got: "System.Data.DataRowView" in txtDeptDesc.Text but no error occurred. Here's my snap: D...more >>

The Configure Data Adapter wizard works on 20 other tables in my SQL2000 database, but fails on the following with an error "There were errors configuring the data adapter" Granted it's an oversize table, but what are the limits? Also, can I "view" the errors configuring the adapter? I've ...more >>

I have tree tables that are linked, I would like to create one composite table that uses elements of the tree tables the tables are like this: Foods Ingredients Recipe IngredientsID FoodID-------FoodID FoodName RecipeID-...more >>

Hi, I have one question, I have one database table used to store image (blob), i want display the image in datagird direct from dataset, i check tablestyle in datagrid doesn't have image column, how can display the image in datagrid ? Tks a Lot ! Ken ...more >>

Hi, Where can i find more information about "How to create Custom Control" ? Tks a Lot ! Ken ...more >>