Hi All, I have a many-to-many relationship between two tables using a third table as a joining table. I have a single dataset with all three tables loaded and the correct relationships added to the dataset. If I set the datasource of a datagrid to one of the outer tables then I can navigat...more >>

Hi I need to perform two queries in sequence on two identical access tables. The source table is coming from a dataset returned by a web method and the destination table is from a local access table. The queries are; UPDATE [destTbl] INNER JOIN srcTbl ON [destTbl].entry_id = srcTbl.entry_id ...more >>

Hello, I have a datasource set up from an ODBC source (Access database). When I populated the properties of the combobox with the appropriate datasource and the display member is also populated with the proper field, I run the program. All I get is an empty combo box. I know the data sou...more >>

one more thing i want to display the updated MSG in the bottom bar how do i do so ? ...more >>

I've created my first application - a form that writes info to a DB. I created the OleDbAdapter1 and OleDbConnection1 and DsImporter1 and they are all fine. i added the folowing code to my form : OleDbDataAdapter1.update(DsImporter1) MessageBox.Show("Database updated!") The Issue is the in...more >>

Hi all i have a simple question: 1. how do i bound a listbox to a table in the DB? 2. I want to check against the information stored in the DB if a value is already stored. (using TextBox) if the value is stored i want to display a msg. ...more >>

Hi I need to update one access table from another in a way that all new records are inserted and all existing records are updated. Is there an example of this that I can follow? Thanks Regards ...more >>

Hi I have a dataset which has received its data from a remote web service. How can I now save the dataset into a local access table? Thanks Regards ...more >>

Hi, I'm running Visual Studio 2003 Enterprise. The ADODB component is not listed in the .Net tab of the Add Reference dialog though there are several ADO versions, 2.0 through 2.7, on the COM tab. I'm trying to learn ADO .Net from VB .Net and Francesco Balena's Visual Basic .Net book...more >>

Hello, I have an object which has various properties, including one which is of type DataSet. I need to serialize this object in binary format, but I've discovered that the BinaryFormatter will only format datasets in XML format. I've read various articles on how to address the problem, i...more >>

Hi I need to copy records from table A to a new table B (overwrite if exists) based on a flag field not set in table A. I then need to set flag for all records in table A that are also in table B. How can I do this in ado.net using vb.net? Thanks Regards ...more >>

