Search:
Type: Posts; User: Tom Sawyer
Search:
Search took 0.14 seconds.
-
Ya, that was just for one specific example. I can't, for instance, see a situation where I'd use a LinkedList instead of a List and numerous articles about performance tests between the two seem to...
-
Ya, that's kind of the heart of the question that I was asking. Are they a general theoretical concept that it's nice to know to be able to better understand the technical concepts behind...
-
I had a job interview yesterday and it came with a C# technical test involving building a class that did stuff with a LinkedList. I've never used one of those in my life and a basic google around...
-
Does anyone know how to go about scripting out all the stored procedures in a Sybase database? We're putting them into source control, but I can't find a way to do it any other way than by going...
-
I have a query that I'm running:
SELECT ProductSymbol, COUNT(ProductKey)
FROM OptClosePrice
GROUP BY ProductSymbol
HAVING COUNT(ProductKey) = 1
What I want to do is update a field for the...
-
Ya, it looks like I'm stuck with something like that.
-
I have a heirarchial flex grid which I've added a bunch of data to using some custom functions. It works fine as a grid, but now I want to get it to expand a subrow for some of the rows to display...
-
Ya, unfortunately we're using a Sybase database, so we can't put them into stored procedures.
-
Actually, the database fields are encrypted and the decryption routines are done in .NET (it's a Sybase database which was built for a VB6 appliaction, so the encryption is weird). Basically, the...
-
I have an application which uses the ReportViewer control to load up some SSRS reports and display them within the app. We have some custom code that runs on the RenderingBegin and RenderComplete...
-
Ya, got that. The problem was that I hadn't made the ColumnName property public so it wasn't coming up as a valid option.
Doh. :(
Thanks a lot.
-
I had a program where I was generating dynamic sql queries based on some column information in XML files that I put into a List<string>.
It was pretty basic along the lines of:
string...
-
Never mind. The problem was that I was setting the variable historyID to an empty string as opposed to having it be null. That apparently throws an error that's completely unrelated to the problem...
-
I have an app where I'm trying to log into an SSRS reporting service on another domain. I have an account on that domain where I'm an administrator both on the SSRS and on the Windows. I am trying...
-
You can just use the Clipboard class:
Dim x as String
x = Clipboard.GetText()
MessageBox.Show(x)
-
I just tried a test and this worked:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.ComboBox1.Focus()
...
-
This might help:
http://stackoverflow.com/questions/4295785/how-do-i-get-datagridview-comboboxes-to-display-their-drop-down-list-in-one-clic
If, where you want to have the list display, you set...
-
Ya, that works too, but I'd like to know how the "not ends with" works.
-
Ya, I got it done fine without using the regular expressions, but it seems like the kind of thing which regular expressions can do and I want to try them out.
-
I've got an application which loads up some Excel files and imports them into a database. There are only certain of the sheets which I want, which are all timestamped and have either an am or pm on...
-
No, it's not a silly suggestion. It's a goddamned genius suggestion is what it is and it worked!
If there's an error I can copy the file back to the import folder for a rerun because it's only...
-
I have an Excel file that I'm uploading into SQL Server via SSIS. The upload works fine, but I'm having an issue where at the end of the process, I want to move the file from the input folder to a...
-
Ya. Oh well. Thanks for your help.
-
Ya, they're actually strings with the 0 added infront for hours where that's needed which I was converting into integers because I thought it would be easier. That failed miserably.
I did it with...
-
I have a database where the times of various trades are stored in an integer format down to the millisecond. For instance, if a stock is bought at 7:15:11.641 seconds, it's stored as 71511641 and if...
-
Thanks. Your response to my question of how to modify the import to insure it loads as text by telling me I need to modify the import to ensure that it loads as text was most helpful. :D
I...
-
I'm importing an Excel file into SQL Server using SSIS. For one of the columns, the data is as follows:
SubscriberId
000223OR
500299
500299
500299
500299
SF002AD
SF002AD
-
I agree that the SQL Server Express would be your best bet. Bulk insert or bcp your files into the database and then you've got a much easier way to access the data that you do when it's in files.
...
-
I'm trying to import a file into a table in Sybase, but the xp_cmdshell is locked down and can't be used. If it were SQL Server, I'd use the BULK INSERT command, but that doesn't seem to work in...
-
I have a project where I need to strip out the last characters at the end of a string if it ends in a .TO or a .V - but only at the end. It's a field in a Sybase database.
For instance, if the...
-
You're looking for a file called Microsoft.Office.Interop.Excel. It's probably in one of the subdirectories of Program Files/Microsoft Office
-
Ya, any use of Excel requires Marshalling and releasing the objects.
-
Ya, change the last line to A.ItemID and it's also redundant to have the text for the ItemID both inside and outside the subquery when you already have the A.ItemID = B.ItemID stated.
-
Just use a Range object:
Dim oRange as Microsoft.Office.Interop.Excel.Range oRange = {worksheet}.Range(worksheet.Cells[row1, cell1], worksheet.Cells[row2, cell2])
oRange.Font.Bold = True
...
-
Have you checked out the task manager to see if there are any processes that start running when you load a url through the Webbrowser? It might be that it loads a copy of IE or something and doesn't...
-
I don't see how having the code inside of another form would improve performance. If the form is aleady open and in use, then sure, but otherwise you're adding the overhead of loading up a new form...
-
Have you looked into the GC (Garbage Collection) AddMemoryPressure and RemoveMemoryPressure methods? What might be happening is that the Webbrowser control loads the entire webpage into memory but...
-
Ya, we're willing to help you with any problems you have and point you in the right direction, but we're not actually going to do the work for you.
-
I'd say that you're probably better off reading it into a dataset and then writing it back into Excel. You can do it with Excel automation, but I've found that to generally be more trouble than it's...
-
Do you have any spaces in your login path? I've run into errors opening a connection to Excel when that was the case - ie the file is in C:\App Docs\Database as opposed to C:\AppDocs\Database.
If...
|
Click Here to Expand Forum to Full Width
|