473,396 Members | 1,760 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,396 software developers and data experts.

Sending query to a database using WPF Browser Application

Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
Please help,
Ofir
Sep 6 '08 #1
5 8274

"ofiras" <of****@gmail.comwrote in message
news:fa**********************************@x41g2000 hsb.googlegroups.com...
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
I assume that the database here is server-side. In this case, you can build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET Data
Services to automate it.
Sep 6 '08 #2
On 6 ספטמבר, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
"ofiras" <ofi...@gmail.comwrote in message

news:fa**********************************@x41g2000 hsb.googlegroups.com...
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)

I assume that the database here is server-side. In this case, you can build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier? That way I can make a .php file
that will get the posted data and send the query I want. I tried it
but it didn't work too because of the security restrictions...
Please help,
Ofir.
Sep 6 '08 #3
"ofiras" <of****@gmail.comwrote in message
news:30**********************************@k13g2000 hse.googlegroups.com...
On 6 ??????, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)

I assume that the database here is server-side. In this case, you can
build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET
Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier?
I don't think so. Why bring PHP into equation
That way I can make a .php file that will get the posted data and send the
query I want.
I tried it but it didn't work too because of the security restrictions...
If you construct the query on the client, and just make the server accept
and execute any query that it receives, then you are opening a very wide
security hole. You need to encapsulate strictly the queries you need for
your client app on the server side.
Sep 6 '08 #4
On 6 ספטמבר, 15:54, "Pavel Minaev" <int...@gmail.comwrote:
"ofiras" <ofi...@gmail.comwrote in message

news:30**********************************@k13g2000 hse.googlegroups.com...
On 6 ??????, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
I assume that the database here is server-side. In this case, you can
build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET
Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier?

I don't think so. Why bring PHP into equation
That way I can make a .php file that will get the posted data and send the
query I want.
I tried it but it didn't work too because of the security restrictions....

If you construct the query on the client, and just make the server accept
and execute any query that it receives, then you are opening a very wide
security hole. You need to encapsulate strictly the queries you need for
your client app on the server side.
Ok... I see... so what is this ADO.NET Entity Framework an ADO.NET
Data Services? Is there a tutorial or article or something that
explains what is it and how to use it?
Please help,
Ofir.
Sep 7 '08 #5
On Sep 7, 6:21*pm, ofiras <ofi...@gmail.comwrote:
Ok... I see... so what is this ADO.NET Entity Framework an ADO.NET
Data Services? Is there a tutorial or article or something that
explains what is it and how to use it?
In the future, please use Google before asking such questions. Merely
searching for the titles of those technologies gives plenty of
relevant links on the top. Or just go to MSDN and search there.

http://msdn.microsoft.com/en-us/library/bb399572.aspx
http://msdn.microsoft.com/en-us/data/bb931106.aspx
Sep 18 '08 #6

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

Similar topics

2
by: Frostillicus | last post by:
I'm trying to get an ASP to return a zip file to the remote browser from an Image (BLOB) field in SQL Server 2000 but Internet Explorer keeps saying: Cannot open C:\Documents and...
20
by: CHIN | last post by:
Hi all.. here s my problem ( maybe some of you saw me on other groups, but i cant find the solution !! ) I have to upload a file to an external site, so, i made a .vbs file , that logins to...
2
by: Gershon | last post by:
I have an ASP.NET/C# web application running against a SQL Server database using ADO.NET. Whenever there is a long-running database query, the web application hangs until the database query is...
3
by: Pradeep Kumar C | last post by:
Hi , I am working on a ASP.Net Web Application which need some requirement as given below. Let's say two user's A and B. When a User A Assign a task to B , Then B need to get some sort of...
5
by: Vishal | last post by:
Hello, I already asked this question in the ASP.NET forums, but no help came. So I am hoping that somebody can help me out. This is really very URGENT me. For my e-commerce application, I...
2
by: junOnline | last post by:
Hi, I am developing an asp.net 2.0 application using visual studio 2005 on my computer and I am getting very inconsistent results when I test on my computer versus from other computers. The...
3
by: Joel H | last post by:
I have pdf files stored in a database image field. I need an aspx page that will send the pdf to the browser. The code I have (in the page_load event) works the first time I run it: ...
1
by: Charles Wilson | last post by:
Can someone point me to some good instructions on using the WinInet.dll functions from VBA? I need to interact with a MySQL database via HTTP strings. We already have the database set up and a...
9
by: Miro | last post by:
VB 2003 at the end of the code, this works great. bytCommand = Encoding.ASCII.GetBytes("testing hello send text") udpClient.Send(bytCommand, bytCommand.Length) and this recieves it Dim...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
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
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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,...

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.