Recent content by Meleagant

I was trying to think of a way to do this without dynamic Sql as well. But it would be nice to have just one copy of the SPs. To shed a little more light on my plight... I currently have these Dbs in Oracle. Prior to my arrival all of the Sql for the web apps are all inline Sql statements in...

All, I have 15+ databases that are all the same as far as table structures. I was thinking it would be nice to have one set of stored procs that could execute against any one of these databases instead of having 15+ copies of each and every SP or function. Is this even possible? Can someone...

Records and columns are tables. What I've done is create one dataSet object. Then I fill that dataSet object with the results of multiple queries. A dataSet can hold multiple data tables. Once that is done you can "query" the children dataTables to get the related rows. This approach works...

Noticed an error in my code. The second code block should be this: Dim drChildren() As DataRow Dim myValue as String = "" For Each dr As DataRow In ds.Tables("DS1").Rows drChildren = dr.GetChildRows(dRel) If drChildren.Length > 0 Then myValue =...

Look into using the DataRelation Class. What I've done is create one dataset with multiple data tables which are the results of my queries. Here is a small sample: Dim dRel As New DataRelation("RelationName", ds.Tables("DS1").Columns("ParentColumn"), ds.Tables("DS2").Columns("ChildColumn")...

Here is my first rudimentary attempt at accomplishing my goal. There are a number of executables that currently run synchronously in a job stream. I would like to run say 2 or 3 at a time until all of the exes have been run. This is just a rough draft and wondering if anyone has any helpful...

All, I've been looking all day and I haven't been able to find an answer (at least one that I can understand). The problem is simply that in a business process I have to execute the same Exe say 12 times with different parameters. The number of times will vary depending on circumstances...

All, I have an HTML table where I implemented an excel like column locking feature. I was trying to improve performance by using the ColGroup/Col tags. Web services return data which is then parsed by JavaScript where basically <TR/> tags are added to a table. The problem I am running into...

All, Does anyone know what could cause "Attempted to Access an Unloaded AppDomain" errors? I'm beginning to see these in the windows event log. Basically I have some long running executables which are started in new threads. But they seems to just die and looking into things I'm seeing these...

I actually just got it. I found another post here that when using RegEx I could use (|-). Using this as a starting point I was able to get what I needed. I'm not sure how this works but it does: Dim myString As String = "Charges + Allowances - Bad Debt" Dim parts As String() =...

All, Is there an easy way where I can split a string and actually get the delimiter as part of the array? For example: Dim myString as String = "Charges + Allowances - Bad Debt" Dim parts as String() = myString.Split("/*-+".ToCharArray) Parts would then yield: parts(0) = "Charges"...

Hope this is the right place. VB 2010 building a cmd line app which references a couple of external DLLs. My solution is on the file server not on my local machine. I used to get that "Location is not trusted" message when opening the solution, but I must have hit the Ignore button b/c I...

I did have a problem a couple of weeks back with IIS7 & Asp .Net 4.0 not sending emails where the attachment was larger than 3MB (in my case mainly Excel files 3 - 5MB). According to MS, I should add the Transfer Encoding property to the attachment. The article is located here. With this app...

All, My web app sends many many emails. Usually PDF, Excel, Word, etc. This is the first time I need to send a Zip file. Every time I send I zip file through code, when I get the zip in my email, then try to unzip it, I get a message saying that the CRC is bad and the file is corrupt...

This is a simple example where on the click of a label I cause a postback. The variable 'setId' is a global declared elsewhere. function lblSortReports_Click() { __doPostBack('SortSet', setId); } Then in the code behind page: Protected Sub form1_Load(ByVal sender As...