ASP.NET

FirstPrevNext

Modules in ASP.NET pages Quecumber25627-Dec-06 5:20 Quecumber256 27-Dec-06 5:20  Is this possible in ASP.NET in Visual Studio 2005. I want to create a web site that contains about 4 pages. The data for each page is stored on a SQL Server 2005 database. The ConnectionString is always the same, but the SelectCommand will differ depending on that page's function. Can't I place these instructions into a global module on the web site and have them called when needed? If this is possible, how do I create a VB module on the web site? Thank you, Quecumber256 Re: Modules in ASP.NET pages Venkatesh Mookkan27-Dec-06 15:43 Venkatesh Mookkan 27-Dec-06 15:43  Hey Quecumber256, VB modules are not recommended in .NET world. But you can still create a module of your own. Just click Add New Item and add a class file. Then clear the file and add Public Module MODULENAME End MODULENAME Don't try to change the extension. The file extension should be .vb only. Another solution: If you are going to store only the ConnectionString info then use Web.Config file which is recommended by .NET. If you want to remember any objects try Sessions. Have a nice day man... Regards, Venkatesh Mookkan. Software Engineer Re: Modules in ASP.NET pages ednrgc28-Dec-06 8:54 ednrgc 28-Dec-06 8:54  You can place the connection string (and others) in the web.config Re: Modules in ASP.NET pages Vikram kshatriya28-Dec-06 18:44 Vikram kshatriya 28-Dec-06 18:44  Hi , Store the ConnectionString in web.Config's AppSetting .Add a new class(note this is not amodule) and write your functions to retrieve the data from database .IN code behind page , call the methods from the class to display the records into page. Vicky Already open Error Sarguna Reddiar27-Dec-06 2:16 Sarguna Reddiar 27-Dec-06 2:16  Sir Please consider my error when it becomes while I click an button.so please tell what are the solutions to claer it..The following errors are: --------------------- Line 839:sub page_load(s as object,e as eventargs) Line 840:con=new oledbconnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("db1.mdb") & ";") Line 841:con.open() Line 842:cmd=new oledbcommand("select * from Table1",con) Line 843:dr=cmd.executereader() Source File: c:\inetpub\wwwroot\project\account1.aspx Line: 841 Stack Trace: [OleDbException (0x80004005): Could not use ''; file already in use.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) System.Data.OleDb.OleDbConnection.InitializeProvider() System.Data.OleDb.OleDbConnection.Open() ASP.account1_aspx.page_load(Object s, EventArgs e) in c:\inetpub\wwwroot\project\account1.aspx:841 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() sargunam Re: Already open Error Arindam Tewary27-Dec-06 4:01 Arindam Tewary 27-Dec-06 4:01  You forgot to close the connection that has been opend already. Whenever to use reader object it must be closed using connection object's close() method. So what you need to do ... add the line " con.close() " and execute it. Hope you can solve it now. Arindam Re: Already open Error Sarguna Reddiar27-Dec-06 18:40 Sarguna Reddiar 27-Dec-06 18:40  Sir, Thank u for ur reply...but it makes an error when I already gave correctly con.close() method.but the db1.mdb has same name which stored in another path.. Is there way to come an error...please review my error Re: Already open Error Venkatesh Mookkan27-Dec-06 15:38 Venkatesh Mookkan 27-Dec-06 15:38  There is another way which produce this error. If you have been kept your mdb file open. (ie) You have been opened the db1.mdb in Access or equivalent application. Close that application before you open the connection. Regards, Venkatesh Mookkan. Software Engineer Re: Already open Error Sarguna Reddiar27-Dec-06 18:41 Sarguna Reddiar 27-Dec-06 18:41  Thank u for ur reply...but it makes an error when I already gave correctly con.close() method.but the db1.mdb has same name which stored in another path.. Is there way to come an error...please review my error Re: Already open Error Venkatesh Mookkan27-Dec-06 19:23 Venkatesh Mookkan 27-Dec-06 19:23  Could you debug and tell me what are you getting in, Server.Mappath("db1.mdb") Check the path with your location.... Regards, Venkatesh Mookkan. Software Engineer Re: Already open Error Sarguna Reddiar28-Dec-06 2:46 Sarguna Reddiar 28-Dec-06 2:46  Sir, In my project contains two Forms.Form 1(namely Login page) and Form 2(namely account page).Form2 contains two buttons, we click an 1st button another page will open if button1 as set as start page.probably it would work directly click an form 2.But if we enter through an form1 to form2 then click button1 it forms an error like .. File Already open in open() so what can i do Re: Already open Error [modified] Venkatesh Mookkan28-Dec-06 15:58 Venkatesh Mookkan 28-Dec-06 15:58  I think this might help... Check your permission level of that directory... Cause This error usually happens on Windows NT, Windows 2000 or Windows XP and may be caused by any of the following conditions: - the database file or database folder doesn’t have necessary security permissions to write to, or erase an .ldb file created by Microsoft Access when opening the database - the database file doesn't have sufficient security permissions or write permissions to be modified when updating data in it. The web browser is seen by the web server as a Internet User that has the server account IUSR. This user needs to have write permission to the database file and to the database folder. Resolution Follow these steps to resolve this issue: 1. Use Windows Explorer to find the folder on the disk, which contains the database file (.mdb). This is usually your project folder. 2. Right-click on the project folder and select Properties. 3. Uncheck the Read-only property. 4. Click on the Security tab in the properties window. (Attention: If you don't see such tab (Windows XP), close the properties window, open any folder, select Tools -> Folder Options -> View, and uncheck the option Use simple file sharing.) 5. Click Add and find, then select the user IUSR_<COMPUTERNAME>. 6. Select the Write checkbox in the Allow; column to assign Write permissions to the IUSR account. More Info After being fixed, this error may reoccur when compacting the MS Access file since the database file being compacted is being erased and a new one is created in its place. Source: Click here[^] -- modified at 1:37 Friday 29th December, 2006 Regards, Venkatesh Mookkan. Software Engineer, India Already open Error indian14327-Dec-06 20:01 indian143 27-Dec-06 20:01  One advise if you dont mind, whenever you are opening a connection check whether its closed or opened. like as follows if con.state=connectionstate.close con.open(); Remember always follow this and follow the above also. S/W Engineer Akebono Soft Technologies aleem_abdul@akebonosoft.com. Can I delete all the elements at once from a .net server drop down list indian14327-Dec-06 1:48 indian143 27-Dec-06 1:48  Can I delete all the elements at once from a .net server drop down list control by using Javascript function. Or atleast show me how can I find the count of items in a .net server side drop down list box by using Javascript function. So that I can use <ddlname>.remove(<index>). But show me atleast any one thing, please. Thank you very much. S/W Engineer Akebono Soft Technologies aleem_abdul@akebonosoft.com. Re: Can I delete all the elements at once from a .net server drop down list Venkatesh Mookkan27-Dec-06 15:33 Venkatesh Mookkan 27-Dec-06 15:33  Hey man use, document.getElementById('CONTROLNAME').length=0; This will remove all the elements from the DropDownList box. This code works fine in IE and Mozilla's latest version. Regards, Venkatesh Mookkan. Software Engineer Re: Can I delete all the elements at once from a .net server drop down list indian14327-Dec-06 20:48 indian143 27-Dec-06 20:48  Yes its working nice. Thanks dear. S/W Engineer Akebono Soft Technologies aleem_abdul@akebonosoft.com. Re: Can I delete all the elements at once from a .net server drop down list Venkatesh Mookkan27-Dec-06 20:51 Venkatesh Mookkan 27-Dec-06 20:51  You are most welcome man.... Regards, Venkatesh Mookkan. Software Engineer, India post data programatically subai27-Dec-06 1:14 subai 27-Dec-06 1:14  hi everybody and merry xmas I am developing a C# library that should send(POST) some data to special page and at the same time redirect to it. i tried to get httpcontext from caller page and initialized the request.Form with my data and then using response.redirect redirected to page but an error message tell me that request.Form is readOnly and can not be assigned. do anybody know how i can POST data and redirect in my Library(NOT Aspx page) ? I Wish the Life Had CTRL-Z Re: post data programatically subai27-Dec-06 2:04 subai 27-Dec-06 2:04  i solved the problem by creating a method that return a proper auto submit FORM with hidden fields containing my data then response.write the result into empty page it's not good but just works I Wish the Life Had CTRL-Z RegularExpression validator....... Nagraj Naik27-Dec-06 1:01 Nagraj Naik 27-Dec-06 1:01  Hi all, I want to write RegularExpression for accepting 1)only integer values 2)value should not be null. For only integer I create RE but second condition is not satisfy. Can anybody knows solution............plz share with me. Regards, Nagraj Re: RegularExpression validator....... Manuel F. Hernandez27-Dec-06 11:53 Manuel F. Hernandez 27-Dec-06 11:53  Null might be tricky. regular expressions are concerned with whether characters exist or not. If you search "" with a regex of [0-9]+ (at least one numeric) you will get a false. But .net does not interpret "" as null. It defines "" as String.empty. Does that help? Password 4 a word document BINOVAR27-Dec-06 1:00 BINOVAR 27-Dec-06 1:00  hi Can anyone tell me how to set password 4 a exisiting word document thru code.. The exact requirement is , I am giving the customer a WORD DOCUMENT with some info abt the product,but i have to protect the document with some password (dynamically creating password is not my problem).My problem is how to create password and protect it.. Thanks in Advance.. Regards Bino Varghese Is there a way to verify the caching ... Arindam Tewary27-Dec-06 0:32 Arindam Tewary 27-Dec-06 0:32  Hi all Is there a way to cross check that indeed my user control that I am trying to cache in server ( using @OutputCache ) in getting cached . But I just want to see physical files stored in the server .... to make sure CACHING IS WORKING ... Can anyone help ???? Arindam VirtualFile - Seems to be caching. Tristan Rhodes27-Dec-06 0:05 Tristan Rhodes 27-Dec-06 0:05  I have a proxy that routes web page requests from my local network to my internal cassini applications. This uses a VirtualFile with an internal HttpRequest that makes the request and returns the response stream through the proxy stream. However, the page fires only once the first time it is called and i can step through the process, but anything after that is ignored, no breakpoints are hit in the virtual file. How do i stop this virtual file thing from caching? As it's loading a dynamic page? Cheers T asp.net Error Code 1460: timeout P. S. Pundeer26-Dec-06 23:30 P. S. Pundeer 26-Dec-06 23:30  Has anybody solution to it. i tried uploading video, i got this error.

Last Visit: 31-Dec-99 18:00     Last Update: 23-Sep-24 10:17 Refresh ᐊ Prev1...5518551955205521552255235524552555265527 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.