Re: Searching in database - ASP.NET Discussion Boards

First Prev Next

Re: Is it possible to detect if a client software is installed on a machine using browser? [modified]

sashidhar10-Mar-10 0:21

sashidhar

10-Mar-10 0:21

Yes its a good Point..!
its possible with active x controls...|

Do you have any other idea..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

modified on Wednesday, March 10, 2010 6:30 AM

Searching in database

Krunal Berawala9-Mar-10 15:48

Krunal Berawala

9-Mar-10 15:48

Hi guys,

I have customer database with about 30 fields in it.

I need to develop search facility for it.

I have tried using some queries like below

Select * from customer where name like '%' + @search + '%' ( similarly for all the fields in the same query)

But u know that this is not efficient search....

Let says client name is "Erina Art Clubs and Pubs"...............if i search for "ART", result is found but

if i search for "art erina" it wont come up............

Can you suggest me some better searching techniques combining sql and vb.net programming..........include some examples

Thanks

Re: Searching in database

Anurag Gandhi9-Mar-10 16:08

Anurag Gandhi

9-Mar-10 16:08

I guess you are looking for Full Text Serach.
Follow the link:
http://www.developer.com/db/article.php/3446891/Understanding-SQL-Server-Full-Text-Indexing.htm[^]
http://aspalliance.com/1512_Understanding_Full_Text_Search_in_SQL_Server_2005.all[^]
http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/[^]

Still didn't find your solution? you can Google it and you will get a lot more.

BTW, please try not to post your database question in asp.net forum. We have separate database forum also.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Searching in database

Krunal Berawala9-Mar-10 17:14

Krunal Berawala

9-Mar-10 17:14

i tried that now.............it worked.

bt does it affect the performance of the server.......???

Re: Searching in database

Anurag Gandhi9-Mar-10 21:08

Anurag Gandhi

9-Mar-10 21:08

Full Text search gives you better performance compared to the conventional query using "like".
Read those articles completely for details.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Searching in database

Krunal Berawala10-Mar-10 13:10

Krunal Berawala

10-Mar-10 13:10

The actual application is very big.
This searching requirement is actual a small part of it.
I saw that it slows down other parts of the application.

Wht do u say ???

Re: Searching in database

Anurag Gandhi10-Mar-10 15:47

Anurag Gandhi

10-Mar-10 15:47

Well, It would be difficult to guess why your application got slower and how much and why your full text search is affecting your other part of the application without seeing your application design/architecture.

I would suggest try to explore the reason why it slows down the application instead of simply guessing something. Your guess may or may not be correct.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Searching in database

Vimalsoft(Pty) Ltd9-Mar-10 19:51

Vimalsoft(Pty) Ltd

9-Mar-10 19:51

want something like this

Coding an N-Tier Application in C# Without Any Wizard: Part II[^]

?

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Response.Redirect corrupting redirect URL

redfish349-Mar-10 11:30

redfish34

9-Mar-10 11:30

I am trying to Response.Redirect to another web application but ASP.NET keeps corrupting the URL. Example, if i am at "http://localhost/application1/main.aspx" and i do redirect to "http://localhost/application2/default.aspx" the redirected url will become "http://localhost/http://localhost/application2/default.aspx". It is as if ASP.NET is guessing that i am redirecting using partial URL, but i am not. How does one fix this?

Re: Response.Redirect corrupting redirect URL

Not Active9-Mar-10 11:47

Not Active

9-Mar-10 11:47

redfish34 wrote:
ASP.NET keeps corrupting the URL

ASP.NET is not corrupting it, you are just not using the tools correctly. How are you making the redirect call?

I know the language. I've read a book. - _Madmatt

Re: Response.Redirect corrupting redirect URL

redfish3410-Mar-10 9:03

redfish34

10-Mar-10 9:03

In the click event of a form button i have VB "Response.Redirect(url string)" It is really quite simple. The string i pass is what i described in my initial posting, it is a complete "http://" string. It appears that ASP.NET and/or the IIS server is disregarding the "http://" part and assuming that i am making a relative reference and so adds the redirect url to the server root url, as i describe in my initial post. I tried doing workaround by calling a html web form and use javascript to automatically submit it and the form submit creates the same url corruption. Funny thing about this, this redirect url corruption only occurs when calling different web applications that are in the same domain, such as "http://server1/application1" and "http://server1/application2". If i call a web application on "http://server2/" instead of "http://server1/" i do not experience this. As i mentioned, the corruption does not occur all the time, but frequently enough to be a major issue. So far i have found no solution or workaround. I may have to contact Microsoft technical support on this one.

Re: Response.Redirect corrupting redirect URL

doudoufly9-Mar-10 15:36

doudoufly

9-Mar-10 15:36

If you wanna redirect to another web application url. you need add "http://" at the beginning.

Response.Redirect("http://localhost/application2/default.aspx");

Small part of web page...

igor.senych9-Mar-10 8:14

igor.senych

9-Mar-10 8:14

Hey guys,

I need to load only a small part of web page. Is it possible to do that using WebBrowser control?

Thanks.

Re: Small part of web page...

Not Active9-Mar-10 9:40

Not Active

9-Mar-10 9:40

Just to be clear you are talking about a Windows app loading a portion of a webpage correct? If so then you would need to get the portion of HTML you need and insert it into the WebBrowser control, you can't request a portion of a web page unless it is available from the content provider as such.

I know the language. I've read a book. - _Madmatt

Re: Small part of web page...

igor.senych9-Mar-10 10:20

igor.senych

9-Mar-10 10:20

Yes.

