Search:
Type: Posts; User: VB.NETGAL
Search:
Search took 0.04 seconds.
-
Hi, looking for any help i can get... as I'm sure this type of thing will be easy to those who know how.
I've come across a problem in my work where I have data in my datatable after it has been...
-
I've written a
Public function OptionSplit(OptionString$, optional ByVal StrBegin$ = "", Optional byval StrEnd$ ="") As List(Of String)
If StrBegin.Length > 0 AndAlso...
-
I am a software developer for a ticketing company. We host and own the websites. It's not a case of getting an API done. We have api's for pricing but different areas of our stadium have different...
-
How very perceptive of you..but I actually work for a ticketing company and I'm doing load testing and need to get the option values to pass different values into my load test.
-
Hi all.. been looking online for a solution for this but with no luck. A few posts suggested regular expression but I couldn't work out how to implement it as my solution.
I'm just looking for...
-
Hi all, I'm a complete novice with Javascript so wondering if anybody can assist me with an issue I'm having.
On my webpage I have a minimum and maximum date set in hidden fields hdfMinDate and...
-
Both Excellent answers and exactly what I needed.
Many thanks for your help! Appreciated :)
-
Hi all,
I haven't posted for a long time...but need to ask the experts as I believe what I'm trying to do should be really easy
I have a viewmodel returned with a list called called...
-
update... it seems to sort properly when DEPT15 is the first column in datatable.. I'd love to know why tho
-
Hi,
I'm having a really bizarre problem sorting datatable data.
I have a datatable dtpayment which has several columns and one of them is DEPT15 and has different department names in. there's...
-
Hi,
I have a problem which I'm not sure on how to resolve.
I've made a small reporting application in WPF which works with a local SQL database stored in the same folder as the report tool.
...
-
Thanks for your reply... I have refactored my code to your format as it certainly looks alot more logical. For some strange reason though I'm still getting the same error and the connection not...
-
Yes... if I remove the using... then I'm guessing it just creates new objects each time?
Without the using statement because I use the same function to pull data 3 times using different select...
-
;) I guess the error would help ha.
When i first run the code it creates a "job" on the iseries database and it's this instance that makes me think its not being killed properly
124779
the...
-
Public Function IBMDatatable(SelectCommand$) As DataTable
Dim dt As New DataTable
Using cn As New iDB2Connection
cn.ConnectionString = "Data Source=" & SYSTEMID &...
-
I'm using button click events like winforms app.
Was hoping for a similar way to do it like the code above but then I don't know how to reference the different controls.
I can load one control...
-
Hi there,
I'm creating WPF application and I am creating some different user controls which I am loading into my main form.
So, I have my main form called MainWindow
This form consists of 3...
-
Hi... My mistake.
I had some style in my global application settings to change the style of "button" to make it a minimal width and that property must be used on the calendar control itself.
...
-
<Calendar DisplayMode="Month" Name="DTRECFROM"></Calendar>
Hope somebody can help..Hopefully an easy one.
I have a WPF calendar inside a control and I've noticed there is a lot of blank...
-
I just wanted NETTVALUE to be updated with PRENETTVALUE if PRENETTVALUE had a value.
If PRENETTVALUE is DBNULL then update with SALESVALUE.
I know that for my testing the first bit of code you...
-
Hi, Yes that worked perfectly!
I just couldn't work out the syntax as I thought it would need to be as an IIF statement.
-
Hi there,
Hoping somebody can help.
I have 3 columns in a datatable which has been created in memory.
PRENETTVALUE, SALESVALUE, NETTVALUE
NETTVALUE is my calculated column. I want to...
-
Hi,
I'm copying data from one table to another using the below
Dim dt2 As DataTable = dt1.Select("STATUS = 'SALE'").CopyToDataTable
My problem is that I want my new datatable to only have...
-
Thank you for all of your help. It has been extremely useful!!
:thumb:
-
Hi there.. could you help me account for this situation.. where there may be a reference in dt1 but nothing to match it to in dt2
With the below ref 1006 is in table 1 but not table 2.
...
-
No it's okay I understand.. I'm going too far ahead instead of breaking it down into manageable parts. I just don't have too much experience with Linq.
I'm getting an error "Specified cast is not...
-
Hi,
Been trying to find out how to do this for a while.
Let's say I have two data tables. dt1 and dt2
They both have two columns: reference, amount
Is there a way to go to each reference...
-
Hi.. yea think I was having a mind block trying to make it harder than it needed to be.
I can just call the same code inside an If statement for each checkbox :duck:
-
Hello,
I don't have much experience with using a loop but hoping someone can help.
I am using windows forms to run a report and download data from location1 into a datatable. I want to add...
-
I found this answer on another forum and worked perfectly.. no need to release any objects :D
Sub Main()
DoOfficeStuff()
GC.Collect()
GC.WaitForPendingFinalizers()
'' Excel.exe...
-
Hi.. hope somebody can advise on what I might be doing wrong.. I've had a look on some other forums to no avail.
Basically, after I release my COM objects and close my excel application it's not...
-
I figured it out.. thanks for you help
Dim BindingSource1 As New BindingSource
BindingSource1.DataSource = dt
With BindingSource1
.Filter = "ID = 1"
-
Hi,
Thanks for your input.. I have seen this example before online but I'm not sure it does exactly what I need.
Basically I have more than 1 text box. txt0,txt1,txt2,txt3,txt4 and so on.
...
-
Hi.. I'm hoping somebody can help with something I'm trying to achieve.
To keep it simple.. lets say I have a datatable called dt
dt has two columns, ID, Description
in ID it has rows 0-9...
-
Hi there..
In Excel it's possible to do a COUNTIF function on a column... eg say I had a named range called REF filled with
A
A
A
A
B
A
-
102633
Hi.. as an example in the attached image I have the two tables... which all the tables/columns are built visually in dataset designer, so not defined by my own code. I just want to be able...
-
Thanks for your help.. I have created the relation in my dataset between the two tables so I'll just have to read up some more on returning my results
-
I have downloaded data from a database into two data tables which I have called dtsales and dtpayments.
Both of my initial SQL downloads are already quite labour intensive on the database so I'd...
-
Hi..
I have two datatables..one with purchases information, one with payment types.
Each table has a payment reference in.
I want to know how I can pull the payment type i.e COLUMN PYTP...
-
Hi there.. I was hoping a few things could be clarified for me...
I have started building a simple reporting application which runs SQL, downloads the data into Excel, and then creates pivot...
|
Click Here to Expand Forum to Full Width
|