Showing results 1 to 25 of 324
Search took 0.02 seconds.
Search: Posts Made By: JustinCase2
Forum: .NET Database and Reporting 05-29-2015, 02:09 AM
Replies: 0
Views: 2,424
Posted By JustinCase2
MSSQL - Insert > 1000 rows

When inserting rows to MSSQL, it has a limit of 1000 rows per statement. I have an import function that opens a text file With a special format, reads lots of logs from this, manipulates the data,...
Forum: .NET Installation / Documentation 04-09-2015, 03:48 AM
Replies: 0
Views: 1,900
Posted By JustinCase2
Equivalent of "everyone"

I am using InstallShield to create an installer for a program. In one of the folders the installer creates, i want to set permissions for "Everyone". Now, I can add that in the permissions dialog in...
Forum: .NET Database and Reporting 02-24-2015, 07:55 AM
Replies: 2
Views: 4,093
Posted By JustinCase2
Well

Kindof hard to tell whats wrong without seeing the code, but i will make a Guess:
You created the Field in question AFTER you dragged/dropped the adapter from the data Source, and have not updated...
Forum: .NET Database and Reporting 02-24-2015, 07:52 AM
Replies: 1
Views: 3,263
Posted By JustinCase2
Correcting you 'cause you're wrong :)

Crystal reports is the Perfect tool for what you want to accomplish. Creating a program similar to this on Your own would be... well, a Lifetime Project. So don't start. Use Crystal reports, it can...
Forum: .NET Database and Reporting 02-24-2015, 07:26 AM
Replies: 1
Views: 2,389
Posted By JustinCase2
Define a statement

To update a table adapter (or Select, delete etc), it needs to know what SQL statements to run for each of those. I believe there is a property on the tableadapter for this. However, if you generated...
Forum: .NET Database and Reporting 02-24-2015, 07:19 AM
Replies: 2
Views: 2,777
Posted By JustinCase2
So..

If you're doing more queries than this you really should read up a bit on SQL and joining tables, it's not that complicated and highly useful. :)

Anyway, for this one it would be quite simple:

...
Forum: .NET General 02-24-2015, 05:12 AM
Replies: 2
Views: 843
Posted By JustinCase2
Hmm

What do you meen it does not fire? Have you gone through the code in debug mode and seen what the values of the "room" Object is when it comes to it? Also, you say it doesn't fire even if the...
Forum: ASP.Net 02-23-2015, 07:20 AM
Replies: 1
Views: 3,385
Posted By JustinCase2
DataFormatString currency

Having an issue with using DataFormatString={0:c}, which is currency. It will display the value formatted with the currency of the current locale (Thread.CurrentThread.CurrentCulture). How does that...
Forum: Database and Reporting 10-10-2014, 01:07 AM
Replies: 1
Views: 1,330
Posted By JustinCase2
Well

I'm not sure I would go about it in this way, and rather put the GetFilter declaration in a class or module file. Anyway, it should be as simple as

formfilter = frmMainForm.GetFilter

Of...
Forum: .NET General 10-09-2014, 06:48 AM
Replies: 0
Views: 579
Posted By JustinCase2
Ajax requests

So I am making a library (dll) that, among other things, connects to a website to retrieve some data. The webserver ONLY accepts ajax requests. How can I go about this? Can I even make a proper Ajax...
Forum: .NET General 10-02-2014, 05:48 AM
Replies: 2
Views: 2,599
Posted By JustinCase2
Thanks for your post

I have attempted this, With the following code:

Dim jsonString As String = "{'user[name]':'admin','user[password]':'mypwd'}"
Dim data = Encoding.UTF8.GetBytes(jsonString)
Dim u...
Forum: .NET General 10-02-2014, 02:19 AM
Replies: 2
Views: 2,599
Posted By JustinCase2
Http login through code

I am having some trouble login in to a webpage through code. I have an URL that should Return json data. The URL is behind a login. Here is the example I have on how to accomplish this through...
Forum: .NET General 10-02-2014, 01:59 AM
Replies: 2
Views: 1,040
Posted By JustinCase2
Well

