Use the following query to give execute permission to the procedure GRANT EXECUTE TO SelectItem
GgAben
Posts
-
Error when using stored procedure in C#.net -
autorefreshIf you need just refresh the page, add
to the
part. If you need to postback the page use the java script timer.
-
run time controlsYou are creating controls dynamically. right? If so, you can do a postback using javascript. Use two hidden controls for storing qustion number and selected answer. Set these hidden variables before postbacking the page. Then you will get the values in the codebehind. add this to the selected answers hash table. Then use simple loop to compare both hash tables
Gg
-
Doubt on SerializationHi The real use of serialization is in object usages. For instance I have a object named Person. And i am keeping informations like name, address, salary etc as members of that object. Then if i need to persist it and later i need it in same form. Then we can use serialization to keep that object for future use.
Gg
-
Closing Pop Up.alert('saved'); window.close();
Gg
-
Postback problemIf you are using .net 1.1 use smart navigation by setting page argument smartnavigation to true. <%@Page language="c#" Codebehind="test.aspx.cs" AutoEventWireup="false" smartNavigation="True"%>
Gg
-
Accessing my ASP pages from other PC1. Install IIS 2. Create a virtual directory in the iis websites/default websites and it should point to your home page directory. Keep your home page name as default.html or index.html. Eg:- MyHome 3. Desable firewalls if any. 4. Use http:///MyHome from remote machine
Gg
-
run time controlsYou can use two Hashtable instead of arraylist. And it is good to use question number as key for both hashtables. Then you can easily find answer of each question by the question number.
Gg
-
minor math questionUse random numbers Dim rnd As Random s = rnd.Next()
Gg
-
Search By DateHi I think the date field of the DB is date type. And the date in view state may be string type. Please make sure both are date type. If both are string type it will not return correct result, because it is using string sort not the date sort.
Gg
-
UserControl and data from Default.aspx ?If you are using small amount of data it will not affect performance. But it will be a performance hit if there is a large amount of data, because session uses application memory area. Please read the following articles. Then decide which you can use. http://msdn2.microsoft.com/en-us/library/87069683.aspx[^] http://aspnet.4guysfromrolla.com/articles/100902-1.aspx[^] http://ggaben-developer.blogspot.com/[^]
Gg
-
Scheduling the application.Use timer System.Timers.Timer()
Gg
-
UserControl and data from Default.aspx ?1. You can add a public property and initialize it from the page initialize method. If you are using property then you can assingn value through html code in the aspx page or dynamically pass value throgh code behind 2. You can use session, application etc.. variables for passing data.
Gg
-
Event and Functionsprivate sub Form_Load(byval sender as system.Object,byval e as System.Eventargs)handes MyBase.Load End sub
This Form_Load is a event handler for Load event. That means when the page load event fires this handler will be invoked. Then, then function
private function abc()as string end function
This is need to call as abc() for executing.
Gg
-
Compression switchesSorry for posting here. I could not find details from winzip/winrar sites. And I am deleloping a web pages that has capability to compress files. And I am using .NET for this. And I hoped if someone may did this. That's why I posted here and I got the result. Thank you
Gg
-
Compression switchesThank you Dave I got the details by hitting F1.
Gg
-
Compression switchesHi I am developing a web page that has a functionality to zip and upload. For this i am using winzip and winrar. I need all the commands and switches used in the command line for Winzip and Winrar. For example: Winzip.exe a -ep1 -r myfile.txt myzip.zip I need what is the use of each switch like -a, -ep1, -r. Is there any good link for this? Gg
Gg
-
WInzip and Winrar commands and switchesHi I need all the commands and switches used in the command line for Winzip and Winrar. For example: Winzip.exe a -ep1 -r myfile.txt myzip.zip I need what is the use of each switch like -a, -ep1, -r.
Gg
-
URL in actionHi You can keep any one file with file name from default.htm,default.html,index.html,or home.htm. Then you can keep this file as home page or can redirect to the home page. Working: The IIS will search for the default file if we didn't specify the exact file name. We can set the order of search for the default file in the IIS.
Gg
-
Asp page submit errorHi Thank you for your response. I solved that problem by setting the Smart navigate property to false.
Gg