I have a table colSimulations which has an indentity column, id. According to stuff I've read so far, in the DataSet, I've set the AutoIncrementSeed and Step to -1 to create my "placeholder" values. I have another table called colPatches as a child of colSimulations, it has an id field (not au...more >>

hello, i used temp dataset (TempDataset1) to load data from datasource and then merged it to working dataset (Dataset1), is it possible to load data from TempDataset1 into Dataset1 selectively, i mean by using queries??? tnx in advance, Adriano ...more >>

Ok guys iv'e created my first form. the form has 4 TxtBoxes In it and i want to create a button that will do 2 things : 1. Close the form - Simple me.close 2. update a specific table in a database with TxtBox1 TxtBox2 etc. is there any code sample for that ? never done it in my life ...more >>

Hi! I'm using the following Code to get rows from my Database. In each row either Nr is filled an Nr2 is NULL or vice versa. Now the user can enter in two text boxes the number to select. i want to pass this to a parametrized dataadapter, but i always get errors or no result rows at all. i...more >>

When a query fails using DB.OpenRecordset, I want to be able to get the actual error message returned from SQL Server, not just simply 'ODBC call failed'. Is that possible? In addition, when I use DB.Execute, in some cases I don't get any error at all, though executing the sql in Query Analy...more >>

Hi I have a datagrid in my vb6.net project. The grid is populated fine and the first column of each row is hidden to the use (width = 0) and holds a unique id for the selected record. My question is when a row is selected an the user presses the EDIT button how do I read the value of column...more >>

Hi! All, I have a datagrid which is bound to a datatable. What I want to do that if anyone deletes a row then he would get a message that you cannot delete the row and then it would still display the row that was deleted. But now the problem is that the message appears but the row disppears. ...more >>

Hello: Our small software shop is developing a small VB.NET Shipping Order application for our internal use. Our goal is to develop a useful application while learning the .NET framework at the same time. We're having a problem figuring out the best way to store each Shipping Order obje...more >>

Greeting .... I have a small app in vb.net that allows the user to seleect from a series of access mdb files. I would also like to be able to select from the tables within the mdb file......any idea's thank you steve ...more >>

To All: I am fairly new to both VB.net and Access and have a question regarding the combination of these via ODBC. The code in question is at the end of the message. I have a procedure with which I am connecting to an Access2000 database and counting the number of records in table 'mc' tha...more >>

I have just started teaching myself VB.NET and SQL. I just need a little help in the syntax. I am at a loss on how to do this: I have a dropdown list that needs to show a "FirstName, LastName" from a table. Here is what I have so far: Private Sub SalesmanLoad() Dim ds As Da...more >>

Hey ppl, I am having trouble in building a smart device application. I cant create a table on SQLCE server using this line. Anyone can tell me what the problem is? I am able to create another 3 Tables same way but this SQL line is always gives me problems. command4.CommandText = "CREATE T...more >>

-English format? -Regional setting depending format? Do i have to use always english format to query by date (MM/DD/YYYY)? Thanks you ...more >>

how to retrieve database names from an sql server? and how do i connect to the server? im using a vb.net application. basically, i want to fill my combo box with all the available database in the server. any ideas? thanks for the help guys.. -------------------------------- From: Jason Rey ----...more >>

This is the article I've based a report viewer on: http://support.microsoft.com/?id=210132 I've been able to execute 2003 reports but can't seem to figure an appropriate way to show the reports selection criteria from either the filter or where clause. Does anyone know how to execute a re...more >>

Hi, can anybody give me idea to solve my data transmission problem? Previously, i declare a single dimension array and then send to UART com port as follow: dim ByteArray(64) as Byte ... MsComm1.Output = ByteArray However, after i modify my program and change the...more >>

I have an OLE column in an Access database. The column name is "PHOTO". I have JPEG files stored in that field. For the life of me, I cannot get this data to show in a PictureBox. I have learned that the OLE data type in Access handles data differently than just storing a blob of data conta...more >>

Hello, I Have a VB=2ENet Winforms application using data binding=2E The= model I used is based on an example from a book=2E The problem= that I am having happens when I try to add a new row to the= datatable=2E I am able to add the row via= datatable=2Erows=2Eadd(datatable=2Enewrow()) and...more >>

I am having an issue with the VB.NET JoinView (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325682) I added event handlers for the various changing events (see code below) but the problem is that I receive numerous OnChanging/OnChanged events just by clicking rows in the binded Dat...more >>

Hi, I need to extract a string from another string separated by "," like a .csv file. for example I have this string: String1 = 000,federico,00,439827HGH,1233,FGB,0000,00,000 and from that string i need to extract string "federico" and string "FGB" and separate then into another 2 string...more >>

All, I am having a problem gathering related data from two tables in a dataset. I create the dataset from an xml file with the structure below. The Table structure is below that. What I want to know is how do I Select * from Resource (Where Keyword_Text LIKE 'searchstring%') The resul...more >>

Hi ! My problem is to create function returning, for example country name, from entered country_code. There is an access table (Country) with two columns (CountryCode and CountryName). In VB6 functions like this, were working preaty good, but in vb.net I can only build Connections, DataAdapt...more >>

How do you check to see if a value is in a column of a table in a dataset. I want to flag items in column one dataset that already exist in another column of a different dataset. If DataSet1.DataTable1.Column1.AllValues exists in DataSet2.DataTable2.Column2.AllValues Return True. I am stu...more >>

I have been trying to do this for hours with only limited success. I have no idea why MS makes something that should be so straight forward a real pain. Can anyone point me in the right direction? ...more >>