[Code]...
Dear Moderator Sorry for posting it here. Could not find a proper place for posting Query related post and also it was urgent. I have a database in MSAccess.I have a table as tbl_Menu.This table has a parent child relation ship.Parent Node is : MenuItemId and its Child Node is : MenuItemPopUpHeaderID
[Code]...
[Code]...
First i populate the data i wan in a listview than i click on a button to export all the data in the listview into a notepad call default.txt but upon clicking the button i realise that there no data inside my notepad
I want to create a notes app for Windows Phone 7 using Visual Basic.I have read a few tutorials but they are all suited for C# not VB. Basically, I have a main page and a page to add notes. Once the user types out a note on the add notes page, the title of that note appears on the main page. I also want the user to be able to select that title and it will display the note. I have done a bit of research and I know I will need to use isolated storage (not sure how to implement it in VB) to save the notes. I think I will also need a list box that will store the title of the notes.
View 2 RepliesI have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesI am creating a xml with which now i need to attach the name of the mdb file.I dont know if i need to write a query or function.My current database name is Menus.mdb. I have an api which has a ExecuteSql(sqlQuery) Function which automatically connects to the database and returns a dataset.What type of query should I pass here to get the Database Name (Menus.mdb).The name of mdb is not fixed depends upon client to client.
View 1 RepliesI have a text box in which a file path is displayed. A button to click and open the file. Code executes properly but the file dosent open.Here is the Code[code...]
View 3 RepliesI am having btnUpload and btnTransfer. On btnUpload I open a openFileDialogue select any type of file and at transfer i want to transfer it to another location suppose D:TransferTest.But its giving this error Could not find a part of the path 'D:TransferTest'.
The code is as below :
Dim filename As String
Dim ofd As OpenFileDialog
[code]....
Now to save form in while creating or changing, I will have to either write a Insert Statement or a Update Statement with 125 controls to be passes as parameters. Thats hectic..
Solution : I can bind those control to a dataset. At the time of saving, I get the full data in a table in a dataset.
Requirement : Can I get a code for saving in which the dataAdaptor will automatically create a Insert Or Update statement?
Basically I have the follwing:Dim ctx As New AdminCoreEntities Dim roles = (From r In ctx.Roles where r.Name.StartsWith("cust") Select r) 'list of System .Linq.IQueryable(Of AdminCoreModel.Role)
[code]...
The error i get when i run this is: Unable to cast object of type System.Data.Objects.ObjectQuery`1[AdminCoreModel.Role] to type AdminCoreModel.Role
Basically I have a many to many situation and I try to get all the Quicklinks objects queried by their roles and not quite sure why EF will cast to a single AdminCoreModel.Role when i.Roles is a collections of objects.
I have got an xml document which looks something like this.
<Root>
<Info>
</Info>
<Info>
[Code]...
How can i write a linqToXML query so that it returns me an IEnumerable containing each child element, in this case all five child elements of , so that i could iterate over them. The order of child elements is not definite, neither is number of times the may appear.
i have a one two many relationship on a form that loads empty so that the user have to do a search in order to populate the data into the form. To acomplish this, i created a filter (query) in the dataset. The filter works fine for the parent data, but how can i load its corresponding child data?
This is the code generated automatically when i created the filter in the DataSet:
VBCode
Try Me.TblConfidencialesTableAdapter.Buscar_Confidencial(Me.ConfidencialesDataSet.tblConfidenciales, TablillaConfidencialToolStripTextBox.Text)
Catch ex As System.Exception
[Code]....
Im working with MDI parent/child objects. when closing the child objects i need the child to check to see if it is the last child object before closing. i couldn't find anything on google, maybe im searching for the wrong thing.
View 2 RepliesI have an application which has a label, set to multiline. This area of the app is for notes and comments. One of the database tables behind the app is specifically for thenotes/comments table.I want to set it so that when someone puts in a new entry, the date is auto-inserted so we can see when they did it.
View 3 RepliesI've written an VB application and have successfuly got it into the form of a web page using Visual Web Developer (VWD).The application has a link which opens up another web page in a new window. I would like it that code triggered by a Button on this application will only run if the web page has been opened via this link. In VB it was easy as clicking a Button object made code run (which opened up the WebBrowser within the application) and I could therefore include a line of code such as eg. trigger=1 (and then later I could use "if trigger=1 then"). But in VWD Toolbox objects "Link" and "Button Link" take you directly to the web page (ie they are hyperlinks), without giving me the opportunity to include my "trigger=1" line.
View 3 RepliesI used vb2008 and make a good application and make setup file by advanced installer builder .And install and use one month then I formatted my pc .Then install my application without install vb2008but I get a warning message as
View 1 RepliesI have three Tables in the MS Access database as below:
Company_Data
Name|Age|Department|Salary
User_Data
[Code].....
and i have a compare button on the VB form. Is there any code that can compare the Company_Data with User_Data and copy all the records not found in User_Data to Changes_Data table. When updating it should update the "updated on" Column to the current Date.
Same needs to be done in the opposite way. Compare User_Data with Company_Data and note the diff. No Need to update Salary in this case.
I have three Tables in the MS Access database as below:
Company_Data
Name|Age|Department|Salary
User_Data
[code].....
Application - Powerpoint 2003
VisualBasic - 2008
I want know, How can i extract the power point note text?
currently i have created a note pad which contain names
For Example : ( inside the note pad ) Sam1
Candy1
John1
But it not showing up in my listview1 box , it seem to go straight into the Error Msg ( File not found )
Private datCallDefaultResult As StreamReader
Private Sub frmTesting_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I am using the following code to create an email note[code]...
View 2 RepliesI would like to make a sticky note using Visual basic 2010 express. Is that possible ?
View 1 Replieshow Work setup or an executable file in Visual Basic Dot Net 2008 note that the program is linked to a database
View 1 RepliesAlright I am trying to make my checkbox have like a little discription on what the check box means when the users mouse is hovering over it. How would I do this?
View 5 RepliesI am rather new to VB and every now and then I get an idea of a small project I would like to work on to increase my skills. What I am trying to do is:
1. Input the sound from the microphone
2. Detect what pitch the sound is
3. Compare it to the pitch displayed
For example, lets say I was to have the button "Start". When start is clicked, a pre determined (Or possibly random) note is displayed through a Label for 5 seconds (Lets use C as an example). During this time, the user can attempt to match the note C. When the user sings through the microphone VB picks it up, detects what note the user is singing at, and then scores him over the 5 seconds based on the difference between his note and C. It would also be nice if I could display the volume of the microphone, but this is not too important.
I'm pretty new to VB and I chose a project for school to recognise the pitch/note of a sound comming from my microphone (Which I'm using singular notes using my Guitar). I have no idea if this is even possible :/ So if possible, what things should I be considering and what I pretty much need to do to get the ball rolling for me
View 1 RepliesWhat i need it when you select a row, it will add the Note to the richbox. For example when i select that row, it will add "this is just a test " to the richbox. How would i do this ?
View 2 RepliesI want to make a program that detects the note that is being played in front of the microphone. I am testing the FFT function of Naudio, but with the tests that I did in audacity it seems that FFT does not detect the pitch correctly. I played an C5, but the highest pick was at E7.I changed the first dropdown box in the frequency analysis window to "enchanced autocorrelation" and after that the highest pick was at C5.
View 3 RepliesIn VB.NET 2005. i am trying to experiment with sound. I started out trying to produce a single note at a single left-right position, for a particular duration (maybe until i shut it off. with a particular frequency.It can be a sine wave, or a square wave or maybe a general midi sound. This seems to me to be a simple task, but i cannot find out how to do this.I suspect that the answer lies inside direct sound or xaudio2. I want a simple solution i don't want to have to spend 1600 hours learning xaudio2 in order to learn how to how to make a beep.The ideal answer wold be for me to write a routine that accepts waveshape,freq,volume,Stereo_Position,duration).
View 4 RepliesDim obj_DataTable As New System.Data.DataTable("Category")
Dim obj_DataSet As New DataSet()
'Declaring the array of DataColum to hold the Primary Key Columns
[code].....
My program handles XML files that have certain elements within a root-child node that are identical expect for their inner text value. So while populating my combo box with all of a root-child's child element's names I get like five identical items listed. Which brought about the problem of selecting say the third item and getting the value of the first displayed. So I came up with a loop function that determines if the selected combo box item is preceded by one of the same name, if it is, then it adds +1 to a counter variable and keeps checking farther and farther up the list. Once it loops to an item that doesn't have the same name it exits and it reads the Xth (X = counter mentioned earlier) element's inner text from the file. This works great for elements 1, 3, 4, and 5. But not for 2. A while back when I was focused on this problem I discovered the root of the problem but I was unable to circumvent it. I'll put the loop below so you can see the problem in action instead of trying to follow my verbose explanation:
[code]...