DB/Reporting :: Create Local Databases On The Light-side Of Things?
Jul 18, 2008
My boss wants me to create local databases on the light-side of things. I was researching on what solutions are available, we discussed the possibility of using text or xml files... but we dropped the idea since we want to use SELECT, UPDATE, DELETE command sets (or the like)I proposed the idea of using Access files (mdb) but he told me that he doesn't want the user to have Access installed on their computers.What are the choices avaible, am I forced to install Access on machines that would be using my VB .NET app to access mdb files?
View 2 Replies
ADVERTISEMENT
Jun 1, 2009
ive been asked to write a program to deal with supply chains (tracking commodities, personnel, etc). I want to create a program that will allow multiple office to run the same software and update their local databases as well as a central database.how to best send the data/ recieve it, and store it so that all offices can see, edit, and store the data both locally, and over the internet.
View 13 Replies
Feb 22, 2010
I am looking to add a local database file (.sdf) into my .Net Project, so i go right click on my project, click "Add" -> "New Item", select "Local Database" and rename it to what i want.I then click the "Add" button and get the following error."The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet assosciated with the file will not be generated."I am using Visual Studio 2008 .Net Framework 3.5.
View 4 Replies
Jan 8, 2009
I am writing an application in VB.Net, the application stores a number of images within the database and therefore the SQL database size gets quite large. At the moment I use a single database, however what I want to do is create a new database for each project within my application. I need some advise on the best way to proceed with this and also the best way to be able to create a new database for each project. Below is the approach that I was planning to adopt:
1. When the application is installed it automatically has a common database that comes with the application and this database is attached to the SQL Server, lets call this application "AppA" and common database "AppADB" Within the AppADB there would be a table called projectsTbl and in this projectsTbl it has a 2 columns called "projectDesc" and "projectDB". projectDesc would hold the description of a project and then the projectDB would hold the SQL database name for that project.
2. The user would login to my application and in the admin side of the application have a create project form. In this form he would enter the project description and also a 3 character code for the project. When the user OK's the form it would take the project descrption from the form and put this in the "projectDesc' field in the AppADB and then take the 3 character code from the form add this as a prefix to "AppADB" and put this within the "projectDB" field within the AppADB e.g. if the 3 character code was "SIM" then the projectDB name would be "SIMAppADB"
3. What I obviously now need to do is create a new database called "SIMAppADB" now what I was thinking was I could create a SQL database backup of a database that has the standard database structure that is required and then I can restore this .bak file (which would be in my application installed directory) to this new name, using the following code:
Code:
RESTORE DATABASE SIMAppDB
FROM DISK = 'C:Program FilesAppA Installed DirectoryDB.Bak'
WITH REPLACE, MOVE SIMAppDB_Data' TO 'C:MSSQLDATASIMAppDB_Data.MDF',
MOVE 'SIMAppDB_Log' TO 'C:MSSQLDATASIMAppDB_Log.LDF'
4. Then when the user logins to my application again, on the login screen he will see a list of projects from the "projectsTbl" table in the "AppADB" database. The user can then select the project they wish to login to and from this the application and extract the database name from the "projectDB" table in the "AppADB" database. I then can store this database name in my application and when the application needs to connect to the database it modifies the connection string to connect to the respective database.
View 1 Replies
Apr 8, 2009
I am making a program that will take your initial balance of your checking account and then you can enter your checks, deposits and withdrawls into a database. Then The option will be given to return a report of deposits, withdrawls, etc. Well, I am having the problem with creating a database I can open when the program runs, first time to get the initial balance, and after to tell current balance. Then, I need to just keep on adding the new checks, deposits, withdrawls to the database everytime the person uses it. So, say I used it and put in 5 checks and then a week later I use it and put another 5 in. I want to be able to give a report of all the checks that have been inputed (this example is 10) back out to the user. So, essentially my question is, I guess, how would I create a database in VB 2008 that I can keep adding to it everytime it gets used?
View 1 Replies
Sep 7, 2010
I am attempting to modify DBaseIV files using ADO in .NET I am able to open and read the data with no problem but everything is showing as read only and there is no way (at least that I can find) to perform Updates/Inserts/Deletes to the underlying Database table.
There seems to be almost no documentation that I have been able to find dealing with DBASE files. I have found a few references that BDE (Bordland Database Engine) needs to be installed and used for changing DBASE database files. However, it appears that BDE must be purchased. I found one reference that indicated ADO Jet 3.5 would work but 4.0 would not. Then I found another that said 4.0 had been updated to include Update/Insert/delete SQL interfaces.
Can anyone point me in the right direction for being able to modify a DBASE IV database table using ADO (or some other method within .NET) It is currently not possible to change from DBASE to another database structure this may be coming in the next year or so but will still need to perform modification to DBASE files for the forseable future.
View 1 Replies
Aug 19, 2009
I want to send a image to server side using HTTPService,I am using ASP.NET for server side coding. I don't know how to write server side code to receive the image sent as a byteArray, and I am also not sure if my client side code is correct or not。is there any IT PRO..[code]I could not get the image in my disk,I think the flex side should have not problem, but the VB code side should be something wrong.
View 9 Replies
Dec 22, 2009
E.g. how do I get VB.Net to statically type a local variable to be the static type of the expression on the right had side of the assignment?
View 1 Replies
Jun 17, 2012
If NewEntryName.Text = "" And OpenFileDialog1.FileName = Nothing Then MsgBox("Please choose a name for your game.", vbExclamation) MsgBox("Please find your game.", vbExclamation) Else Button1.Text = NewEntryName.Text
[code].....
View 1 Replies
Aug 15, 2011
I don't know how to join multiple datatables created in Designer in 1 single Datatable. I need 1 Datatable with all data in it so I can give that single Datatable to one single Tablix in ReportViewer (rdlc). Problem: ReportViewer Tablix can accept only one datatable at time and I need them all at once in one tablix.
How did I get stuck here:* I have added Dataset from Solution Explorer to my Project (ds1). Double click on that item gave me Dataset Designer (ds1.xsd). Here I have created 4 Datatables with all needed columns, mutually connected with parent-child relationships (one to many, nested). dt1 is parent to dt2, dt2 is parent to dt3, dt3 is parent to dt4 (dt1 > dt2 > dt3 > dt4).
On my forms I have binded all my controls to this 4 Datatables and their respective columns so the data is populated hierarchically to dataset (as planed). I have added ReportViewer Control to one form for reporting purposes and Design a new report (rdlc)...As I have read in past few days (read: week or two) I need to Join all my datatables to one single (flated) datatable somehow and then feed that DataTable to my Report.
So basically I have 2 questions: 1. How to join my 4 datatables? Can I do it from Designer or I must do it in code? 2. If I cant do joining from Designer how will I see this new datatable with all columns from my Report? If I wanna add a Dataset/DataTable to my Report I go to Tab Report Data - New - Dataset - comboTo SelectExistingDatasets and if Datatable/Dataset is not created in Designer I can not see it here to add it to work with it.
View 7 Replies
Mar 22, 2009
I need a simple method for a user to enter as many rows of data as they wish (probably won't exceed 50 in most cases and that's pushing it) and then store that data for retrieving the next time they want to reuse that list. I will also need to read the rows in for manipulating text in a file with those entries.
Would the best method to be to use the DataSet in VB Express 2008 and then use the DataGridView for allowing the display and entry of the data?
View 1 Replies
Jun 9, 2009
I have finished my program and now i am ready to deploy it. The only problem is it is a multi-user application. All i want to do is simply run the program with the database from a server, and have other local computers with the program access this same database. I know that you have to change the connection strings for the local computers, but how can i go along doing this?
View 2 Replies
Jun 7, 2010
I need to make an application that from a master database creates a number of access database files (tables of a larger db), then these are manually given to users who fill in data, the database files are emailed back to a user who, through the application, combines them again.The only part of this that I am unsure about is problematically creating the access db's. I have read that through Microsoft Jet OLE DB Provider and Microsoft ADO Ext I can create them (the tables and data), but I also need forms.
View 1 Replies
Dec 14, 2011
I'm using VS2010, SQL2008 and using asp.net vb - im stuggling with some db related items.I have a couple tables, Project and Projectstatus - looking something like this.project
- ProjectID (autoincrement)
- ProjectName varchar50
- Projectoverview varchar200
Projectstatus
- statusID (autoincrement)
- projectID varchar50
- projectstatus varchar200
What id like to happen is that when i create a new project (into the project table),that a row is created in the projectstatus table, inserting the projectID from the project status for reference.I don't think this can be done from within VS, correct? therefore, do i need to create a SP to perform this action from DB side?
View 3 Replies
Jul 10, 2009
I want to create autohide Side bar in Winforms using VB.Net 2005. I have main form there is already fixed side bar with lot of options now just I want it autohide just like VS.NET 2005 Toolbox?
View 17 Replies
Jun 11, 2012
Basically, we have three databases to grab data from. One is a SQL Server database, one is an Access database (which is particularly annoying to connect to because we have to map a network drive and such), and the final one will be an Oracle database when IT finally gives us rights.I'm thinking about creating a helper function that makes querying any one of these databases as easy as possible. I want to create a two-dimensional array
Dim myEasyResultArray(10,10) as String
myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Is this a good design decision? Also, how can I have the array be the right size? Can I just do this?
Dim myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Should this be a module or a class? I don't really need to share variables?
View 2 Replies
Jan 25, 2010
i m using vb.net 2005 i create a window form separated by two side. One side i have a list box and other side i have a webbrwser.in listbox some id is present. if i click a button then first pick the 1st id and it is append with a url and the respective page will display. in that page an add button is present.whenever i click that then the second id from list box will be encountered.
View 1 Replies
May 23, 2011
Can I send an object from client-side javascript to server-side code via ASP.NET ?
View 5 Replies
Apr 13, 2010
I know this defeats the purpose of client side vs. server side (refer to title of this thread). What I would love to do is build my own custom progress indicator on the client showing how far a server side code has progressed. I figure if I could only get a JavaScript to fire and render a value of some control at pre-defined intervals while the server is working I could make it happen - but alas I'm beginning to believe that this is impossible. Below is some code that performs three 2 sec loops. At the end of each I want to change the visible value of a control on the browser. [Code]
View 8 Replies
Feb 23, 2012
I have a basic asp.net web page. I have a menu bar divided into 3 columns. Each column displays an xml file. However instead of showing them side by side it displays them one on top of each other. i think it might be to do with my css?
My asp.net web code:
<div class="menubar">
<div class="menuleft">
[code]....
View 2 Replies
Jul 13, 2011
Using the following script:
$("#some_button").click(function() {
var changed = [];
[CODE]...
I need to send back the id, the old value from _1 and the new value from _0 back to the server. What is the best way to format this data so I can easily extract the data from the server side so I can easily email someone for example to let them know which textboxes have changed, what the old values were, and what the new values are
At the serverside level, I am using .NET-3.5 (VB). I know how to send the data bacl. and how to email the data, I just wanted to know how to best format the data at clientside before sending it back. I could have upto 50 sets of id, old, and new values to send back. Sorry for not making that clear earlier.
Example:
How can I modify the script above to generate this?
[
{
"id": "name_0",
"new": "text",
[CODE]...
View 3 Replies
Dec 18, 2011
I'm working on a 2d game. making a button that can move in a path random up,down, side -side, etc. in a selected space. and once hits end of the form to slide out and reappear at other side of the selected space and do same thing over.
View 1 Replies
Oct 14, 2010
Here are my two grids -- they are ExtJs grids however we wrap the declarations in vb.net code:
Dim VehicleOptionsGrid As New Framework.WebControls.Grids.Grid
With VehicleOptionsGrid
.ID = "VehicleOptionsGrid"
.Title = "Vehicle Options"
[code]....
Using javascript, is there anyway I can add a bottom scroll bar to these grids? Doesn't seem like we have a wrapped command to do it...
View 1 Replies
May 14, 2011
I currently have a parent Listview and its child Listview displaying in the centre column of an HTML page that consists of three columns left, centre and right. And all looks very good. However I would like to display the child list view in the right column beside the parent list view.
To do this it seems I must somehow generate from the code behind page a new row in the table every time the parent Listview displays a record of its data and then some column HTML so the first child list view will appear in the right hand column.
View 1 Replies
Nov 6, 2011
Dont be afraid to spam the thread with things you can create.The more the better!
View 2 Replies
Apr 22, 2011
I'm trying to, from a client-side piece, call off to a server-side piece. I need to do this synchronously. On my server-side code, though, I'm calling off to another piece of code, which I want to have a maximum of, say, 10 seconds to return a value. If I don't have a response within 10 seconds, I want to force my own server piece to set my result equal to 0, and return to the client.
Here's what I have on my server-side code so far:
Public Function GetWebResult(ByVal inputParameter As Object) As WebReturnObject Implements IWebInterface.GetWebResult
Dim result As New WebReturnObject
Dim webItem As WebItem = Nothing
[CODE]...
I realize this code is not functional. The problem is that I'm unsure how I would go about getting back into GetWebResult to set the appropriate return values before it is sent back to the client.
View 1 Replies
Jun 22, 2011
I am struckup with a problem from last two days. I am creating a web application using VB.NET, Ajax & RAD Controls. When user clicks on a button I want to open a RAD Window and show the list of ledgers available to the user, so that he can select one from the list. And to open that window I have to call a java script function from client side, which is already achieved using the below code.
[Code]...
View 8 Replies
May 1, 2011
Is there a way to override/modify/create the left-side shortcut buttons in the SaveFileDialog or OpenFileDialog controls? Defaults are "My Recent Documents", "Desktop", "My Documents", "My Computer", "My Network"... how would I change "My Recent Documents" to "My Super Cool Folder"?
View 1 Replies
Jan 25, 2012
I add an option to a select with jQuery. When I save with an asp button, I don't see the changes on the server side in the click event.
And the HTML is all correct after I add the option.
Is it a coding problem or I don't understand something?
$(selectCourant)
.append($("<option></option>")
.attr("value",$(dropdown).val())
.text($(dropdown + " option:selected").text()));
View 1 Replies
Jun 18, 2012
I have an application which have multiple tab pages. On of these pages I have a group box with many controls that do something.Now the problem is I want to add exactly the same group box by the current one that can have different paparemeters.This is exactly the way that i want to add comparison capability between to set of parameters.I have more than 500 lines of code that responde to changes of these parameters and does something.Is there any way to replicate the the whole gropbox and use the same code for both and and being able to difrentiate between gropboxes.I think there was an array control in vb 6 but I am not sure if this the best way to do this in vb.net.What is the best way to do this for the least amount of changing the code and wasting time.
View 1 Replies
