|
|
Hi Dear
I use VS 2005, in Gridview i have a column that in the Basic Table have a relationship to other Table. I want like a combobox, show another field to the user, not show the forign key.
How can i do that?
|
|
|
|
|
Hi,
Explain your problem in detail. As no one can make out what your problem is. Your foreign key issue you should handle from sql query.
I guess your solution is the "DataKeyNames" property of gridview.
|
|
|
|
|
Hi Dear
I use VS 2005. in a gridview i set one of numeric column DataFormat String to {0:N} and a number like 123456 at out put is like : 123,456,00
but i want to omit the decimal. like : 123,456
how can i do that?
|
|
|
|
|
I think DataFormatString="{0:###,###,###}" will work.
I didn't get any requirements for the signature
|
|
|
|
|
Thanks , it work correctly.
|
|
|
|
|
DataFormatString="{0:#,#}" is enough to make the trick hapen.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
I am developing a web application in which i have used a dropdown list on which update panel is applied ,and on list select event I'll set some cs file variable values that are not visible on my javascript function all though the values of cs variable getchanged is there any way to solve these problem ?
thanks
|
|
|
|
|
either you have no clue of what you doing or you did not explain your problem.
Abhishek Rana wrote: I am developing a web application in which i have used a dropdown list on which update panel is applied
So far so good
Abhishek Rana wrote: and on list select event I'll set some cs file variable values that are not visible on my javascript function
If all you want to do is handle the select changed event in javascript, why do you need updatepanel? Update panel is used/needed only if you have to process the event on the server, so you don't refresh the whole page.
Abhishek Rana wrote: on list select event I'll set some cs file variable values that are not visible on my javascript function all though the values of cs variable getchanged
No there is no way you can access the variables from javascript.
Abhishek Rana wrote: is there any way to solve these problem ?
Yes, Since you have update panel, forget about javascript and handle what ever you want on the server. Things will work for you magically.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Yusuf wrote: Abhishek Rana wrote:
is there any way to solve these problem ?
Yes, Since you have update panel, forget about javascript and handle what ever you want on the server. Things will work for you magically.
Funny.
But I agree with Yusuf. Unless you are writing a website that will be very high volume, it is always easist and cleanest to just write your code in C# and use the ajax panel. It is one thing if you are proficient with asp.net, html, javascirpt and it easy for you. But if you are not an expert, don't even bother trying to use a bunch of javascript. You will probably just shoot yourself in the foot.
I didn't get any requirements for the signature
|
|
|
|
|
Hi Dear
I registered as ASPSpider.com member. I uploaded my Database and ASP.NET 2005 files in my space, but when i connected to the address http://aspspider.info/sasannaderi/ (you can see it online) this error occured :
Keyword not supported: 'integrated security'.
My connectionStrings is this :
<connectionStrings>
<add name=sasannaderi_maskan Data
Source=.\SQLExpress;Persist Security Info=True;Integrated
Security=SSPI;Initial Catalog=sasannaderi_maskan
providerName=System.Data.SqlClient/>
</connectionStrings>
Can anyone help me to solve the problem?
|
|
|
|
|
Integrated Security=SSPI means using Windows Authentication. Does that give you a clue?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
I set it to True, but it don't work!
the project on my local system work as well.
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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? 
Thanks,
Arindam D Tewary
|
|
|
|
|
Arindam Tewary wrote: IN MOST CASES, but NOT for ALL CASES
Stop shouting. It is rude.
|
|
|
|
|
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.
|
|
|
|
|
Arindam Tewary wrote: Windows authetication works well in local environment. But not in deployed environment.
 Why ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
