ASP.NET

Arindam Tewary17-Apr-09 2:37

Arindam Tewary

17-Apr-09 2:37

Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.

Thanks,
Arindam D Tewary

sasan5617-Apr-09 2:47

sasan56

17-Apr-09 2:47

In ASPSpider.com (Free Learning & Training Hosting)you can add only SQL Express database and in the guide, tell you that chang your connectionstring to this :

"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName"

i change my connectionstring to above format, but it don't work yet!

Arindam Tewary17-Apr-09 3:04

Arindam Tewary

17-Apr-09 3:04

I am sure that they have advised that considering that indevidual would be working ( rather practising ) in their local system when you have SQL Express and application(which is accessed) is in the same COMPUTER.

But if you have your code(application) which you try to see using HTTP , then you have to go for SQL Server authentication unless you have the ACCESS TO DATABASE AND YOU CAN CONFIGURE THE SAME DATABASE TO ALLOW WINDOWS AUTHETICATION FOR DEPLOYED APPLICATION.

BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.

Thanks,
Arindam D Tewary

Abhijit Jana17-Apr-09 3:24

17-Apr-09 3:24

Arindam Tewary wrote:
BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.

Arindam, I don't understand why it will not work. If you have the access right to that database then what would be the problem ?

cheers,
Abhijit
CodeProject MVP

Arindam Tewary17-Apr-09 3:45

Arindam Tewary

17-Apr-09 3:45

Abhijit,

I just told that IN MOST CASES, but NOT for ALL CASES, and that I have seen from my experience. But surley I will try to find out some more of windows authentication in deployed server and that will help me getting much fair idea as well.

Windows Authentication is also possible. Why not? Big Grin | :-D

Thanks,
Arindam D Tewary

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay17-Apr-09 5:24

Colin Angus Mackay

17-Apr-09 5:24

Arindam Tewary wrote:
IN MOST CASES, but NOT for ALL CASES

Stop shouting. It is rude.

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay17-Apr-09 3:00

Colin Angus Mackay

17-Apr-09 3:00

Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.

That is utter tripe! That statement tells me that you have little idea of how it works rather than it being a deficiency on the part of SQL Server.

Abhijit Jana17-Apr-09 3:03

17-Apr-09 3:03

Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment.

Why ?

cheers,
Abhijit
CodeProject MVP

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay17-Apr-09 3:06

Colin Angus Mackay

17-Apr-09 3:06

sasan56 wrote:
the project on my local system work as well.

This is because in your local environment you were using a different windows account to the one being used in the hosted environment.

When an ASP.NET application is run inside IIS it will use the ASPNET user (typically) and that user is the one used to connect to the database.

In your local environment you probably used Visual Studio's built in web server which would use your own personal credentials to authenticate against the database.

You have to modify the database to permit logon from the user that the ASP.NET application is connecting as.

Ashfield17-Apr-09 9:04

Ashfield

17-Apr-09 9:04

Of course it didn't. You have to be in a trusted domain for it to work, thats why its called WINDOWS AUTHENTICATION

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

how to display date in gridview header

Dev S17-Apr-09 4:01

Dev S

17-Apr-09 4:01

write conn. string like this :
<pre> <add name="sasannaderi_maskan" connectionString="Data Source=.\SQLExpress;Initial Catalog=sasannaderi_maskan"
providerName="System.Data.SqlClient" />

may be this work for you.
But when u upload it on server a proper data source is required. As "." is ok for local but i dont think for server.

rahul.net1117-Apr-09 0:15

rahul.net11

17-Apr-09 0:15

Hello All,
I want to display dates in gridview header for eg:
If the week start on 12 (Sunday) then i want to display all the week dates in its header as follows.

S(12) M(13) T(14) W(15) T(16) F(17) S18

how can i do this?

Thanks
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Re: how to display date in gridview header

Ashfield17-Apr-09 2:04

Ashfield

17-Apr-09 2:04

I can't see what your problem is, if you have a start date to use then just add 1 to it to get the next date - simple with the datetime class.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: how to display date in gridview header

wasifahmad17-Apr-09 3:36

wasifahmad

17-Apr-09 3:36

If you have a data table and you are binding your grid with datatable then gridview header caption will be made by datatable.Columns(0).ColumnName property. Whatever you will assign in ColumnName property of column will become grid view header caption.

Let me know this solves your issue or not?

Regards,
Wasif Ahmad

difference between DataReader and DataAdapter??

Pradeep Shet16-Apr-09 23:28

Pradeep Shet

16-Apr-09 23:28

what is the major difference between DataReader and DataAdapter??

Re: difference between DataReader and DataAdapter??

Abhijit Jana16-Apr-09 23:33

Re: adobe flex in asp.net

16-Apr-09 23:33

pradeep.shet wrote:
what is the major difference between DataReader and DataAdapter??

DataReader Vs DataAdapter

cheers,
Abhijit
CodeProject MVP

Message Removed

16-Apr-09 23:26

gunasundari

16-Apr-09 23:26

Message Removed

Abhijit Jana16-Apr-09 23:35

How to customize t Shirt..

16-Apr-09 23:35

gunasundari wrote:
How to integrate the adobe flex file in asp.net web application?

Did you gone through the Flex Online help. That is one if the based resource from where you can learn.

cheers,
Abhijit
CodeProject MVP

KiranKumar Roy16-Apr-09 23:03

KiranKumar Roy

16-Apr-09 23:03

i want to customize t shirt with asp.net.

please refer blow site and please give me some idea how it is possible with the asp.net.

http://en.tailor4less.com/tailormade/shirts/configure[^]

Kindly Check it and give me right way to do this..

thanks in advance.

KIRANKUMAR ROY
http://www.misc-story.blogspot.com

Abhijit Jana16-Apr-09 23:26

16-Apr-09 23:26

KiranKumar Roy wrote:
i want to customize t shirt with asp.net.

I didn't get you!

cheers,
Abhijit
CodeProject MVP

KiranKumar Roy17-Apr-09 1:40

KiranKumar Roy

17-Apr-09 1:40

have you visited site which i have given on my post...
it will explain you all the things....
I need a site which dynamically generate image of T shirts in which i can
select the t shirt color, T shirt size text on the T Shirt...
Kindly visit the below site..

http://en.tailor4less.com/tailormade/shirts/configure[^]

Thans for you reply..

KIRANKUMAR ROY
http://www.misc-story.blogspot.com

SeMartens17-Apr-09 1:38

SeMartens

17-Apr-09 1:38

Well write a webapp... You could use silverlight to make it look fency...

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

KiranKumar Roy17-Apr-09 1:44

KiranKumar Roy

17-Apr-09 1:44

can you give me some base from where i can start.
i dont have any idea.

KIRANKUMAR ROY
http://www.misc-story.blogspot.com

Ashfield17-Apr-09 2:06

Ashfield

17-Apr-09 2:06

Employ someone to do it. If you have no idea where to start then this sort of thing is going to be way out your league.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP