473,399 Members | 2,858 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Desperately need help to setup with asp net !!

I am beginning aspNet, I know well win apps.
Need a simple and schematic code example to start work.

This is what I need to accomplish:

----------------------
Given button and a TextBox on a web form when one presses the button on
the web form on a client pc, the sql query which is contained in the
text box is sent to a vb net application on a server pc. The win
application sends the query to the database, collects the results,
creates a web page showing some of these result and send the page back
to the browser (for future queries).

1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
2. Database --> WinApp on Server pc --> create NewAspPage --> client
pc (Browser)
----------------------

I am kind of desperate and I don't know where to start . I very
*simple* example in code would really help a lot.

Help!!

-Pam

Jun 25 '06 #1
8 2055
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I am beginning aspNet, I know well win apps.
Need a simple and schematic code example to start work.

This is what I need to accomplish:

----------------------
Given button and a TextBox on a web form when one presses the button on
the web form on a client pc, the sql query which is contained in the
text box is sent to a vb net application on a server pc. The win
application sends the query to the database, collects the results,
creates a web page showing some of these result and send the page back
to the browser (for future queries).

1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
2. Database --> WinApp on Server pc --> create NewAspPage --> client
pc (Browser)
----------------------

I am kind of desperate and I don't know where to start . I very
*simple* example in code would really help a lot.

Help!!

-Pam

Jun 25 '06 #2
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I am beginning aspNet, I know well win apps.
Need a simple and schematic code example to start work.

This is what I need to accomplish:

----------------------
Given button and a TextBox on a web form when one presses the button on
the web form on a client pc, the sql query which is contained in the
text box is sent to a vb net application on a server pc. The win
application sends the query to the database, collects the results,
creates a web page showing some of these result and send the page back
to the browser (for future queries).

1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
2. Database --> WinApp on Server pc --> create NewAspPage --> client
pc (Browser)
----------------------

I am kind of desperate and I don't know where to start . I very
*simple* example in code would really help a lot.

Help!!

-Pam


Jun 25 '06 #3


You might look into

"web service"
or
"remoting"

I have a sample remoting service at:
http://sholliday.spaces.msn.com/ 9/27/2005 entry. (You may have to "View
More" at the bottom to find it)
If you have biz logic in your winforms presentation layer, then I don't know
what youre going to do.
I've never heard of talking to a windows application from a web page. I'm
not saying it can't be done, but 10 years in the business, I've never heard
of it.
I understand I'm not answering your question exactly. That's because I
don't know what the answer is.


<pa***********@libero.it> wrote in message
news:11*********************@r2g2000cwb.googlegrou ps.com...
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I am beginning aspNet, I know well win apps.
Need a simple and schematic code example to start work.

This is what I need to accomplish:

----------------------
Given button and a TextBox on a web form when one presses the button on the web form on a client pc, the sql query which is contained in the
text box is sent to a vb net application on a server pc. The win
application sends the query to the database, collects the results,
creates a web page showing some of these result and send the page back
to the browser (for future queries).

1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
2. Database --> WinApp on Server pc --> create NewAspPage --> client
pc (Browser)
----------------------

I am kind of desperate and I don't know where to start . I very
*simple* example in code would really help a lot.

Help!!

-Pam

Jun 25 '06 #4
Thanks Sloan

you mean "Leveraging Dot Net Remoting To Keep Your "Secret Code" Safe",
right.
Actually that's a nice repository of good information.

I am a little worried by your answer, especially after reading the
material on the blog. My scheme would seem quite common and it's hard
to believe that .net does not provide ways to deal with it.

After all, I just want to talk - using a browser - with my application
running on a server. Is it possible that .net has not envisioned this
possibility? Or am I missing something important?

-Pam

sloan ha scritto:
You might look into

"web service"
or
"remoting"

I have a sample remoting service at:
http://sholliday.spaces.msn.com/ 9/27/2005 entry. (You may have to "View
More" at the bottom to find it)
If you have biz logic in your winforms presentation layer, then I don't know
what youre going to do.
I've never heard of talking to a windows application from a web page. I'm
not saying it can't be done, but 10 years in the business, I've never heard
of it.
I understand I'm not answering your question exactly. That's because I
don't know what the answer is.


<pa***********@libero.it> wrote in message
news:11*********************@r2g2000cwb.googlegrou ps.com...
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
>I am beginning aspNet, I know well win apps.
> Need a simple and schematic code example to start work.
>
> This is what I need to accomplish:
>
> ----------------------
> Given button and a TextBox on a web form when one presses the button on > the web form on a client pc, the sql query which is contained in the
> text box is sent to a vb net application on a server pc. The win
> application sends the query to the database, collects the results,
> creates a web page showing some of these result and send the page back
> to the browser (for future queries).
>
> 1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
> 2. Database --> WinApp on Server pc --> create NewAspPage --> client
> pc (Browser)
> ----------------------
>
> I am kind of desperate and I don't know where to start . I very
> *simple* example in code would really help a lot.
>
> Help!!
>
> -Pam
>


