Can anyone reccommend a good database that I can use on a local machine to storenames/addresses etc. and that integrates easily into .Net 2.0.I have used MySQL a fair bit, so something along that route would be great but without the need to install additional software on the computer or connect externally to a server
View 1 RepliesI am working on a small concept but since i am a novice in .net i am not getting the concept.I have 2 controls on the page.1st is Text Box: User enters the int value and that value is checked from database. In database there are 3 fields. One for ID, second for int value and 3rd for country.If the text box value in database is associated with country US then it should show US in 2nd control ( can be text box or combo box) in UI. Else for anything else it should show London.
View 3 RepliesOur project is to make some simplified POS software, in our case, for a restaurant. The form I am currently working on is where you pick food items and add them to a listbox which will essentially be the order form. I made a database in Access that has food-item info and linked it to the VB project.url...My combobox narrows down the food items according to what category is selected, i.e. "Lunch".Now.. is there any way I can select an item from my database records (right box) and add them to an empty listbox that I'll save to a txt file. The database box is called "FoodItemsDataGridView" but maybe I don't even refer to that, I have no idea..
View 1 RepliesI have this online quiz that generates random questions, but the only problem is that it repeats the previous questions. I have limited questions (I have 10 questions in my table, but I have limited the number of questions to be 5. The output would only display 5 random questions) which I named as RequiredRecords.
question_id
1
3
4
[code].....
I have tried to visit this question, but it doesn't resolve my problem. Below is some of my code and SQL statements I used.
I figured out that there's nothing wrong with my query on creating random questions and I can display it with no duplication, but there's something wrong with my other codes that makes the program having a duplication.
Code Behind using VS2008 3.5
Partial Class Student_DetailView
Inherits System.Web.UI.Page
Shared TotalRecords As Integer
[code].....
how to retrieve data from SQL Database using SQL Connection by selecting the individual value in a ComboBox which the data in the ComboxBox is also retrieved from the SQL Database using DataBound. A 'Display' Button will be clicked to display the data in a TextBox, based on which value the user had selected.
Below is my current
Private Sub displayBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayBtn.Click
'Create Connection
[Code]....
I'm doing INVENTORY project... i'm using ACCESS databse with vb.net... i'm having purchase, sales tables...
THIS IS MY PURCHASE TABLE:
CodePriceCategory TypeDat SPBrnd
11222cde bgf9/10/2025356asd
12255MEN Shirt5/10/2010355Vanhesun
55322bb bb9/10/2025456asd
66422bb bb9/10/2025556fdd
when i select CODE in SALES form, corresponding values have to shown in respective fields... I.e if i select 55, corresponding values have to be retrieved and showed in respective fields...
trying to display data with space from database (ms-access) eg selecting 0776578969 and displaying 0776 578 969 using access and vb.
View 2 RepliesI have the following code to select records from an access table based on a date range. The user is required to select a week ending date (Saturday) from a datetimepicker field.The date field in access is formatted as short.The values in the database range from 12/04/2009 to 2/05/2009. When I select datetimepicker as 2/05/2009 (i.e. 2 May 2008), no rows are returned. Following is the resultant sql statement:
show: Select * FROM Work_Time WHERE WorkerID =1001 AND (WeekDate >=#26/04/2009# AND WeekDate <=#2/05/2009#)
However, if I select datetimepicker as 25/04/2009, the correct numbers of rows are returned. Following is the resultant sql statement:
show: Select * FROM Work_Time WHERE WorkerID =1001 AND (WeekDate >=#19/04/2009# AND WeekDate <=#25/04/2009#)
Private Sub btnGetTSData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetTSData.Click
Dim dSelect As Date
dSelect = dtWkEnding.Value
[code]....
I cannot get my combo box to populate using a select statement from mysql database.
[Code]...
I posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
[Code]...
I want to take my access database which i used in my project on visual studio2008 backup by selecting the local drive of my computer at the time of backup i choose the drive & there were i taken the backup i restore my database. Is is possible to take backup atomatically when i close my application.
View 1 RepliesOk, so I`ve been studying a bit of VB lately.. bought a few books and read lot`s of articles and seen hours of instructional videos, and I slightly start to get the hang of a few things.. :) I`ve recently started a fun little project, but I seem to lack a bit of knowledge to reach my goal. I`ll first try to describe my project:
[Cde]...
I am trying to get back a single from from a EF database model using the below line of code..
Dim _classRoom As classrm = db.classrms.Select(Function(b) b.Course_ID = _CurrCourse.course_ref)
Where classrm is the name of the entity and db is declared as a new entity. What I am trying to do is select a row from the entity based on matching Course_ID which in this model is a string. So that I can later use the variable _classRoom to get other items out of the same row.. However I am getting the following error:
Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[System.Boolean]' to type 'Trial_Online.classrm'.
I have to preform similar tasks with several different Entities but if I get pointed in the right direction I can manage from there...
Using a checkboxlist not a simple checkbox I need to select 1 checkbox otherwise display a error message in an label once I submit the form. My checkboxlist does generate correctly now I just need to validate it
'check checkboxlist
For Each ckbox In checkBoxCropsFertilzed.Items
If ckbox.Selected > 1 Then
lblErrorMessage.Text = "too many selected"
End If
Next
I have the following document[code]...
Now, how can I get the ID of the Div, by selecting text in his Field?
For example, if the user selects the text "Div1 - Text" (or part of him), the result should be "ID1".
if the user selects the text "Div2 - Text" (or part of him), the result should be "ID2", and so on.
ive got several combo boxs on a search form and its all working great if you select the items from the list, but have a problem if you type the value, the selectedvalue isnt being returned what do i need to do, this is what im using to get the value when selecting via clicking
Private Sub BTYPE_ComboBox_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTYPE_ComboBox.SelectedIndexChanged
If Len(Trim(BTYPE_ComboBox.Text)) > 0 Then BTYPE_FILTER.Text = BTYPE_ComboBox.SelectedValue.ToString Else BTYPE_FILTER.Text = 0
End Sub
I wrote some software that use the AVICAP32.dll to do a spot of video capture.All was going well till they went and bought a laptop with a built in webcam.Now my software picks one a random and uses that for the video (somewhat annoying to say the least) Can anyone tell me how to pick a camera to use,I suspect it is related to DVM_DIALOG but my experiments have not been too successful.
View 1 RepliesI Have a problem with selecting a row in a datagridview. I want the user to press on the data rowheader of the data gridview of a particular row and then that rows first item are put in a string. But the problem is that if i Select an item another item is still selected. So If I press the mouse button on the row header the previous item is still selected and then the wrong data is in the string. Here is the code under the event of the datagridview mouse click:
Private Sub dataGridView1_MouseDown(ByVal sender As Object, ByVal e As MouseEventArgs) Handles DataGridView1.MouseDown
Dim hit As DataGridView.HitTestInfo = DataGridView1.HitTest(e.X, e.Y)
Dim index As Integer
[code]....
I am trying to get back a single from from a EF database model using the below line of code..
Dim _classRoom As classrm = db.classrms.Select(Function(b) b.Course_ID = _CurrCourse.course_ref)
Where classrm is the name of the entity and db is declared as a new entity. What I am trying to do is select a row from the entity based on matching Course_ID which in this model is a string. So that I can later use the variable _classRoom to get other items out of the same row.. However I am getting the following error:
what is wrong in this statement i want the time to show after e selected time
i want the time to be shown after 22:00
for each r as datarow in mydataset.tables("Bookingen").rows
if r.item("td") >="22:00" then
messagebox.show(r.item("td"))
I have a form that needs to add user selected items to a listbox. But these selections are done outside the form itself. So in windows explorer, the form pops up and then the user keeps clicking on files and I want these file names to be added to the listbox. How can I do this? in my case, as soon as I click outside, obviously the form loses focus. How can I "listen" to mous clicks outside?
View 3 RepliesI have a series of ovals named "lamp1" through to "lamp26" and wish to change a particular lamp's backcolor.I have done this for labels (Controls("Label" & intButton).BackColor = Color.Black) but Controls does not work for Ovals. I assumed this was because Ovals are part of the PowerPack set but I cannot get any further.
View 1 RepliesI've data of 40 temperature sensors in a data table. I want to extract particular column from SQL from this data table, usually for this to occur One can Say write "Select value FROM table" where value is the parameter, this is ok, but it returns a value in specific row(s) of specific column whereas i want opposite. I want to my query to select particular column as argumument. I have 40 Columns.
Like: SELECT S1 FROM Table, SELECT S2 FROM Table .... but this is too hectic to write it for 40-50 sensors. Is there any way that i can replace S1-S2 in above statement as argument and provide it on runtime to select particular column?
My problem is i have two comboboxes, cmbFamily and cmbModel, I have values in cmbFamily: A320, A330 etc And i have a database that has all the available models for these aircraft types, i have got some help on a query so i can fill up cmbModel with all the models of aircraft available, but i only want to display the models related to the family that is selected in the cmbFamily combobox.
The query i have so far is
Query = New OleDb.OleDbCommand("Select Model From Availability", AccessConn)
'AccessConn is my database connection string I would like to have something that views the text in cmbFamily and then looks for all related model entries in the dataset.
I want to select a Particular Row from a DataTable;may i know what is the best way of doing it?
This can be done using the DataView but i want to know the best way of doing the same.
i can write the xml i need which looks like:[code]This shows me the value fine! when i change the attribute name to another field like: MessageBox. Show((XMLItem.Attributes("postingHiddenFieldsCount").InnerText))i get a null reference error,
View 9 RepliesI have following xml:
[Code]....
and I need to pick node from Id 25 to id 75. It is a portion of XML. Original XML is very long. How to do it without XPath? Dim nodeList As XmlNodeList = xmlDoc.SelectNodes("//Node[@id >" & 25 & " and @id <" & 75 & "]") Dim sb As StringBuilder = New StringBuilder For Each childNode As XmlNode In nodeList sb.Append(childNode.InnerText) Next but it is not working ...
I have a simple ASPX page with a listbox and a button. Listbox has about 8-10 items in it. After the user selects an item (listbox is multi-select) and clicks the button, I'm iterating through the items to get the selected one like so:
For Each Item As ListItem In lstLetters.Items
If Item.Selected Then
Dim LetterID As String[code]....
When I step through the code, I select the first item from the listbox. I setup a watch on the 'Item' variable. The code will iterate through each of the items -- but Item.Selected always reads 'False'.I double-check the page, and sure enough my item is selected on the form.What the heck is going on?
I want to know if there's a better method for selecting the sender of a sub like this .[code]
View 8 RepliesI have a datagridview that is bound to a dataview. I use a textbox to sort the list of data in the datagridview. Once the list is sorted I want to click on a row to populate the textboxes in order to update the data. Problem is once I sort the data I click on say row 3 and it pulls up the orginal data before the data was sorted in the datagrid view. For instance:
Before Sort:
1. betsy
2. james
3. john
After sort:
1. john
2. james
3. betsy
If I double click row 1 it will pull betsy info into my textboxes instead of john. I currently refresh my datagridview after every letter is entered into my textbox. I also reload my dataview and rebind the dataview with the datagridview.