Assuming each line in your post is a line in the listbox:

ListBox2.Items.Add(
ListBox1.Items(0).Split("=")(1)
& "-" &
ListBox1.Items(1).Split("=")(1)
)

That should put Bob-Marley in...
Forum: .NET Database and Reporting 05-22-2014, 05:10 AM
Replies: 1
Views: 897
Posted By JustinCase2
Database select executions with ORMs

I have been testing the difference in speed between an ORM (NHibernate in this case), and standard SQL use With SQLCommand etc. I have a table With 44 MILLION records, and ran a few tests to see the...
Forum: .NET General 05-13-2014, 07:44 AM
Replies: 2
Views: 504
Posted By JustinCase2
I think this may be simpler

Dim d As Date = DateTime.Now
Dim minute As Integer = d.Minute
Dim hour As Integer = d.Hour
Dim iAddHour As Integer = 0
Dim iOver As Integer = (minute Mod 10)
...
Forum: .NET General 05-09-2014, 05:50 AM
Replies: 1
Views: 682
Posted By JustinCase2
Just gonna answer part 2

To get proper random numbers, you need to "Randomize()" at some point in Your code. The best i Guess is on the Project startup.


...
Randomize()
...


Should be all you need.
Here's some...
Forum: .NET Office Automation 05-06-2014, 02:47 AM
Replies: 1
Views: 3,560
Posted By JustinCase2
Actually

I don't see why you need to do anything With Your program. Just Write one that opens the file and does the work, and then set it to run once per day in Windows Scheduled Tasks.
When it comes to...
Forum: .NET General 04-30-2014, 03:48 AM
Replies: 1
Views: 423
Posted By JustinCase2
Try some of the solutions here

http://social.msdn.microsoft.com/Forums/vstudio/en-US/b25e2b8f-141a-4a1c-a73c-1cb92f953b2b/instantiate-shell32shell-object-in-windows-8
Forum: .NET Database and Reporting 04-30-2014, 03:41 AM
Replies: 2
Views: 814
Posted By JustinCase2
Some code

Think i'd need to see Your code for this to specify where to insert the update. I imagine 2 scenarios, either using an SQL trigger on the support table to update the underlying tables, or use a...
Forum: .NET File I/O and Registry 04-11-2014, 04:51 AM
Replies: 2
Views: 3,635
Posted By JustinCase2
Something like this?

Private Sub mnuSearchClick_Click(sender As System.Object, e As System.EventArgs) Handles mnuSearchClick.Click
dim searchString as string = InputBox("Enter video name:", "Search")
...
Forum: .NET Office Automation 04-09-2014, 07:01 AM
Replies: 1
Views: 3,084
Posted By JustinCase2
Should be simple enough

If I understand you correctly, it is the "Drag Drop" part you are having difficulties with. All you need to do is:

Set the forms "AllowDrop" property to True.

Add this in the codebehind:

...
Forum: ASP.Net 04-09-2014, 06:41 AM
Replies: 1
Views: 8,909
Posted By JustinCase2
Bit hard to say

Not sure about this without seeing the actual datasource. But i think Your second attempt is the best one:


Dim myQuery As String = "INSERT INTO dbo.femtocell ([uploadID],[clientID],...
Forum: .NET General 04-09-2014, 03:10 AM
Replies: 3
Views: 640
Posted By JustinCase2
Some code please?

Sounds like Your Logic is fine, so i expect there is an issue in the actual code. Could you post some of it?
Forum: .NET Database and Reporting 04-04-2014, 08:28 AM
Replies: 1
Views: 1,161
Posted By JustinCase2
well

When you say "Skip a line", I assume you meen a line in the Excel sheet, not the recordset. So you want to insert the first 12 lines from the recordset into Excel rows 1-12, then put nothing in Excel...
Forum: ASP.Net 04-04-2014, 06:19 AM
Replies: 1
Views: 3,176
Posted By JustinCase2
Easy enough

Just make a database IMAGE column, and save the images to that.
Optionally you could convert the image to a byte array and save that to a ByteA column.
Showing results 1 to 25 of 324

 
Forum Jump
Advertisement:



Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe