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 Replies
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'm inserting from one table to another, if there are any contraint issues (duplicates found on the VolInterestID and client_id) I want to still insert the ones that are not Duplications. But this terminates the statement if any duplicatiuon is foundIs it possible to do a loop using this insert and pass the where the @client_id and the @clientvol_ID and if it finds a dup just keep going ot e next row?
[Code]....
I'm getting this error when trying to connect to SqlServer:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
A few points:All was working well 6 hrs before, and I didn't change anything.I get the error anytime I try to connect to a local database (not remote, but I tried anyway to allow remote connections and here's a screenshot of what I get - there's nothing there:
http://www.zumodrive.com/share/5OKBNDg0OT)Screenshot of trying to configure SqlDataSource control:
http://www.zumodrive.com/share/5OJEYmVhMm
Screenshot of trying to connect in Sql Server Management Studio:
http://www.zumodrive.com/share/5OJINGQ2MG
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I am using Visual Studio 2010 for the first time. I program in MS Access for a long time at decide to move to the ASP world. My problem is that I design my first web .aspx default page with a simple data grid. I decided to connect the data via the business object data adapter. I use the Dataset designer to great the dataset. All looks well and works fine on my PC. But when moved to the server I get the Terror "The type specified in the TypeName property of ObjectDataSource not found".
From my reading for the past two days, it seems that something need to be define (a class of some sort) to let ASP know where to find the data adapter. If this is the case, then why did not Visual Studio 2010 did not automatically build the class in the appropriate BIN/ APP_CODE or Global directory and more importantly, why would it work fine on the PC , but not on the server. I am totally blind-sided by Visual Studio 2010 allowing me to design and test on PC but throws me a curl ball with moving to a server. Am I assuming to much from Visual Studio 2010???
What is the solution.. What I am looking for is to know where exactly where and how to write this class. I am so new to ASP, all of my reading just confusing me more and more by reading so many post on this error. I know it is probably a simple class to write somewhere, but why did not Visual Studio 2010 write it accordingly.
I have a dataview on a page. I am binding a list of Items, and each item has a Person object. So I get this exception "field not found in selected datasource" when I try to bind to any property on the person object.
[Code]....
It appears that the dataview is having problems with the person object because it will display all the properties for the Item correctly.
why I get a not found on the boundfield and not on the eval?
I added a new table to my type dataset. When the code tries to execute the new row on that table I get the error message.
(if you can't see the error. "MissingMethodException was caught" "Method not found: 'MyTableDataTable MyNamespace.get_SSCase().")
I've tried the wizard and also click and drag the table from solution explorer to the xsd file. The other tables work, just this one table won't work. What should I check?
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
I'm really new at asp.net 3.5 I'm comming from Classic ASP and I have been experimenting with ASP.NET. I'm trying to use the ListView Control to display a products catalog comming from a database. My first test was succesfull but I have a question.I want to be able to display the title of the product in Bold if certain conditions exists for that product. I tried using the ItemDataBound event but I don't know how I to get the value from the database field.I have the following code
ASPX PAGE
[Code]....
CODE BEHIND
Protected Sub productsList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles productsList.ItemDataBound
Not sure why it works if i connect to SQL 2005 on another server, but now that i have SQL Express on the same server as the pages, im getting the following error: I have attached my connection string within my web.config and also how its being called within the code behind. Now this page was written by another programmer some time back.. so not sure if the method he used to do this is the best or only way. But i have connected to other SQL database with other applications with alot less code.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error: Line 131:
Line 132: //connect to this sql server
Line 133: c.Open(); -----> this is the line it complains about.[Code]....
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
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 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 RepliesI have a gridview in which dtasource binded is a List which returns class type. If no records in list, I want to display 'No records found' in GridView.
[code]...
In else part, what code i have to write to get desired output?
I'm busy working on an ASP.NET Web Application (3.5) and can't seem to connect to a MySQL DB. I first created the entire application using a WinForms template and everything works 100%, but as soon as I move the exact same code to the Web Application, I can't connect anymore. Here's the code:
Code:
public class DBC {
OdbcConnection connection;
public bool CreateConnection() {
try {
string connFormat = "Driver={MySQL ODBC 5.1 Driver};Server=[SERVER];Database=[DBNAME];User=[UID];Password=[PWD];";
connFormat = connFormat.Replace("[SERVER]", Properties.Settings.Default.DBServer);
[Code] .....
As soon as I try to create the new OdbcConnection instance, I get the error:
Code: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
As noted this works in a WinForms app, and even more strange is that I don't even specify a DSN name...
All I could find from reading through forums all over the internet is suggestions of downgrading the MySQL ODBC driver version, which I'd really rather not...
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?
Is 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 found this very useful [URL]....
How to display No Match Found when there is no data with the entered initials.
Ex: zz
Output No Match Found
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
On Page_Load I create dynamically table as following:
//compose the SQL statement
string strSQL = "SELECT images.location, products.description, products.price, products.isNew ";
strSQL += "FROM images INNER JOIN products ON images.idImages = products.idImage ";
strSQL += "WHERE products.idCategory=" + str_idButtons;
strSQL += " AND products.doShow=1 ORDER BY products.isNew DESC"; //new first
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["????????"].ToString());
MySqlCommand command = new MySqlCommand(strSQL, con);
con.Open();
[code]...
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.
