|
|
I have this code in my vb.net program.
Me.TickersTableAdapter.Fill(Me.DataSet1.Tickers)
It fills the data from the external file fine. However, I'd like to be able to refill the data after it has been changed by an external program. Calling the line a second time doesn't work because I get "datareader already active on this command" error. How can I refill the data from the external file?
tia
|
|
|
|
|
create another data adapter?
|
|
|
|
|
Sorry, that doesn't make sense to me. I have one dataset that I want to keep updated. The dataset can be updated by an external program. I would like to refresh the dataset by re-reading it periodically to reflect those external changes. This seems like it must be possible using only one data adapter. But maybe I'm missing something. thanks for your response!
|
|
|
|
|
first of all make a function to fill dataset .
then whenever u want to reload ur dataset , call ur function .
but dont forget to clear the table(Tickers) in which it is going to load b4 calling the function . i hope it might work for u .
|
|
|
|
|
hi,
i don't know if there is any way to do this but here is what i would like to do:
1. open an AVI file (which has just video data)
2. open a MP3 file
3. saving the two together as an AVI file
any suggestion, hints,..?? please!!!
thanks 
|
|
|
|
|
I don't know about using an mp3 file directly, but you can use the program VirtualDub to merge an avi file with a wav file. Open the avi file and select the wav file to use for audio. Select Full Processing Mode for audio and select mp3 for audio compression. Select Direct Stream Copy for the video and save as a new avi file.
---
b { font-weight: normal; }
-- modified at 4:21 Monday 24th July, 2006
|
|
|
|
|
Guffa wrote: I don't know about using an mp3 file directly, but you can use the program VirtualDub to merge an avi file with a wav file. Open the avi file and select the wav file to use for audio. Select Full Processing Mode for audio and select mp3 for audio compression. Select Direct Stream Copy for the video and save as a new avi file.
I know that, but i wanted to be able to do this within my program in VB.NET
there's the problem 
|
|
|
|
|
You sound like you've never even seen this done before.
There is a LOT more to it than just copying two streams together. You have to make sure bit rates for both streams are correct and that you supply exactly that much information. Synching up the audio and video is difficult and KEEPING it synch'd harder!
There are some open source tools that do this very thing. Search SourceForge for a few. Take a look at their source code and you'll find out just how complex this project really is.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
How can i add DTS Package into my aplication?and is it possible to execute the package with no SQL Server installed?Thanks.
|
|
|
|
|
Hi all,
I am trying to move data from an access mdb file to mySQL using VB.NET.
I am re-designing the new schema on mySQL and want to move the access
data to mySQL.
I'm using mySQl 5.0 and the .NET connector. If anyone can point me to some sample code or give me some pointers I would greatly appreciate it.
I tried experimenting with using mySQLDataAdapter but am getting "Conversion from String "fieldname" to type integer is not valid. "fieldname" is define as integer in the access db and "fieldname" is define as decimal in mySQL.
Thanks.
|
|
|
|
|
How do i change the ShowWithoutActivation property for my form and mke it so that when my form shows, it doesn't steal focus.
Posted by The ANZAC
|
|
|
|
|
ShowWithoutActivation is a read-only property. You can set form’s TopMost property to True, if you like to show your form without activation.
|
|
|
|
|
i am using a datagrid and if currently i am in a row of datagrid and i want raise an event of datagrid row becoze there is not predefined event for the row of grid. focus is on grid row how i will use key press event plz tell me.
|
|
|
|
|
I am getting this error when I run the program. I am not sure how to fix this error, if anybody can help me I will appreciate it. The program has two forms. Form1 has the search textbox and form2 takes the information from form1 and populates form2. I have attached the code for both forms, so you can see what I am talking about. Any help will be appreciated. Thanks
Form1 Code:
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click<br />
Dim oForm2Data As New Form2.Form2Data(Me.txtbarcodeid.Text)<br />
<br />
If oForm2Data.HasData Then<br />
<br />
Form2.Initialize(Me, oForm2Data)<br />
<br />
Else<br />
' The Data does not exists for the item in the textbox<br />
<br />
End If<br />
End Sub<br />
Form2 Code:
Dim dt As New DataTable<br />
Dim sqlStr As String = "SELECT * FROM testbackup"<br />
Dim sqlstr1 As String = "SELECT * FROM history"<br />
Dim connstr As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source = backup.mdb"<br />
Dim dataadapter As New OleDb.OleDbDataAdapter(sqlStr, connstr)<br />
<br />
Public Shared Sub Initialize(ByVal Owner As IWin32Window, ByRef oForm2Data As Form2Data)<br />
Dim result As DialogResult<br />
Dim frm2 As New Form2<br />
<br />
With frm2<br />
'Using TheData Populate each Control on Form2<br />
End With<br />
<br />
Result = frm2.ShowDialog(Owner)<br />
<br />
If Result = System.Windows.Forms.DialogResult.OK Then<br />
<br />
<br />
With frm2<br />
'Now update the values in TheData with its value in its Form2 Control<br />
End With<br />
<br />
'Save Changes<br />
oForm2Data.SaveData()<br />
End If<br />
<br />
End Sub<br />
<br />
Public Class Form2Data<br />
Public HasData As Boolean<br />
Public TheData As DataRow<br />
<br />
Public Sub New(ByVal Value As String)<br />
Dim dsData As DataSet<br />
Dim stSQL As String<br />
<br />
stSQL = "Select * from testbackup Where barcodeid = '" & Value & "'"<br />
<br />
'Database code to return dataset to dsData<br />
<br />
<br />
Select Case dsData.Tables(0).Rows.Count<br />
Case 1 'One Row Returned<br />
HasData = True<br />
TheData = dsData.Tables(0).Rows(0)<br />
Case 0 'No Rows Found<br />
HasData = False<br />
TheData = Nothing<br />
Case Else 'More then one row returned<br />
'Decided how to handle<br />
HasData = True<br />
TheData = dsData.Tables(0).Rows(0)<br />
End Select<br />
<br />
<br />
End Sub<br />
<br />
Public Sub SaveData()<br />
'Routine to save the data<br />
End Sub
|
|
|
|
|
Where is the exception being thrown?
Mike Lasseter
|
|
|
|
|
at this statement
Select Case dsData.Tables(0).Rows.Count
|
|
|
|
|
I don't see where dsData is getting Initialized. Is your database code working?
Mike Lasseter
|
|
|
|
|
which database code. I am not sure which one. I wanted to post my program here, but I don't know how to do that. Can you tell me where to initialize my dsdata
|
|
|
|
|
<br />
Dim dsData As DataSet '--THIS VARIABLE IS NOT GETTING INITIALIZED/SET<br />
Dim stSQL As String<br />
<br />
stSQL = "Select * from testbackup Where barcodeid = '" & Value & "'"<br />
<br />
'THIS IS DB CODE I AM TALKING ABOUT<br />
'Database code to return dataset to dsData<br />
<br />
Without seeing the code I can't say exactly where your problem is, but here are some things to check.
1. Is the dsData nothing when you step through your code?
2. If not does it contain any tables?
My guess is the dsData is not getting populated correctly in the Database Code
Mike Lasseter
|
|
|
|
|
can i e-mail you my program, so you can see what is happening. let me know. thanks for your help so far
|
|
|
|
|
Just post the code for 'Database code to return dataset to dsData in the forum. It shouldn't be that long.
Mike Lasseter
|
|
|
|
|
I am not sure what to put in that area. Would you be able to help me with that if you don't mind. thanks
|
|
|
|
|
|
Public Sub New(ByVal Value As String)<br />
Dim dsData As DataSet = New DataSet("BackupInfo")<br />
Dim stSQL As String<br />
Dim backupTable As DataTable = dsData.Tables.Add("testbackup")<br />
<br />
stSQL = "Select * from testbackup Where barcodeid = '" & Value & "'"<br />
<br />
'Database code to return dataset to dsData<br />
<br />
<br />
backupTable.Columns.Add("Barcodeid", Type.GetType("System.Int32"))<br />
backupTable.Columns.Add("location", Type.GetType("System.Int32"))<br />
backupTable.Columns.Add("datein", Type.GetType("System.String"))<br />
backupTable.Columns.Add("dateout", Type.GetType("System.String"))<br />
backupTable.Columns.Add("timein", Type.GetType("System.String"))<br />
backupTable.Columns.Add("timeout", Type.GetType("System.String"))<br />
backupTable.Columns.Add("comment", Type.GetType("System.String"))<br />
<br />
Select Case dsData.Tables(0).Rows.Count<br />
Case 1 'One Row Returned<br />
HasData = True<br />
TheData = dsData.Tables(0).Rows(0)<br />
Case 0 'No Rows Found<br />
HasData = False<br />
TheData = Nothing<br />
Case Else 'More then one row returned<br />
'Decided how to handle<br />
HasData = True<br />
TheData = dsData.Tables(0).Rows(0)<br />
End Select<br />
<br />
<br />
End Sub
-- modified at 16:57 Saturday 22nd July, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
