Web Development Discussion Boards

Connection String in Web Services for MS Access databases

gaorellana6-Apr-06 15:53

6-Apr-06 15:53

Hello:

I am developing a web service which is consuming data from an MS Access database. I am in trouble when testing the service from a client.

When debuging the web service directly either I define the connection stirng as 1) or 2) it works.

1) connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='~\App_Data\OVRData.mdb'"
2) connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='E:\Projects\MyWebService\App_Data\OVRData.mdb'"

But if I try to test the service from my client only writing the Web.config as the option 2) works. Otherwise
try to find the file in something like c:\Documents and Settings\...\VisualStudio\IDE\...

Given I have no control on which absolute path is going to have when I move to the web server. How can I write my connection string to be relative?

Thanks

Re: Connection String in Web Services for MS Access databases

Vasudevan Deepak Kumar6-Apr-06 18:25

Vasudevan Deepak Kumar

6-Apr-06 18:25

You can try using Server.MapPath to get the physical path of the application and then build the path for your MDB database.

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

Tree view like the code project forum

2hdass6-Apr-06 9:52

2hdass

6-Apr-06 9:52

I am in a design stage for my new web applciation. What should i start looking at if i want my web application to act something like this forum, where u click on a topic it will expand the content?

thx for your suggestions!

Re: Tree view like the code project forum

alexey _N10-Apr-06 18:45

alexey _N

10-Apr-06 18:45

Try this html:

<html>
<head>
<script language="JavaScript" type="text/javascript">
function Expand(name)
{
var elem = document.getElementById(name);
if (elem.style.display == "none")
{
elem.style.display = "block";

}
else
{
elem.style.display = "none";
}
}
</script>
</head>
<body>
<Table >
<tr>
<td>
<a href="#" onclic k ="Expand('content');">click this</a>
</td>
</tr>

<tr>
<td>
<table id="content">
<tr>
<td>
line1<br/>
line2<br/>
line3
</td>
</tr>
</table>
</td>
</tr>

</body>

</html>

-- modified at 0:47 Tuesday 11th April, 2006

Re: Tree view like the code project forum

2hdass12-Apr-06 3:05

2hdass

12-Apr-06 3:05

hmmm...this doesnt seem to be working...

Re: Tree view like the code project forum

alexey _N12-Apr-06 17:31

alexey _N

12-Apr-06 17:31

Remove space in "onclick" If I post it without quotes it'll be replaced by "removed" word. Like in this:

<html>
<head>
<script language="JavaScript" type="text/javascript">
function Expand(name)
{
var elem = document.getElementById(name);
if (elem.style.display == "none")
{
elem.style.display = "block";

}
else
{
elem.style.display = "none";
}
}
</script>
</head>
<body>
<Table >
<tr>
<td>
<a href="#" onclick ="Expand('content');">click this</a>
</td>
</tr>

<tr>
<td>
<table id="content">
<tr>
<td>
line1<br/>
line2<br/>
line3
</td>
</tr>
</table>
</td>
</tr>

</body>

</html>

Re: Tree view like the code project forum

2hdass13-Apr-06 14:10

2hdass

13-Apr-06 14:10

cool.. this works, now how do i do this part in C#? whats the libary for elem.style.display? or should i make it a server control?

<script language="JavaScript" type="text/javascript"><br />
            function Expand(name)<br />
            {<br />
        var elem = document.getElementById(name);<br />
               if (elem.style.display == "none")<br />
               {<br />
                    elem.style.display = "block";<br />
                    <br />
               }<br />
               else<br />
               {<br />
                    elem.style.display = "none";<br />
               }<br />
            }<br />
        </script>

Re: Tree view like the code project forum

alexey _N13-Apr-06 17:32

alexey _N

13-Apr-06 17:32

That was a simple html solution.
Read this article http://www.codeproject.com/asp/aspforum-n-membersys.asp
for complete information.

Best regards, Alexey.

ListBox value

ekendricks6-Apr-06 6:17

ekendricks

6-Apr-06 6:17

I have a listbox "Employee" that is pouplated with a SQL stmt. In the SQL stmt, I can SELECT ID, Name, Dept, Etc. The listbox shows the "ID - 25" and "Value -Name". I do not need to see any additional information in the listbox, but I need a javascript function to populate a textbox "Dept" with the "Dept value" that was retreived with the SQL stmt.

Ernest

Re: ListBox value

cdengler6-Apr-06 8:41

cdengler

6-Apr-06 8:41

More information required here.. Are you saying that you already have the listbox populated, and that when a users selects one of the items in the dropdown that you want that item's text data to be populated in a separate text box?

Re: ListBox value

ekendricks6-Apr-06 9:07

ekendricks

6-Apr-06 9:07

Correct: This list box is already populated using a SQL stmt. User can currently select an item in the dropdown.
The fields in the list box are ID=1d, and Value=Name which is displayed to user. The SQL stmt returns: ID - Name - Dept. I need an onchange event that will populate another text box "Dept" with the 3rd column of the list box "Dept".

Thanks

Ernest

Re: ListBox value

cdengler10-Apr-06 8:47

cdengler

10-Apr-06 8:47

Ok, if I understand this, what you're saying is that you have three values... the ID, the name and the Department. And now based upon which one they select, you need to populate another area with the department value.

