Sending Entire SQL Query Over Winsock?
Aug 20, 2010Using vb.net Winsock Can we send SQL Query from Server to client?
View 1 RepliesUsing vb.net Winsock Can we send SQL Query from Server to client?
View 1 Repliesorder to attach a file to a mail using winsock. I use the following code to send the mail and it works OK
View 3 Repliesthis is my vb.net code -
in the subroutine i have -
Private Sub xxx()
[code].....
I know how to send emails using mssql and vb.net but I cannot figure out how to send an email with an attached sql query results using vb codes.I tried to use SqlDataReader and XmlReader but cannot seem to send the entire row read from a table.What�s the best approach?
View 5 RepliesI have a query that returns Lname, Fname, and Email. I want to send 1 email (that Is already set up and working) that contains the results of the query as part of the body that includes an additional message; "The persons listed below.........." Need to know how to get them "listed below". Then I want to send a separate e-mail to each email address the query returns, separately not in a group but the same message.
View 19 RepliesI have a field called "payor" where the user selectes either "All, Medicare, Managed care" from a drop down list. I am sending the value of payor to the Fill query once the user selects the one they want.
I have no problem with coding 'Where (payor = @payor) if the user doesn't pick ALL, but what code do I need to include ALL records if the user selects "ALL" in the where statement?
I am trying to Send an Email with an attachment (using Gmail) but I keep getting errors like "Operation Timed out" or Failure Sending Email". It was working earlier today but I found out that i needed to add Using statement because the email was having a file open that had to be deleted after it was sent but afterwards it doesn't work.
Here's what I have (Portion of it):
Private Sub SendMailOneAttachment(ByVal un As String, ByVal pass As String, Optional ByVal smtp As String = "smtp.gmail.com")
Using oAttach As Net.Mail.Attachment = New Net.Mail.Attachment((Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) & "\" & My.Computer.Name & "_" & fName & " .zip"))
Dim client As SmtpClient = New SmtpClient(smtp)
[Code] .....
The ports are correct I believe, no firewall up on my PC...
Which is better for Sending Files/Sending Images/Msg for P2P Chat?
View 1 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
How can I use winsock in VS 2008? I can't figure it out..
View 1 RepliesI am doing my project in vs 2008 for WIFI transfer . We have to use winsock control to do this but in vs2008 there is no win sock control.Later we found that it is available in vb6.So i am trying to do in vb6.Can u assist me to develop coding to transfer data from one PC to another through WIFI?
View 1 RepliesHow do I properly add a Winsock Control in WPF for purpose of LAN applications? I tried adding the Winsock control dynamically but then the event functions are not available then.
View 1 RepliesIs this possible and how?Is it hard code or can i learn it?
View 1 Repliesi kinda need one.. i know how to make it work in vb10 by upgrading it from vb08, but i need to put it in a allread existing vb10 existing vb10 project, whit multitrheading.. so i cant use .net 2.0
View 9 RepliesI have project it use Winsock component if i take Open and Send Data in the same place it error
[Code]...
How can I add winsock Control in my toolbox?
View 1 RepliesHow to add winsock listener in Vb 2008
View 1 RepliesI'm in college and I want to show my friend how to use winsock but for some reason, I can't add the Winsock control through references. Is there any way to load it through code?
View 3 RepliesI'm working on a server/client chat program in vb 2008 using winsock. I have a connection and can send data, but for some reason I can't receive data. [Code]
View 2 RepliesI'm trying to connect two programs using winsock, I connected it, but I want to send to the server to do some thing like open the camera . or do any thing .
View 1 Repliesi have a problem with my console in vb 2010 ! in windows form applications
we can use this event for winsock control:
i have added 2 winsock controls on form at server side and client side and used 2 different ports 1001,1002both winsocks gets connected i used condition winsock2.state=sckconnected and it shows that connectedi want that at certain time winsock2 will send data the timer gets activatedi put breakpoint on winsock2.senddata() in timer_tick() event the line gets executedbut at client side on winsock2_dataarrival() i put a msgbox() but it never popup
Server side-
vb.net
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
Recently I was handling a TCP/IP server-client window-based program in VB.NET. But in VB.NET. after I include the winsock on it, it cannot check the state. Normally, in VB6, to check the state is as below: If
[Code]...
I am making a chat program.
I use
Private Function winsock1() As Object
Throw New NotImplementedException
[code].....
I'm trying to put a winsock control into my app using VB 2008 but I'm reluctant to find it. Is there one in this version?
View 2 RepliesActually i want to add a "Refresh button" at the client side such that when it is pressed some specific lines should be executed at the server side.(e.g. when the "refresh button" is pressed at the client side, the server should evaluate some variable "data" and executes this line "winsock.sendData(data)" ) OR Can i set my server to refresh every 30 seconds or so to evaluate some variable and then execute the line "winsock.SendData( )"? is there a way to accomplish any of the above?
View 1 Repliesmy client/server desktop application that i created in vb.net.....
(1)Actually i want to add a "Refresh button" at the client side such that when it is pressed some specific lines should be executed at the server side.(e.g. when the "refresh button" is pressed at the client side, the server should evaluate some variable "data" and executes this line "winsock.sendData(data)" )
OR
(2)Can i set my server to refresh every 30 seconds or so to evaluate some variable and then execute the line "winsock.SendData( )"??
how to send file using winsock in vb.net and i don't found
View 4 RepliesI cannot get WinSock running. I am running XP Pro, with VS2008. I have downloaded mswinsck.ocx and installed in the c:windowssystem32 and syswow64 directories and ran regsvr32 C:windowsSystem32MSWINSCK.OCX and regsvr32 C:windowsSysWOW64MSWINSCK.OCX. I have added it to my tools panel. Once I add the control to my form, the form will not run. I get the error below. It I cannot even run other winsock examples.
[Code]....
Ive been trying to get this tcp server to work it uses winsock, I can connect to the server fine but as soon as i send a messege It errors with this messege Unable to determine size of incomming packet. It's possible you may need to use Legacy SupportWinsock_Orcas.AsyncSocket.ReceiveCallbackWhat does this mean?note: vb isnt making this error the program itself is, a link to the project is:I think error might be the cause of all the failures of Tcp servers i have tried how it would only recieve
View 3 Replies