Are there any performance implications to storing a stored procedure in one database that accesses data in another database? Same server, just a different database. My reason for storing it on the other database is mainly for organizational purposes.
I don't do much VBScript programming, I have some VBScript in an ASP page.
I need to request the value of a server variable which I have done:
Sub GetRoles
dim decryptedRoles
decryptedRoles = Decode(Request.ServerVariables("HTTP_ROLES"))
GetRoles = decryptedRoles
End Sub
Then...
I'm looking for a way to search a string for a specific div, so that I can remove it. The div does have an id so it should be easy to find the start index, but I'm not sure how to indicate that the end index should be "</div>". How can I accomplish this?
I've been having a lot of trouble trying to implement cascading dropdowns (select a country, and then a state) with regular asp.net dropdowns. I've posted on a few other message boards and no one seems to know the answer.
When the country dropdown selection changes, I send the selected value...
Is anyone aware of a control I can embed on an ASP.NET page (VS 2008) that will play a .wma file? I believe I can embed the windows media player but in the past it always required user interaction because it's active x. My boss opposed to the user having to install anything first so I'm...
I have a SQL Datasource attached to a GridView. The SQL Datasource accepts a few parameters. I'm trying to provide sort of multiple filtering capabilities. So I may need to include logic to filter on only one parameter, not both. Is it possible for me to use the same SQL Datasource for all...
I have some data that I am "pivoting" and storing in a DataTable. The original subset of data needs to be filtered various ways, then pivoted and bound to a GridView. The data is display only, I don't need to allow for editing, etc. I want to make sure that I'm not creating copies of...
I'm making a custom XmlSerializer that I only need to use for serializing (my classes are populated by a SqlDataReader). I need to loop through all of the elements and check the value of a property. How can I loop through the elements in the WriteXml method? I don't seem to have access to a...
I'm using a datareader to iterate through recordsets, and I'm doing a lot of this:
Employee.FirstName = dataReader["FirstName"]...
This "feels" wrong because there are a lot of hard-coded column names, but I don't see a way around it that doesn't seem a whole lot more work than it's worth...
I need to store hashtables that hold index information into collections of items stored in classes representing an XML document (generated by a tool similar to xsd.exe). For instance, suppose I have the following XML structure (please excuse my lame example):
<Dresser>
<Drawer>...
Looking in the object browser, I see two System.Collections.Generic. One is in System.dll and one is in mscorlib.dll. I see there are different types within each one though. Can anyone tell me the reason for this? Why isn't System.Collections.Generic just one namespace?
We have currently been using XSLT to transform data from SQL into an XML format we need, and have found performance to be slow. Instead of traversing an XML file with XPATH we have decided to create classes to represent the nodes (using xsd to generate the classes). Is there an easier or more...
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.