Re: Database - Web Development Discussion Boards

orangetree20-Jan-05 16:12

20-Jan-05 16:12

I am trying to finish this csv import page, I can currently import files that are located in my C or D drive but if I try to import a file from my desktop I keep getting the error 'File Not Found'. Can anyone help me on how I can address the file from my desktop or network.

I am currently submitting the address from a file-field in a form
then using this code to read the file:

csv_to_import = replace(Request.Querystring("csvImport"),"'","''")
set fso = createobject("scripting.filesystemobject")
set dct = fso.opentextfile(Server.Mappath(csv_to_import))

If anyone can help would be greatly apprecieated.

regards,
JB

How to integrate C++ application with ASP.net Web Application?

webdevelopex19-Jan-05 15:37

webdevelopex

19-Jan-05 15:37

Hi there,

Currently, I have a C++ program running that communicated with
a communication device. I can execute commands and receive responses
via my C++ program to/from this device.

Now,i want to setup another version of this system with WEB BASED
capability. And i want to reuse back my existing resources which is
my C++ program. My questions are:

1. Is there any web technology that be able to integrate with C++ program?
2. Is it possible that ASP.net be able to do the job with combination of
c# or vb.net?
3. How about open source web environment which we can integrate with
C++ program?
4. How can a web browser always listen to the server's response if
there has changes going on from the communication device
without refreshing the whole web page?

Pls suggest a suitable architecture for my system in order to run in
both windows and web application with only 1 back-end engine.

Thanks.Pls as soon as possible.

Re: How to integrate C++ application with ASP.net Web Application?

V.20-Jan-05 22:29

20-Jan-05 22:29

1. Is it a dll or exe?
You can try to import the dll into your asp.net project, if it fails, you can write a wrapper and try via a exe or try via a dll that can be imported.
-> exe, you can call exe's and pass arguments to them.

2. I'm not sure what job you're talking about, but I think so. You can also use a general (winforms/services) dll from C#(Vb.net) or use webservices.

3. I'm not sure what you mean by this.

4. I'm thinking in the line of a service. The page will reload, but always the cached version until a flag or something is checked. Then it will refresh.

Hope it helps a bit, good luck.

"If I don't see you in this world, I'll see you in the next one... and don't be late." ~ Jimi Hendrix

JavaScript + dll howto...

spaceus19-Jan-05 10:32

spaceus

19-Jan-05 10:32

I know this is possible, but currently have no time to look into it, so hoping somebody out there will give me the answer Wink | ;)

What Im wanting to do is to call a .dll from a .js

Say I've made some HelloWorld.dll with a
hello() system.Console.write("hello")

then in a .js want to call this function how do I do this??
function hello(){
var helloDll = new ActiveXObject("HelloWorld");
helloDll.hello();
}
Would this work if i put it in system32 folder or something..??

apreciate any help Spaceus

How terrible is wisdom when it brings no profit to the wise

Database

Yulianto.18-Jan-05 18:01

Yulianto.

18-Jan-05 18:01

I have a table, with the field name GroupId and GroupName as primary key. In a asp file, I connect to the database and execute an insert query. What if the record which i`m going to insert is already in the database. How do I catch the error?

<italic>Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

Re: Database

Colin Angus Mackay19-Jan-05 4:46

Colin Angus Mackay

19-Jan-05 4:46

Well, I cannot help with the ASP bit as I don't know the database connectivity tools it offers.

goodmast3r wrote:
What if the record which i`m going to insert is already in the database. How do I catch the error?

If you want to insert the data only if it does not already exist then try this:

CREATE PROCEDURE InsertGroupIdAndName
    @GroupId int,
    @groupName varchar(128)
AS
    IF NOT EXISTS(SELECT * FORM GroupTable WHERE GroupId = @GroupId)
    BEGIN
        INSERT GroupTable(GroupId, GroupName) VALUES (@GroupId, GroupName)
    END
GO

You have not mentioned what database you are using so I made the assumption that you are using SQL Server 2000 (You should always mention the database you are using - there are difference between them)

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: Database

Yulianto.19-Jan-05 16:04

Yulianto.

19-Jan-05 16:04

How do we know whether the procedure insert the record or not? How do we catch the error. By the way, I`m using SQL Server 2000.

<italic>Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

Re: Database

Colin Angus Mackay19-Jan-05 22:03

Colin Angus Mackay

19-Jan-05 22:03

Assuming you use the stored procedure I put in my previous post. If you use the SqlCommand.ExecuteNonQuery()[^] method the return value indicates the number of rows affected. If the record was inserted it will return 1, if not it will return 0.

If you want to just run an INSERT command directly through SqlCommand to the database then you can enclose ExecuteNonQuery() in a try catch block.

try
{
    myCommand.ExecuteNonQuery();
}
catch(SqlException e)
{
    // Something went wrong, deal with it here
}
finally
{
    myCommand.Connection.Close();
}

Does this help?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: Database

Yulianto.21-Jan-05 14:29

Yulianto.

21-Jan-05 14:29

I don`t know whether ASP script can do that. But thanks anyway.

