Db Schema Design And Saving Data?
Mar 6, 2012
If you know a bit about database design, you would mind glancing at this? I don't know if I my logic is right or not.Schools, players, and coaches can have awards. Schools have players and coaches, states have schools. - Am I missing something?As far as populating the database, I want to have static data entered into the database before a user runs the program and then allow them to add new information that would only be saved (to a save file, not overwriting the original static data) if they clicked a button. How do I go about this
View 10 Replies
ADVERTISEMENT
May 16, 2012
I have a small dataset which has most of its schema defined at design time, but I add a few columns to one of its tables at runtime. My problem is how do I reset those changes? he dataset is not linked to any datasource. It just has its own table which I "manually" populate. The static columns have been added to the datatable at design time. However, I add a few columns as runtime based on a list of categories. Like this:
[Code]....
The dataset is used in a small dialog that pops up within my application. I add the dynamic columns when the dialog is opened by using the Load event. Everything works great the first time. But if you close the dialog and reopen it, there are problems. My startup routine tries adding the dynamic columns again, but an error is thrown saying the column already exists. I have tried a lot of things and did some reading but I can't figure out a way to reset the dataset when the dialog is closed. The only solution is to close the whole application and reopen it. I have tried the following in the Leave event of the dialog form:
[Code]....
View 3 Replies
Jun 27, 2012
I have a php web service that I can call from a php client. I need to call this web service from a vb.net application. When I try to add a reference to this web service I get this error:The root element of a W3C XML Schema should be <schema>here is the top of my wsdl file:
<?xml version="1.0"?>
<!-- partie 1 : Definitions -->
<definitions name="raidService"
[code].....
View 1 Replies
Mar 9, 2009
rewriting a class I use for saving Treeview data to a XML file for use of saving ListView data I can't really figure out the rewrite, I'm stucked, unfortunately Listviews seems to be a big problem for me in general.
Option Strict On
''' <summary>
''' The TreeViewDataAccess class allows the nodes within a TreeView to be
''' persisted to xml for later retrevial.
''' </summary>
[Code]....
View 9 Replies
Nov 17, 2010
I'm building a vb.net application that composes messages for later message queueing in accordance with a predefined schema that an observer of the message queue requires.I've made the XSD file for the schema already, but I was wondering if there was any way to import the schema as or convert it to a custom object type in my .net application, where the elements of the schema would represent data fields or sub-objects to be filled programmatically.
Is there any way to do this?Am I getting my terminology correct here, or would there be a better way to accomplish what I'm attempting to do?I'd like to be able to create a schema and use it as a definition for some kind of data transfer object in my applications, without having to make the object as a separate VB class file.
View 1 Replies
Jan 19, 2012
The new command text returns data with schema different from the schema of the main query. Check your query's command text if this is not desired. I am getting this warning, whenever I add a query in a Strongly Typed DataSet which returns a single column.
Ex
SELECT DISTINCT Building
FROM Room
ORDER BY Building
When I give this query it will show me a warning. Because warning leads to a constraint error when ever i call the same function in a windows form.
View 1 Replies
Aug 5, 2010
I have a purely XML database. It's stored as XML, there is no other database file. I did this by first creating a dataset in VB, then adding tables and relationships. I load the database by calling DataSet.ReadXml(FilePath), and save the database by calling DataSet.WriteXml(FilePath).
Now I need to make schema changes, but need to preserve existing data. How might I go about doing this? As soon as I load the database I loose all data if I change the schema in the dataset designer.
I have searched for changing database schema, but everything I find deals with real databases, not XML only ones, and the info doesn't apply because they are using db connections and then running sql against it and AFAIK XML databases have no way to "connect".
View 5 Replies
Aug 3, 2011
i have been coding for years, but never integrated XML. So I guess I'm a newbie. I have inserted an XSD file in my project, ARequest.xsd. I created a folder in my project called XML just to organize things, so this file ARequest.xsd, is in this folder.
Now I have a form that displays data from a database that has the same fields that are in this XSD file. Can I load the XSD file into my Windows Form, load the elements from the data on the windows form and then create an XML file then send it? If so how? Any code snippets would be helpful. Now I do know how to create the XML file, we'll call it Test as
[Code]...
View 8 Replies
Feb 12, 2012
Currently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
[Code]...
View 7 Replies
Sep 19, 2010
I need to control a device with a GPIB port. I have the commands that I need to use to do this; but I don't know which is the sintaxis in Visual Basic.
For example if I need to send a instruction like "START:0.01" to the external device which are the libraries that I have to include?, how should I write the programming line to do this?
The main tasks that I need to program are sending data, receiving data, and saving data
View 5 Replies
Jun 2, 2010
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
View 2 Replies
May 18, 2010
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 Replies
Aug 22, 2009
I�m working on a project that saves records to a datatable/dataset. I then serialize the dataset to save it, and deserialize to show the records in a datagridview, I add more records, serialize, deserialize etc etc. � I�m using binary formatting. I added the dataset/datatable from the toolbox and selected �untyped� for the dataset. I want to print out this table and other text. Do I need to draw a report using graphics on to a page and then programmatically add the data from the deserialized file, or is there a better way to design and add data to a report? I�ve looked at crystal reports and report viewer and I cannot see how to programmatically add data using them � they both talk about connecting to a SQL or ADO database which mine isn�t.
View 5 Replies
May 18, 2012
i try using both detail view and form view but they are not flexible enough to place my picture where i want it
View 1 Replies
Aug 10, 2010
how to organize the classes within my RPG project that I'm making. I've tried to implement a battle system but I am not comfortable with my initial results. This is the basic layout I currently have for my classes. [Code] clsCharacter contains statistics pertaining to one character, including magic available to that character to use. Also includes what weapons that character has equipped. clsTeam contains multiple clsCharacter, as well as a list of items that each clsCharacter in the team can use. clsBattle contains two clsTeams. One team is the player and the other is the computer. Now, this is a wonderful way to organize data. However, I see limitations with this approach. For instance, to pass data from Battle to Character, it has to pass through the team class and vice-versa. Plus, if I use Properties, it transfers data as ByVal instead of ByRef, so I cannot guarantee that I'm editing the original and not a copy of the passed object (IIRC)
In addition, I feel it is just messy code to include methods within the clsCharacter class that invoke this: MyTeam.MyBattle.DoAction(). Plus, the clsCharacter might not even be in the battle at the time - I don't won't to bog down that class featuring code that is exclusive for battling when I also need to be concerned about moving around the map, saving/loading data, etc. So, any suggestions? Right now, I'm burnt out of ideas. One idea I have so far is to include a function for the clsCharacter that exports a list of all possible moves the character could make, and if the character is CPU choose the most optimal one, and if Human than wrap it up in some nifty GUI so they can choose what action to take. But at the same time, how do I use that information within the context of the battle?
View 2 Replies
Nov 6, 2011
There exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
View 1 Replies
Nov 26, 2010
I have created my webpage in asp.net in 1024*768 resolution, my problem was that when i change my monitor resolution then the controls in my webpage will be displayed in unmanaged manner .
How to arrange items in my webpage which support multiple resolution ...
Whatever the resolution of my monitor the controls in my webpage will display as it is as managed in 1024*768 reolution !
View 1 Replies
Jul 20, 2011
I can articulate my question well enough to get some clear and usable feedback here. I have reports (like paper reports) in my .NET application that have data bound to them. Typically the reports are a combination of many data elements across several busniess entites that may not all relate through an Inheritance hierarcy, etc. This makes it difficult to get all the needed data placed together to bind to the report.
So what I have done before are make 'Report' classes with data elements specific to supporting the reports they are bound to, and on the back end might be tied to specially created Stored Procedures that bring this data back (maybe several joins across many tables to get the right data needed). So if I was to make an analogy to the database world, I am essentially 'denormailizing' the data structure to get all of this data into a single class to make it easy to bind to the report.
However on the hard line OOP concepts and architecture design, one could say that a report is just another 'thing' to bind data to, and its class should not be designed just to suit the needs of data binding. In this thought process, I would actually need to make my class design be able to create the relationships needed to get all of the data together properly to still be bound, but not create any special 'Report' classes. I find this difficult to do sometimes. It is much easier to create these relationships in the back end stored procedures and then just output the resultset to be almost immediately bound to the report.
So what is the right way to solve this? If I create these specialized report classes with really no behavior, am I introducing an anti-pattern like the Anemic Domain Model?I could use some feedback, and please speak up if my question and scenarios did not make sense.
View 1 Replies
Jul 3, 2011
in my application i have to print some data on alrady printed forms...for example: i have print on a BANK CHEQUE.
Now my problem is that these forms are printed differently and different bank have different check but all have the same data..and to meet this requirement printing need to be ajusted for eg i might need one colom two place down or left or right.. so i need a printing tool in which i can edit the location of printing meterial i mean take them few places left or right and adjust them as my requirement.i have used crystal reports and ms reports at very basic level but what i have found is that i can not edit design move drag etc from the application..
View 2 Replies
Jun 27, 2011
I seem to have reached a limit on the size of the form. I cannot make the form longer and I need to add more fields. Is there a limit on how many fields can be included in a form?
View 1 Replies
Aug 19, 2010
This is a followup to the question I asked here:
[URL]
I understand the answer in the post above, which is absolutely amazing, by the way. It's about implementing interfaces with a class. However, what if a class needs to share features with another class?Yes, that class can an Interface. However, let's use this sample definition.
[code]...
Or, in other words:An equippable item can perform acts outside of its typical usage of a shield or weapon. But not all items can act as a sheid or weapon.I mean, I could create a class that implements IWeapon, IShield, IMagic, IUseableItem, etc. But there should be a better way than returning NULL when those interfaces are called.
View 2 Replies
Jun 28, 2011
I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
View 1 Replies
Jul 20, 2008
Dont understand where to start on visual basic iv been leaning alot about computers over the months and i would now like to design a program and to be honest its all new and i dont no where to start or what any of these woulds mean like string, data enadled application and refactoring.
View 3 Replies
May 25, 2011
I searched codeplex and google. I have found so many such as tustena but unfortunately they are not domain driven based and in these solutions I could not find a good modelling documents or references. i am a newbie in CRM but I am sensetive to design it with solid object-oriented fundamentals. Any reference or open source solution especifically for CRM design and implementaion in .NET? Cheers
View 1 Replies
Feb 17, 2010
Im doing my first project with WinForms, and Im trying to get the DataBinding working. Theres no database in my project, but I'd like to bind some of the TextBoxes to objects' properties. In the other section of this forum (here) I found this line of C# code which does it: textBox2.DataBindings.Add(new Binding("Text", this.myPerson, "LastName"));
my question is can data binding to object properties be set up during design time (without writing code)? If so, how? P.S. I know how I would set up this binding if in WPF, but I'm forced to use WinForms.
View 1 Replies
Jun 22, 2012
Why it says Connection Property has not been initialized ?
PublicSub save()
Dim con AsNew OleDb.OleDbConnection
Dim adapter = New OleDb.OleDbDataAdapter
Dim cmd AsNew OleDb.OleDbCommand
Dim sqlQuery AsString
[Code]...
View 6 Replies
Jan 18, 2011
i have a data set on the data set many data adapters .i add a data adapter in the data set the designer was automatically delete then lot of error was coming and i search in google and i go this method and i do that right click the data set and "Run Custom tool" on that time the designer will automatically created. but when i do that a error was coming "The custom tool 'MSDataSetGenerator' failed. Exception of type 'System.Data.Design.InternalException' was thrown."
View 2 Replies
May 29, 2010
I'm developing a web application that provide a service of online reservation, and I need to save the data (for example in a specific day and access to them).How can I do that.Is it possible using : System.Web.UI.WebControls.Calendar?
View 1 Replies
Nov 6, 2011
I'm working on a project which are generating some data from my VB.NET software and I wish to save those data into sql server. But my concerns is the speed of saving and the large amount of data. For every 0.5s, one set of data will be generated and the process will keep running for about 8 hours, so at the end of 8 hours, roughly there will be 60,000 set of data generated.May i know what is the best option/method of saving the data into the sql server in not hanging up my software and also keeping the pace with the speed of 0.5s data being generated?
- Speed of 0.5s. I have to maintained for every 0.5s, one data must be generated. Cannot delay too much.
- I can afford delay in the sql database, meant the data might not be necessary close to real time.
View 5 Replies
Aug 19, 2011
I have a small application that consist of five tables. The main table is called inventory. I have four tables linked to the Inventory table
[code...]
I can go in and enter data, create a new record and add more data and then click Save - nothing happens. I can cycle through the records and they will show. However when I exit and reenter the program (stop/start debugging) done of my new data is displayed.
I am thinking the problem has to be with the four tables connected to the main table via the ID's. Although a record is not being added to these subtables. So, I am not sure what's going on.
I have provided the code below. Please take a look and give me some direction.
[code...]
View 1 Replies
