Visual Basic Discussion Boards

First Prev Next

Re: my oledbdataadapter is not refreshing

Vimalsoft(Pty) Ltd6-Nov-07 20:04

Vimalsoft(Pty) Ltd

6-Nov-07 20:04

hi
Did you use a wizard to create your adapter, or did create it your self, if so then lem me see the update command of your adapter.

try this and tell me your Error and remember if your table has no Primary key , you can never update the table.

Try
         DsAsets1.Clear()
         OleDbDataAdapter1.Fill(DsAsets1)
         count()
     Catch ex As OleDb.OleDbException

         MsgBox(ex.Message)
     End Try
 End Sub

.

And Dont Forget to import the name space like this

Imports System.Data.OleDb

Thanks

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

Re: my oledbdataadapter is not refreshing

Motajo Tolu7-Nov-07 5:39

Motajo Tolu

7-Nov-07 5:39

thanks. I was able to find the solution after visiting many forums.
I used this code to refresh and its now working fine

Conn.Open()
mycmd = "Select * from Asset"
da = New OleDb.OleDbDataAdapter(mycmd, Conn)
da.Fill(dsAsets1, "Asset")
Conn.Close()

I really appreciate your concern. am very grateful.Thanks again.

Re: my oledbdataadapter is not refreshing

Vimalsoft(Pty) Ltd7-Nov-07 18:51

Vimalsoft(Pty) Ltd

7-Nov-07 18:51

You are Welcome

Filtering a DataGridView

furjaw5-Nov-07 18:52

furjaw

5-Nov-07 18:52

Visual Basic 2005:

I have a DataGridView in Last Name sequence.

Is it possible to when a user types the first letter of a last name

that it displays all rows with last names that start with that letter.

When he types the second letter, it displays all records whose last name starts with those 2 letters, etc.?

Re: Filtering a DataGridView

N a v a n e e t h5-Nov-07 19:34

N a v a n e e t h

5-Nov-07 19:34

furjaw wrote:
When he types the second letter, it displays all records whose last name starts with those 2 letters

On text changed event or keyup event, rebind it with filtered data.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Filtering a DataGridView

Mr.PoorEnglish5-Nov-07 21:32

Mr.PoorEnglish

5-Nov-07 21:32

You should offer a "Filter-Textbox" for that.
So the user can see the current filter and edit it.

In Textbox.TextChanged() you can build a valid filter-expression like:
Dim sFilter as String = "LastName like '" & Textbox.Text & "*'"
And pass that String to the BindingSources (I hope you use one) .Filter - property

Re: Filtering a DataGridView

furjaw6-Nov-07 8:39

furjaw

6-Nov-07 8:39

I can't believe how well that worked!
Thanks!!!
Below is the code that I ended up with:

If LastNameTextBox.TextLength > 0 Then
PatientBindingSource.Filter = String.Format("LastName Like '" & LastNameTextBox.Text) & "*'"
Else
PatientBindingSource.Filter = String.Empty
End If

Outlook Add-In to Enhance Send Functionality

John Thelen5-Nov-07 16:20

John Thelen

5-Nov-07 16:20

First, let me apologize if this isn't the right place for this.

I've been asked to create an Outlook add-in that will enable me to pop-up a dialog box at the time the "send" button is clicked on an outlook email message. The goal is to confirm the existence of a properly composed subject line.

Can any one point me in the right direction? Perhaps there is a good on-line resource for tapping into the "send" functionality.

My limited skills include VBScript in Visual Studio.

Any assistance is greatly appreciated!!!

John

Save File

Socheat.Net5-Nov-07 16:06

Socheat.Net

5-Nov-07 16:06

Hi,
I currently using textbox in vb.net, I want to save data file to the file path, if i open it, it will not show SaveFileDialog, if not it wil show SaveFileDialog. how can i do?

Socheat

Re: Save File

Mitch F.5-Nov-07 18:53

Mitch F.