Jun 25 '06 #5
Hi Pam,

It sounds like you want to create your own custom HttpHandler. It can get
the posted query from System.Web.HttpContext and pass that along to get the
data. Once you've built the HTML code, you ship it back out with
HttpResponse.

If you do a search on IHttpHandler and HttpContext you'll get more info.
Here's a starter that generates a 'Hello World' HTML page.

http://msdn.microsoft.com/library/de...processing.asp

Can't help more than that because I haven't used that capability. It seems
to me there must be easier ways such as user controls or Web parts to do
what you need.

Ken
Microsoft MVP [ASP.NET]
<pa***********@libero.it> wrote in message
news:11*********************@r2g2000cwb.googlegrou ps.com...
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page
can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
>I am beginning aspNet, I know well win apps.
> Need a simple and schematic code example to start work.
>
> This is what I need to accomplish:
>
> ----------------------
> Given button and a TextBox on a web form when one presses the button on
> the web form on a client pc, the sql query which is contained in the
> text box is sent to a vb net application on a server pc. The win
> application sends the query to the database, collects the results,
> creates a web page showing some of these result and send the page back
> to the browser (for future queries).
>
> 1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
> 2. Database --> WinApp on Server pc --> create NewAspPage --> client
> pc (Browser)
> ----------------------
>
> I am kind of desperate and I don't know where to start . I very
> *simple* example in code would really help a lot.
>
> Help!!
>
> -Pam
>

Jun 25 '06 #6
Hi Ken

actually there is a simple hello world example which *seems* to be in
right direction. The rest of the documentation is quite concise and it
seems there is a long struggle to do.

I am not clear if the Process Request is routed by IIS to the
IHttpHandler (which I might enclose in my server application) or the
talk is directly between the Browser and the IHttpHandler (?)

I see not many people out there are using this stuff, but, to me, it
seems quite useful to be able to talk to an application through a
browser. If someone has some code or pointers to show how to use these
handlers it would be great.

If there other suggestions I will be listening here! Thank you

-pam
example from documentation:
----------------------------------------------------------
Imports System.Web

Public Class HelloWorldHandler
Implements IHttpHandler

