how i can connect to remote sql server db

yoord · May 29th, 2004, 07:04 AM

Quote:

quote:Originally posted by Imar
You can't, really. ASP.NET pages will post back to themselves. The action attribute will always point to the current page, to enable the PostBack mechanism.

You can take a look here: http://www.codeproject.com/aspnet/CHtmlForm.asp and here: http://www.experts-exchange.com/Prog..._20966296.html for some ideas on how to work around it.

My suggestion is to try and use the PostBack mechanism, instead of posting to another page. You'll avoid a lot of problems....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hi thanx to u and Other thing is it how i can setup a counter in a page using ASP.NET Application Object And Session Object

Imar · May 29th, 2004, 07:39 AM

I believe I already answered that one here: http://p2p.wrox.com/topic.asp?TOPIC_ID=14152

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hal Levy · June 1st, 2004, 11:51 AM

Imar, Cam you write a program for me?

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Imar · June 1st, 2004, 12:30 PM

Sure, no problem. Send me the details and I'll do it for you.... ;)

It never stops to amaze me that people can't read or are willing to do some investigations themselves. I try to get them on track by giving them directions, rather than ready-made solutions, but sometimes it just doesn't come through..... :-(

Imar

yoord · June 11th, 2004, 02:31 AM

Any One Help Me About How I can Use N' Switch In DotNet Or ADO.NET And In Parameterized Manner How I Can Do It .
I Am Using Like This But It Cause An Error In ADO.NET
strSql="select * from member_info where username=N'@username and password=N'@password";
How I Can DO It.
Regards Yoord

melvik · June 13th, 2004, 02:38 AM

if u use [u]VS.NET Visual mode </u>when u set ur CommandText to:

Code:

select * from member_info where username=@username and password=@password

It will create ur Paramaeters & U'll only need to set them.
but if u dont use [u]VS.NET Visual mode</u> u just set ur test to:

Code:

select * from member_info where username=@username and password=@password

Again & set ur Parameters urself.

HTH.

Always:),
Hovik Melkomian.

yoord · June 16th, 2004, 01:40 AM

Quote:

quote:Originally posted by melvik
if u use [u]VS.NET Visual mode </u>when u set ur CommandText to:

Code:

select * from member_info where username=@username and password=@password

It will create ur Paramaeters & U'll only need to set them.
but if u dont use [u]VS.NET Visual mode</u> u just set ur test to:

Code:

select * from member_info where username=@username and password=@password

Again & set ur Parameters urself.

HTH.

Always:),
Hovik Melkomian.

Thanx 2 Hovik And Other It help me very much .