5-Nov-07 18:53

Could you please rephrase your question/problem? It's not exactly clear what you're trying to do, and, if you have a small chunk of code that you cold post, that'd be helpful too.

Thanks.

Changing Mouse Cursor

Widgets5-Nov-07 13:51

Widgets

5-Nov-07 13:51

Anyone knows a code for changing Mouse Cursor... e.g. from vbDefault to vbHourglass using vb 2005.... Thanks

Re: Changing Mouse Cursor

Christian Graus5-Nov-07 15:43

Christian Graus

5-Nov-07 15:43

Cursor = Cursors.HourGlass

Something like that

Christian Graus - Microsoft MVP - C++

"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 )

Newbiw VB Help required

rayvb5-Nov-07 12:15

rayvb

5-Nov-07 12:15

Hi all is there anyone who can help I would like to create a util that lets me extract

Name, Email, Contact, Date,

From a .txt file full of differnt data but that does have this information i want (see example) i think this would be a good project for me to learn so i would appreciate it if someone could take me under their wing so to speak so i can learn how i would do this in VB. Many online utils just exract email or one column

example of what in my txt file there is say 500 of these in it

Position: Software Development Support Engineer - Warrington
Location: Warrington, Cheshire
Rate: Benefits
Skills: My market leading client based in the North West is currently
looking for a Software Development Support Engineer to join their team
on a permanent basis. You will be responsible for providing support and
programming expertise to 3rd party suppliers/clients and also work with
internal teams to ensure successful project completion. The ideal
candidate will have excellent customer facing skills and good knowledge
of C++ and knowledge of Symbian, GSM, UMTS or the mobile telecoms
industry would be...
Type: Permanent
Start Date: ASAP
Advertiser: IT Recruitment Regions
Business Type: Test Employment Agency
Contact: Jame Bloggs
Phone: 0141 717 8919
Email: mailto:James.Bloggs.520C0.07D68@mail.jobserve.com
Ref: JA119898
Date: 02/11/2007 09:49:13
Apply Now: http://www.jobserve.com/EC5F94B13EAA96675ZA0E555748F74BF.jsap
Full Job: http://www.jobserve.com/EC5F94B13EAA96675.job
Add to Basket: http://www.jobserve.com/EC5F94B13EAA96675.jsbk

So i would be looking for an ouput of

Name, Email, Phone, Date

James Bloggs,James.Bloggs.520C0.07D68@mail.jobserve.com,0141 717 8919,02/11/07

in CSV format and would also like a count in there as well

hope some can help thanks

Re: Newbiw VB Help required

Christian Graus5-Nov-07 15:44

Christian Graus

5-Nov-07 15:44

You could use File.ReadAllLines to read the text as a string array then look for strings that start with Name: ( etc ) and parse out the values.

Folder Properties

ChadYKK5-Nov-07 10:48

ChadYKK

5-Nov-07 10:48

I am writing a program to update some of my files that I have on other computers. It is simple and just transfers the files from a cd to a given location. The location is a read-only folder. I need to change this property by using code before I can copy the new file to the location and then return the folder to read only. I already have the code to transfer the folder but I need to code to change the property of the folder from read-only = true to read-only = false. This needs to occur before the file is moved. I do not know where to start so any help will be appreciated.

I have this:

Dim str_ToPath As String = "C:\Folder\myFolder"
Dim str_FromPtath As String = System.IO.Directory.GetCurrenDirectory()
Dim localfile As String = "myfile"
Dim fso, file

' Get handles to folders current location.
fso = CreateObject("Scripting.FileSystemObject")

'Here is where I need the code to check if the folder is read-only or not and
' change if it is read-only. The folder will be the str_ToPath folder.

file = fso.GetFile(str_ToPath + localfile)
' Delete the folder.
file.Delete()

file = fso.GetFile(str_FromPath + localfile)

' Copy the file to correct location.
file.Copy(str_ToPath + localfile)

Re: Folder Properties

Christian Graus5-Nov-07 15:46

Christian Graus

5-Nov-07 15:46

ChadYKK wrote:
System.IO.Directory.GetCurrenDirectory()

So this is VB.NET ?

ChadYKK wrote:
fso = CreateObject("Scripting.FileSystemObject")

Why on earth are you doing this ?

Re: Folder Properties

ChadYKK6-Nov-07 2:09

ChadYKK

6-Nov-07 2:09

VB 2005, I am using the fso object to delete files and move files to other locations.

Using VB.NET controls in Commercial Applications

jsp_15-Nov-07 9:28

jsp_1

5-Nov-07 9:28

Hi,

I create VB.NET applications/utilities for the company I work for and I was wondering what is the policy for using the VB Controls from Code Project in these VB.NET applications/utilities?

I have been looking around the Code Project web site and cannot find anything written specifically about use of code/controls for commercial use, guess I have not been to the right place.

I have seen some good controls here and I do not want to reinvent the wheel, but I need to know if I can use them or require permission or what not.

Thanks,

Jamie

Re: Using VB.NET controls in Commercial Applications

Christian Graus5-Nov-07 15:47

Christian Graus

5-Nov-07 15:47

The general idea is that you can use them, but the sensible approach is to ask the authors of the controls you want to use.

Re: Using VB.NET controls in Commercial Applications

jsp_18-Nov-07 1:26

jsp_1

8-Nov-07 1:26

How would you contact the Author, add a message in the Discussion at the bottom of the Article? Is there a way to contact them directly?

Jamie Parsons

Catching errors v2

svanwass5-Nov-07 7:01

svanwass

5-Nov-07 7:01

Hello all,

I have an app that requires a certain active X plug in be installed. During testing, if i uninstall the active x control, I am presented with a rather nasty error. I have trapped other error messages with...

<br />
    'Unhandled exception error<br />
    Dim WithEvents ap As AppDomain<br />
<br />
<br />
    Private Sub ap_UnhandledException(ByVal sender As Object, ByVal e As System.UnhandledExceptionEventArgs) Handles ap.UnhandledException<br />
<br />
        Try<br />
            WriteErrorLog(e.ToString)<br />
        Catch ex As Exception<br />
            WriteErrorLog(ex.ToString)<br />
        End Try<br />
<br />
    End Sub<br />

How can i capture this one too?

Re: Catching errors v2

nlarson115-Nov-07 7:48

nlarson11

5-Nov-07 7:48

remove the variable and the 'handles' from the subroutine.

AddHandler AppDomain.CurrentDomain.UnhandledException, AddressOf ap_UnhandledException

Adding Problem

Cedrickdeorange5-Nov-07 5:49

Cedrickdeorange

5-Nov-07 5:49

I am doing a game of Blackjack. I have only one problem to figure out.

I cannot get the dealers cards to add up if it is more than two cards.
i am giving two cards to the dealer on the on the first deal. I can get the dealers total hear, but i can't get the totals if the dealer needs more than two cards. I am using arrays for the cards and card values plus piture boxes. I also have an array for the players and dealers last four cards. The players four extra cards i have on a click event. It is just the dealers totals i cannot work out.

Regards
Zeldacat

Re: Adding Problem

Kschuler5-Nov-07 7:37

Kschuler

5-Nov-07 7:37

You're going to have to give us more information about what is going wrong in your code. Are you getting an error? What code are you using right now?

Re: Adding Problem

svanwass5-Nov-07 7:39

svanwass

5-Nov-07 7:39

Are you storing the value of the dealers cards in an array? If so, is it large enough to hold as many cards as he has? Some example code may help get you an answer.

Last Visit: 31-Dec-99 18:00 Last Update: 13-May-24 21:22

Refresh

ᐊ Prev 1...2027 2028 2029 203020312032 2033 2034 2035 2036 Next ᐅ

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