do you have any example which shows the next words - 'you would need to get the portion of HTML you need and insert it into the WebBrowser control'?

Thanks.

Re: Small part of web page...

Not Active9-Mar-10 11:43

Not Active

9-Mar-10 11:43

I'm sure there are better examples but these should give you and idea, Using XML, XSL, DHTML and Javascript in your Windows applications[^]
Screen Scraping with C# for ASP.NET[^]

I know the language. I've read a book. - _Madmatt

MaskedEditExtender and MaskedEditValidator

paper679-Mar-10 7:07

paper67

9-Mar-10 7:07

Hi,

I have the following code :

<form id="form1" runat="server">
    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" />
    <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:TextBox ID="TextBox1" runat="server" Width="70px" ValidationGroup="ValGrp"/>
            <asp:MaskedEditExtender ID="TextBox1MaskedEditExt" runat="server" TargetControlID="TextBox1"
                Mask="99/99/9999" MaskType="Date" UserDateFormat="DayMonthYear" />
            <asp:MaskedEditValidator ID="TextBox1MaskedEditVal" runat="server" ControlExtender="TextBox1MaskedEditExt"
                ControlToValidate="TextBox1" IsValidEmpty="False" EnableClientScript="False" ValidationGroup="ValGrp"
                EmptyValueMessage="*" InvalidValueMessage="dd/mm/jjjj" /><br />
            <asp:Button ID="SubmitButton" runat="server" Text="Submit" ValidationGroup="ValGrp" />
        </ContentTemplate>
    </asp:UpdatePanel>
</form>

TextBox1 is a required date field. On submitting the code throws me a client exception saying :

'className' is null or not an object

What is wrong here ?

Re: MaskedEditExtender and MaskedEditValidator

Sandeep Mewara9-Mar-10 9:14

Sandeep Mewara

9-Mar-10 9:14

Do you have any Javascript code too associated with the page?

'className' is a javascript attribute and the error sounds like client side.
Check if you have assigned/missed any css.

Ajax SlideShow Controller

Ersan Ercek9-Mar-10 2:27

Ersan Ercek

9-Mar-10 2:27

Dear All,

My slide show extender does not work automatically even though defined as follows:

<cc1:SlideShowExtender ID="SlideShowExtender1" runat="server"
BehaviorID="SSBehaviorID"
TargetControlID="img1"
SlideShowServiceMethod="GetSlides"
AutoPlay="true"
ImageDescriptionLabelID="lblDesc"
NextButtonID="btnNext"
PreviousButtonID="btnPrev"
PlayButtonID="btnPlay"
PlayButtonText="Play"
StopButtonText="Stop"
Loop="true" >
</cc1:SlideShowExtender>

should I check somewhere else..

please advice it is drawing me crazy...

Re: Ajax SlideShow Controller

Anurag Gandhi9-Mar-10 2:41

Anurag Gandhi

9-Mar-10 2:41

Ersan Ercek wrote:
SlideShowServiceMethod="GetSlides"
AutoPlay="true"
ImageDescriptionLabelID="lblDesc"
NextButtonID="btnNext"
PreviousButtonID="btnPrev"
PlayButtonID="btnPlay"

Please check whether you have created ServiceMethod named GetSlides properly. Moreover, pls check for other controls have created the same id as you have defined in properties: lblDesc, btnNext, btnPrev for their corresponding controls.

If you are still getting problem, you can download the Ajax Control Toolkit Sample Application and see the code sample how it is working.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Ajax SlideShow Controller

Ersan Ercek9-Mar-10 2:50

Ersan Ercek

9-Mar-10 2:50

Dear Anurag,

Thanks for the response..

I created the following method in aspx.cs file.. I did not get it is realition with asmx files.. Does it have anything to do with it?

[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static AjaxControlToolkit.Slide[] GetSlides()
{
AjaxControlToolkit.Slide[] imgSlide = new AjaxControlToolkit.Slide[4];

imgSlide[0] = new AjaxControlToolkit.Slide("images/1.jpg", "Autumn", "Autumn Leaves");
imgSlide[1] = new AjaxControlToolkit.Slide("images/2.jpg", "Creek", "Creek");
imgSlide[2] = new AjaxControlToolkit.Slide("images/3.jpg", "Landscape", "Landscape");
imgSlide[3] = new AjaxControlToolkit.Slide("images/4.jpg", "Dock", "Dock");

return (imgSlide);
}

It does not throw any exception. Why do you think it happens=

Re: Ajax SlideShow Controller

Ersan Ercek9-Mar-10 4:20

Ersan Ercek

9-Mar-10 4:20

Dear Anurag,

Well I tried a sample code, also it did not work..

do you think it could have something to do with my AjaxToolkit version?

Re: Ajax SlideShow Controller

Anurag Gandhi9-Mar-10 6:16

Anurag Gandhi

9-Mar-10 6:16

Do other controls of the sample code are working on your system? if not, then, you may try re-installing Ajax Toolkit.
If yes, Try to debug the code and find out what error it is throwing/ where it got struck.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

vertical-align problem

benams9-Mar-10 2:09

benams

9-Mar-10 2:09

I try to set a div's vertical-aligment to middle. like this:

but it doesn't work in any web browser and it seems like the vertical-alignment is still "top"

Re: vertical-align problem

Viral Upadhyay9-Mar-10 2:28

Viral Upadhyay

9-Mar-10 2:28

Hi,
Please explain little more, else no one can help,
It look like div width problem or other div not position problem.

Viral
My Site

Save Our Tigers

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 12:10

Refresh

ᐊ Prev 1...1050 1051 1052 105310541055 1056 1057 1058 1059 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.