Dear all,
I am trying to connect the MS SQL Server Database.
When user browses my website.
He can create a text file on his local disk.
And the text file has some Product_ID.
Could the server's ASP.NET program can read that text file and select the Product where Product_ID = the text file's Product_ID??
The point is " How can I read the text file in client's disk ? "
Or is any configuration has to be set ??
Thanks a lot !

You can't do that. The server has no ability to read anything on the client's machine. The only thing you could do is provide the ability for the user/client to upload the text file.

Peter
------------------------------------------------------
Work smarter, not harder.

I dont think so, there must be a way Im sure look for it! im sure u'll find some samples. use some sites & ur .NET Documentation.

Always:),
Hovik Melkomian.

ASP.NET can't. But there is a way. You have to use 'Smart Clients'. You also have to set the permission of the Smart Client to read so that it can gather the necessary information. Smart Clients are VB applications and they run in a sandbox on the user's machine. The user also has to have the .Net framework installed. And you have to have a Web Service enabled to receive data sent to the web server.

i think you could use the method of File Control to upload the client file to the server , i use this function to upload images to sever

    Function loadPicToServer(ByRef ofile As System.Web.UI.HtmlControls.HtmlInputFile, ByVal ServerVirtualDir As String) As String
        Dim strFileName As String
        Dim strFilePath As String
        Dim strFolder As String

        strFolder = HttpContext.Current.Server.MapPath(ServerVirtualDi r & "\")

        'Get the name of the file that is posted.
        strFileName = ofile.PostedFile.FileName
        strFileName = Path.GetFileName(strFileName)
        If strFileName = "" Then Return ""

        'Create the directory if it does not exist.
        If (Not Directory.Exists(strFolder)) Then
            Directory.CreateDirectory(strFolder)
        End If

        'Save the uploaded file to the server.
        strFilePath = strFolder & strFileName

            ofile.PostedFile.SaveAs(strFilePath)
            Return strFileName & " has been successfully uploaded."

        'Display the result of the upload.
        '''frmConfirmation.Visible = True
    End Function

if any one find a smartest solution or modification i would be appreciated for that.

Ahmed Ali
Software Developer