Visual Basic

Re: Regenerating Datasets and table adapters

3-Sep-07 10:55

Hi, I changed the connection string datasource property to "DataSource = ../../data/databasename.mdb" instead of using the hard coded location(i changed this connectiong string everywhere in my application using the search function and entering the connection name). Anyways...I can't preview my data anymore now but it records to the database correctly? I have had to change the design of my tables in my database and now need to regenerate my data set as well as table adapters(I used all the built in tools to generate this before). How do I go about doing this? I am using vb.net 2005 and writing a windows application. PLEASE HELP!!!

Mr Oizo

Christian Graus3-Sep-07 12:37

Christian Graus

3-Sep-07 12:37

Mr Oizo wrote:
i changed this connectiong string everywhere in my application using the search function and entering the connection name).

If you have your connection string in more than one place, then your code is probably a maintenance nightmare in other ways, too. You should consider a better approach in future.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Regenerating Datasets and table adapters

Mr Oizo3-Sep-07 23:16

Re: Regenerating Datasets and table adapters

3-Sep-07 23:16

Well I used the the vb.net "add datasource" to create my connections. I just searched for everything with that connection name in the application.Then i changed the connection data source to a relative path. Anyways how would I regenerate my datasets and table adapters?

Mr Oizo

Dave Kreskowiak4-Sep-07 4:20

Dave Kreskowiak

4-Sep-07 4:20

I don't use the dataset desginers at all, so this may be wrong.

But, I think you have to manually add the new/modified columns to the datasets. Open your Data Sources window, or click on the Data Sources tab if you have it, right-click on your dataset/table and click on Configure DataSet with Wizard. You should be able to add/remove the new columns in there.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Accessing Exchange server public folders

manisghouri3-Sep-07 5:49

manisghouri

3-Sep-07 5:49

Hello everyone,

Can anybody help me how to access public folders on exchange server.

For example 'Public Folder/All Public Folders/Email/2007/January/Sales/..

In my application I have a requirement to automatically file email messages and attachments.

Thanks

Nas

combobox: append

Tom Deketelaere3-Sep-07 4:21

Tom Deketelaere

3-Sep-07 4:21

I can't seem to find a solution for this (and it's probably very simple)
Situation:
I have a combobox with a list(of string) as datasource
I've put the autocompletmode to append and the autocompletesource to listitems
everything works fine untill here

problem:
my users has to be able to type into the combobox but only text that is in the list
this works with a bit of code (check to see if there is text in the textpart of the combobox, if so check the list, if the list contains the text go on else clear combobox and start over)
but now when I start typing a word that is in the list the combobox appends the rest of the word (exactly like I want it) the only problem is that if I don't type the word out full the text that needs to be appended is not appended. The combobox only does this when I hit enter (this is not an option since the combobox is on a dialogwindow and hitting enter is accepting)

question:
anyone know how I can force the combobox to append the text when I leave the combobox (with tab)?

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

Re: combobox: append

Johan Hakkesteegt4-Sep-07 2:11

Johan Hakkesteegt

4-Sep-07 2:11

You could consider mimicking the combobox's behavior, in the leave event. If you do it with a little function, you would even be able to reuse it with other comboboxes.

Combob1.Text = YourLittleFunction(Combob1, Combob1.Text)
or
Combob1.SelectedItem = YourLittleFunction(Combob1, Combob1.Text)
and

Public Function YourLittleFunction(Byval combob as ComboBox, Byval TypedSoFar as String) as String<br />
'loop through the items in combob, and compare them with TypedSoFar.<br />
'Which ever comes closest is the winner.<br />
Return the winner<br />
End Function

Or something along those lines...

Good luck,

Johan

My advice is free, and you may get what you paid for.

Re: combobox: append

Tom Deketelaere4-Sep-07 3:31

Tom Deketelaere

4-Sep-07 3:31

thanks for the reply
turned out I was able to do it very simpel with the code already in the leave event (the code that check wheter or not the text exists in the list) apperently the text that is apended is already in the .text property the only problem I had was that its case sensitive and the text in the list was uppercase and the text entered lowercase.

but you're post did help me with forming an idee of what was going on so thanks...

just in case you are wondering how I did it here is the code:

If cboType.SelectedItem = Nothing And Not cboType.Text.Equals("") Then
            Dim l As New List(Of String)
            For Each s As String In cboType.DataSource
                l.Add(s.ToLower)
            Next
            If l.Contains(cboType.Text.ToLower) Then
                cboType.SelectedItem = cboType.Text
            Else
                cboType.Text = ""
                cboType.Focus()
            End If
        End If

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

