|
Hi Dz
I have developed a site for online sale/purchase of Vehicles(cars,motorcycles,aircrafts,RVs,Heavy Equipment etc). I put a Search Box on top of each page for General Search in addition to Advance Search(Search by selecting Vehicle's category,Make,Model,Year of Manufecturing).
In General Search Customer can type search text like....
Ford(Make)
Ford Mustang(Make,Model)
2000 Ford Mustang(year,Make,Model)
Ford Mustang 2000(Make,Model,Year)
Mustang 2000(Mdel,Year)
2000 Mustang(Year, Model)
Harley Davidson Ultra Classic(Make,Model)
Now I need suggestions that how I can I make my General Search more more efficient so that I can get only relevent records as well as dont miss any record matching criteria.
Note: I am using MySQL at backEnd with ASP.net(VB.net)
Thanks in advance
Lets work it Out.........!
|
|
|
|
|
SELECT Make, Model, Year
FROM MyVehicleTable
WHERE Make Like '%' + @generalSearchCriteria + '%'
OR Model Like '%' + @generalSearchCriteria + '%'
OR Year Like '%' + @generalSearchCriteria + '%'
I forget if you use parameters with @-symbol in MySQL; it may be something else, but hopefully you get the suggestion.
|
|
|
|
|
I have many textbox where user enters different number and I need to change them all in format ex. "45.82" or something like that and if the user enters 45,89 it need to change the number to 45.89 and if the numer is entered 67 -> 67.00 and so on.... i need it fast!! Thanks for advance!!
|
|
|
|
|
Use the Replace method to replace the decimal comma to a period. Use double.Parse or double.TryParse to parse the string to a number, and the ToString method with the format string "n2" to format it with two decimals.
---
b { font-weight: normal; }
|
|
|
|
|
use String.format({f:2},var) to get the decimal values to 2 digits.
|
|
|
|
|
Thanks!!! now it's working fine!!!
|
|
|
|
|
Hi,
This is the error that I am getting when attempting to send an email via asp.net 2.0.
Mailbox unavailable. The server response was: 5.7.1 Unable to relay for username@hpadsds.org.uk
Any ideas please?
THanks
|
|
|
|
|
most imp link http://codebetter.com/blogs/peter.van.ooijen/archive/2006/04/05/142331.aspx
http://forums.asp.net/1131801/ShowPost.aspx
http://www.thescripts.com/forum/thread477848.html
http://www.vbcity.com/forums/topic.asp?tid=104166
just have a look on these links, may be it could help!
Good Luck
Enjoy!
|
|
|
|
|
|
How to deploy a web application to another system
The system have only IIS
So we want to add .Net Framework and the Application at the time of installation
My application also have some resource files(.resx) and one dll
Guide me pls
-
|
|
|
|
|
You only need to install the .net framework
After that, copy/paste the folder of your web application to the server, create a virtual directory for your web application in IIS, and that's it, it should work without problems.
.resx files are not needed for the web application to work, only the aspx files, images, .js files, .css files, all other content, and your bin directory with the web app's dll file.
That's it
daniero
|
|
|
|
|
how can i define an array with row and column???????
for example:
int[][] Deptor = new int[30][];
int[][] SumDeptor = new int[30][];
is it right???????????
|
|
|
|
|
|
Hello, I have a problem with my .Net Web Application.
I was developing with 2003, but I migrate my application to the 2005, and in my local machine I don't have any problem I can see my applivcation in the browser, but when I put my application on the server I have the next error:
(With 2003 I got not problem,neither in the server neither in my local machine)
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type '_GenerateProduct'.
Source Error:
Line 1: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="GenerateProduct.aspx.cs" Inherits="_GenerateProduct" %>
Line 2:
Line 3:
Source File: /GenerateProduct2005/GenerateProduct.aspx Line: 1
I don't know if the proble is that i'm missing a dll, but I don't know where is the dll. Whith ASP.net1 .X was so easy, but I don't know where the ASP.net2.0 locates the dll.
In ASP.net1.X I had a bin folder with the dll inside. Can I configure the place where I want the .Net to put my dll?
Thank you in advanced
Sergi
|
|
|
|
|
Are you sure the server has 2.0 installed? If so, is your web application on the server configured to use 2.0?
|
|
|
|
|
Problem is when I add MS Office charting 10.0 component in toolbox it appears as disabled.
But when i add this comp. in the VS 2005's window version it gives no problem.
How do I use OWC10 office component in ASP.NET 2.0?
|
|
|
|
|
|
Hello,
I am a beginner in .net i have a problem with file uploading .my problem is i want to upload a word document into server's folder and the url is stored in the database.the platform i am using is asp.net 2005(c#).can anybody help me to solve this.
thanks in advance.
alex.
|
|
|
|
|
Hi Alex. There are lots of examples out there for doing this sort of thing - Google will help you find them.
Have you written some code that isn't working? Are you getting a specific error message?
|
|
|
|
|
Hi All,
I want to convert the text document to PDF also copying data from one PDF to other while run time. Can anybody please tell me where can I get any 3rd party freeware control.
Thanks a lot
|
|
|
|
|
AnantAwadhut wrote: Can anybody please tell me where can I get any 3rd party freeware control.
Google?[^]
|
|
|
|
|
|
Can anyone help me in providing the search facility on my portal. I wish to provide the facility wherein the user provides the keywords and text phrases and these words and phrases are searched inside the Word Document and Acrobat files.
Once the search is complete, all the files meeting the search criteria are listed with the links to them. Most importantly, I do not wish to use the SQL Servers' Full Text Search feature.
|
|
|
|
|
|
i am having a checkboxlist in gridview . I have populated with sql database by
<asp:templatefield headertext="Select">
<itemtemplate>
<asp:checkbox id="CheckBox1" text="<%# DataBinder.Eval(Container.DataItem,"cg_type")%>" runat="server">
now i want to get the value of the checkboxes which are clicked on button clicked event.
protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder str=new StringBuilder();
string str1;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
bool isChecked = ((CheckBox)row.FindControl("CheckBox1")).Checked;
if (isChecked)
{
str.Append(GridView1.Rows[i].Cells[1].ToString());
str.Append(",");
}
}
str1 = str.ToString();
}
But i am not getting the values ??? can anyone help me out ???
|
|
|
|