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...
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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.