dataset

hi all, been awhile since i posted here i'm not %100 sure this is the proper forums (my question is about DataSets within the code) but here goes: i have a DataSet with 3 tables - 1 parent table ("TableA"), 2 child tables ("TableB", "TableC"). i need to cascade the results when i filter the...

Hello I am new to developing, I have vs2010 express sql2008 express. I have a data entry form and a report form. I want to retrive the values from a specific recordset preform muiltiple calculation's on th data and send the result's to the report form. My question is what is the best way to...

I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect...

I'm writing an app in VB.Net 2008 that needs to transpose a list of values in a database. I found that the Join command will just do that. :D Only works on arrays though. The dataset only has one column. So I'm trying to find an elegant way of converting it to an array. I've got 18000 rows...

Hello all, I'm trying to make a program in which football (or some other sport) prognostics can be entered and scores can be calculated automatically. I've set up the database and I've created 3 layers. In the data layer, I've added my access 2007 database (it already has the right links...

What is new in this release? The long awaited version of Aspose.Words for .NET 9.0.0 has been released. This new release of Aspose.Words includes plenty of new and remarkable features like client profile are optimized for client applications. The Client Profile is available for .NET Framework...

hi all, i have a dataset in my application (vb.net2008) that has a parent table with some child tables linked with a relationship. i would like to be able to open the form in "new" mode, and allow the user to create the whole dataset, and hit the save button once, but this isn't working for...

Confused!! I am trying to fill a DataTable with a DataSet using a SQL query with one parameter. The parameter is the Node text of a treeview whose checkbox has been checked. It will retrieve Products from one table and any associated Packages from a different table. I am using a FOR loop to...

Hello, I have a dataset that I search using the dataset.tables("table").Select("WHERE clause") method to query. I then use a datarepeater to display the results. Is there a way to programatically tell if no results are returned? I'm aware of the Dataset.tables.Rows.count, but can this...

I have a problem with a combobox and no page on the Internet has been able to help me so far. So I hope that one of you can. I have a form (with information about clients) with textboxes binded to a dataview. One of the columns in the dataview contains a number that tells me what kind of client...

hi, i am trying to insert some data from a dataset into a database. i have used the following code that works absolutly fine. For Each dr In myDataSet.Tables(0).Rows strSQL = "INSERT INTO [~AgeBandsEmpty] (a,b,c) VALUES ('" & dr ("a") & "','" & dr ("b") & "','" & dr ("c") & "')"...

First Post.... I've built many reports based on many architectures ranging from web-based reports using java/struts, to batch reports using cobol. Super easy. I had control. Enter vb.net rdlc reports....I'm a little new to VS and vb.net I have built an entire standalone application building...

I have loaded a .csv file into a dataset and now i'd like to import from that dataset into a table in SQL server using VB .net. Is there a quick easy way to do this? Also this will be importing over 13,000+ records. ***JUST SAW I POSTED IN THE WRONG PLACE******

hi guys. i'm just new here at vb.net forums. so this is my first post here. hope this one will be helpful to me and i hope that i can help others too someday. i just graduated from college and i've studied VB6 at school but not that deep. now, i'm currently learning vb.net. i have a company...

I have a table (tblSpanishVerbs) of spanish verbs and need a function to return the corresponding English verb after passing the Spanish verb. For example, from below i want to pass the verb "comer" and return the verb "eat". I am using Visual Studio Express 2008 and have imported a SQL Server...

Hi I am using a web-service that is returning me result in form of a dataset. Now this dataset i am displaying in form of a Tree. the dataset results in arn 15 values which i want to display in 3 columns instead of one long list. Any Idea how to display in 3 columns??

this is the situation an application has a main form with many button a button calls a dialog that is used to add to the database a button calls a dialog that is used to delete from the database a button calls a dialog that is used to search and so on i use many datasets (one per form) is...

Hi, I have 2 problems with the haschages method 1 : when i do like this: Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing Me.Validate() Me.DataTable1BindingSource.EndEdit() If...

Hello all.. I have a dataset .. with one datatable.. which i generated by reading a textfile.. Now I want to move this dataset /datatable in to an access database table this table is already built with all constraints in place.. I want to move it as a whole.. as apposed to loopin through the...

I have an application that uses a database, I have my dataset with different tables and methods for each tables. The current server where the tables are is to be closed in the next weeks, my question is simple : is there a way to tell VB.Net that my tables are on server X instead of server Y...