DB/Reporting :: Making Design Changes To Table In Live Environment
Apr 12, 2012
In a program I am creating, i want to let the user add and remove fields on an entity, lets say "people". So I have a table named "People", with ID and Name columns. Now, I want to let the user choose "add field" in a webpage, define for instance "email" field, and then use "ALTER TABLE" from the codebehind to create the new field in the table. What I want to know is: is this recommended? It seems like a simple way to do this, but since I have never seen any other programs doing it like this (Using ALTER TABLE statements from codebehind in a live environment) - and since it changes the design of the DB -
View 3 Replies
ADVERTISEMENT
Nov 15, 2009
I successfully converted a VB6 program to .net 2008. Phew. Thats the fast way to learn a new language I'd like to get an exe that I can try running out of the design environment. Is that the "Publish" menu selection?
View 3 Replies
Apr 21, 2010
I am designing a system for our sales team to enter their sales expenses. I have designed an input form and need some advise on what exactly I should store in the expenses table VS lookup from the employee table.
First, the form has a text box where the user must enter their EmployeeID. Management asked for a text box VS a combo box because they do not want users looking at each others expenses. The form has a search feature where by after you enter your employee number, it will look for an existing expense ticket first before allowing you to create a new one. Anyway, here are some of the decisions I have to make.
When the user enters their employee number, I would like to display their employee name. The EmployeeID is saved in the Expense table but should I also store the name in the expsense table? If I do save it, it's duplication of data, if I do not, I have to look it up each time the record is loaded. But is there a point storing the name long term? Does this qualify as related data? If I was to perform some reporting, could this cause a problem if an employee changes their name etc.
The expense data is spread over 2 tables, the first for the header details including employeeID, expense date and Expense ID etc. The second table contains the expense lines information. Amount, customer, category etc. My next question is when the employee chooses an expense category, there is an associated general Ledger code with that category. Again, the expense category data is stored in a table. When the user chooses the expense category, should I store the categoryID or store the values associated with the ID (GLAcct, CategoryDescription etc.) Does this qualify as related data or should lookup values always be duplicated in the master table? It is possible that over time, the GL accounts associated with the Expense categories could change. So for accuracy purposes, should they be stored in the expense lines table?
View 2 Replies
Jul 7, 2012
We have two systems, one is created in VB.Net 2003 and the other is created in VB6. Both systems are client/server desktop application system. There is a requirement that we need to send and response data to each systems. The data will come as result of process of each system and then transfer it to the other system. These is formatted in a message format. Is it likely to become socket programming? how can I send and response data between servers?
View 1 Replies
Sep 21, 2009
in a windows form if i want to duplicate the properties window layout on my form, which is basically a 2 column table with title on the left and value on the right, what control do i use to achieve that?
View 1 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
Mar 5, 2009
Am using VB.net 2005, and I've created columns for the datagridview at design time. But when I run the code the fill method of the DataAdapter, the columns I created are not filled with data, but automatically generated columns appear. How can the columns I created at design time be filled with data?
View 1 Replies
Oct 2, 2009
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
View 3 Replies
Sep 8, 2011
I have this code:
[Code]...
View 12 Replies
Jan 14, 2009
I've got a large and complex database system that is about to get even more complex, and I'm having trouble coming up with a reasonable way to model the new requirements so as to minimize the performance hit.For simplicity's sake, I'm going to use the example of certification exams, although it's not a perfect analogy for my system. So we have the following tables:
- Person
- Certification
- Exam
- Certification_Exams (join table indicating which exams are required per cert)
- Person_Exams (join table indicating which exams a person has taken)
Given that model, we can easily show that Certification A requires Exam 1, and Certification B requires Exam 2 and Exam 3.We can also determine whether a person is certified by checking Person_Exams to see if they have passed all exams required for the certification we're querying. (Note that we are not directly storing certifications for a person; these must be derived. That's one of the areas where the cert exam analogy doesn't quite match my real-life scenario, so please accept that there's a good business reason for it.In my world, the cert requirements are going to change frequently, so a person might get suddenly "un-certified.")Now enter the new requirement: We now need to be able to indicate that Certification A could be satisfied by either Exam 1 or Exam 4.And furthermore, Certification B always requires Exam 2 but also requires either Exam 3 or the combination of Exams 5, 6, and 7.I've come up with a couple different approaches so far, but the subsequent queries to be able to tell whether someone meets the criteria for a given certification are then incredibly complex.
View 11 Replies
May 27, 2010
converting a speadsheet into a proper data source. I have imported it in to a table called "B" in access 2007. The problem is that the data is spead out of multible columns and rows, looks like a crosstab query. I need to convert it back to its data. I could do it with UNION Queries but this would be unpractical due to the number of columns.I have created a public function in my module. But I am not sure on how to call it. I get the error:
Quote:
Circular reference caused by 'BOut'.
on this line:
Code: Set rstout = CurrentDb.OpenRecordset("BOut", dbOpenDynaset)
Here is my first try:I have a table called "B":
Quote:
InvoiceCode,XXX001,XXX002,XXX003,...
A,$10,$15,$20,...
B,$1,$2,3$,...
[code]....
View 1 Replies
Jul 7, 2011
Rather than running numerous queries in Access I am trying to write a front end for a DB2 database. The Access database is getting to a size that it is causing Access 2007 to have reliability issues and frequent compacting is required. I have created the Dataset, the Table Adaptors, and the Connection String already, but when I put in a bit of code in to fill the Table Adaptors the remote connection I have to work is going crazy (chewed up about 180MB before I realised it was pulling data from work).
Before I started the project I copied the .accdb to my local PC HDD and I pointed the connection string to it, but it still looks like it is trying to pull data from the work network. If it was a small database I wouldnt be concerned but it is pulling major data every time I run it. I have only 2 out of the 4 Table Adaptors running and it didnt fill them even after 10 minutes.
Here is the code I was trying to run... Server name has been substituted for Server for obvious work reasons.
Because the tables are so large I was looking for a way to pull only the columns I need to from the tables, I tried adding .SOFT_ID to the first line of code but the TA spat the dummy message below...
Value of type 'System.Data.DataColumn' cannot be converted to Application_Name.DS_DB2Database.Server_SOFTDataTable'.
Code:
Me.TA_ServerSOFT.Fill(Me.DS_DB2Database.ServerSOFT.SOFT_ID)
Me.TA_ServerSOFT_FOUND.Fill(Me.DS_DB2Database.ServerSOFT_FOUND)
Me.TA_ServerHARD.Fill(Me.DS_DB2Database.ServerHARD)
Me.TA_ServerREF_SUP.Fill(Me.DS_DB2Database.ServerREF_SUP)
I would also like to pull just the data columns I need to speed up the query.
Note: In case youre wondering why I am not connecting directly to the DB2 database. I currently dont know where it is stored and while leveraging Access I am trying to put a level of separation between the app and the db for the time being, later I will try connect directly.
View 9 Replies
Apr 9, 2008
A portion of my code is below. I am making a database application using FlexGrid and an ADO Control. I get errors on the statements following .saying that "Overload resolution failed because no accessible 'Fields' accepts this number of Arguments". Can someone explain this error and also a fix for it? I am using Visual Basic 2008.
[Code]...
View 1 Replies
Jan 20, 2010
WIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?
View 2 Replies
Dec 15, 2009
I have VB6 Dll which I am referencing in vb.net ,I am calling the following function in it. It working fine in developemnt environment but not in deployement environment.
Error Method not found: 'Boolean MyUtils._MyUtils.LoadMyObjectRecords(ADODB.Stream ByRef, System.Array ByRef)'.
View 4 Replies
Jul 11, 2011
Im looking to build a nice form which a supplier can quote prices on. SO the form will have Labels down the left hand side and then their would be a Column per requested Product/Quantity from the buyer. So it would have n number of columns.Because of the way html tables are coded you need to build a row at a time. (I want to keep this as one table so its neat HTML)Before I go ahead and create Repeater for each row of information the user needs to enter. Is their a way to be able to create a sorta grid view but instead of each records you pass it going to create a new row. It would create a new column and you could define the first column as the header column?
My table sort design is (txtb stands for textbox and lbl stands for label which is updated as values are entered)
Quantity 500 1000 2000
Delivery Cost txtb txtb txtb
Pricing txtb txtb txtb
[code]....
View 2 Replies
Nov 7, 2010
i have create a new dataset to pull data from my Access database. May I know how do you call them to use it?
View 2 Replies
Aug 2, 2010
Let say I have a function inside a class which require 4 parameter (table name,field name,field value, return field) When I use this function my form, such as
myclass.Search("customers", <-- after pressing the "," a popup list will be displayed that contain all the fields in "customers" table.
View 19 Replies
Jun 16, 2010
I want to make a database of all the xbox live arcade arcade games on the xbox live marketplace, I need to parse an xml file and add the needed data from the xml node into a datagridview.Here is the xml file i need to use to grab links and other data about the game:
[URL]
Being the noob I am it took me about 6 hours to figure out how xml works and to write some code for what i need to do.
Here is what i came up with:
'for grabbing the name of the update
Public Sub updatename()
Dim xmldoc As New XmlDataDocument()
[code]....
That code works fine.Now when i add another column to the datagridview called "update size" i want to know how to add the grabbed data from another sub i made to the new column.What would the code be for adding the strings for the new sub into the seconds column? the first was, DataGridView1.Rows.Add(str)" . So what would the second be ?Also another question i have is how do i put an image in an imagecolumn by a web link, not a local picture.
View 5 Replies
Jan 18, 2010
How would i get the primary key id number from a Table WITHOUT making a second trip to the database in LINQ To SQL?
right now, i submit the data to a table, and make another trip to figure out what id was assigned to the new field (in an auto increment id field). I want to do this in LINQ To SQL and not in Raw SQL (I no longer use Raw SQL).
also, seond part of my question is: i am always careful to know the id of a user thats online because i'd rather call their information in various tables using their id as opposed to using a guid or a username, which are all long strings... i do this because i think that SQL Server doing a numeric compare is much (tentative use of the word 'much') more efficient than doing a username (string) or even a guid (very long string) compare.
View 5 Replies
Oct 18, 2009
Public Class HotelReservation
Dim currRec As Integer
Dim totalRec As Integer
Dim dt As New DataTable
Dim cmd As New OleDb.OleDbCommand("SELECT * from Reservation", conn)
Dim da As New OleDb.OleDbDataAdapter(cmd)
Dim ds As New DataSet
[Code]...
View 1 Replies
Jul 10, 2009
database = microsoft access application = microsoft visual studio .net 2003
i have a dataset, i dont know how to hide the rows.
View 1 Replies
Nov 29, 2010
I have a database called Houses.mdf , in it is a table called House with ID , NAME , PRICE.
I want to SUM all the PRICES and get a total price of all houses. I also want to display the result in a textbox.
View 1 Replies
Jan 5, 2009
I am confused as to why you have to pass the name of the table in the .Fill() method? As an example, see the following code:[code]I have already specified "NameTable" in the query string, so why do I have to put "NameTable" again in the Fill() command?
View 4 Replies
Mar 27, 2008
Anyone know how to copy a table from one database to another? I know the statement 'INSERT INTO Table1 SELECT * FROM Table2' but I want to copy from one database to another from a server to a PC. Of course, I could do a select statement for all the records and use a loop to insert them one by one, but surely there is an easier way.
View 8 Replies
Jun 4, 2009
I am trying to insert data into two tables on two different forms. My problem is that I don't know how to get the last entered Auto generated ID from the first table to pass it to second form.
View 4 Replies
Oct 28, 2008
I am using the following from the MS website to add a row to an access table and retreive the last autogenerated number.
Code:
Dim cnJetDB As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb")
[code].....
View 1 Replies
Apr 28, 2008
Using VB2005, Access 2003
I'm having a problem trying to read an access table with the following code:
HTML Code:
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
" Data Source=C:DBFILESService.mdb;" & _
[Code]....
View 3 Replies
Nov 8, 2009
How do I add a row and then refill or refresh a DGV? The row is added/inserted successfully.What I can't work out is how to get the new row to show in a properly refreshed DVG.In one case I keep the old DVG view but the new row is missing.
View 1 Replies
Sep 24, 2008
I'm importing a .csv file into my SQL Server (2005) using SSIS on a schedule, after its imported I would like to change the name of the file. The name of the imported file is always different as its coming from an external source.Is there anyway of changing the table name?
I've looked at using the stored procedure sp_rename, i.e.
Code:
USE TESTDATABASE1
GO
EXEC sp_rename 'dbo.SalesTerr5673A1889', 'Values';
GO
What I would like to use is a wildcard?
View 1 Replies
