|
Oh.... see, not only was this entirely a SQL question ( did you post it there ? ), but you were not asking what I thought you were asking. I kept asking you how you called the proc, b/c I thought you wanted to know how to pass the parameter into the proc. Really, you wanted to know how to write a stored proc in the first place. This is where posting code really helps, if you'd done that in the first place, I'd have made sense of your question and answered it ( the way you pass params into a proc depends on how you're calling it in .NET code, that's why I kept asking that and not giving a full answer ).
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i am manually creating the record no in the table , database - sql-server
when i see those records in the crystal reports , it is comming in arbitrary order.
Is there any way to arrange the records in an order.All i want is that , can i use the order by clause in crystal reports.
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Thank You to all of u...
Problem is solved.
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
I want to avoid to page to get refreshed on click of F5,Is it possible and how?
Thanks..
|
|
|
|
|
Not possible. You are programming an engine to provide HTML to IE, you cannot stop IE from working.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I've downloaded some sample project and I found that contains code of how to implement adding items from design mode (CollectionBase).
I've started to implement that into my test project I was working on and created a property like.
public MenuItemCollection MenuItems
{
get { return items; }
}
When I go to design mode and add user control, in property grid, of that user control, I have MenuItems, but it doesn't open a dialog letting me to add the items. It acts like a string  .
To check whether I am crazy or not, I've added bool property to see will this work fine and display as a dropdown with true and false.
That did worked, so now I am puzzled. I've searched on the net with no luck.
I don't see any differences between that sample project and mine except that I use UserControl (partial class), but then again, why shouldn't properties work with partial classes as well (they worked with bool property) so now I am asking you for help.
Thanks.
|
|
|
|
|
Kasic Slobodan wrote: public MenuItemCollection MenuItems
{
get { return items; }
}
Looks like you are missing some attributes that has to be specified to add collection properties through property grid. I have an article which explains this. Have a look at here[^]
|
|
|
|
|
Your article helped.
Thank you.
|
|
|
|
|
Hi,
I am trying to save non-english text in my database, I tried using the ntext and nchar but none of them seems to be working..
Any ideas on how to do this
Thaaaaaaaanx
Mohammad
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
I think when you create a DB, you set up what character set it uses, then I'd expect nvarchar and nchar to work just fine.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
My db is an sql database created in the server explorer in VS 2005, I really didn't notice any charset settings, and now when I select database properties I still don't see any settings for character set.
Any idea on how to modify these settings?
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Mohammad A Gdeisat wrote: My db is an sql database
Of course it is. All DBs are SQL databases. Do you mean SQL Server ?
When I right click on a DB in SQL Server management studio, there's a property called 'collation' which looks to me like the char set to use.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yes, I meant SQL server DB.
I found the collation property in server explorer column properties, and it works just fine 
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
can any one let me how can i send mail through asp.net
|
|
|
|
|
|
w209 wrote: can any one let me how can i send mail through asp.net
You've asked the same question 3 times already in the forums.
What part of 'learn how to use Google' don't you understand?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I wrote this[^] article, just for people like you.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
C# and VB.NET are the same, just the syntax is different. There are online converters to help you, too.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Many thank for the lead. I will give this a try.
|
|
|
|
|
Yes this works fine - many thanks.
|
|
|
|
|
I've added Image control to ASP.NET web application project in C#. While clicking on some button I want the picture from hdd file to be displayed in it. Providing Image.ImageUrl = @"full hdd path\picture.jpg" doesnt seem to work at all. I do not want to copy the images to project folder either.
Also Image control provides only stretch mode. How to make it fit say 100x100 sized control so it keeps its aspect ratio?
chesnokov
|
|
|
|
|
Chesnokov Yuriy wrote: Image.ImageUrl = @"full hdd path\picture.jpg"
This won't work as it requires virtual path like (/images/someimage.jpg). Also it should be in the virtual directory where project is running.
Chesnokov Yuriy wrote: How to make it fit say 100x100 sized control so it keeps its aspect ratio?
It won't resize using aspect ratio. You need to create a Bitmap object with required width and height and draw the image to bitmap. Now send this to response, also set content type to image/jpg. I suggest using HTTPHandler for this.
|
|
|
|
|
How's that?
You can load bitmap from the hdd? can't you. For a dummy in ASP.NET how to show that Bitmap then with Image control or any other control on a page at specified location.
chesnokov
|
|
|
|
|
If you are going to use handler, just make the ImageUrl.Url = "imagehandler.ashx?url=the_image_path",
then in the handler :
load the bitmap as usual, and then use the context object as context.output.write(image as byte).
Otherwise you can simply use the Server class, I believe it has a method like PhysicalPath or something.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