I would create a Javascript array on the page populated when the SQL populates the dropdown. The array would contain the IDs of each dropdown associated with DEPARTMENT. On the OnChange, have the script look up the value of the selected item in the dropdown, get the department value, and populate the other area. Make sense?

Re: ListBox value

ekendricks10-Apr-06 9:02

ekendricks

10-Apr-06 9:02

Yep... you understand..... Thanks for the reply.....
Now I just need to find samples or figure out how to do just that..

Thanks

Ernest

ISAPI DLL under WinCE Registry

RamL5-Apr-06 23:04

RamL

5-Apr-06 23:04

Hi All,

Would u tell me
what are the settings needed under WinCE Registry to work the ISAPI extension DLLS?

How to do it?

Thankx in advance,

Regards,
Ramesh.

middle web service

hung_ngole5-Apr-06 16:22

hung_ngole

5-Apr-06 16:22

Hi,
I'm writing a web service using ASP.NET in VS.NET 05, I want my web service can receive the request from client and get the response (including HTML, Javascript...) from the web server. It is in the middle of web server & client.
How can I do?
Thanks,

Hung

Re: middle web service

cdengler10-Apr-06 8:51

cdengler

10-Apr-06 8:51

Hung,

I'm guessing that no one is replying to this because it's hard to follow. Do you want your web service to simply return HTML and Javascript? What is this HTML and Javascript?

quick javascript question

Sam 20065-Apr-06 12:18

Sam 2006

5-Apr-06 12:18

hi,

i've got a quick javascript question. i don't know if its possible... how can i call a function when text in a textbox is changed?

thanks in advance,
sam kline

Re: quick javascript question

smadan5-Apr-06 21:37

smadan

5-Apr-06 21:37

Hi,

For this purpose try writing code in the textchanged event or else use an extended textbox.
Extended textboxes allow you to write delegates and events and on those events javascript functions can be called.

Code for extended text box can be found at the code project site itself.

Thanks.

ASP.net 2.0

felopater5-Apr-06 5:44

felopater

5-Apr-06 5:44

hi all,

i got a small problem but its really annoying.
i want to use the new implicit localization feature of asp.net 2.0. i created default resource file in local resources folder say def.aspx.resx thent i created number of resources files with diff languages like def.aspx.fr-FR.resx. the defualt resource file works greate but when i change culture and uiculture to another culture say fr-FR. nothing changes and the resource file def.aspx.fr-FR didn't loaded i dont know why??? it works only when i make it as defualt resource. def.aspx.resx but changing cultrue anf uiculture doesn't work!!!!
Thanks in advance.

marcoryos

.net Language Interoperability

smadan5-Apr-06 0:14

smadan

5-Apr-06 0:14

Hi,

I am working on a web application in ASP.net & C# .For one of the utilities on my site, i need to use an available VC++ project.
This VC++ project produces an exe as its output.
I tried changing the output type of the VC++ project to .dll, but it doesn't help and after this, the project itself stops working.

Can someone please tell me as to how to use this VC++ project into my web application?

Thanks.

Re: .net Language Interoperability

Sarvesvara (BVKS) Dasa5-Apr-06 21:19

Sarvesvara (BVKS) Dasa

5-Apr-06 21:19

EXE in a web page??? looks strange to me.

You can try to re-write the code for .NET itself Smile | :)

"He that is good with a hammer tends to think everything is a nail."
- Abraham Maslow

Re: .net Language Interoperability

smadan5-Apr-06 21:29

smadan

5-Apr-06 21:29

What i am trying to do seems a little difficult, but i learnt that .net supports language interoperability.

"How" is the point of concern. I've tried a lot but have not been able to accomplish this task.

Using dlls is easy, but with this exe project, i'm at sea... dont know how to use it.

I'll be grateful if you can provide any useful information on this.

I hope you appreciate that rewriting an entire project would be very time consuming and complex.

Thanks.

Re: .net Language Interoperability

RichardGrimmer11-Apr-06 7:25

RichardGrimmer

11-Apr-06 7:25

You can't just convert an exe to a dll in C++ like that....they're COMPLETELY different creatures. You'd have to basically start over and take the functionality from the exe that you need, and put into a dll, but have to bear in mind that there will be no UI...

You can't run an exe in a webpage at all....you just can't do it. What you could try would be writing an ActiveX control that is installed on the client machine, together with the appropriate exe and supporting files and then use ShellExecute() to run it - though to be honest, am not even sure that would work.

.NET does support language interoperability, but only at the assembly level - ie, can use vb to talk to a c# assembly...

Unless someone more knowledgable knows anything, think this

smadan wrote:
I hope you appreciate that rewriting an entire project would be very time consuming and complex.

is your only option Frown | :(

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

how to add only vertical scrollbar

Chetan.visodiya5-Apr-06 0:13

Chetan.visodiya

5-Apr-06 0:13

hi,

I want that when page is too long, only vertical scroller bar is display. Please send me solution with writing code.

Thanks

C Patel

Remove scroll bar from the page

Chetan.visodiya5-Apr-06 0:10

Chetan.visodiya

5-Apr-06 0:10

Hi friends,

I want to remove scroll bar from web page( not disable but remove).
If this is possible the help me. and also write the code.

Thanks,

Chetan Visodiya

Last Visit: 31-Dec-99 18:00 Last Update: 24-Jun-24 13:33

Refresh

ᐊ Prev 1...920 921 922 923924925 926 927 928 929 Next ᐅ

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