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 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 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]......
I'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.
A 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 am developing application using both C# and vb.net.How can I get information about Current internet connection like IP address (not Local System IP) given by service provider, Location details (ISP Name, ISP description, Country, Address, City, PinCode, and etc.)?
View 2 Repliesi want list all forms in current project. example
listbox1.items.add(form1.name & form1.text)
i want load all form details in current project.the following code give for only open forms.
For linti As Integer = Application.OpenForms.Count - 1 To 0 Step -1
Application.OpenForms.Item(linti).Text
Application.OpenForms.Item(linti).name
Next
i want all form and its text.
I need to add some common details in more than two tables. [code]So i have stored the Department (from drop down list box) and assigned it to Dept.So i guess dept would have Csc if i choose csc and commerce if i hoose commerce.When I checked with breakpoint it s workin. Datas are added perfectly. But they are not visible in that respective table
View 2 RepliesSay someone purchases something in store and I have set up so the customer receives an e-mail confirming the purchase and date of delivery, I want to put the customers credit card details on the e-mail but i want them to be in the format off ******1234, how would i go about hashing out the first 12 digits and leaving the rest to be seen?
View 1 RepliesI have a form for the Clients, and the user goes through and adds in all their details. But sometimes two Clients are linked together in a marriage or whatnot. I have one Clients table, and if I make two details views of it, all that happens is both views display the same Client, when they should be different. Currently, I'm adding in the second client via another form, and using textchanged events to display the data on the original form. How would I put both clients on the same form without the first clients information repeating itself? I would like to avoid using binding sources if possible.Also, I have a second question, how do I refresh the information in the details view without using binding sources? I've used queries for add/edit/delete, and I've attempted to create one to refresh, but it's not working well at all.
View 2 RepliesI need to be able to get the details of a m4a file (Title, artist, album) via a script so I can rename and move the files into a folder. Currently I have around 3200 songs that I accidentally renamed and moved to the root of my drive. I want to write a script to put them back into an organized file structure. Is there a way that I can do this using VB or Powershell?
View 1 RepliesI have a "remember my pass and username checkboxes" on my login , but i want do use another button , so that when i click it , it will for get my login details ?
View 3 RepliesI am trying to get files for my database and load it into comboBox. But for some reason I get systax error.. As I mention into other post I am not familliar with VB so check my code and let me know where I mess up... Here is my code:::
Public Class Form2
Dim DatabaseOpenConnection As New SqlConnection("Server=localhost;User Id=root;Password=root;Database=test")
[code]....
i have invoice form separated into 2 parts the upper part is master (header) and detail (body) in invoices where header contains date,name,invoice number,etc ..and the lower part is the body contains the datagridview with its details like the item name or code,qty,price,discount,etc the problem is i want to save the invoice headers in a table and the body in another different table but with a realtion between the 2 of them by the invoice id i think i put it in the invoices' form load. but i cant get it right.by the way iam using vb. net 2005 and my db is sql 2005.
View 1 Repliesi want speech reg. source details in vb.net how it is possible
View 1 RepliesI want to get the details of a com port on my machine. To be more precise the com port presents itself in the device manager as:
MyPort(COM3)
I know how to get the name of the port i.e. COM3. Is there a way to get the rest of its description i.e. "MyPort".
How can I collect details regarding the hardware and software, of a PC ?As for registration process of the product (my app), I wish to collect the details of that PC and get it saved into my server.When the client request for a new serial key, because of formatting the PC and other reasons, I would compare the PC details and will issue a new serial key based on the result. (small changes in the PC will not be considered)
View 4 RepliesI have a dialogue box that pops-up on a click event which offers the user a selection of three employee types which are selected using checkboxes. These checkboxes have been drag'n'dropped and are in a groupbox, called uiSelectEmployeesGroupBox.
On this click event, I have the following
'some code omitted for clarity
If uiEmployeeDetailsDialogue.uiEmp1CheckBox.Checked Then
mEmployees.Add(New Emp1())
[Code].....
1.How to handle com exception? Here is the attachment of the error... (1st attachment)
2.Is there any way to convert .accdb file to .mdb or .mdf?(2nd attachment)[code]
To create a login form which checks the username and password fields from the database.
I`m using below login solution and need to add one more column with Working Group details.
Once user logs-in (after OK command MDIparent form is displayed), working group details will be displayed in toolstrip status label.
[URL]
I'm trying to allow users to update their details after logging in on an asp site using vb. Textboxes are populated with user details using session variables in the form_load. The textboxes should be editable but for some reason are not registering the changes when the submit button is clicked.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Txt_Fname.Text = Session("First_Name")
Txt_LName.Text = Session("Last_Name")[code]..........
I am trying to edit and update a selected users details, following the tutorial
[Code]...
I have a gridview that displays items details, I added two template fields one is a checkbox and the other is a textboc, what I want is simply to check all the items the customer wants to buy, and write down the quantity in the textbox, when I click on a button, I should check all rows in the gridview and when the checkbox is Checked then I should compare the value in the textbox with the value in a databound field of the gridview called Quantity and then carry on my order function...
View 1 Replies