I am trying to convert a asp page to asp.net.
I changed everything except this one line Set dbC = Server.CreateObject("ADOX.Catalog")
Can anyone suggest an equivalent to this ADOX.Catalog in asp.net This dbC is being used in the following way in asp
[code]....
Can you let me know the equivalent of C/C++ #define in asp.net?
View 5 RepliesI am converting some code from asp classic to c#
Need to createObject
Object obj=new Object();
obj= server.CreateObject("SOFTWING.ASPtear");
It doesnt compile, I added the dll into my bin folder and into WINDOWSsystem32
I added using System.Net; what other references I need to add for it to compile?
I am building UI for a large product catalog (millions of products).
I am using Sql Server, FreeText search and ASP.NET MVC.
Tables are normalized and indexed. Most queries take less then a second to return.
The issue is this. Let's say user does the search by keyword. On search results page I need to display/query for:
Display 20 matching products on first page(paged, sorted)
Total count of matching products for paging
List of stores only of all matching products
List of brands only of all matching products
List of colors only of all matching products
Each query takes about .5 to 1 seconds. Altogether it is like 5 seconds.
I would like to get the whole page to load under 1 second. There are several approaches:
Optimize queries even more. I already spent a lot of time on this one, so not sure it can be pushed further.Load products first, then load the rest of the information using AJAX. More like a workaround. Will need to revise UI.Re-organize data to be more Report friendly. Already aggregated a lot of fields.
I checked out several similar sites. For ex. [URL]. Not only they display the same information as I would like in under 1 second, but they also include statistics (number of results in each category).
The following is the search for keyword "white" [URL] How do sites like zappos, amazon make their results, filters and stats appear almost instantly?
I'm trying to develop a web application that dispatch (Dispatcher) to multiple versions of another webapp on a per-request basis. To to that end, I'm using ApplicationManager.CreateObject to create new AppDomains running the web app in question, but the new app domains seem to be failing to load the Dispatcher's DLL (and I'm copying the DLL over to the web app's bin directory, so I'm pretty sure it's there).
[code]....
The Appbase seems to be pointing at the root of the development server, rather than the path passed in to ApplicationManager.CreateObject and it only seems to be searching directories under the development server which seems strange. how to make the new AppDomain search for the DLL in the web app's root rather than under the development server?
i had NT authority user account on the web server (or simillar priviallge account with sid like s-1-5-21-1311... ).
recently, due to security issue, had to remove this account and the application hosted on the webserver stopped working.
the issue seems to be with the database connectivity. not able to analyse the issue as, this occuring only on production and not on development server.
On our web server we have a search form that fires off multiple searches and combines the results into 1 page. The main search is of the indexing catalog for our web site. We have used this for several years and it works just fine. The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error. The word "weigh" works fine but if we add that "t" on the end it fails. Here is the error:
Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF, STRING, PREFIX_STRING. SQLSTATE=42000
This is the query at the time of execution:Select DocTitle,URL from SCOPE() where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by Rank DescDoes anyone have an idea of how to get past this problem? I'm guessing that "weight" is probably a key word or something similar.
there are an access file . >> "test_file.mdb"
there are a table in mdb file .>> "test_table1"
and there are 2 columns in "test_table1" >> "name" and "age"
and i have 2 textbox in my web form . >> "textbox_name" and "textbox_age"
and i have a button for save textbox_name.text and textbox_age.text in mdb file .
i need adox vb code for save textboxs data in mdb file .
I am new to LDAP so it is a bit confusing for me. I am converting a Legacy application from ASP to ASP.Net. That application is using LDAP so i have to find an alternative/equivalent of this.
My questions are:
1- LDAP is still used or obselete?
2- Equivalent/alternate of this?
3- How it is different from?
4- How can i setup a small test LDAP server if i have to test it locally ?
5- Any examples/source code/tutorials?
I have googled it and i know the basic concept of LDAP but i was unable to get the proper answer for all of the above.
I need a div element to cause postback to the server. I can use window.location tough but then I think I won't be able to fire any event back on the server. How can I call the asp.net generated dopostback function properly?
View 1 RepliesI have a catalog that hase standard pricing now i need to increase this to 5% for each product. this is the way i bind the data:
Price:<%#Eval("Price",
"{0:c}")%>
I am wondering if there are any good articles you could point me to that would present the implementation details or options for delivering advanced search capabilities. Like what we see at [url] and similar Web sites offering vast numbers of products to be searched. The search process for these starts with a simple "Search" text box - usually with auto-suggest. Then the user can drill down and narrow the search by [for example] price, manufacture, size, capacity, and other relevant attributes of the product being searched.
When I navigate such sites and search for products, drilling down into the various categories, it's easy to think that there is some complex engine behind the scenes that generates dynamic SQL to satisfy the various and potentially extensive criterion required to satisfy the search requests.
Or could it be simpler than that? In any case, I understand this question may not have a specific answer; so I'm hoping for some article or reference implementation I could study. Short of that, if any of you have implemented advanced search of a product catalog (presumably searching products stored in a reasonably normalized database; through 3NF or so); any critical implementation considerations would be appreciated. I'm particularly interested in the meta data that may have to be present in the underlying data set in order to satisfy some of the search requests.
I have created SQL CLR database project in 2010. when I try to deploy it to sql server 2008, it gives me error like Msg 6528, Level 16, State 1, Procedure UmAlQuraConverter, Line 2 Assembly 'SqlClassLibrary' was not found in the SQL catalog of database so, how to add SqlClasslibrary to sql catalog
View 1 Repliesi m developing a product Catalog. All fine, i want to manage wish list for product, which user wish to see, now my question is that how can i manage this wish list, coz i have no uniqueness of the user, coz ny one whether it is registerd or not can wish the product in my scope, i thought to distinguish the user by their IP address becoz this wish list is temporaray, how can i delete the record when user close the browser if go to the IP address for distinguish..
View 2 RepliesIs there any good code (paid or open source) out there for:Handling PPC ads on our site? This would (hopefully) include pages to create ads, reports of ads run, determining what ad to show, and tracking billing.Adding comments to our site? This would (hopefully) include up/down/inappropiate votes on other's comments.A product catalog? This would (hopefully) include advanced search and entering product items.
View 1 RepliesI'm looking for a way to add 3 level product catalog to cart based on MVC musicstore sample:
root product categories
sub categories
products
Clicking in catalog item should show subitems with pictures.
Control is placed to Site.Master. It can be treeview in cart left side or horizontal menu in upper part of screen.
Data is read from database from controller.
How to implement this ? Which free control is best for this or is there sample code for this ?
I have different roles like Administrator ,Accountant, Clerk,Enforcment When user open Catalog Zone to add parts to Web part Zone i want only those parts should apper on the screen for which user selected Group,like if user selected Enforcement Group then Parts of that group should only appear in the Catalog Zone.
I want Catalog Zone cantains to be depend on which Group user was selected.
i want to add control 1, control 2 etc.. by default in Declarative Catalog Part
and using following code
[Code]....
but it only displays last item in it
any one guide me what mistake am i doing or what is the solution to my problem?
actually i want to give default 4-5 webparts options so that user could add it to page
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee
a list appears
kneepads
here's my getCompletionList
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim items As New List(Of String)
Dim myConnectionString As String
myConnectionString = GetSQLConnString()
Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK()
OVER (Order BY PartNumber, ShortDescription, LongDescription)"
[Code]....
I am debating between 2 scenarios for handling the display of a product catalog for a website redesign I am performing. I will be using the IIRF isapi filter to perform the rewriting for an asp.net website.
Here is what the urls will look like
[URL]
[URL]
[URL]
etc...
There will be a total of 8 or 9 product group pages
Scenario 1: I have these pages rewrite to one general purpose page that will look something like this:
[URL]
Then I decide which catalog to display with a switch/case based on the querystring. All of the code for displaying the catalogs would be based off of one page.
Scenario 2: I create a separate page for processing each different catalog page. The rewriting would look something like this then:
[URL]
Then each catalog page would have it's own .aspx to handle the processing and display of that group of items.
I am developing an intranet application that needs to authenticate against a global catalog server (containing about 14 domains). What would I use for the connection string?
GC://DC=mb,DC=rellish,DC=com
I need some good hosting. recommend me some.
View 1 RepliesI am having the table which contains Name,DOB From this i have to retrive the records of those who are celebrating their birthday is lie between today and coming 7 days. here is my query,
SELECT Profile.Name,
GetProfile.DOB,
FROM Profile
WHERE
Month(DOB)
=
Month(GetDate())
And
Day(DOB)
BETWEEN
Day(GetDate())
AND
Day(DATEADD(Day,6,
[Code]....
Ranking of CONTAINSTABLE StatisticalWeight = Log2( ( 2 + IndexDocumentCount ) / KeyDocumentCount ) Rank = min( MaxQueryRank, HitCount * 16 * StatisticalWeight / MaxOccurrence ) can anyone explain this algorithm, more importantly i want to know about these variables used in this algorithm, whats their purpose?it would be more useful for me?
View 1 RepliesI been googling a bit and not having a clear picture on this. I have a few database now sitting duck in Express and we planning to migrate to 2005 or 2008 enterprise version. Currently, all the sensitive and important data are stored in the Express. We wanna do the migration but we do not want to impact a single column in a table. E.g. some numbers becomes different format like 234E whatever watever. Is there any good tools out there to do the job with the least efforts ?
View 2 Replies