<italic>Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

Re: Database

Colin Angus Mackay21-Jan-05 14:36

Colin Angus Mackay

21-Jan-05 14:36

Yulianto AKA goodmast3r wrote:
I don`t know whether ASP script can do that.

I would imagine that classic ASP would have some sort of mechanism to catch when SQL Server does a RAISERROR, even if it is not similar to the ASP.NET way.

Alternatively, you could create the stored procedure to return an explicit value if the record is inserted. This could be either through a return value, or by performing a simple SELECT 1 for success or SELECT 0 for failure. You could pick that up as if you were reading a normal dataset and just pick out the first column of the first row (which should be the only data to exist) and find out if it was successful or not.

I hope this gives you a few more ideas.

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: Database

mtone26-Jan-05 3:36

mtone

26-Jan-05 3:36

You can raise the error in the Stored Procedure

Like Colin Stated

<br />
CREATE PROCEDURE InsertGroupIdAndName    <br />
   @GroupId int,    <br />
   @groupName varchar(128)<br />
AS    <br />
IF NOT EXISTS(SELECT GroupId,GroupName FORM GroupTable WHERE GroupId = @GroupId AND GroupName=@groupName)<br />
 BEGIN        <br />
    INSERT GroupTable(GroupId, GroupName) <br />
    VALUES (@GroupId, GroupName)    <br />
 END<br />
ELSE<br />
 BEGIN <br />
       RAISERROR (Group Name:%d with groupID %d Already exists',<br />
      16, 1,  @groupName , @GroupId)<br />
 END<br />
GO

16,1 = severity , state
lookup proper syntax for RAISEERROR

Then Catch the error in the code. You do catch you errors right?

If using vbscript in the asp page....

<br />
On error resume next<br />
<br />
Database insert stuff...<br />
<br />
If err.number <> 0 then<br />
   do something with err.number & err.description<br />
End IF

Event not firing in composite control

ttapping18-Jan-05 15:20

ttapping

18-Jan-05 15:20

I read Nick Pirocanac's CoolButton composite control article and downloaded the code and have it running on my machine.

I created a simple composite control from scratch but the delegate is never called and the event never fires. I would appreciate another pair of eyes to point out what I am missing. Here is my code:

namespace TestCustUC
{
[ToolboxData("<{0}:WebCustomControl1 runat=server>")]
public class WebCustomControl1 : System.Web.UI.WebControls.WebControl
{
private Button butOK;
public event EventHandler Click;

protected override void CreateChildControls()
{
butOK = new Button();
butOK.Text = "OK";
butOK.Width = Unit.Pixel(50);
Controls.Add(butOK);
// Add handler for the OK button click postback event.
butOK.Click += new EventHandler(this.OnButOK_Click);
}

protected virtual void OnButOK_Click(object sender, EventArgs e)
{
if (Click != null)
{
Click(this, e);
}
}

}
}

Thanks for taking a look!

tim t

Re: Event not firing in composite control

epatton20-Jan-05 2:49

epatton

20-Jan-05 2:49

I had to study the examples in the SDK QuickStart (plus others I found online) quite a bit before I got my own custom control working just the way I wanted. I changed your code slightly in headers and declaration, and the event is now triggered; hope this at least helps get you started. Check out esp. info on implementing the INamingContainer interface and EnsureChildControls.

Regards,

-lp

using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace TestCustUC
{
//[ToolboxData("<{0}:WebCustomControl1 runat=server>")]
public class WebCustomControl1 : Control, INamingContainer
{
private Button butOK;
public event EventHandler Click;

protected override void CreateChildControls()
{
butOK = new Button();
butOK.Text = "OK";
butOK.Width = Unit.Pixel(50);
Controls.Add(butOK);
// Add handler for the OK button click postback event.
butOK.Click += new EventHandler(this.OnButOK_Click);
}

protected /*virtual*/ void OnButOK_Click(object sender, EventArgs e)
{
if (Click != null)
{
Click(this, e);
}
}

}
}

Re: Event not firing in composite control

ttapping21-Jan-05 18:06

ttapping

21-Jan-05 18:06

epatton -- Thanks for taking the time to dig into my code and suggest changes and resources for more information!

I played with the code as well and got it to work following a different avenue. It appears that if you attribute the control class for design time support ([DefaultProperty("Text"),ToolboxData...), then you should follow through and implement, for example, the 'Text' property, using the call to 'EnsureChildControls'.

Sounds OK, huh? But the project still didn't run correctly!

This will sound like a bunch of hocus pocus, but the next thing i did was to re-arrange the Page and Register directives on the .aspx page that used the control, F5 and then everything ran perfectly!

I believe this forced VS to rebuild its in memory representation of the project, rewiring the project correctly and allowing it to run.

Anyway, that's my theory....

Thanks again for your help.

tim t

Accessing child page function through JavaScript

Hemant Mane18-Jan-05 4:48

Hemant Mane

18-Jan-05 4:48

Hi frinds,

I am working on a project where i want to access the function of child web page

i know if u want to access the function of parent webpage
u can access it through window.opener or document.parent

But i want to access the function of child form
is there any code to access the child form or i can make the object of child form and then access the function.

thanks
(Hemant U. Mane)

Re: Accessing child page function through JavaScript

JKroschel25-Jan-05 8:01

JKroschel

25-Jan-05 8:01

when you open a new window using window.open(), you end up naming the window in the second argument.
window.open("bob.html", "bobWin", "width=500, height=500") for example creates a new window called bobWin. if you use that instead of "window", you should be able to point to anything there.

Exception thrown when use IOleContainer::EnumObjects function

mayforest18-Jan-05 1:17

mayforest

18-Jan-05 1:17

I tried to access the frames in an HTML page hosted by CWebBrowser2 control. Each time, I can query valid IOleContainer interface. However. When use EnumObjects function of this interface, an exception was thrown. Does anybody know what kind exception was thrown, what cause this problem?

I followed the instructions published in Microsoft web (How to get the WebBrowser object model of an HTML frame http://support.microsoft.com/default.aspx?id=196340) here are the codes:

I followed the instructions published in Microsoft web(How to get the WebBrowser object model of an HTML frame http://support.microsoft.com/default.aspx?id=196340) here are the codes:

// Get the IDispatch of the document
LPDISPATCH lpDisp = NULL;
lpDisp = m_webBrowser.GetDocument();

if (lpDisp)
{
IOleContainer* pContainer;

// Get the container
HRESULT hr = lpDisp->QueryInterface(IID_IOleContainer,
(void**)&pContainer);
lpDisp->Release();

if (FAILED(hr))
return hr;

IEnumUnknown* pEnumerator;

// Get an enumerator for the frames
hr = pContainer->EnumObjects(OLECONTF_EMBEDDINGS, &pEnumerator);
pContainer->Release();

How to determine if IIS is already installed

exhaulted18-Jan-05 1:01

exhaulted

18-Jan-05 1:01

Hi all, i am involved in writing an application at the moment that will require IIS to be installed to run. Is there a way that i can check to see if IIS has already been installed when i install my application? And if it has not already been installed i need to install it, although i think i can manage that bit Smile | :)

Cheers

Kev

install process...web based

oxygen_fiend17-Jan-05 10:38

oxygen_fiend

17-Jan-05 10:38

Hi,

does anyone know how macromedia does the silent install of the flash player? do i need wise to automatically install some components? or can i use msi...if so how do i do it?

thanks

Re: install process...web based

raouls17-Jan-05 20:45

raouls

17-Jan-05 20:45

i know that other tools have a "/silent" option, where you can execute them with the silent commandline flag. i would presume that msi would have the same or similar...

--
Raoul Snyman
Saturn Laboratories
e-mail: raoul.snyman@saturnlaboratories.co.za
web: http://www.saturnlaboratories.co.za/
blog: http://blog.saturnlaboratories.co.za/
linux user: #333298

Re: install process...web based

johnhebert18-Jan-05 6:22

johnhebert

18-Jan-05 6:22

Even though it is not defined on this page :p, the .msi install option you want is "/q". I'm sure there is a similar list of .msi install option flags somewhere on Microsoft's site...

John Hebert
Solvitur Ambulando

download file for one time using GPRS

manasrahfantom17-Jan-05 3:17

manasrahfantom

17-Jan-05 3:17

Hi everyone,

i have an ASP.NET service site, that is used to send a link to the mobile of the customer to download a file from our server throught GPRS, now the problem i face is that i want this customer to download this file only one time...then if he try to download the file again, he cant...

so is there any to know if this customer downloaded this file , or is there any way the web server can know that a gprs connection contacted that file and it has been downloaded...

Kind Regards
Mahmoud Manasrah

using ASP/VB script how to write/copy a text file from a server to client machine

nbiju16-Jan-05 20:28

nbiju

16-Jan-05 20:28

I would like to know

using ASP code

How to write / copy a text file from a server into client machine's root(c:\).

I tried using fso but the file is created/copied in the server machine itself.

Please give me a sugggestion

Thanks in advance

Biju Smile | :)

Re: using ASP/VB script how to write/copy a text file from a server to client machine

raouls16-Jan-05 21:16

raouls

16-Jan-05 21:16

nbiju wrote:
How to write / copy a text file from a server into client machine's root(c:\).

the short answer is: you can't.

the long answer is: you can get the user to download the file.

--
Raoul Snyman
Saturn Laboratories
e-mail: raoul.snyman@saturnlaboratories.co.za
web: http://www.saturnlaboratories.co.za/
blog: http://blog.saturnlaboratories.co.za/
linux user: #333298

Re: using ASP/VB script how to write/copy a text file from a server to client machine

nbiju16-Jan-05 21:21

nbiju

16-Jan-05 21:21

Thanks for the reply.
Actually I am searching for a solution other than download or saveAs method.
That means the work should be done without user's knowledge.

Thanks
Biju

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