Public Sub ProcessRequest(ByVal context As System.Web.HttpContext)
Implements System.Web.IHttpHandler.ProcessRequest
Dim request As HttpRequest = context.Request
Dim response As HttpResponse = context.Response
' A file named ending in .MyHello need not exist. This handler
' executes whenever a file ending in .MyHello is requested.
response.Write("<html>")
response.Write("<body>")
response.Write("<h1> Hello from Synchronous custom handler.
</h1>")
response.Write("</body>")
response.Write("</html>")
End Sub

Public ReadOnly Property IsReusable() As Boolean Implements
System.Web.IHttpHandler.IsReusable
Get
Return False
End Get
End Property
End Class
Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

It sounds like you want to create your own custom HttpHandler. It can get
the posted query from System.Web.HttpContext and pass that along to get the
data. Once you've built the HTML code, you ship it back out with
HttpResponse.

If you do a search on IHttpHandler and HttpContext you'll get more info.
Here's a starter that generates a 'Hello World' HTML page.

http://msdn.microsoft.com/library/de...processing.asp

Can't help more than that because I haven't used that capability. It seems
to me there must be easier ways such as user controls or Web parts to do
what you need.

Ken
Microsoft MVP [ASP.NET]
<pa***********@libero.it> wrote in message
news:11*********************@r2g2000cwb.googlegrou ps.com...
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page
can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
>I am beginning aspNet, I know well win apps.
> Need a simple and schematic code example to start work.
>
> This is what I need to accomplish:
>
> ----------------------
> Given button and a TextBox on a web form when one presses the button on
> the web form on a client pc, the sql query which is contained in the
> text box is sent to a vb net application on a server pc. The win
> application sends the query to the database, collects the results,
> creates a web page showing some of these result and send the page back
> to the browser (for future queries).
>
> 1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
> 2. Database --> WinApp on Server pc --> create NewAspPage --> client
> pc (Browser)
> ----------------------
>
> I am kind of desperate and I don't know where to start . I very
> *simple* example in code would really help a lot.
>
> Help!!
>
> -Pam
>


Jun 25 '06 #7
Pamela,

Actually, the idea would be to create a class that the browser based
program would call to do the processing. This would contain all of the
business logic that you are saying is in the VB application. It is
like creating a DLL for use by multiple applications and placing it on
the server.

Robert

pa***********@libero.it wrote:
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I am beginning aspNet, I know well win apps.
Need a simple and schematic code example to start work.

This is what I need to accomplish:

----------------------
Given button and a TextBox on a web form when one presses the button on
the web form on a client pc, the sql query which is contained in the
text box is sent to a vb net application on a server pc. The win
application sends the query to the database, collects the results,
creates a web page showing some of these result and send the page back
to the browser (for future queries).

1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
2. Database --> WinApp on Server pc --> create NewAspPage --> client
pc (Browser)
----------------------

I am kind of desperate and I don't know where to start . I very
*simple* example in code would really help a lot.

Help!!

-Pam


Jun 27 '06 #8
have you got my email?

raibeart ha scritto:
Pamela,

Actually, the idea would be to create a class that the browser based
program would call to do the processing. This would contain all of the
business logic that you are saying is in the VB application. It is
like creating a DLL for use by multiple applications and placing it on
the server.

Robert

pa***********@libero.it wrote:
Thank you Ken. This piece of the puzze I already have.

The problem is I want to send the request to a VB.NET program which is
running on the server because it must do some complicate processing
*before* doing the query and *after* doing the query. The response page
is not simply to fill a grid but the result of some processing that
must be done by the Vb.net application on the server. The VB.net
application also prepare a complex response page (with a lot of more
stuff, charts, pictures, photos, diagrams, etc) which I would like to
return to the browser.

What I have hard time to implement is passing data from the browser to
the VB.net application on the server, and, then, passing back the page
generated by the VB.net program back to the Browser. Just as I have
indicated in my schema. If you bypass the VB application you are not
answering to my original question. It's crucial the dialogue with the
server application.

Thanks for any help.

-Pam

Ken Cox [Microsoft MVP] ha scritto:
Hi Pam,

This sounds like a fairly simple ASP.NET page. Not sure why your spec
includes a "vb net application on a server pc" because the ASP.NET page can
do it all... that's what it was designed for.

Anyway, let us know if the ASP.NET 2.0 code below helps?

Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub btnSubmit_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
If txtQuery.Text <> "" Then
' Quick sample code to submit a SQL string
' and view the results in ASP.NET Gridview
' Ken Cox [MVP] - June 25/06
Dim strConnection As String
strConnection = "Data Source=.\SQLEXPRESS;" & _
"Initial Catalog=Northwind;Integrated Security=True"
Dim con As New Data.SqlClient.SqlConnection(strConnection)
' The following is probably not sufficient to protect you
' from a SQL injection attack but it's better than nothing
Dim cmdtext As String = SafeSqlLiteral(txtQuery.Text)
Dim cmd As New Data.SqlClient.SqlCommand(cmdtext, con)
Dim ds As New Data.DataSet
Dim da As New Data.SqlClient.SqlDataAdapter _
(cmdtext, strConnection)
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
End If
End Sub

Private Function SafeSqlLiteral(ByVal inputSQL As String) As String
Return inputSQL.Replace("'", "''")
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Textbox SQL query</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtQuery" runat="server" width="470px"
text="SELECT companyname from customers"></asp:textbox><br />
<br />
<br />
<asp:button id="btnSubmit" runat="server"
onclick="btnSubmit_Click" text="Submit query" /><br />
<br />
<br />
<asp:gridview id="GridView1" runat="server">
</asp:gridview>
&nbsp;</div>
</form>
</body>
</html>

<pa***********@libero.it> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
>I am beginning aspNet, I know well win apps.
> Need a simple and schematic code example to start work.
>
> This is what I need to accomplish:
>
> ----------------------
> Given button and a TextBox on a web form when one presses the button on
> the web form on a client pc, the sql query which is contained in the
> text box is sent to a vb net application on a server pc. The win
> application sends the query to the database, collects the results,
> creates a web page showing some of these result and send the page back
> to the browser (for future queries).
>
> 1. client (Browser, IE) ----> WinApp on a Server pc ----> Database
> 2. Database --> WinApp on Server pc --> create NewAspPage --> client
> pc (Browser)
> ----------------------
>
> I am kind of desperate and I don't know where to start . I very
> *simple* example in code would really help a lot.
>
> Help!!
>
> -Pam
>


Jun 28 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Rodney King | last post by:
Hi, I have developed an ASP page which dynamically displays a list of checkbox options based on a SQL statement. Here is my code: <div style="OVERFLOW:auto; Height: 150px"> <table> <% dim...
7
by: Mike Kamermans | last post by:
I hope someone can help me, because what I'm going through at the moment trying to edit XML documents is enough to make me want to never edit XML again. I'm looking for an XML editor that has a...
2
by: robert | last post by:
I've made a gallery site for an artist and it works well -- the gallery page has a central large image which is swapped when thumbnail images are clicked. I'm using Dreamweaver's "SwapImage"...
17
by: EkteGjetost | last post by:
This is definitely not the smart thing to do as far as my learning goes, but desperate situations call for desperate measures. The final lab for my introduction to C programming class is due...
6
by: Joey Liang via DotNetMonster.com | last post by:
Hi all, I have a drop down list which store all the different brands of product.When i selected the particular brand from the drop down list, it will display all the products with the selected...
9
by: Gordon | last post by:
Hello again, Sorry to repost this request, but I'm under a bit of pressure to find a quick solution. All I basically want is an automatically updating link (OLE, not DDE) between a control in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.