passing a dataset...where's my data? - Visual Basic Discussion Boards

currently i was using the AX mediaplayer to play the midi file which most of the game dont use mediaplayer to play sound...
anyone know other method to play the midi which in simple way? and it able to loop the midi file also.

You can use MCI, it s very useful to do simple tasks like this.
I guess u can use the apis sndPlaySound or PlaySound too.

wat is MIC? sory i'm quick begining with vb.net,
even i search in the book none of it have talk about sound function...

Hi,

I'm designing a framework for an enterprise application.

I have done this earlier but I used to define model (properties, methods, events…) inside framework itself.

Programmer writes codes based on the model defined in framework, in other words interface that is created inside framework later implemented by the programmer.

Now I would like to isolate model definition from framework and define the model in a separate XML file so that framework will extract model definition from XML file dynamically.

How do I achieve this ?

Advance Thanks !

Regards,
aB.
D'Oh! | :doh:

well... i think this can be done using codeDOM.

http://www.cswl.com/default.html
Here There is a nice wPaper on "Interface Creation and Deployment at Runtime".

please share your experience on codeDOM.

Thanks,
aB Roll eyes | :rolleyes:

Hi, I have a 5.1 soundcard and im trying to play 5 different sounds (5 different wav files) at the same time, one per each speaker.

Ive checked out some tools which came with the soundcard software and ive seen they could play a sound through any speaker, so i should be able to do it too, but im not achieving it.

Ive tried using MCI, low level apis and a dll ive found on the Internet, but everytime i play a mono sound it is heard on the two front and the two back speakers. Im doing this in VB.Net, but clues in other codes are welcomed.

A note, with MCI, sending:
set id output 0, the sound file was played on the 4 speakers,
set id output 1, no sound was heard,
set id output 2, i got an error,
status id output, i got "mapper" (i thought the argument must have been an integer)
Isnt this the command which I should modify to do what I want?

Do you have any idea about what I should do? Any examples?
Thanks

i have linked the adodc with ms acess using its properties butone of my form is not updating access i have been using this code till now to update my records on access
adodc1.recordset.addnew
adodc1.recordset.update
adodc1.refresh
it shows an error multiple-step operation gemerated error.check each status value.what the hell does this mean Confused | :confused:

the same code is working for my other form.

I am trying to separate my data access code from my form code. I have a created a data access class containing a function to accept an EmployeeID and return a dataset containing just information for that employee. When I try to display the employee information on the form I am getting the column name rather than the value contained in the column. What am I doing wrong?

Form Code

    Private Sub frmMaint_Load(ByVal sender As Object, _<br />
                              ByVal e As  System.EventArgs) Handles MyBase.Load<br />
<br />
        Try<br />
            dsSpcInstrFRM = m_DAL.SpecialInstructions(strEmpIdFromChooseFrm)<br />
            dtSpcInstrFRM = dsSpcInstrFRM.Tables("SpcInstructions")<br />
            lblSpcInstructions.Text = dtSpcInstrFRM.Columns("SpcInstr").ToString<br />
        Catch ex As Exception<br />
            ‘Error Routine<br />
        End Try<br />
<br />
    End Sub

Data Access Code

    Friend Function SpecialInstructions(ByVal m_strEmpID As String) As Dataset<br />
<br />
        Dim sqlRiskDR As SqlDataReader<br />
        Dim SpecialInstructionsDS As New DataSet<br />
        Dim SpcInstrDT As New DataTable<br />
        Dim SpcInstrDR As DataRow<br />
<br />
        Try<br />
            sqlRiskCN = New SqlConnection(My.Settings.SQLRiskCNString)<br />
            sqlRiskCN.Open()<br />
<br />
            'Use Stored Procedure<br />
            strSql = "GetSpecialInstructions " & "'" & m_strEmpID & " '"<br />
<br />
            sqlCM = New SqlCommand(strSql, sqlRiskCN)<br />
            sqlRiskDR = sqlCM.ExecuteReader()<br />
<br />
            SpecialInstructionsDS.DataSetName = "SpecialInstructions"<br />
            SpecialInstructionsDS.Tables.Add(SpcInstrDT)<br />
            SpcInstrDT.TableName = "SpcInstructions"<br />
