|
Hi all,
I am making oledb connection for reading excel file.
when this code is executed from the server which has this code then every thing is
ok but when this code is executed from other computer in a browser,
error occured related to opening the connection.
error message is:
-----------------
objEx {"The Microsoft Jet database engine cannot open the file 'C:\\Documents and
Settings\\lc\\Desktop\\CommissionReports\\Latestfiles\\latest
files\\Download0507tu.xls'. It is already opened exclusively by another user, or
you need permission to view its data."} System.Exception
{System.Data.OleDb.OleDbException}
BUT file is not opened by any other user.Every PC other than server(where code exists) gives this error message.
Server(where code exists) executes the code successfully.
code looks like:
----------------
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+ path1 + "
;Extended Properties=\"Excel 8.0;IMEX=1;\"";
OleDbConnection con = new OleDbConnection(connection);
string str1 = "select * from [" + sheetName + "$]";
OleDbDataAdapter adp = new OleDbDataAdapter(str1, con);
ds = new DataSet();
adp.Fill(ds);
Please give suggestion for this problem.
|
|
|
|
|
Hi...
How can i perform the body Onload event of a content page, while using Master Page. Since there is only one body tag in the Master Page.
Thanks in Advance
Mahesh.J
|
|
|
|
|
Put an id and runat="server" in the body control so that you can reach it from code behind. Put a property in the master page that exposes the control publically, so that you can reach it from the content page. In the content page you have to cast the Page.Master property to the actual class of the master page to be able to reach the property in the master page.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hello,
You can add the following code to the aspx page
<br />
<script type="text/javascript"><br />
<!--<br />
function LoadPage(event)<br />
{ <br />
alert('Load')<br />
}<br />
<br />
document.body.onload=LoadPage; <br />
</script><br />
It's strange but it works only if you write rigth in aspx file, it did not work when I try to use RegisterStartupScript.
I hope this will help you : )
|
|
|
|
|
Hi,
I want have an image beside the text in a drop down(combo box).Is that possible in ASP.NET 2.0? If yes how should I go about it?
Thanks for your time.
Regards
 Sabyasachi
Sabyasachi
|
|
|
|
|
No predefined controls available. You need to write one from scratch.
|
|
|
|
|
Hi,
Navaneeth thanks for your prompt response. Can you give me a guideline on how to go about it? Thanks for your time.
Regards
Sabyasachi
|
|
|
|
|
I am not sure about what I am telling, but you need to start WebControlLibrary project to start with control creation. You will get overrided Render() method which have HTMLTextWriter object as parameter. Using this, write HTML code for your combo box to the response. You won't be able to use classical HTML select control. Create a div element and add image tags into it. Using javascript you can make a feel of dropdownlist.
Before doing all these, do a quick search for any opensource projects. If you are developing one like this, I am sure it is time consuming.
|
|
|
|
|
how to get particular element value from xml file.
Pradeep Reddy
|
|
|
|
|
XMLDocument XDocument = new XMLDocument();
XDocument.Load(YourXMLFile);
Response.Write(XDocument.GetElementByTagName("YourElement")[0].InnerText);
|
|
|
|
|
Hi Everyone,
I have added a statement in both C# and VB (code-behind) as follows:
Listbox1.items.add("\x2260"); //C#
Listbox1.items.add("\x2260") //VB
I found the output varies. I need the same output as in C#. Can anyone help me in this regard.
Regards,
Manowj
|
|
|
|
|
Dear u have to make the code like this
Listbox1.items.add("\\x2260"); //C#
just adding another \ in the code
Kareem Elhosseny
|
|
|
|
|
Hi kareem,
Can you place this statement in aspx.vb file and run the application
Listbox1.items.add("\\x2260")
It is not showing the correct output.
U can check this placing in aspx.cs file
Listbox1.items.add("\\x2260"); //The output should be same for above statment.
Regards,
Manowj
|
|
|
|
|
My Dear
I'm trying this code in C# and it work correctly but not in vb
u know where is the problem the problem in / because its a keyword so we have to add anoter one / to be like this //
really dear I'm sure i try it now
i hope to B usefull 4 u
Kareem Elhosseny
|
|
|
|
|
Hi kareem,
I have tried as you said, it seems not working in aspx.vb
can you send me the statement which you have checked with aspx.vb
I have tried with c# before posting this issue, it works fine. I need to implement using vb.
Regards,
Manowj
|
|
|
|
|
Hi
try this
String str=@"\\x2260";
Listbox1.items.add(str);
Best Regard
pathan
---------------------------------------------------
|
|
|
|
|
Hi pathan,
I need this in VB(code-behind). Before posting this issue , i had tried using C# its working.
Regards,
Manowj
|
|
|
|
|
is it possible to put datagrid inside datagrid?
Anu
|
|
|
|
|
anujose wrote: is it possible to put datagrid inside datagrid?
YES. Inside template column you can put
|
|
|
|
|
thx a lot for your efforts
i want to make all pages in my project accessible from any other page on my project to interact with it (controles ....or any thing)
so is there a way to make any page public to see and interact with it in another page
Kareem Elhosseny
|
|
|
|
|
elhosseny wrote: i want to make all pages in my project accessible from any other page on my project to interact with it (controles ....or any thing)
You can't do this. Check with ASP.NET lifecycle in MSDN. When UnLoad() method calls before you see the page, all controls objects will be removed. So you won't be able to do this. Tell me real time scenario where you need to do such things ?
|
|
|
|
|
Dear Navaneeth ;
my real case is i want to make something like resource file
as
my application support to make the user change the application to his language and his culture dynamically
i make combo box carry all culture and language
and another combo carry all pages in my project
here is the problem when i choose the page i want to load the main page with the all controle in the selected page in combobox (labels, headers....)
which i can change them to the selected culture or language like the customer want
but i cant access the pages ;
and also i want to do this action without open the page which include the controle in the fact
note iam using xml file to be intermadte between master web application (which include the pages) and the translator pages
there is my all case
and iam working on it step by step
but my huge problem is what i say about accessing anotrher page resource like controle with out open it
plz help me or show my case to codeprjoect if any programmer can help me
thx for your attention
and i hope to be usefull for u in the future
Kareem Elhosseny
|
|
|
|
|
Your requirement seems very tough. I implemented internationalization in my projects using resource files. In that user can change their language by changing browser default language. If you can do that, it will make your process easier.
elhosseny wrote: when i choose the page i want to load the main page with the all controle in the selected page in combobox (labels, headers....)
which i can change them to the selected culture or language like the customer want
I am not sure that I understood properly, Do you mean that, you need to show preview of the page where language will be changed, on the main page when page selects from dropdown ? If so, you can make use of WebClient class instead of opening that file. WebClient will give you rendered HTML of the page, which can be put into some literal control to show the page in your main page as preview.
|
|
|
|
|
my dear;
i know its toooooooooooooo tough
ok can u send to me your solution for this problem or hints on it
thx for your time
but i have an idea
in page load for each page i made a session which carry an array of controls in the page
can i open the page and close it in the same time just for take the session which i made and interacte with them?
if yes
plz how can i open page and close it in the same time?
or how can i close the page from other page?
if not
kindly tell me about your solution
Kareem Elhosseny
|
|
|
|
|
elhosseny wrote: can i open the page and close it in the same time just for take the session which i made and interacte with them?
No, no you cannot. As I keep saying, you seem to have no idea how ASP.NET works, you need to buy a book and read it.
And, as I've said before, user controls are the way to reuse control layouts between pages, but they will not have any state, you get the layout, but no values.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
