I have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code:
Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
[Code]......
Ive been trying to figure out what report I should use as it appears I have crystal reports built in and also have Microsoft Report Viewer in this VB 2008.What I need to do is give the user a list of names and when a ame gets clicked it will show all the details in a report.I have loaded a ListView Control with the names from my database and this is letting the user pick a report so I can get the name and ID number of the record to show this way and just need to figure out how to get that record onto a report and what report to use?Ive done similar in VB6 but have never looked at .Net. The data is comming from an access database.
View 2 RepliesI have 4 Tables Master And Three Tables Details
how to programming this Technique
This Picture dispaly what i mean http://img300.imageshack.us/img300/3981/26072009110315.png
I am attaching one vb.net file but one problem is there when we save the data that's member name is not storing in the db table it's saving in the grid only.when we closing the window it's not retaining in the table next time when we r taking nothing is in the database
View 1 RepliesI'm trying to get a details view in ASP.NET to display the details of the logged-in user only. I have been told to use:
select * from STAFF where USERNAME = user.identity.name
I thought this was too simple to be true and I was correct as it shows no data when I attempt to run.
I have a database with three rows and colums
IDNAMESURNAME
1BOBSMITH
2JIMJONES
3MARKTHOMAS
I have three buttons and I have a panel with the details bound to the database (not a datagridview, but the other option that you can drag onto the form: "details")
When the user presses button 1 I want the row with "ID 1" to be displaied in the details. Likewise for buttons two and three. (The user will later be able to edit the names and save the changes, so this is why I want to use ID as the selector)
I have been looking at things like "selected key" and "selectedindex" but I can seem to find a way to populate the details. I tried to make a query serach but it's not working (i think beacuse ID is the identity seed?)
* I added the picture to try and explain better what I am trying to do. the part in the middle is bound to my database. It shows my database in in "details" form, not sure if it has a special title.. the others are obviously buttons. I want the middle parts to show the selected row. Using the navigator bar above I can type 3, hit enter, and it will show me row 3.. I want to emulate this idea but using the buttons.
I am doing a simple backup of sql server database through VB.NET form. It gets executed well but I want to display details of successful query execution in a label (i.e. time taken, database size etc.)
The message which I want to display in label is like "Processed 296 pages for database 'aaa', file 'aaa' on file 1. Processed 1 pages for database 'aaa', file 'aaa_log' on file 1. BACKUP DATABASE successfully processed 297 pages in 0.522 seconds (4.660 MB/sec)."
This result we get in sql server query window when we execute backup query there. I want to get this message in label when I fire backup query from Windows form in VB.NET
I am building a site for our company to share files between all users but administrators will be the only users who can add new files to the site.I need the administrator to be able to upload a file to a folder on the server and at the same time create a new record for that file and include a title, description, url of file, and other details in the database. In one click.
View 4 RepliesI am importing a image in to a database but it would be able to add some of the file details in to the database as well. So I would like to pull out all the details in the camera section
View 1 RepliesI'm a newbie in visual basic. I'm doing a login system. I'm done with the GUI. but for the programming part, I want to know where to store new user's information along with the username and password. I've done research. seems like it has something to do with database. p/s: I'm looking for high security in storing data to prevent hacking.
View 1 RepliesI've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script etc.
View 1 RepliesI got a DATASource connected, changed the table to details and draged it on to my form, but then it shows me the bindingnavigator at to of my form.
q1. how do i make it so every time this form opens it is like add new?
q2. how do make my own save button (don't want the binding navigator at top)
q3. in my form all my collums aper as textboxes how can i change it so there is a drop down menue that has forexaple 3 pre defined items that the user has to select on of.
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesRecently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesA registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.
View 2 RepliesI need to programmatically add a row to a MS Database.How is this done?
View 2 RepliesI don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
I'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
View 5 RepliesI am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 Replies[Code]....
Thought I should probably say im using Windows 7 and the 2010 beta Visual studio
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code:
Imports System.Data.SqlClient
Public Class frmMain
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
View 3 Repliesbelow is the coding i want to ask :[code...]
this code is used for login by querying into the database....the logic is like this..it query accoding to the username text box and pass word text box...if there is indeed such rows in the table, then the bacadata.read, else something else happens...i have a few question :
1.is this the right way of login in by checking the row is available or not?
2.is there any enlightment and solution for the appropriate way to login system by using database other than the one teached by my lecturer?
I am trying to use the .net connector within my program. I have got add, delete and update working however cannot get search to work. What I would like the program to do is, you enter a value into a textbox and then press a button. The value in the textbox is searched and then the values in the database corresponding to that value are entered into the other text boxes. This is what I have so far:
Private Sub PrescriberSearch()
pre.SelectCommand = New MySqlCommand("SELECT Name FROM Prescriber WHERE Name =?Name like Name = ?Name")
[code].....
Well my problem is that I have a image stored in a database which is a OLE Object.
My Problem is that I am trying to view the database in Vb (windows form) but the image does not appear.
All I can see is a small red cross where the image should be.
I have tried both Datagrid view and Detail View.
I am developing a software that connects to a database and manipulates product and user data. It works on my computer but it will have to be used by many computers maybe even world wide (who will access the same database) so I have no idea what kind of systems people will have. I still don't know how to ensure that they will be able to connect to the database for I have already had problems in Windows 7 computers which don't have jet oledb.4.0
I am a bit lost here because I don't know if I should first try to do a connect, or if I should first look for a jet oledb engine on the computer where the software is installed. And in case they don't have it installed should I prompt them to install it before running the program further? Or should I pack the engine along with my program? What is the line of thought here to make the program run on (almost) any machine?
how do I use notepad as a database inside a vb.net program.I am making an athletics database/profile program which will include all school records for each and every student.So what I want to know is, how do I use a notepad file, filled with data, to perform search functions on records (like finding the fastest times in a particular event) and sort functions (assending order of times etc.) and view them on a form.
View 1 Repliesi'm using vb 2008 express editor, and 3.5 compact sql, through my program, i make changes, like altering rows, deleting or adding new rows, to a dataset. i want, that when button 1 is pressed, all changes made to that dataset, are updated to my database. what is the line of code that does this? [Code]
View 1 Replies---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?
View 1 Replies