<br />
            SpcInstrDT.Columns.Add("EmpID").Unique = False<br />
            SpcInstrDT.Columns.Add("SpcInstr")<br />
<br />
            Do While sqlRiskDR.Read()<br />
                SpcInstrDR = SpcInstrDT.NewRow<br />
                SpcInstrDR.Item("EmpID") = sqlRiskDR.Item("EmpID").ToString<br />
                SpcInstrDR.Item("SpcInstr") = sqlRiskDR.Item("EmergInstructions").ToString.TrimEnd<br />
<br />
                SpcInstrDT.Rows.Add(SpcInstrDR)<br />
            Loop<br />
<br />
            sqlRiskDR.Close()<br />
            sqlRiskCN.Close()<br />
<br />
        Catch ex As Exception<br />
            ‘Error Routine<br />
        End Try<br />
<br />
        Return SpecialInstructionsDS<br />
<br />
    End Function

Because you are reading the value from the column information in the data set, not from the data rows. Use the Rows property.

---
b { font-weight: normal; }

Using the rows property makes sense, but now it brings up the question of how I actually retrieve the data from the dataset. As you can probably tell I am new at this. What code do I need to add to my form to get this to work?
Thanks!

lblSpcInstructions.Text =
dtSpcInstrFRM.Items("SpcInstr").ToString
Go here for more info

"People who never make mistakes, never do anything."
My Blog

Using item still places SpcInstr in the text of the label. I am trying to get the value from the column named "SpcInstr". Any other suggestions?

I am trying to create a gantt chart, and the article says that you must right click on your toolbox and add a the EventCalendarControl.dll, but I have added it to the toolbox but it does not highlight. I am using Visual Basic Express Edition.

Please Help

NOKO

Add a reference to the dll. In the solution explorer drag that to your toolbox.

"People who never make mistakes, never do anything."
My Blog

I am having a problem with a user control that I created for a windows form using VB.NET. The problem is that when I click the tab key or minimized the form, the control moves to the right side of the form. I really appreciate if anyone gives me any suggestion to stop moving that control from clicking tab key or minimize the form.

Thanx in advance.

Thanx

This control should only move if you have code to move it. Do you have something setup to change the layout of your controls?? I would also check the designer generated code that creates the controls for you to see if there is anything in there that setups up the wrong docking and anchor properties.

If you have any control containers on your form, make sure that the control that is moving is a member of the correct container.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Thanx for your reply...I fixed the problem. I really appreciate that.

Thanx

I have a multiline textbox on a form that a user can type information into. When they click update it writes the contents to a SQL table. If the user types a quote in the textbox the update fails. How do I update when there are quote characters?

Thanks for any help on the matter

That is because you don't handle the string values in the query correctly. You have to escape some characters when you put a string value in an SQL query.

For MSSQL and Access you escape the apostrophe by replacing them with double apostrophes.

For MySQL you escape backslashes by doubling them, and apostrophes by putting a backslash in front of them.

---
b { font-weight: normal; }

Thanks, I remembered reading that awhile back but had fogotten it.

Or you use parameterized queries (best practice!) and you won't have to worry about escaping anything yourself.

For more information, read SQL Injection Attacks and how to prevent them[^] by COlin Angus Mackay.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I have created a student database in Ms-Access.
the records are stored through the FORM(VB.NET).the form has different buttons for selecting the education forex-Primary,secondary & higher secondary etc.
now what i want is once a record is saved.the value in the name field(that is the name of the student) should be listed in the listbox depending on the button clicked (as mentioned above)

raman

How did you fill the ListBox in the first place? All you'd have to do is call that code again.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I have established a connection with Ms-Acess through dataset.Now i want to know how to generate autonumber in a textbox field(ID_NO) in my form
If i save the record then the next record should not have duplicate values
AND ALSO IF THE RECORD IS NOT SAVED THEN THE NUMBER SHOULDNOT BE SKIPPED
PL TELL ME

Arun

Arun Hegde wrote:
Now i want to know how to generate autonumber in a textbox field(ID_NO) in my form

You don't. That number will only be generated when the record is actually written back to the database.

IF you went a "checked-out" a blank record in the database, you'd get the number generated, but you would be forced to "use or lose" the number.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

-- modified at 10:55 Friday 10th March, 2006