Hi, Is there a built in mechanism to turn a datatable into a string array and insert chars after each row. I know I could loop through and create the string myself but I thought that old ASP and ADO had some method to return a string array from a recordset and put characters after each row. I ...more >>

My dataset's select query select columns from 2 tables, I need to write own insert, delete and update command. I am wondering if there are some sample codes I can find to write these command Thanks ...more >>

Newbie question: I am trying to write some code to loop through all of the SelectedValue values of a multiselection listbox. For example, I have a form with two listboxes that when instantiated, shows what groups a user is assigned to, and which are available to add them to. When I add a gr...more >>

Can someone point me to an easy to use step by step tutorial or help for populating a server side control with data from a dataset (derived from sql server) or directly from sql server ? I have tried to accomplish this several times and can get the code done, but no data returned. Missing some...more >>

Using VB.Net how do I read an XML file and then update its values. What I would like to do is load data from an XML file onto fields on my form. I would then like to type in new values into these fields and then update the values in the XML file. Thanks in advance, Lou Here is the contents...more >>

Hi all. I am new to VB and have been working on a project for uni but am currently stuck. I have a program that stores information regarding teams, players, referees, games and statistics for a football season, in an Access database. My problem is this: I have tables Referee(name), RefStatTy...more >>

How does one set an applications Icon (i.e. the Icon associated with the application). -- mark...more >>

Hi, i createda function which i can execute in sql server as follows declare @out varchar(2000) exec @out = dbo.find_all @cli = '0190529467' print @out now i want to use this iin my dot net app. what would be the best way to retrieve the output? appreciate any help that you can ...more >>

I'm wondering if it is faster to use a DataTable.Select method to act on a set of rows matching certain criteria or use a For Each loop? For the number of rows I'm using, it probably doesnt matter (maybe 100-150), so this is more curiosity than necessity. Any thoughts? Thanks Dave Taylor ...more >>

If I manually create my own dataset with no backing database, is it possible to run an Update sql command on this dataset? What I would like to do is this Dim ds as New DataSet Dim dr as DataRow ds.Tables.Add("table1") ds.Tables("table1").Columns.Add("column1") dr = ds.Tables("table1")...more >>

Is it possible to use a DataAdapter to fill a DataTable, change the DataColumns of that DataTable (and maybe even it's name) and then commit those changes to the database (in my case SQL Server 2000)? Eg: [VB.NET] Dim dc As New SqlCommand("SELECT TOP 0 * FROM SomeTable", SomeSqlCon...more >>

Hi, all! Running VS.Net 2003... Trying an example from a book, and I keep getting the error: "Invalid command sent to ExecuteXmlReader. The command must return an Xml result" at the ReadXML command. Code follows... Can anyone suggest what I might be doing wrong here? The connection st...more >>

I have a couple of questions regarding the rowfilter property and how to use the dataview after setting it. Hopefully someone out there has a good answer for me... If I set the rowfilter for a dataview, how can I get the count of the rows that would be selected according to the rowfilter crite...more >>

Hello Everyone, Please let me start by saying that I'm new to programming, but I've heard from a lot of guys that it's best to create database applications in Visual Basic. Is this true? I bought a copy of vb.NET 2003 Standard and I cannot find any books on how to create a simple loca...more >>

Hi: Can someone point me to some resources, possibly a tutorial or other written documentation, that would walk me through the design, creation and coding of a form and then connecting it to a data source, adding controls and connecting those to the data source etc etc etc? I am having a...more >>

I have a table that I would like to do a row.find on and return a specific row. The table has a composite primary key (composed of a username and date fields) I understand how to do a row.find on a table with one column that is the primary key, but how do I search for a particular row using both ...more >>

From: "Hari" <harixseshadri@yahoo.com> Subject: 2 extreme newbie ?s Date: Friday, August 13, 2004 2:43 PM I just started programming in Visual Basic.NET about a month ago, so I am completely oblivious as to which libraries to look in. However, I have good experience with Java and C. Below a...more >>

Hello All, I have the following query... SELECT Demographics.Full_Name, Demographics.Year_of_birth, Status.Status_OK, SUM(2004 - Demographics.Year_of_birth) AS Age FROM Demographics INNER JOIN Status ON Demographics.PrimaryKey = Status.PrimaryKey GROUP BY Demographics.Full_Name, Demograp...more >>

Hello. Can I read and edit data directly in the DataGrid (not in DataSet) from my code (if yes how)? ...more >>

When downloading a file a dialog box pops up... how does one deal with it using VB.Net? Details: I select a file to download.... a dialog box pops up for me to confirm the file download... I would like it to select "ok"... TIA ...more >>

Good morning, I have written a VB.Net application that reads records from a Foxpro database and inserts them into a SQL Server database. The problem I am running into is that the insert statement in code is failing because it is telling me that a certain column cannot contain a NULL value,...more >>

A requirements change is forcing me to modify the database schema of an existing program. Since the product is already in the field I need to make the change invisible to new and old users. To accomplish this, I'd like to check for the existence of a field in a database then add it dynamically ...more >>

I have this xml file: <?xml version="1.0"?> <Settings> <AppSettings Key="Width" Value="1000" /> <AppSettings Key="Height" Value="2000" /> </Settings> How can I retrieve the value 1000 by providing the "Width" key. I have tried with an xpath search but I must do something wrong: xNode...more >>

I have a table, "ListData", with four columns: analyzer_id (int) list_name (nvarchar 20) position (int) process_stream (nvarchar 50) There is a primary key defined on the first three fields. There is also a corresponding DataSet.DataTable and I populate a ListBox from a sorted DataView o...more >>

It's failing at the da.Update(dt) at the bottom with the error message listed in the Catch block. Do I have to phrase my InsertCommand text differently? Private Sub listEncodings() Dim enc As Encoding Dim dt As New DataTable("msl_CharacterEncoding") Dim dr ...more >>

I want to have a Crystal Report set up like grp1 event1 event2 event3 grp2 event4 event5 event6 event7 event8 grp3 event9 etc. my tables are set up like tbl1 unitID, unitname tbl2 eventID, FKunitID, eventdatetime, evdescription tbl1 unitID is related ...more >>

I am trying to insert a row into a VFP data table from an ASPX web page using VB.NET and the VFP OLEDB driver ver 8. The insert fails with the message: "Cannot update the cursor WEB_ORDERS, since it is read-only. Microsoft OLE DB Provider for Visual FoxPro" Any help would be appreciated; I'm ...more >>