if it matters which of the repeated tables you drag onto forms? I know there's a parent-child relationship between orders and details, which is why details appears "under" orders, but details also appears in other places. What's the difference between its different appearances below?
View 4 RepliesHow to display a hierarchical file structure with checkboxes for each file and directory. The end result should be something like:
+[] ROOT+[] dir1[]file 1[]file 2+[] dir2[]file 3[]file 4
How I might do something like this? The intention is to take in a full list of files and be able to pair it down to a custom list.
We can easily pass a DataSet with a single table from one form to another,
View 2 RepliesI have a simple access database that a log record gets written to a few times an hour.
I'm trying to make a DataGridView that shows that data as it arrives.
My "Solution" is simple;
when a user clicks the view -> read from the database (fill the datatable) -> update the view.
Not what I dreamed of, but functional, if totally sub-optimal.
However, my "solution" is a dud, using fill draws every single record from the database, even if there are already 599 on screen.
Really, I just want fill the datatable once, and add new records as they arrive (or on click if needs be).
Bonus point if you can also explain another way (that isn't called so often) to hide the ID column, and change the header of column 1 (named DateTimeStamp) to TimeStamp.
Public Class FormMain
Shared dataAdapter As OleDbDataAdapter
Shared logTable As New DataTable("log")
[Code]....
I have used a datarepeater with a dataset and it was simple to implement by dragging fields from the Data Sources window onto the DataRepeater control
I am trying to use Linq as a data source instead of dataset.
How do I bind data to textbox with Linq for Datarepeater?
Where did this Data Source window go? How can I get it back? I just upgraded to VS 2010. [URL]
View 5 RepliesI have a XML file that temporary stored data from the DB. i have DataSet that reads from the XML file and fill the DataSet. i want to set this Dataset as data source to ReportViewer in runtime
View 1 RepliesI've made a dataset using the dataset designer, and I'm trying to add a column to reflect changes made to the database (added a column, nothing fancy). Is there a way to 'refresh' the dataset schema from the datasource without deleting my adapter (and all the methods and queries I've created)?
View 2 RepliesOnly my local dataset updates when adding, deleting or editing records.The Source Database is supposed to update on issuing DataAdapter. Update(dataset )However, when I check my source database after running the operations it remains the same as the original.
View 6 RepliesI am working on a project that organizes the structure and hierarchy of departments. I want to view and display the whole structure of the organization visually, but I am stuck. I wanted to know what is the best way to do it in ASP.net 3.5; my goal is to achieve something like this by code and each node is linkable and can have CSS.
View 2 RepliesI have 2 tables that are related. Each app can relate to many apps. ie, office can be related to word, excel.[code]I would like to do the following query. I use vb.net but c# is ok.Query is to return all the apps that are not related to (1), so the result should be (4, quake) .
View 3 Replies(using VB.Net 2008) I have been using the Settings feature of vb.net to store user/application settings of my program. For small stuff it's great, but quickly starts to feel limited as the data gets more complex.Now I need to group certain settings together and organize them in a hierarchical (or relational) fashion. But from looking at the Settings tab inside of .Net, everything appears to be stored completely flat. So what's the best option for me? Some ideas I have are:
1. Use a small local database (such as an .mdb or .sdf) to store user settings. I think this could become a pain if I ever needed to update/create more settings while avoiding losing previous user data - not very flexible to change.
2. Use datasets and convert the tables to XML files.
I have 2 representations of similar data from 2 different systems and I need to match each entity in one system with the entities in the other.[code]...
View 1 RepliesI'm trying to populate a treeview on a windows form app with Hierarchical data from a SQL db.[code]...
View 1 RepliesI m using Treeview to create a hierarchical data. I have 3 tables which i m using to create an hierarchy. So that it would be as:
[Code]...
I want to add a "object" as a data source... then fill a "dataset" using the datasource?
View 1 RepliesI'm writing a order entry system and I'm using structures to pass information around various parts of the program for things like the order header (order date, customer name, etc).
In building the form I discovered that you could use a binding source between form controls and the struct which is great because it means alot less code on a form that will be very busy anyhow. Unfortunatly I'm either doing something wrong, or I've discovered a bug in vb.net because when you fill in a textbox and the binding source fires the setter for that attibute of the struct, it does one of two things. It either: Finds the struct that I assigned to the binding source then creates a new instance of it after it is done thus destroying any changes.Creates a new instance of the struct because it wants to rather than use the one I instructed.
I know this sounds confusing so I'm including a small program that demonstrates the problem I'm having.
I am trying to bind a list of a structure to my datagridview. But I just get a load of empty rows (I created the columns manually).
Public Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
[Code]....
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesCan some one tell me how retrieve database structure in dataset with primary key columns or get the columns that not allow nulls
View 2 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I have text box which I use the properties window, datasource set to bindigsource1 in my dataset.. I want to trim the text that is being populated.. Is there a wayt o do this through the visual studio gui or is it redo in codebehind?
View 1 RepliesI have an existing project written in VB.NET using Visual Studio 2005 communicating to a SQL Server 2005 database. The database was migrated to a sql server 2008 r2 on a different physical server so the dataset's server name needs to be updated. I do not have access to the database anymore. is there a way to just update the server name without invoking the dataset wizard and requiring a connection to the database?
UPDATE: I tried to created a new project with just a button with the command calling the following subroutine to test the connection from a windows app to the sql server database. here is the sub:
Public Conn as New ADODB.Connection
Public Sub PubSubConnectToDB()
Conn.Open("Server=w2k54
[Code]....
I am able to created a system dsn on the same server with the same credentials and test the connection successfully.
I am creating a database application via visual studio, using VB.NET and with an access database. I've connected them and have been using them fine so far however I've had to make some changes to the original access database. I am unable to find an obvious way to update the current dataset object within the project from the new updated source file. My database has this new schema but the dataset has the old one so its causing conflicts. The only way I've found to do this in the past is to manually update the dataset with the changes I've made in the access file, so actually doing the same thing twice! Surely this isn't the only way? The changes I've recently made are massive so will take sometime to have to do it all again. If I delete the current datasource object and add it again, there are many errors left from the deletion. If I manually try to update the files, there's always some hidden ones I've missed. Ive found some sort of guide for updating the datasource via the dataset but what I want to do is the opposite!
View 4 RepliesI need the Logitech HD Webcam C310 to be preselected.When the Main Form opens the Webcam must be running allready, withoute having to select it from the Video Source Window.
View 1 RepliesI have tried everything I can to get beyond this error which shows below as <<<<< error here. It is trying to fill a dataset from a data adapter. If I change the SELECT statement to just SELECT * FROM xTable I get the correct number of records in each table. But anytime I try with a more complex statement I get the error message shown below which indicates System.Data.Common.DbDataAdapter.Fill(DataSet dataSet. I've completely erased all data and entered a new set of test data so I know there is no problem with relationships. Each table has primary key which is foreign key in other table. IS there something wrong with the Imports section: Imports System
[Code]...
Can you please explain me and/or show some good tutorials how to do it?It seems pretty complicated because visual studio usually does it all for you and that made me stupid and not to do anything about it.Things I don't know to do in code but I know VS does it for me:
[Code]...
I'm sure there is a good tutorial somewhere on the internet. I'm okay with doing it with designer, but now when I have a situation where I can't use MDI container but tabcontrol.Other solution would be to make a MDI container out of tabcontrol. Is it posible or only other form can be MDI container.
i am trying to copy data from a standard Dataset to a Type Dataset (XSD) of same table structure. i want to use Automapper to do that one. So how can i do that using automapper?
View 1 RepliesI have two Datagrids, One grid has all the customers garments on it with style number and contact length. The other grid has the users who have garment issued to them. the style number is in both grids. I need to loop through the users grid and say if the contract number is 1 from the first grid then the contract date on the second grid will be todays date + 365 days (year contract) I have looked at using a stored procedure and also a for each command but I am just getting stuck with it all. [Code]
View 1 RepliesIn VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
[Code]...