|
hi friends,
I have a sp for delete like this
ALTER procedure [dbo].[pr_DeleteCampus]
(
@campuscode smallint
)
as
delete from campus
where campuscode = @campuscode
but when i pass the parameter in the method and do NUit test like this
public void deletecampus(int campuscode)
{
campuscode = 7;
Assert.That(7, Is.Not.EqualTo(campuscode));
}
It throws an error
Sql Error Exception:Exception Procedure or Function sp_name expects parameter '@campuscode',which was not supplied.
|
|
|
|
|
This code doesn't call the proc, so a piece is missing.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
I have a dll which calls the procedure. The same method works for select stored procedure option.
|
|
|
|
|
Hello,
I'm doing bit of fire fighting here on an old piece of code written by someone else. Its an application in Arabic.
In the application currency is formatted using VisualBasic functions and string formatting. Example:
FormatCurrency(amount, 3)
This is how currency is displayed now: 123،34.342 ر.ع
But they want it to displayed with different group separator and decimal separator, like 123,34/342 ر.ع
I have created a function like this:
Private Sub SetCulture(ByVal culture As String, ByVal useUserOverride As Boolean)
Dim cultureToUse As New System.Globalization.CultureInfo(culture, useUserOverride)
cultureToUse.NumberFormat.CurrencyDecimalDigits = 3
cultureToUse.NumberFormat.CurrencyDecimalSeparator = "/"
cultureToUse.NumberFormat.CurrencyGroupSeparator = ","
cultureToUse.NumberFormat.CurrencySymbol = "ر.ع."
Threading.Thread.CurrentThread.CurrentUICulture = cultureToUse
Threading.Thread.CurrentThread.CurrentCulture = cultureToUse
End Sub
I call this function like
Me.SetCulture("ar-OM", False)
But Currency group separator is still the old one. The regional settings of server where I'm testing this app is set to English. I tried with English and Arabic(Oman) in my local PC regional settings, currency is displayed the way I want only if I set English settings. But here in Oman, people mostly set their Windows for Arabic language. Could someone point out what I'm doing wrong here?
Regards,
Blumen
|
|
|
|
|
hi
how can i use onmouseover i want to show large image size. my image is filled from database and show in grid view. and how i apply this javascript. 
I will do my best?
|
|
|
|
|
The javascript needs to change the size of the image tag, so the image grows.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Many many thanks Mr. Christian Graus.
I will do my best?
|
|
|
|
|
for shoppigcart I use session or cache?whitch on is better?why?
(a customer select the item and can go to shoppingcart page and edit the order and then when the customer click the save button ,orders save in database.)
|
|
|
|
|
Session or cache ? It shows you have no idea about what it is. Please purchase a book and learn ASP.NET.
Session : Specific to user
Cache : Available to all users
|
|
|
|
|
In this case you have to use session, because Session is based on user. where cache is common for all user.
you can use Cache where data for all user same.
cheers,
Abhijit
|
|
|
|
|
A more reliable implementation would be to have a temporary orders table you can save selections to this table up until the "check out" procedure.
A vistior comes, you check for a cookie (shopper=1234), if they have the cookie you can query the temp table for previous orders, if they don't have the cookie, tag them with one.
Any selection is saved to the temp table using the shopper id from the cookie. Once at check out, their cart would have items from the temp table, push these items to the real store/basket table. Once the order has been processed - do whatever.. removing the entries from the temp table. Once a month, once a week or every 24 hours, purge the temporary table to relieve bloating.
Something like that should work and it would be more reliable. Relying on session or cache is never a good idea - both can expire unexpectedly.
|
|
|
|
|
Hi,
lets say i have a datatable with a column called images.
and in the images column i have images/image1.png,images/image2.png,images/image3.png
Now how can i make the column it is bound to display all 3 images?
Thank you ahead of time.
|
|
|
|
|
Make images column as a template column. Put image tag and set "src" to the value from data source.
|
|
|
|
|
Can you please give me a sample of that you wrote? What do you mean make images column as a template? i don't think i know how to make it a template column.
|
|
|
|
|
Hi
You can add more than one image control in your image template column and put image url what you want to display.
Thanks and Regards
Rasma 
www.rasma.dom.ir
|
|
|
|
|
Is there a way to make an item in a dropdown list to be unselectable. What it means is that, it will show up in the dropdown however when users try to select it it will not be the selected item.
thanks.
|
|
|
|
|
try to make Enable = false
|
|
|
|
|
Maybe I donot know what you say.
Another way
1. change the Auto postback = true
2. add code DropDownList1_SelectedIndexChanged even
DropDownList1.Items.Add("a"); // a is the value of default.
DropDownList1.Items[this.DropDownList1.Items.Count - 1].Value = "";
DropDownList1.SelectedIndex = this.DropDownList1.Items.Count - 1;
|
|
|
|
|
Thank you for your response.
I think may be I have not explained what I really want to happen. Below is the senario.
The dropdown is populated during the page load with list items from a database. What I want is, for users not to be able select a specific item from the dropdown list. For instance let us say, the dropdwon contains, "apple, orange, peach" as its list items. I do not want the peach to be an item that can be selected by a user eventhough it is shown as an item in the dropdown.
Thanks for your help.
|
|
|
|
|
Ginbot7 wrote: I do not want the peach to be an item that can be selected by a user eventhough it is shown as an item in the dropdown.
If you don't want users to select it, why to show it there ? You can set "AutopostBack=true" for the drop down, handle selected index changed event, check selected item is the one which you need to prevent and show necessary messages.
|
|
|
|
|
You are absolutely right. In normal situations, no need to show it if it is not to be selected. However in our situation we want the item to be selected through code depending on another control result but should be non selecteble by the user.
e.g.
public void txtdate_textChanged(Object sender, Args e)
{
ddlfruits.selecteditem.text = "Peach";
}
|
|
|
|
|
Well, If you know the index of Peach, just set the SelectedIndex property.
ddlfruits.SelectedIndex = PeachIndex If not, iterate through each item, check the text is Peach, if yes make it selected.
ddlfruits.SelectedIndex = -1;
foreach (ListItem item in ddlfruits.Items)
{
if (item.Text == "Peach")
item.Selected = true;
}
|
|
|
|
|
|
|
Do they have examples ? Do they have forums ? There's a small number of peopel who are very active in this forum, and how do you know any of us even use this library ?
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
