Visual Basic Discussion Boards

Re: get and compare ascii code in vb.Net

Luc Pattyn27-Nov-09 0:24

27-Nov-09 0:24

Hi,

some basic info for you:
1. In .NET all characters and strings are Unicode, not ASCII.
2. Hitting a key causes several events, starting with a KeyDown; have a look at KeyEventArgs
3. Keys are identified primarily by their KeyCode, not their KeyChar
4. there is a Keys enumeration to help you identify keys, including all the special keys.
5. only some keys (the ones typically generating text) also fire the KeyPress event
6. you can influence some of the key handling by using ProcessCommandKey, IsInputKey, and maybe some more; however you would seldom need these.

So start using KeyDown event and KeyCode value.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Arrange database Column entries by ascending order.

jeshra27926-Nov-09 19:19

jeshra279

26-Nov-09 19:19

Hi All,
I have a SQL database column "ID", in which I added one by one entries as 2,5,6,1,8... randomely.
I want to arrange these entries in Ascending order so that in datagridview it get displayed in order 1,2,3,4... like this.
Can someone help me on this?

Thanks.

Re: Arrange database Column entries by ascending order.

dan!sh 26-Nov-09 19:30

dan!sh

26-Nov-09 19:30

Use order by in the query/stored procedure you are using to retrieve the data.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Arrange database Column entries by ascending order.

Shameel26-Nov-09 19:46

Shameel

26-Nov-09 19:46

This is not the appropriate forum for your question. Choosing the correct forum helps you get more answers (and better answers).

Re: Arrange database Column entries by ascending order.

Vimalsoft(Pty) Ltd26-Nov-09 22:20

Vimalsoft(Pty) Ltd

26-Nov-09 22:20

If you have a SQL Question Post here

General Database
http://www.codeproject.com/Forums/1725/General-Database.aspx[^]

in the Query that you use to display the Grid with , add the Following line of SQl

Order by ID ASC

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

[VB6] On Change Event issues

Blake Dickson26-Nov-09 18:52

Blake Dickson

26-Nov-09 18:52

So I have finally figured out how to dynamically add data to comboboxes created on the fly however I still cant create an on change event for the combobox.

Heres what I am looking at doing.

    Set optioncombobox = Me.controls.Add("Forms.ComboBox.1", "Cheese" & comboNumber)
    With optioncombobox
    .Text = "Please Select an option..."
    .left = 114
    .width = 276
    .top = 102
    .Height = 18
    End With
While Not (IsEmpty(Range("'Info'!a" & Counter)))
    X = Range("'Info'!a" & Counter).Value
    If InStr(1, X, "|") > 0 Then
    Else
    With controls("Cheese" & comboNumber)
            .AddItem (Range("'Info'!b" & Counter).Value)
    End With
    End If
Counter = Counter + 1
Wend

Then I am trying to create something like this

Private Sub Controls("Cheese1")_Change()
Do Stuff
End Sub

But I am getting an error saying "Expected: Identifier"

Anyone have any thoughts on how I can resolve this??

However when I create a commandbutton click event it can do all of this with no issue.
But I want to do this in an On Change event.

Even if there is some way to run an event if any combobox on the whole form changes that would be fine.

Re: [VB6] On Change Event issues

Shameel26-Nov-09 19:50

Shameel

26-Nov-09 19:50

In VB6, handling events for dynamically added controls in quite difficult. There is a keyword WithEvents that may help you, but I am not sure how you can use it with dynamically added controls.

Your syntax for event method declaration is totally wrong Frown | :(

Work on the WithEvents keyword.

Re: [VB6] On Change Event issues

Vimalsoft(Pty) Ltd26-Nov-09 22:09

Vimalsoft(Pty) Ltd

26-Nov-09 22:09

Why are you still using VB6 in 2009 ?

Selecting MAX value from a Database column.

jeshra27926-Nov-09 18:35

jeshra279

26-Nov-09 18:35

Hi,
I am using SQL database with VB. The database "company" has 1 column "EmpID" which I filled with 0,1,2,... so on, and "EmpID" column is in string format.
Now I want to get the MAX of this "EmpID", for this I wrote a code like this in VB :

SELECT MAX(EmpID) From company.

I found that out of 0 to 150 EmpID in database, it is selecting MAX value as 9 and sometime as 99.
I think there is something wrong with this. Also, If I test it for small data, say from 1 to 15, it is selecting correct MAX value.

Can someone help me how to do this? My basic idea is to get the last "EmpID" which I will add and use it as next "EmpID".

Thanks
R.S.

Re: Selecting MAX value from a Database column.

dan!sh 26-Nov-09 19:15

dan!sh

26-Nov-09 19:15

I think that is because your EmpId id not an integer in your database. It something be varchar or something similar. You should change it to int if it can have only integer values. In order to make the query work in current condition, use following:

SELECT MAX(cast(EmpID as int)) From company

Note that this is not a good practice.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Selecting MAX value from a Database column.

Shameel26-Nov-09 19:53

Shameel

26-Nov-09 19:53

It is because your EmpID is stored as text instead of number. The correct datatype to use is 'int', and your EmpID column most probably is 'varchar' datatype.

Re: Selecting MAX value from a Database column.

Niladri_Biswas29-Nov-09 0:49

Niladri_Biswas

29-Nov-09 0:49

Select MAX(cast(EmpId as int)) from TblName

Select top 1 EmpId from TblName order by EmpId desc

Niladri Biswas

Automation Error : Library Not Registered [modified]:It's Urgent

Ashish Kumar Vyas26-Nov-09 17:11

Ashish Kumar Vyas

26-Nov-09 17:11

Dear,
Could any body assist me regardig the following issues.
1. In my VB project when I am trying to upload .xls file.Error message is coming "Run Time Error '-2147319779(8002801d)' Automation Error : Library Not Registered"
Code Line where error is coming...

<br />
If (fso.FileExists(Trim(Text1.Text)) = False) Then   <br />

however same code is running in other machine without any error.

Please let me know asap.

Thanks
Ashish

modified on Friday, November 27, 2009 1:09 AM

Re: Automation Error : Library Not Registered [modified]:It's Urgent

Shameel26-Nov-09 19:56

Shameel

26-Nov-09 19:56

I believe this is VB6 code and you are using File System Objects in your code. Your target system is missing the Microsoft Scripting Runtime Library DLL (scrrun.dll).

Please note that there is a known versioning problem with this DLL. Ensure that you copy and register the correct version that you have compiled your application with.

Re: Automation Error : Library Not Registered [modified]:It's Urgent

Ashish Kumar Vyas26-Nov-09 23:44

Ashish Kumar Vyas

26-Nov-09 23:44

Dear Shameel,
I have done what I was told by you.Still the same error is coming.Even I have given full rights for me(as a login user).

Could you/anybody suggest me for that...
Thanks
Ashish

Re: Automation Error : Library Not Registered [modified]:It's Urgent

Shameel27-Nov-09 2:04

Shameel

27-Nov-09 2:04

Check if you have scrrun.dll in your target box (typically in %System32% folder), and if it matches the exact same version of the dll that is in your development box.

Open automatically excel preview using vb

C#Coudou26-Nov-09 15:26

C#Coudou

26-Nov-09 15:26

mates,

Is it possible to automatically open an excel print preview?
if possible, can you give me an idea how to do it..
thanks.

note: I will code this in visual basic.

thanks in advance

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: Open automatically excel preview using vb

dan!sh 26-Nov-09 19:03

dan!sh

26-Nov-09 19:03

I think you can use Microsoft.Office.Interop.Excel.Workbook.PrintPreview method for this.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Installing SQL Express / Creating a database during deployment

Ekjon26-Nov-09 7:06

Ekjon

26-Nov-09 7:06

I need to deploy a .NET 2.0 windows application so if no SQL Server found on the network, it will allow them to install SQL Express.

If there is SQL Server, then it will allow them to create a database with some baseline data.

Really need help on this,
Thanks,

Ekjon

Re: Installing SQL Express / Creating a database during deployment

Ekjon27-Nov-09 8:33

Ekjon

27-Nov-09 8:33

Basically, my concern is - to create a database with 30/40 tables with some data in some of them - the sql statements would be large. What would be the best approach to deal with it?

Character Movement

helelark12326-Nov-09 3:36

helelark123

26-Nov-09 3:36

Hello,

I am programming in vb2005
I have some pictures of a character that if you change them you got a movement of him. I write a small function that move the character when clicking on right arrow. THe images are in PNG format so it is good for the transparency. Then problem is when I put the characted on a image backkground I get jump of the picture.
How can I fix the problem?
Thank you

Shay Noy

Re: Character Movement

Dalek Dave26-Nov-09 3:48

Dalek Dave

26-Nov-09 3:48

What code have you got so far?

Hard answer unless we know the bigger picture.

------------------------------------

In science, 'fact' can only mean 'confirmed to such a degree that it would be perverse to withhold provisional assent.' I suppose that apples might start to rise tomorrow, but the possibility does not merit equal time in physics classrooms. Stephen J Gould

Re: Character Movement

helelark12328-Nov-09 19:21

helelark123

28-Nov-09 19:21

I don't understand your reply.
Have you understand my post?
Thank you

Shay Noy

Re: Character Movement

Dalek Dave29-Nov-09 22:54

Dalek Dave

29-Nov-09 22:54

[LOUD AND SLOW...]

Post the code you have written already

[/LOUD AND SLOW...]

Re: Character Movement

helelark1231-Dec-09 4:33

helelark123

1-Dec-09 4:33

Imports system.Reflection

Public Class Form1
Private arrLeft(5) As Bitmap, arrRight(5) As Bitmap

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
arrLeft(0) = My.Resources.L1 : arrLeft(1) = My.Resources.L2 : arrLeft(2) = My.Resources.L3
arrLeft(3) = My.Resources.L4 : arrLeft(4) = My.Resources.L5 : arrLeft(5) = My.Resources.L6

arrRight(0) = My.Resources.R1 : arrRight(1) = My.Resources.R2 : arrRight(2) = My.Resources.R3
arrRight(3) = My.Resources.R4 : arrRight(4) = My.Resources.R5 : arrRight(5) = My.Resources.R6

End Sub

Private Sub Form1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
Static ind As Integer, LastDir As String
Static counter As Integer

Select Case e.KeyCode
Case Keys.Left
If LastDir = Keys.Right Then ind = 0 : counter = 0

If counter Mod 5 = 0 Then
PictureBox1.Image = arrLeft(ind Mod 6)
Application.DoEvents()
PictureBox1.Left -= 10
ind += 1
End If
LastDir = Keys.Left

Case Keys.Right
If LastDir = Keys.Left Then ind = 0 : counter = 0

If counter Mod 5 = 0 Then
PictureBox1.Image = arrRight(ind Mod 6)
Application.DoEvents()
PictureBox1.Left += 10
ind += 1
End If
LastDir = Keys.Right
End Select

counter = counter Mod 21 + 1

End Sub

End Class

Shay Noy

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