Search:
Type: Posts; User: squatman
Search:
Search took 0.05 seconds.
-
Hi there,
Did you get anywhere with this?
I had a console application working fine with just user credentials, but now the company has two factor authentication enabled it has stopped working....
-
dday9, thanks for the response.
Expanding on my item no. 3. I would have a form with textboxes for example that the user would click a button to accept, this would (in this example) add a new...
-
Hi there,
I've recently started trying looking into memory usage of my application and if I need to make some changes.
To start with I've been looking at my DataGridView (these figures are from...
-
Hi there,
I've been programming in VB for a while now and I've always:
Filled a DataTable using SqlDataAdapter
Set DataGridView.DataSource = DataTable.DefaultView
Added/Updated/Removed...
-
-
Hi,
I have various controls within a Panel running vertically (they're actually in a TableLayoutPanel, that is within a Panel). The Panel has AutoScroll enabled.
When a user is scrolling down...
-
jmc,
Thank you very much, that did the trick. Legend.
-
Hi,
I'm not sure if this will be the correct forum so apologies if not.
I have a solution for one client that will be the basis as a solution for a new client, it will basically be the same...
-
Thanks all for your replies.
I've managed to create a Web Service in NodeJS with ExpressJS that accepts requests based on a URL. This returns data in the form of JSON. Which I assume means I have...
-
techgnome thanks for the reply,
I've been playing around in Azure for the first time today and set up a free trial SQL server which actually allowed me to connect exactly the same with my original...
-
Hi there,
I've developed applications previously that would connect to a Microsoft SQL Server on the same network using the following code:
Imports System.Data.SqlClient
Public Class Form1...
-
Aussie,
I've come across this exact problem today after using SQL Server on our network, the MySQL code examples looked like once reference I could just replace things like SqlConnection,...
-
Hi there,
I'm creating a windows service application in vb. When using WinForms I can connect to the SQL database no problem, but with the Windows Service I get the following error:
I've...
-
Goggy, I have remote users operating on poor connections which is what I think may be my issues. What was you going to suggest if the connection is the problem?
Thank you
-
Thanks for the response .paul.
I tried a couple of solutions that used the WM_MOUSEWHEEL aka &H020A, but I couldn't get them to work.
Luckily your mention of this message allowed me to find a...
-
Hi there,
I have a ComboBox inside a TableLayoutPanel, inside another TableLayoutPanel, inside a Panel. The Panel has scrolling enabled when the Form windows is resized smaller than the content.
...
-
Niya, thanks for the response.
Unfortunately neither worked, and now I get this all too familiar screen when I've been using custom controls :-(
183624
I'm using Visual Studio Community 2019...
-
Hi there, I stumbled across this post whilst working on a CustomLabel, that enables part of the Label to be bold. I'd now like the bold section to change colour on MouseEnter.
I'm somewhat new to...
-
szlamany, thanks for the response that's good to hear!
This is all new to me, but I'd assumed the SO code would sit on the my Windows server which has direct access to the files, but rather than...
-
Hi,
We have a windows server in our office that stores our files.
We have a web hosting with GoDaddy.
I want to create a secure web page on the web hosting, this page will display a list of...
-
Hi there,
I've rotated the Text within a Button using the Paint Event.
And I've been messing around with the Graphics quality, and I just can't seem to get it to look the same as the non...
-
Using a post from NetMage on StackOverFlow I've managed to sort this, though unfortunately I don't fully understand the LINQ section.
...
-
I decided to figure out how to achieve the PIVOT within VB, so that I can retrieve all data values initially and each time a user filters, it will filter the data and re-apply the PIVOT.
This...
-
Hi there,
I have a DataTable that looks like this:
Employee | Cert | Expiry Date
Joe | H&S | 2022-02-12
Joe | Induction | 2023-07-20
Bob | H&S ...
-
Hi there,
I'm developing a form that uses a DataTable/DataGridView to show the expiry dates of various training certificates for each employee.
Each certificate has a "valid from date", "expiry...
-
Done. Thank you. Sorry.
SELECT @test1 = STUFF((SELECT DISTINCT ',' + 'MAX(' + QUOTENAME(ct.[name] + ' (Valid)') + ') AS ''' + ct.[name] + ' (Valid)'''
FROM...
-
Actually not quite, now my columns don't have a name!! aahhh!!
-
Apologies again, I need to learn a lot more SQL.
A bit of Googling and creating some more variables with MAX( ) around the columns names I've managed to get it as I want it.
Final query below,...
-
Ok I've managed to get the query to execute and now I understand what you was referring to with the ALIAS, with you saying in the SET I was looking in the wrong place.
Thank you techgnome.
I've...
-
Apologies for all the replies, I've been writing the SQL out manually rather then with variables to see exactly what's going on.
The problem with the "name" is in the PIVOT:
PIVOT ...
-
Ok I've been playing around and saw the my SELECT @cols where returning the column names with squad brackets around them e.g. [Cert 1 ' (Valid)' AS 'V'] which I thought this may have been causing the...
-
Thanks for the response tg, appreciate it.
Not sure if I've got the wrong end of the stick, but I updated the SELECTs to the following to include the aliases:
SELECT @cols = STUFF((SELECT...
-
techgnome,
Thanks for your response, I'm just picking this up again now; I managed to get it working as a stored procedure so thank you. During development for filtering purposes I've realised I...
-
The SQL ran fine in SQL Management Studio so I didn't think there was anything wrong with the query, I wanted to make sure it wasn't a result of me doing something wrong with the Parameters.
I've...
-
I've just got a bit further setting my parameters direction to Output:
cmd.Parameters.Add(New SqlParameter("@cols", SqlDbType.NVarChar, 255) With {.Direction =...
-
jmc, thanks for the response.
I've used Parameters before e.g. cmd.Parameters.Add("@cols", SqlDbType.NVarChar).Value = "value"
But what would values would I fill them with in this instance, as...
-
Hi there,
I have the following tables:
User
id | full_name
1 | Bill Gates
-
Thank you both for your responses.
Paul, I'm still tot est but that looks like a really neat way to get the information back into a DataTable so thank you.
Chris, it doesn't look like this...
-
Jmc,
Thank you for your response.
I've updated my code as follows, though do I really need to enter and select every column?
I've opted for your first solution, as every other column is...
-
Hi there,
My original issue was wanting to concatenate values in a DataColumn across DataRows.
I have the following data:
id | col1 | col2 | Category...
|
Click Here to Expand Forum to Full Width
|