|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 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.
|
|
|
|
|
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
|
|
|
|
|
Yes its working nice. Thanks dear.
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
You are most welcome man....
Regards,
Venkatesh Mookkan.
Software Engineer, India
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Has anybody solution to it. i tried uploading video, i got this error.
|
|
|
|
|
Have you tried increasing the number of second system will wait before sending timeout meesage ...
add executionTimeout="500" or more depending upon your requirement
in httpRuntime section in web.config file.
<httpRuntime executionTImeout="500" />
I guess it will solve your problem !!! 
Arindam
|
|
|
|
|
Thanks Arindam for timely help. Now it is uploading successfuly.
|
|
|
|
|
Arindam
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