lines in multiline rich text box

BooleanTrue3-Sep-07 3:58

BooleanTrue

3-Sep-07 3:58

Hello!
I have a rich text box with multiple lines. I can count number of lines but cannot find a line with maximum number of chracters.
Thanks for Any help.

colgateas900197

Luc Pattyn3-Sep-07 5:47

Luc Pattyn

3-Sep-07 5:47

RichTextBox.Lines

Luc Pattyn [Forum Guidelines] [My Articles]

Paul Conrad3-Sep-07 7:12

Paul Conrad

3-Sep-07 7:12

Luc Pattyn wrote:
RichTextBox.Lines

Doesn't that just tell how many lines are in the control? Sounds like the OP wants the line with the most characters in it Suspicious | :suss:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Luc Pattyn3-Sep-07 7:30

Luc Pattyn

3-Sep-07 7:30

public string[] Lines { get; set; }

tells a lot, including the number of lines, and with a simple loop also the length of
the longest/shortest/whatever line.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Accessing the windows forms generated code

Paul Conrad3-Sep-07 7:35

Paul Conrad

3-Sep-07 7:35

Luc Pattyn wrote:
with a simple loop also the length of
the longest/shortest/whatever line

I figured once one grabs the info from Lines, they could pretty much do whatever at that point Smile | :)

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

MP3 Playlist

Indra PR3-Sep-07 3:37

Indra PR

3-Sep-07 3:37

Hello all, this is my first posting in codeproject. Does anyone know how to make mp3 playlist like winamp playlist... Need help... >_< The concept is just the same as winamp, we can add song with the add button, then the song will appear in the list. Some forum said that I should use datagrid component in vb.net, but I don't know what to do with that thing. Don't know how to add data to the datagrid, etc. lol. I still don't know how to use MSDN help. T-T Heeeeelllp... Dead | X|

- No Signature Available -

Re: MP3 Playlist

plural3-Sep-07 4:41

plural

3-Sep-07 4:41

it depends on the format you want, but if you want to use the universal .m3u playlist format read and learn something about collections but just use these codes...its a real bad programming practice, not that, but it works

Dim sr As IO.StreamWriter = IO.File.CreateText(Application.StartupPath & "\Playlists\" + TextBox1.Text + ".m3u")

sr.WriteLine("#EXTM3U")
lstItems = ListView1.Items.Count - 1
For i = 0 To lstItems
'ext = System.IO.Path.GetExtension(CStr(ListView1.Items(i).SubItems(0).Text))
'w = CStr(ListView1.Items(i).SubItems(0).Text + ext)
sr.WriteLine(CStr(ListView1.Items(i).SubItems(1).Text))
Next

sr.Close()
sr = Nothing
w = Nothing

do u understand the codes...i used directx to do a music player and a dj soft
try this out

phatkin

Re: MP3 Playlist

plural3-Sep-07 4:43

plural

3-Sep-07 4:43

create a txt file with the format .m3u

the write the first line as
sr.WriteLine("#EXTM3U")

then write the location of all the songs in the playlist

the save it..u can even open with VLC or windows media player

but its a real bad practise so go and read on collections

phatkin

Mr Oizo3-Sep-07 3:27

3-Sep-07 3:27

Hi. I'm trying to access the windows forms generated code to change the connection strings so that they are not hard coded. I'm using an access database. Please let me know how to access the windows forms generated code in vb.net 2005. Smile | :)

Mr Oizo

originSH3-Sep-07 3:39

originSH

3-Sep-07 3:39

next to the Form in the solution explorer there should be a '+'.

Click it and spot the file called *.designer.cs

Mr Oizo3-Sep-07 7:38

3-Sep-07 7:38

Thanks. I didn't see that coz I needed to click "show all files" D'Oh! | :doh:

anyways now I gotta hunt down the connection string dat source.

Mr Oizo

Paul Conrad3-Sep-07 7:57

Paul Conrad

3-Sep-07 7:57

May I add that it is generally not a good idea to change generated code since changes you make in the designer could change the generated code. Do this with caution Big Grin | :-D

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Mr Oizo3-Sep-07 7:55

3-Sep-07 7:55

Thanks man. I fell really stupid now....Didn't click "show all files" so i didn't know it was there D'Oh! | :doh: