Visual Basic

15-May-08 23:00

You just host it on a web server, using IIS

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Datagridview...

Jamal Abdul Nasir15-May-08 20:02

Jamal Abdul Nasir

15-May-08 20:02

--> How to delete an uncommited row from a datagridview..?

J A Nasir K

Re: Datagridview...

John_Adams15-May-08 23:09

John_Adams

15-May-08 23:09

Hi Nasir,

We can remove an uncommitted row using VB.Net in the following way.

BEGIN CODE

Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)

If dataGridView1.Rows(dataGridView1.CurrentRow.Index).IsNewRow <> True Then
dataGridView1.Rows.Remove(dataGridView1.CurrentRow)
End If
End Sub

END CODE

This will check to see if the row you are trying to delete is a new row or not. If not then it will remove the code.

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Re: Datagridview...

Jamal Abdul Nasir18-May-08 20:33

Jamal Abdul Nasir

18-May-08 20:33

--> Your code does'nt work. I did the same functionality (which you suggested to me) in one line....

J A Nasir K

Get Character Width

Zheyi K15-May-08 15:17

Zheyi K

15-May-08 15:17

Hi, everybody.

I've been just started learning VBA programming.
And what I want to know is how to get a character width and the entire width of the text in a cell of Excel Worksheet.
I mean charaters of all languages such as English, Japanese and so on.

Please help me to resolve it.
Thanks!

Eduard Keilholz15-May-08 23:19

Eduard Keilholz

15-May-08 23:19

Erhm, I don't think this is possible using VBA, however you can create a dll which contains that functionality using .net and then call a function within that dll which contains the functionality.

To get the length of a string, use the MeasureString function of the Graphics object. Pass a string and a font, and the size of the string will be returned.

Good luck

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Zheyi K15-May-08 23:40

Zheyi K

15-May-08 23:40

Dear Keilholz.

Thank you for your attention.
I hope you know I'm a beginner in programming in VBA, but only have a knowledge about c++ programming.
Can you show me a little code block about using MeasureString?
Is it possible to get a character width by using it?

Thanks.

Eduard Keilholz15-May-08 23:51

Eduard Keilholz

15-May-08 23:51

Yup...

<br />
Font fArial = new Font("Arial", 10.0f, FontStyle.Bold, GraphicsUnit.Pixel);<br />
SizeF stringSize = Graphics.MeasureString("W", fArial);<br />
Console.WriteLine("String width is : {0}", stringSize.Width.ToString());<br />

