|
--> How to delete an uncommited row from a datagridview..?
J A Nasir K
|
|
|
|
|
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 
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
--> Your code does'nt work. I did the same functionality (which you suggested to me) in one line....
J A Nasir K
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
That's really helpful.
Thanks a lot.
|
|
|
|
|
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..
|
|
|
|
|
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 ?
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 )
|
|
|
|
|
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.
|
|
|
|
|
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 ?
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 )
|
|
|
|
|
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.
|
|
|
|
|
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 ?
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 )
|
|
|
|
|
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[ ^]
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
|
|
|
|
|
I mean if form1 has a listbox called lb1, NEVER make it public. Always expose no more functionality to other classes than you need to.
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 )
|
|
|
|
|
Hi Friends,
I have an one .Net windows application setup project which consist for following files.
1.Setup.exe
2.Setup.msi
3.sample.txt
My question is, how to get sample.txt file when installing the setup file?. Because i will be refer from some criteria in sample.txt file.
Urgent
Thanks in advance
Rameshkumar Thirumalaisamy
|
|
|
|
|
Windows.Forms.Application.StartupPath & "\" & "sample.txt"
Shay Noy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
