Database - Each Estimate Can Have Its Own Individual Parts List ?
Jun 5, 2011
The program I am trying to make needs to be structured like this.
Table 1: Estimates (Details View)
Customer ID
Employee ID
Form Factor
Problem
Proposed Solution
Estimate Acceptance (Boolean)
Table 2: PartsList (Grid View)
Part Number
Part Name
Part Cost
Now, the trick is, I need to have it where each Estimate can have its own individual parts list. It needs to be this was as each estimate could have just one part, or many parts. How can I do this effectively? I already have the tables and the layout of the app, I just need to get it all connected up.
View 4 Replies
ADVERTISEMENT
Jul 11, 2011
So I have a code atm that has 2 combo boxes, one to select the make, then it will enable the model, I have 3 model choices, here's code: [code] Once I have selected my model of the car, it takes me to that specific form with a picture of that model, I then want to display individual parts, with individual prices that will add up in a text box above.
View 2 Replies
Jun 2, 2012
using vb 2010 to find the fingerprint or digital ID of individual parts of a computer, specifically the motherboard? I have no idea where to begin and everything I can find on the net is written for C#.
View 2 Replies
Apr 23, 2012
I have thius code that gets the html results of google search
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
Dim PageElements As HtmlElement = WebBrowser1.Document.GetElementById("rso")
TextBox2.Text = PageElements.OuterHtml
Dim text = TextBox2.Text
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
WebBrowser1.Navigate(TextBox1.Text)End SubAnd it returns the html code.I want to get each list item and takes it html and put each individuals html in to a variable. How would this be done.
View 1 Replies
Jun 22, 2009
Im trying to write a program that displays the content of folders to show files and directories using a treeview with images. I have acheived this and the code is below but what i would like to do is to remove all unwanted parts of archives.Display Example.rar and remove Example.rar, Example.r00, Example.r01 or Display Example.rar and remove Example#Part1.rar, Example#Part2.rar
The reason why i am trying to do this is because i am looking to set a loop that will copy or extract files in certain directories but the problem is with partial files is that full extractions are done to each individual part. Say for example there is 10 files to one archive, the extraction is repeated 10 times, for 20 files, 20 full extractions and so on
Imports System.IO
Public Class Form1
Dim tPath = "C:Documents and SettingsAll User"
[code]....
View 1 Replies
Feb 25, 2011
I have a form with a combobox that is filled with a list of parts from a mysql DB. But the table contains more then 1000 parts. So I decided to load only the first 20. then have 2 bottuns 1 for UP and one for Down. when the user wants to get next 20 he press Down Etc. I see that the data is retrived well from the DB. I use a stored procedure with parameters and test it outside the VB code. In the VB debug I also see that the combobox got loaded with the right data. But the drop down list continue to show the original 20 parts. I also have a code to see if I got to the top or to the end and display a message box. I got the message box display but still the drop down is showing the original 20 parts.
View 4 Replies
Apr 18, 2012
This is a WinForms Application in VB. In my application I am trying to make it easier for the user to pick out items in a list quickly based on the items text color.. So I am trying to assign the color to each item using a select case statement as below... The problem is that I am getting an error saying "Public member 'Attributes' on type 'String' not found." VB flags the lines with the Attribute.Add param with this error.. Here is the code that I currently have...
For Each u In _units
_counter += 1
u_lookupNumber_box.Items.Add((Convert.ToString(u.UnitId)) + " - " + (Convert.ToString(u.perMonthCost)))
[Code].....
I did notice that when I did the .attributes part when I hit "." and typed "att" it did not appear in the intelisense box in vb.. Which makes me think I need to assign the name "attributes" somehow to the dropdownbox first.. It should be noted that u_lookupNumber_box is the name of the drop down box on my form..
View 2 Replies
May 27, 2010
I normally place all db related work in my databases in SQL Server Express 2005. But in tutorials I have seen, I heard that one needs to re-create referential integrity and relationships and constraints and checks and defaults anew in datasources mapped onto databases. Is this true? What parts of a database are NOT mapped on to datasources?
View 2 Replies
Oct 24, 2009
I have an access database with one table and 4 or 5 different fields.
All I need to do is be able to be able to use a loop to read the values in a specific row and column and store it in a variable (or array).
I don't need the code for the loop or anything, just the syntax for reading the value of a specific row and column in a table to a variable.
View 3 Replies
Aug 12, 2010
I am doing a project on Sending/ Recieving SMS through VB.Net 2008. I am getting the following string while recieving a message from the modem
+CMGR: "READ READ", "+919223336661",,"08/10/10,12:45:00+22"THIS IS A TEST MESSAGE
Now I want to break it and store in database as
Sender= +91223336661
Date Time= 08/10/10,12:45:00+22
Message=THIS IS A TEST MESSAGE
Where Sender, Date Time and Message are the column name of the database. The maximum length of the Message is 160 characters.
View 1 Replies
Jan 20, 2012
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.
View 5 Replies
Aug 12, 2010
I am doing a project on Sending/ Recieving SMS through VB.Net 2008..I am getting the following string while recieving a message from the modem +CMGR: "READ READ","+91922333666 1",,"08/10/10,12:45:00+22"THIS IS A TEST MESSAGE..Now I want to break it and store in database as [code]where Sender, Date Time and Message are the column name of the database. The Maximum length of the message is 160 characters.
View 2 Replies
Sep 7, 2009
I have an app that encrypts a file, and I would like to have an estimate of the time remaining, but I don't know how.
View 5 Replies
Mar 23, 2010
I am tring to make a price check calculator and in order for me to do that i need my users to choose their price level.
Right now i have a small web form created and its quite simple but i need my button for onclick to do link to corresponding forms that it goes to...Right now i have it as:
Public
Partial Class WebForm1
Inherits System.Web.UI.Page
[Code].....
View 3 Replies
Sep 19, 2011
how to estimate the time left to complete a download
View 6 Replies
Jun 8, 2012
I am currently using following code to estimate the size of the textbox:
Dim i As Integer, j As Integer, pGr As Graphics, sz As SizeF
For i = 1 To pNumRows
For j = 1 To pWidth
sb.Append("W")
Next
[Code]...
I was wondering if there is any way to remove the for-loops and do away entirely with the pGr (textbox.CreateGraphics) method and still correctly estimate the size of the textbox.If you're wondering why I am (actually the person who wrote the code) is looping through all the 'W', it's because (I think) 'W' has the biggest width and height in the entire character set, so the person (who wrote the code) is trying to guess the maximum area needed.
View 1 Replies
Dec 3, 2010
I have a program that reads from a database...the database pulls its info from a site.it measures in 0 to 100 (%).I know it takes 3 days (i dont know if its EXACTLY 72hrs)..to get to 100%.Currently, i have a progressbar to read from the database field..which is the value.I'd like to 'estimate' the time left before it reaches 100...Is there a math formula for that?
View 3 Replies
Oct 18, 2010
binding navigators, datagrid view, binding source are all sql database parts.Will these parts still work if you havent got sql on you pc and your not using an database file (.log and .mfd) and your not coding to them, im using MS Jet/Oledb to code to Excel.What not to put on an Employee evaluation: This employee has hit rock bottom and shows signs of starting to dig.
View 2 Replies
Jan 22, 2011
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 Replies
Jun 3, 2009
i am having problems getting my code to delete certain parts on an XML.I've tried..
DirectCast(ListBox2.SelectedItem, Data.DataRowView).Item("name").Delete()
DirectCast(ListBox2.SelectedItem, Data.DataRowView).Item("description").Delete()
DirectCast(ListBox2.SelectedItem, Data.DataRowView).Item("manufacturer").Delete()[code]....
But get Quote: Public member 'Delete' on type 'String' not found
View 1 Replies
Nov 16, 2009
I have a xml document that i want to edit, for example true texboxes, any other way would also be welcome :))
[Code]...
View 3 Replies
Jun 18, 2009
Im dont know whos familiar with acronis but im using the command line version and some scripts i made to restore data to hard drives.The program is running in CMD, so its should be doable. It also not only needs to redirect but keep the CMD windows open so i can input y/n if is requires it. [code]...
View 3 Replies
Aug 16, 2010
I have 4 textboxes three for input one for output. Basically what it does is takes input from textbox1, 2 and 3 then combines them in textbox4.here is an example:
textbox1.text = "AA" textbox2.text = "BB" textbox3.text = "CC" textbox4.text = "AABBCC"
what I am trying to do is is compare the input with the output.so take the first two characters in textbox4 and see if they are the same as in textbox1. then take the second two characters and see if they are the same as textbox2.
I know how to do it for just one string of characters but I am not sure how to seperate out different letters in one textbox.
View 5 Replies
Jun 21, 2010
I have a datagrid that show an online status. the Status column have 2 status, OnLine n OffLine. I want to make any record that Status = Online into bold style.
View 2 Replies
Jan 16, 2010
i want to update different areas of my MVC page after one action (say a click) occurs.how, i use ajax, and wrapping the entire area where all these parts need to be updated is counter intuitive as the ajax data being sent back would be close to the entire page.i have a few partial views, - but the problem is, each action only returns one view! how can i return multiple views from this one action?i know a popular solution is to just hammer the server with multiple async javascript ajax requests for each "part" of the view, but this really is unnecessary and inefficient, reconstructing and destroying the page (say) 5 times for just one action, when it should just occur once, and once it does, the server should manage all the partial views then and there.
View 3 Replies
Jan 28, 2010
This string is automatically generated with an application I can't access or change[code]....
View 1 Replies
Jun 4, 2009
I am trying to get the date parts selected by a user on the MonthCalendar control. I know how to set the date, thanks to some help from this forum. Now I have run into another problem. I need to be able to take the MONTH, YEAR and DAY selected by the user. I have tried this example I saw, but it does not work, mmDay = CalendarMonth.Tex.ToString("d").
View 1 Replies
Nov 2, 2011
How to divide a wav file into two parts. I don't very know how to implement this functionality. If possibly, can you give me detailed code snippet or other some useful link.
View 4 Replies
Sep 28, 2009
Many types of credit cards have the same format. This format is XXXX-XXXX-XXXX-XXXX, where X is a digit.The dashes are embedded into the string containing the card number.Create a console application to * Declare String variables Partl, Part2, Part3, Part4, and InputString. * Read a credit number consisting of 16 digits only, no hyphens, into InputString.* Write the statement(s) to extract each four-digit segment into Partl, Part2, Part3, and Part4* Display the four parts.This is what I have, and I cannot figure out what I'm doing wrong because there is an error when it runs.
Sub Main()
Dim inputString As String = "1234567891234567"
Dim part1, part2, part3, part4 As String
[code]....
View 3 Replies
Sep 30, 2009
Written down a xml.
We are using vb2005.
How can we read for example on a simple way the node: logstartdate of the three parts.
xml:
<?xml version="1.0"?>
<Map><Algemeen><Vernietigingsjaar>2005</Vernietigingsjaar><total>3</total></Algemeen><Logs><Log><action>action2</action><number>1</number>
[Code].....
View 4 Replies