Hello I want to insert data from TABLE Master into TABLE tempAr. I have the following so far. Both tables are in a Access Database What am i doing wrong? steve SQLStatement = "Insert into tempAr(MasterId,Payment)(Select MasterId,Cust_leasePmt from masterwhere cust_methodofPayment=2)" SetU...more >>

Please be kind to take a look dsSeaInvInfo.Clear() daSeaInvInfo.SelectCommand = New SqlCommand daSeaInvInfo.SelectCommand.Connection = conSea daSeaInvInfo.TableMappings.Add("Table", "invoiceheader") daSeaInvInfo.SelectCommand.CommandText = "select * from ...more >>

Is there a way to add custom methods to a typed dataset and not have them overwritten when the dataset is generated again from the designer? I would really like to add some more "Findbyfield" routines, but dont want to have to go back in and manually add them every time I regenerate the dataset....more >>

Hi there, What utilz do you guys use to make it easy to make data relations for datasets? Regards/ Jerome ...more >>

I got two po tables, (master and detail) in myMasterPO , there are one unquie key (hidden ), ponumber(user can read and modify it) in myDetailPO , (there are also one hidden unquie key).and ponumber my question is , User may need to amend ponumbe in myMasterPO, and I need to update that pon...more >>

Hello, I have an app that allows the user to modify a dataset (one parent table with 6 related tables). The parent table has an identity column. I want to implement a "Save As New" feature which will allow the user to open an existing parent record and its associated children, modify some da...more >>

I'm trying to write a small app using vb.net going to SQL Server 2k, and using: Imports System.Data.SqlClient Imports System.Data.SqlTypes. I'm using all stored procedures, necessarily, and am having quite a bit of trouble interogating, updating, and generally manipulating the datagrid c...more >>

In VB.Net I have returned a dataset. How do I loop through a named table for all fields for each row returned? ...more >>

BlankDid anyone else come across a combobox whose SelectedValue or = SelectedItem property is bound and the format event is not firing when = scrolling thru records by changing the CurrencyManager position? How do = I get around this? Is this a bug?=20 BTW, it's confusing where to post this ty...more >>

I can't seem to get the ^ and $ characters to work as expected in vb.net. Here's the file I'm parsing (each line terminates with a CR/LF): test line one test line two test line three test line four My code is as follows: Dim sr As StreamReader = New StreamReader("c:\test.txt")...more >>

I'm trying to decide on a database and so far it doesn't look good. I have an application I'm developing that I need to distribute that is highly database driven. It needs to support at least 10 connections and 2GB database size. The problem is, I'm trying to avoid having to require a databas...more >>

I have found that when I create and populate a dataview, then set the rowfilter property, that the rowfilter doesn't effect anything unless I bind it to a control, if I iterate through the rows, the rowfilter doesn't filter anything. For example, I have a dataset, I push a table from the datas...more >>

I'm looking for sample that: a) compare xml with xml file b) compare xml with record in sql I cannot find any sample. I know that i'm stupid, but but few samples that i found, doesn't happy me.... -- Legrooch...more >>

Hi, I have a form with one Tabcontrol who has two TabPages with two Textboxes binded to a DataSet. I have the next problem: 1-I change with code the text of TextBox1 in TabPage 1 (TextBox1.Text="Hello") 2-I click on TabPage 2. 3-I return to TabPage 1. Then, TextBox1 remove...more >>

Hi all, I recently wrote a vb.net app using oledb to an access database. When I inserted new rows in my datatable the identity column was automatically created. This app used an un-typed dataset. My current app is using sqlClient and a typed dataset that I created by exporting an xsd f...more >>

I am having problems reading in data from an excel spreadsheet using the OleDbDataAdapter. Sometimes the data will read okay, but most of the time many of the values are not recognized and read in as dbNull. I have yet to find a pattern. I have formatted all the cells in the spreadsheet the ...more >>

Still fighting with why the EndCurrentEdit seems to clear the underlying Datasets.Item collection when a exception is thrown, I thought of a workaround. I thought I'd declare dsclone as Dataset, copy my actual dataset (which should clone the structure and copy the data) and then after the exc...more >>

Hi there, Is there any efficient way to do DATA RELATIONS of Datasets? Regards/ Jerome ...more >>

