Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Meleagant

    Mutiple Databases & one set of Stored Procs

    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...
  2. Meleagant

    Mutiple Databases & one set of Stored Procs

    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...
  3. Meleagant

    combining (using a union) on two data sets

    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...
  4. Meleagant

    combining (using a union) on two data sets

    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 =...
  5. Meleagant

    combining (using a union) on two data sets

    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")...
  6. Meleagant

    Managing Multiple Threads

    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...
  7. Meleagant

    Managing Multiple Threads

    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...
  8. Meleagant

    Changing ColGroup Class

    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...
  9. Meleagant

    Attempted to Access an Unloaded AppDomain

    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...
  10. Meleagant

    Variation on String.Split()

    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() =...
  11. Meleagant

    Variation on String.Split()

    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"...
  12. Meleagant

    Can't find DLL when debugging

    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...
  13. Meleagant

    Email Zip Archive Corrupts File

    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...
  14. Meleagant

    Email Zip Archive Corrupts File

    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...
  15. Meleagant

    Postback - How to get javascript do button.click() &amp; postback form dat

    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...
  16. Meleagant

    Postback - How to get javascript do button.click() &amp; postback form dat

    As I was reading your post again, I was thinking is the ViewState enabled for the page or control? If not that could be why you cannot get the value on the server side. * Sine scientia ars nihil est * Respondeat superior
  17. Meleagant

    Postback - How to get javascript do button.click() &amp; postback form dat

    Try using something like this. In js where you want the postback: var eventTarget = 'PostBackFromJS'; var eventArgument = 'UserId:Joe|Confirm:Yes'; // Rest of JS function ... __doPostBack(eventTarget, EventArgument); Then on the server side, in the page load: Dim eventArgument...
  18. Meleagant

    Read Data From Excel... Not finding Sheet Name

    I know there is a 31 char limit for an XLS sheet name. Don't know if XLSX has removed that limitation. But it seems when reading data from excel using the Jet provider, the sheet name needs to be less than 30 characters not less than 31. I just wish some other type of exception was thrown...
  19. Meleagant

    Read Data From Excel... Not finding Sheet Name

    All, Not sure if this is the right forumn, but as this is an Asp.Net application, figured good place to start. I have users who upload excel files and then I read the data from them no problem. The problem is when the actual sheet name is really really long. When that workbook with the...
  20. Meleagant

    Bit to Boolean Grouping Function

    gmmastros thanks for the post!! When I ran the function you provided it looked like it worked great! But when I posted my sample table I simplified matters. There is actually a PolicyId that I left off of that table. A policy is made up of multiple rules. The RuleId is just a lookup value...

Part and Inventory Search

Back
Top