Search:

Hello

Tried it in various events, click, doubleclick but not working there either. Have ti say when i out the combobox on the first level then it is working but when i put it in a dropdown level...

Good day,

I am trying to get a toolstrip combobox filled with a query. The query works and also the data is retrieved but it just won't show up in the combobox. Can somebody tell me where i am...

Thanks the links have helped a lot.

Good day,

I am trying to save a text file in ANSI format but it does not seem to work with the normal standard way.

SaveIt.InitialDirectory = "C:\"
SaveIt.FileName = cbxMapName.Text
...

You are right, but after a good night sleep and a good cup off coffee i got it sorted, i had all kinds of snippets, now i got it sorted

Good day,

I would like to import data from a database in a txt file. but i am struggling to get it in the wanted format.
I import the data via the following code:


Using sw As StreamWriter =...

Thanks the body does show but now i see al the rows and cells with all the HTML tags
like this
<tr><td align='right'>Good day,</td></tr><tr><td align='right'></td></tr><tr><td...

Thanks for the pointer, i copied you code into a new function but i am getting nothing in the body of the message


Function rng2html(rng As Range) As String

Dim str As String

For Each Rw In...

allright but i do not know where to put this code,
This is the full code:


Sub tbSendMAster2()
ActiveWorkbook.Worksheets("SeaSend").Unprotect Password:="Oliedom43"
Dim dteDate As Date
...

Yes i have it set to send in HTML to send an i set the font to Calibri in thunderbird. but the text that is in the body stays variable width.
when i select all the text in the body and i change it...

Good day,

I have a peace of code and this is created from a range of cells in excel this i want to send via mail in the calibri font but i cant get it to be changed to this font.
This is the...

Dim dgv As New DataGridView
dgv.Dock = DockStyle.Fill
dgv.DataSource = RestHours2TableAdapter._Select(item(ComboBox1.ValueMember), TextBox1.Text, TextBox2.Text)
...

Public Sub dgv_MouseClick(sender As Object, e As MouseEventArgs)
For Each page As TabPage In DTC.TabPages
Dim grid = page.Controls.OfType(Of DataGridView)().Single()
...

Good day,

I have a dynamically generated datagridview and now i want to do a mouseclick event


Public Sub dgv_MouseClick(sender As Object, e As MouseEventArgs)

But now i do not know how to...

EDIT...... I found it again a stupid mistake have to take the ID up in the Query
Also thanks JMC for the help.

But now for the next steps with a normal dgv and then i mean not dynamically...

I am filling the datagridview with this code:

Dim conn As New SqlConnection(ConnectionString)

Dim strSQL As String = "SELECT CrewId, (SurName + ' ' + CallName) AS Name FROM Crew WHERE...

Magic would be nice but is not expected.

My dynamically generated datagridview for all tabs is named dgv, as described in the posts above

For saving i thought to use code like below:


For...

No it does not, i can not get the dgv of the tabs get connected to the query somehow

All right i have the dgv now as it should be but i have problems to save all the data from all dgv's from all pages to the database, what is the best way to approach that

Thanks in advance

When i let the the program pause and i select the tabpage it goes to the next and when i open that one it goes to the next untill all have been opened and then i do not get the error

When i take...

When i remove the line which creates the problem then all the columns apear the msgbox showed 0 for everything

Good day,

I generate a dgv dynamically and load it with dat from a datasource, when the data is loaded in the dgv. i want to change the appearance of the columns and hide some columns.


For...

Again i am running into a problem how can add on every tabpage a datagridview from a datasource?

Thanks that helped, but i have problems to get the tabpages to be named for every item in the combobox, how can i do that?

EDIT: Found it
page.Text = item(ComboBox1.DisplayMember)

Good day,

i have a query that gets multiple subjects and for each of that subject i have to create a tabpage dynamically

what is the best way to approach that, the subjects can vary everytime...

maybe this can help


Private Sub wait(ByVal seconds As Integer)
For i As Integer = 0 To seconds * 100
System.Threading.Thread.Sleep(10)
Application.DoEvents()...

Well i am lucky it is only a 2 page report now so i could do the second page with different fields in the report footer so for now it is resolved

As i see it i am not updating all records only the one in the datagridview

The database table holds various months and years from various people and when i do the UpdateAll it will update all the records/rows with that month and year which are loaded in the datagridview. ...

Allright i found the problem the mistake is/was that the messagebox was behind the form when i pushed ALT it was showing.
I have resolved it by this peace of code in the messagebox section:

...

No it does not also, i see now that when i create a mistake the catch messagebox also does not show

When i replace the messagebox.show to ME.close it closes the program so why does it not show the messagebox

Yes i did the debugging, also when i remove the messagebox(es).show it does everything what has been coded and the program does not freeze

Good day,

I have some code in a button click event and after the code i want the messagebox to show, but the program freezes see below code

Private Sub btnSave_Click(sender As Object, e As...

In my report designer i have the first page set up like this picture below:

155645

Now the "details a" contains hours and days when looked there are all days of the month so 31 rows.

Now i...

Allright so i have to make the select and insert and update queries in the tableadapter or am i wrong?
How do i call these queries then?

I have an autogenerated bindingsource with a tabeladapter.
I was strugling with collumns getting autofilled with month and year. and then in mt database table all months created got the same month...

When i put datagridview.datasource = nothing then the messagebox shows up but it doesnt save the data. And no multi-threading so quite strange this one

Indeed the messagebox.show is not showing also not in the beginning of the code and freezing the program

You are right did some debugging and came to messagebox.show if i remove that line it is doing what i want.
But it is quite strange that it freezes on that line of code