Note : The code above is .NET (C#) code, not VBA

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

pointing to the wrong dbase

Zheyi K16-May-08 1:14

Zheyi K

16-May-08 1:14

That's really helpful.
Thanks a lot.

zaimah15-May-08 14:09

zaimah

15-May-08 14:09

hi, i'm new in this. i've been doing a prgm using vb.net with asp.net and it's working when i run it in my local pc. but, when i deploy it to my server the database r pointing to my local pc. i've check my web config and my coding. but all are written to point to the server dbase. help me pls..

Christian Graus15-May-08 14:18

15-May-08 14:18

Well, first of all, we have an ASP.NET forum.

zaimah wrote:
but, when i deploy it to my server the database r pointing to my local pc.

Then your code is pointing to your local PC. There's no two ways around it. How do you know it's pointing to the wrong place ? What makes you think you've set it to point elsewhere ?

zaimah15-May-08 15:01

zaimah

15-May-08 15:01

sorry, wrong forum. i know it's pointing to the wrong place bcoz, in my web.config i put server name n dbase. i delete my dbase at my local pc. when i run the prgm tell me my table name is invalid. but when i create th dbase in my local pc and delete the dbase in the server, it shows whatever inside the dbase in the local pc. eventhough in my web.config and my coding r written the server name n database. it's very confusing.

Christian Graus15-May-08 15:07

15-May-08 15:07

Might your website be using a cached web.config ? Why can it see the DB on your local machine at all ? Can you add some data to the server DB to confirm it's not being read ?

zaimah15-May-08 16:00

zaimah

15-May-08 16:00

what is a cached web.config? rite now i'm at my local pc. i connect the server from my local pc. i can add data but it goes to my local DB. this is weird. maybe i did a mistake, but i dont know where to find the mistake bcoz i already check the web.config n my coding in other files. this is my first time doing a prgm.

Christian Graus15-May-08 16:55

15-May-08 16:55

zaimah wrote:
this is my first time doing a prgm.

Well, what a disaster. Why on earth would your first ever program be a web app, with config files to set up, and a database ? Walk before you run.

Having said that, perhaps if you posted what's in your web config, I could point out what's wrong with it ?

How to vibrate a gamepad within vb.net thus use of directinput?

Thomas Stockwell19-May-08 8:08

Thomas Stockwell

19-May-08 8:08

If you happened to use the Database Wizard to configure any part of your application, then Visual Studio may haved added code throughout your project making reference to the local copy of the database.

An easy way to locate local pointers to your database is to open up Visual Studio and then open the find dialog and search for the filename of the database in the entire solution.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios[^]

JUNEYT15-May-08 9:53

JUNEYT

15-May-08 9:53

Hello!

I am able to control any buttons on gamepad within my vb.net code. But I also want to vibrate the gamepad. I am not using XNA but just directinput in my code. There are several properties and events that associated with the directinput. I realized that there is a SendHardwareCommand function. It is requiring two patameters as shown below. I couldn't figure out the 2nd parameter. I wonder what does it do? Is it the function that I should use for vibration?

GamePadDevice.SendHardwareCommand (Command as Int32, Data() as Byte)

If you acknowledge me, I appreciate.

Thanks.

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Re: How to vibrate a gamepad within vb.net thus use of directinput?

Vimalsoft(Pty) Ltd16-May-08 1:48

Vimalsoft(Pty) Ltd

16-May-08 1:48

hi

It seems you dont wanna Goggle

http://www.google.co.za/search?hl=en&q=how+to+vibrate+a+gamepad+in+vb.net&meta=[^]

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Send image to another form

winsane15-May-08 7:42

winsane

15-May-08 7:42

I am writing a program that shows a listbox with the name of 5 bitmap images to pick from. This program will allow the user to pick one for each 16 pictureboxes on the next form. When the user is done, he will push a button and another form pops up and shows 16 pictureboxes with the images he selected for each.
I have the 16 pictureboxes and a working listbox but due to lack of experience using windows forms in visual basic, I don't know how to take the selection from the listbox and use an if statement to tell the second form what to print inside the box.

For example, it would look something like this:
if form1.listbox1.selection = red car
then form2.picturebox1.image = redcar.png

This doesn't work, obviously, but you see what I am trying to do.
Any ideas?

-Live long and prosper

JUNEYT15-May-08 10:29

JUNEYT

15-May-08 10:29

I assume that you need the name of selected item in the listbox such as (red car, Purple car, etc.) and your aim is to use these values on both forms. All you need is a Global variable what will keep the selected item of Listbox. Then you can use this variable to call the values from form1. Here is a brief example.

<br />
<br />
Public MySelectedItem as String 'Define this out of a procedure or function<br />
<br />
<br />
FORM1<br />
<br />
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        Dim I as Int32 = Nothing<br />
            MySelectedItem = Listbox1.SelectedItems.Item(I)            <br />
    End Sub<br />
<br />
FORM2<br />
<br />
Select Case MySelectedItem<br />
<br />
       Case "Red car"<br />
             Form2.PictureBox1.Image = image.fromfile("Redcar.png")<br />
       Case "Purple car"<br />
<br />
End Selection<br />
<br />
<br />

I hope that helps

What a curious mind needs to discover knowledge is noting else than a pin-hole.

winsane16-May-08 8:24

winsane

16-May-08 8:24

Everything seems to work ok except this one thing......

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim I As Int32 = Nothing
MySelectedItem1 = ListBox1.SelectedItems.Item(I)
MySelectedItem2 = ListBox2.SelectedItems.Item(I)
MySelectedItem3 = ListBox3.SelectedItems.Item(I)
MySelectedItem4 = ListBox4.SelectedItems.Item(I)
Dim y As New Form2
Dim x As New Form3
x.ShowDialog()
y.ShowDialog()
End Sub

Error message says:
IndexOutOfRangeException was unhandled
Index is out of bounds of the array
The error points to the MySelectedItem1 = ListBox1.SelectedItems.Item(I)

-Live long and prosper

Christian Graus15-May-08 11:33

15-May-08 11:33

Use a delegate, not a global. If form2 is a child of form1, you don't even need a delegate, just expose a method on the form, assuming it's modeless.

NEVER expose a control on the second form, expose a property that sets a property of the control.

winsane15-May-08 17:38

winsane

15-May-08 17:38

By exposing a control, you mean that I shouldn't allow the user to interact with it? All that I intend to do with the second form is to allow the user to see 16 small windows with pictures of cars in them.

-Live long and prosper

Christian Graus15-May-08 19:22