How do I get the number of records from a SQLDataReader or adapater or dataset? Do I have to cycle through it and count? If so, how to I start the dataset over? Once I cycle through it, such as: Dim dr as sqldatareader = cmd.executereader while dr.read .. end while then try to use dr...more >>

I have a simple data form that can edit and add records to a table. In my "OK Button" code I EndCurrentEdit and then perform a UPDATE method on the data adapter. It works just fine adding and editing data. One field on the table is a foreign key and I have referential integrity enforced on t...more >>

Hi I have a dataset which is filled with data. How can I write this dataset into a local access table and also creating the table if it does not exist and overwriting it if it already exists? A simple code example would be great. Thanks Regards ...more >>

I have a pair of combo boxes on a form. Both have their SelectedValue property bound to a column on a table called "Input_Output". One column is called "Class" and the second is called "SubClass". Each combobox has its datasource, displaymember and SelectedValue member bound to separate tables t...more >>

Hi there, If I make 1 dataset and 1 data adapter for each table, how do I retain the relationship the tables have in the database? Thanks. Regards/ Jerome ...more >>

Hi there, Why is it that when I generate dataset using wizard, it ask me for query statement, and not tables to be imported? When I use query statement, I can't import all tables at once, I end up generating datasets for each table. Is there a way to do this more efficient? Thanks. ...more >>

Hi there, Does anyone know why System.Data.DataRowView shows up on my combo box instead of expected items? Regards/ Jerome ...more >>

I am using VB.NET 2003 and SQL Server 2000. The program inserts new rows in a table based on data read from a file. The table has an ID column, declared as int and identity. I generated the commands and the stored procedures with the DataAdapter wizard. When the UPDATE command is executed the...more >>

hi there, i'm getting a bit confused learning vb.net... is there a way to make it in such a way a single connection string is done, and you just fire an sql statement to get the data? i find php-mysql a bit easier. though, i know that vb.net should have been easier... can someone shed light? ...more >>

Am using this code, which works fine for HTML (ASCII), and partially works for PDF (binary) files: strURL = "http://www.websitename.com/xxx.pdf" [begin snip] Dim objStream As System.IO.Stream Dim objReader As System.IO.StreamReader Try Dim objRequest As System.Net.HttpWebRequest = Sy...more >>

Microsoft provides calendar control for month view in .NET. I want to make week view and day view on based of that. So how can I make that in ..NET . If any one have an idea or if some one have the source code for that. Please pass it on......more >>

I'm using the following code to clear a table: Dim sqlCnxn As New SqlConnection(DBConnect) Dim sCommand As String sCommand =3D "SELECT * FROM " & _FD_AuthUsers Dim daUsers As New SqlDataAdapter(sCommand, sqlCnxn) Dim dsUsers As New DataSet daUsers.Fill(dsUsers, _FD_AuthUsers) dsUsers....more >>

Hello, I am writing an app that uses SQL server as its backend and am looking for some general advice about the queries - specifically is it advised to put them in the database server or in the client front-end? Originally I had intended to put all my queries in the database server and call...more >>

Hi, I have a table with foreign key(s), and i would like to change the values in the table. I've tried to use .update method, but it doesn't seem to work. Is it that i can't use a update if i have fk in my table? if so, what should i do ? thx ...more >>

I know this is easy but stomping me right now=2E What is the= process, using VB=2ENET, to add a record to an Access database and= manually increase the key column by 1=2E Thus, the table has five= rows; 1,2,3,4,5=2E I want the next record to enter 6 in that= column=2E Please help=2E T...more >>

VS 2002 - win xp pro -- access 2002 -- VB -- web forms I'm using insert into with executenonquery One of the fields is a memo field that contains HTML. HTML field has quotes, = and everything in between. This makes my insert into syntax error. Anyway do to do this? Thanks ...more >>

Hi, I have big problem that can't be resolved by me until this moment. Would you please do help me? Okay, to the point... I created a form. On that form I created a DataGrid, that showing content of entire table of a database. With this DataGrid we can add, edit, or delete record(s). By the w...more >>

Hi all, I am new to vb.net and don't really much about how to deal with database stuff. I learn some from a book and all it teaches it to use the windows from designer..(choose some command ) I have a log in screen, and i would like to check if the username matches the password in the d...more >>