ASP.NET

4-Jul-07 3:17

I do recommend using the Parameter route. They help prevent SQL Injection Attacks.

Have you tried writing the same query and running directly on SQL Server? Do you get any results?

I'm actually thinking that since you are only ever getting one value back (the roles) that ExecuteScalar would be better for your requirements (unless you are planning to get more data from the reader in the future)

ExecuteScalar retrieves one value only, the fist column of the first row. It will manage the data reader for you, so you don't have to worry about it. All you need to do is call ExecuteScalar instead of ExecuteReader and if the value isn't null you have matched the login.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

I give up!

Colin Angus Mackay4-Jul-07 3:11

4-Jul-07 3:11

Some people are just a bunch of ungrateful pricks! I did my best to answer the OP here by suggesting various things to look at for a problem that is not immediately apparent. But someone thought it was worthy of a 1-vote.

Sigh | :sigh:

I think I'll concentrate on writing articles and organising events instead of trying to help out here.

Pete O'Hanlon4-Jul-07 3:16

4-Jul-07 3:16

Don't give up - I've 5 voted it to raise it up. I guess this was the same idiot who 1 voted an answer I gave earlier.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Colin Angus Mackay4-Jul-07 3:25

4-Jul-07 3:25

Pete O`Hanlon wrote:
Don't give up

Thanks - I'll try not to give up completely but I've noticed that I'm responding less and less these days. I'm concentrating on presentations, articles and events more and more. That is much more rewarding.

Are you any good at presenting? Would you like to do a presentation in Glasgow sometime?

Pete O'Hanlon4-Jul-07 3:38

4-Jul-07 3:38

It's been a while since I did any presentation type of work, apart from sales pitches. Now, if it's to come back up to Glasgow sometime, then I might just be persuaded. Big Grin | :-D

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Pete O'Hanlon4-Jul-07 3:54

4-Jul-07 3:54

I think I've figured it out - somebody's after your MVP status. You do seem to be the target of scattergun 1 voting.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Colin Angus Mackay4-Jul-07 4:15

4-Jul-07 4:15

Pete O`Hanlon wrote:
I think I've figured it out - somebody's after your MVP status. You do seem to be the target of scattergun 1 voting.

Gosh! That's a bit sad isn't it.

Pete O'Hanlon4-Jul-07 5:02

highlighting search terms

4-Jul-07 5:02

Yup. Mind you, there are people who'll create two accounts just to vote themselves up.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

marky7773-Jul-07 23:44

marky777

3-Jul-07 23:44

Hi.

You guys know the type of functionality in CP where if you search for things in articles you can specify if you want the search terms to be highlighted in the results, right?

Does anyone know of an article or source code that does something like that?
I need to get it working in my project.

Thanks alot!
M

Re: highlighting search terms

Pete O'Hanlon3-Jul-07 23:47

Re: highlighting search terms

3-Jul-07 23:47

One way to do this would be to have a javascript function which would read the page and wrap the relevant text in spans (set the style of the span to have a background colour).

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Pete O'Hanlon3-Jul-07 23:57

Re: highlighting search terms

3-Jul-07 23:57

OK - I've had a quick look round and found this example:

http://www.nsftools.com/misc/SearchAndHighlight.htm[^]

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

marky7774-Jul-07 0:10

marky777

4-Jul-07 0:10

Than you.
I was searching around on the web as well, but probably not as efficiently as you were...;)

Gridview - dynamically added checkbox fields are Disabled

Mohamed El Gohary3-Jul-07 23:39

Mohamed El Gohary

3-Jul-07 23:39

I am using a Gridview and I added to it a checkbox field that is dynamically bound to a bolean value, the thing is that the checkboxes are always disabled and I can't change there status at all. Is there any help with this?

Mohamed El Gohary

Binding Radio Button Control in GridView

Ajeet mittal3-Jul-07 23:36

Ajeet mittal

3-Jul-07 23:36

I have to Bind RadioButton control with a field in database.
as in this field i have two values like completed and notcompleted.
i have show checked radiobutton when it is completed with every row.
can any one tell me how can i do it.
ajeet

'Sys' is undefined

Abubakarsb3-Jul-07 23:23

3-Jul-07 23:23

Hi Friends!

I developed a website in asp.net using c#, I created a master page and using it in all other pages. I also have some javascript functions in content page but there is no AJAX control or any kind of control related to AJAX. But someimes, specially when I send user to 'Home' page from another page then I get this stupid javascript error 'Sys is undefined' but when I refresh the page then there is no error. If anyone of you knows about it please tell me how can I fix it?

Waiting for your reply,

Kind Regards,
Abubakar

Urs Enzler3-Jul-07 23:35

Urs Enzler

3-Jul-07 23:35

Sys is defined in the Microsoft AJAX Library, therefore I assume that there has to be any kind of a AJAX control on your site or at least some JavaScript that references Sys.

I suggest that you take Firefox with the Web Developer Add-on and when you encounter the error then have a look a all JavaScript that is loaded for the page and look for the reference to Sys. Maybe this way you can find the reason.

-^-^-^-^-^-
no risk no funk

Abubakarsb3-Jul-07 23:41

3-Jul-07 23:41

Ya Enzler, You are right, I just remember that as we are calling a webservice in javascript so we are using 'Sys' in a .js file. Here is the code which we are using for that;

PPMService.registerClass('PPMService',Sys.Net.WebServiceProxy);

Will u please tell me what should I do? I have noticed one thing more that if ur page remains untouch for some time then it also gives same error. Plz suggest a solution.

Regards,
Abubakar

Urs Enzler4-Jul-07 0:19

Urs Enzler

4-Jul-07 0:19

A simple solution - but not necessarily the right one - is to add a ScriptManager (from ASP.NET AJAX) to the master page. Then the needed js files are registered on the client.

-^-^-^-^-^-
no risk no funk

Abubakarsb4-Jul-07 0:28

4-Jul-07 0:28

The problem is I am relatively new here in asp.net 2.0 and I didn't develop project, I am just fixing bugs. I have found this in masterpage;

<asp:scriptmanager id="ScriptManager1" runat="server">

but I could not find definiation of 'ScriptManager1'. Will u please tell me how can I add a ScriptManager in masterpage?

Urs Enzler4-Jul-07 0:33

Urs Enzler

4-Jul-07 0:33

Ask someone of your development team or look at http://ajax.asp.net.

Basically drag and drop the ScriptManager from the Toolbar onto the design view of the Master page.

-^-^-^-^-^-
no risk no funk

Abubakarsb4-Jul-07 1:49