Re: Select Audio Track - Visual Basic Discussion Boards

Re: ADODB recordset not returning case-sensitive results

Dave Kreskowiak25-Sep-13 7:57

25-Sep-13 7:57

I have no idea since I don't have any access to any dBase databases. Thats one I have used since 1986.

I have no idea how to make it case sensitive for dBase.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: ADODB recordset not returning case-sensitive results

TnTinMn25-Sep-13 13:34

TnTinMn

25-Sep-13 13:34

I played around with this bit and was perplexed by your problem with case-insensitivity as I was not seeing it. That was until I noticed that you included an "Order By" clause. At least on my end, it is the "Order By" that makes it case-insensitive. Weird! WTF | :WTF:

I only used a single table, so I don't know if that will effect anything, but it may worth a try to drop the "Order By" clause and see what happens.

If that resolves the issue, you could load a DataTable with your query results and apply a sort on the DefaultView to achieve the needed sort order.

Good Luck.

Re: ADODB recordset not returning case-sensitive results

Member 1026522826-Sep-13 4:51

Member 10265228

26-Sep-13 4:51

I tried removing the "ORDER BY" clause, but the results were the same.

However, after running the query from within VB, I ran the same exact query in WinSQL and it returned multiple rows. Then I ran it a second time and it returned 0 rows. Running it a 3rd and 4th time still returned 0 rows.

I returned to VB and ran the query again. Then I reran it in WinSQL and the first time the query returned many rows and the 2nd, 3rd, 4th, ..... runs returned 0 rows. This behavior is repeatable.

That tells me that the VB app is setting some unknown property that is causing the query to be case-insensitive.

I am going to turn SQL tracing on and see if I can find a difference in the SQL.LOG created from VB and the SQL.LOG created by a good run in WinSQL.

Don't you just love it when the application/objects help you by doing something you did not ask it/them to do !!!!!

Re: ADODB recordset not returning case-sensitive results

Member 1026522826-Sep-13 6:07

Member 10265228

26-Sep-13 6:07

Based on a suggestion from someone on another forum, and mega frustration, I decided to abandon the current ODBC DSN. I found and installed a Visual FoxPro driver and created a new DSN using that driver.

The query is now case-sensitive as it should be.

Select Audio Track

Andre.Adrian23-Sep-13 0:32

Andre.Adrian

23-Sep-13 0:32

How To select audio track use vb.net using cronoapi.dll?

Re: Select Audio Track

Dave Kreskowiak23-Sep-13 1:23

Dave Kreskowiak

23-Sep-13 1:23

Never heard of it.

I have no idea where you got it from, so I don't know where you should ask about it either.

You ask the people who write the .DLL about how to use it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Select Audio Track

Brisingr Aerowing24-Sep-13 11:39

Brisingr Aerowing

24-Sep-13 11:39

ChronoTron[^] it seems.

Keep Clam And Proofread
--
√(-1) 2³ ∑ π...
And it was delicious.

Re: Select Audio Track

Dave Kreskowiak24-Sep-13 12:05

Dave Kreskowiak

24-Sep-13 12:05

Yeah, I Goggled the sh*t out of the .DLL name and came up empty. Either way, the advice is still the same. ask the people who wrote it, not the people who are guessing at what you're using! Wink | ;)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Select Audio Track

Brisingr Aerowing24-Sep-13 14:23

Brisingr Aerowing

24-Sep-13 14:23

Dave Kreskowiak wrote:
Goggled

That's your issue, you needed to Google it!

Keep Clam And Proofread
--
√(-1) 2³ ∑ π...
And it was delicious.

Re: Select Audio Track

Dave Kreskowiak24-Sep-13 15:45

Dave Kreskowiak

24-Sep-13 15:45

Damn spellcheck built into IE!

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Select Audio Track

Andre.Adrian25-Sep-13 23:42

Andre.Adrian

25-Sep-13 23:42

can't you show me how to implement it to vb.net source?

Currency Round Off

Biplob Singha Shee22-Sep-13 4:09

Biplob Singha Shee

22-Sep-13 4:09

Hi all,

I am trying to create a sales invoicing system. Everything is OK but I want to round off (+ or -) the value.

Suppose if Invoice Amount is Rupees 2500.65/-

The round off amount will be Rupees 2501.00/- (i.e. 2500.65 + 0.35)

but if the Invoice Amount is Rupees 2500.45/-

The round off amount will be Rupees 2500.00/- (i.e. 2500.45 - 0.45)

I tried the following function...

Private Function CalculateRoundOffAmount(ByVal autoCalculateRoundOff As Boolean) As Double
        
        Dim result As Double = 0.0
        
        result += CDbl(Me.TbRoundOff.Text)
        Dim roundOff As Double = 0
        Dim roundedOffTo As Double = 0
        If autoCalculateRoundOff = True Then
            roundOff = Math.Ceiling(result) - result
        Else
            roundOff = Me.TbRoundOff.Text
        End If
        roundedOffTo = result + roundOff
        Me.TbRoundOff.Text = roundOff
        Me.TbInvoiceValue.Text = roundedOffTo
        Return roundedOffTo
    End Function

TbRoundOff = A TextBox where the round off amount will be calculated and TbInvoiceValue.Text is the textbox where invoice value is being calculated.

and I implemented it in SaveData() method like CalculateRoundOffAmount(True) but nothing happened.

Please help...

Re: Currency Round Off

Richard MacCutchan22-Sep-13 4:55

Richard MacCutchan

22-Sep-13 4:55

You should not use floating point numbers for financial calculations, as they tend not to hold exact values. Use integer values and convert all your totals to NP. You can then do the rounding quite easily by converting to whole rupees and using the remainder to decide which way to round off.

Veni, vidi, abiit domum

Re: Currency Round Off

Biplob Singha Shee22-Sep-13 6:00

Biplob Singha Shee

22-Sep-13 6:00

Hi Richard,
many thanks for your quick reply. But could you please help me on coding method how would I do that ?

Re: Currency Round Off

Richard MacCutchan22-Sep-13 7:01

Richard MacCutchan

22-Sep-13 7:01

When you enter the money amounts, multiply the rupees by 100 and add the paisa, to give the total and convert to (and save as) integer type. You can then perform all currency calculations on these integer values. When you wish to print or display the values you will divide by 100 to get the round number of rupees and use the Mod operator to get the remainder (paisa). You can then print the two values to give tha absolute total, or use the paisa value to decide whether to round up or down. My knowledge of Visual Basic is not very good, so you will have to turn that into code for yourself.

Veni, vidi, abiit domum

Re: Currency Round Off

Biplob Singha Shee22-Sep-13 7:13

Biplob Singha Shee

22-Sep-13 7:13

Thanks Richard,
Let me try it first.

Thanks again.

Re: Currency Round Off

Richard Deeming23-Sep-13 1:56

Richard Deeming

23-Sep-13 1:56

Richard MacCutchan wrote:
Use integer values and convert all your totals to NP.

Or use the built-in Decimal[^] type, which does that for you.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Currency Round Off

Richard MacCutchan23-Sep-13 3:05

Richard MacCutchan

23-Sep-13 3:05

Thanks, I forgot about that.

Veni, vidi, abiit domum

Re: Currency Round Off

Biplob Singha Shee23-Sep-13 10:21

Biplob Singha Shee

23-Sep-13 10:21

Hi all,
Thank you for your ideas. I solved the problem.
Thanks again...
Regards.

How to use Background worker from a form to fill another form?

Suhayb Bashir Yousif20-Sep-13 22:47

Suhayb Bashir Yousif

20-Sep-13 22:47

Okay, so basically I have 3 forms..
The first form asks the user questions, the second form is a loading gif while the third form processes the information into a database. So all the processing happens in the third form while the second form shows a gif saying that the form is loading.

Now when I insert a background worker into the third form, the form freezes and the second form doesnt even show up. What am I doing wrong?

This is my code:

Form 2:

Private Sub Wait1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ProfileSetup.Show()
        ProfileSetup.Visible = False
    End Sub

Form3:

Private Sub ProfileSetup_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.Visible = False
        TextBox1.ReadOnly = True
        TextBox1.Enabled = False
        TextBox2.ReadOnly = True
        TextBox2.Enabled = False
        TextBox3.ReadOnly = True
        TextBox3.Enabled = False
        TextBox4.ReadOnly = True
        TextBox4.Enabled = False
        TabControl1.Hide()
        GroupBox1.Hide()
        TabControl1.SendToBack()
        GroupBox1.SendToBack()
        CheckForIllegalCrossThreadCalls = False
        BackgroundWorker1.RunWorkerAsync()
    End Sub

    Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
    TextBox1.Text = UsersTableAdapter1.LoggedInUser(True)
    TextBox2.Text = UsersTableAdapter1.PasswordGet(TextBox1.Text)
    TextBox3.Text = UsersTableAdapter1.EmailGet(TextBox1.Text)
    Variables.avatar = PictureBox1.BackgroundImage
    original = PictureBox1.BackgroundImage
    previous = PictureBox202
    PictureBox202.Hide()
    TextBox4.Text = UsersTableAdapter1.RankGet(UsersTableAdapter1.LoggedInUser(True))
    End Sub

    Private Sub BackgroundWorker1_RunWorkerCompleted(ByVal sender As Object, ByVal e As System.ComponentModel.RunWorkerCompletedEventArgs) Handles BackgroundWorker1.RunWorkerCompleted
        Wait1.Close()
        Me.Visible = True
    End Sub

What I actually want the program to do is display form 2 with the gif while form 3 is getting ready, when it is ready form 3 opens in gui mode while form 2 closes.

Any help please?

Re: How to use Background worker from a form to fill another form?

Richard MacCutchan21-Sep-13 0:03

Richard MacCutchan

21-Sep-13 0:03

Background tasks should not access the form's controls; you have to do it by invoking a delegate method[^].

Veni, vidi, abiit domum

Re: How to use Background worker from a form to fill another form?

Suhayb Bashir Yousif22-Sep-13 4:40

Suhayb Bashir Yousif

22-Sep-13 4:40

Sorry, mind being a bit more clear?

Re: How to use Background worker from a form to fill another form?

Richard MacCutchan22-Sep-13 4:51

Richard MacCutchan

22-Sep-13 4:51

More clearer than what? Did you follow the link I gave you and read the article?

Veni, vidi, abiit domum

Re: How to use Background worker from a form to fill another form?

Suhayb Bashir Yousif22-Sep-13 4:58

Suhayb Bashir Yousif

22-Sep-13 4:58

Umm, yes? Im still new, I didnt exactly understand everything..

Re: How to use Background worker from a form to fill another form?

Richard MacCutchan22-Sep-13 5:09

Richard MacCutchan

22-Sep-13 5:09

Suhayb Bashir Yousif wrote:
I didnt exactly understand everything.

Then maybe you should stop using advanced features. Seriously, you need to understand events, delegates and threading, and the implications of using them before trying to create a project such as you describe. There are many articles and books that will help you. The article I pointed you to also has links to other articles that give more details on these subjects. It is most unlikely that I could give a better explanation than is provided in them.

Veni, vidi, abiit domum

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.