Jquery - Passing Client Data To Server To Create Excel Or CSV File?
Jan 9, 2012
I'm creating a reporting web page as part of a standard VB.NET web application. The page is data driven, with jquery making calls to a web service local to the application to get values of elements that are dynamically created in the DOM. Ultimately these dynamic elements and their values are all wrapped up in a JSON object, so that part of the client side is fine.
Right now, I can pass that JSON object to a method in the web service which creates an SQL Data adapter from the values and queries a database. My ultimate goal is to have this client JSON data be used to query the database and construct an excel file to send back to the user, or failing that a CSV file.
It's my understanding (from working with PDF file generation) that this type of function can only be done on the server side of the web application, not even from the web service (i.e. I can't have the web service return an array of bytes and have JavaScript/jQuery present that as a file).
So, how do I go about this? Now I have my JSON object on the client side, where should I be sending it, how, and how do I go about returning my file?
I've read about either storing the JSON in a hidden field and having the server take the elements value and go from there, or using AJAX to send the JSON to the server just before a postback is made to fire off the server-side function to run the query and return the data.
I just need a little guidance, and a little help understanding where to use the hidden field, or what I am actually doing with the pre-postback AJAX call.
View 1 Replies
ADVERTISEMENT
Jun 27, 2011
Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
View 4 Replies
Nov 15, 2011
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
View 1 Replies
Dec 1, 2008
I have been reading through Atheists posts in regards to client-server and TCP client/server connection's. But how do i go about writing a program with 1 client and server where the client side creates a text file.Once the server sees there is a text file it connects and downloads it to itself or the client pushes the text file to the server.Once on the server i will read the text file and put its info into a sql db.
View 14 Replies
Oct 20, 2010
IS there any way in vb.net through which we can browse for an excel file upload its data in data grid view and save into sql server.?
View 9 Replies
Jan 20, 2011
I want to import an excel file in .net. Excel file resides on server. when I try to imort the file using below code , i am getting error.
Protected
Function
ExcelConnection() As
[Code]....
If i import excel file from local drive its working fine. But when i try to import excel file from server(URL of file) then i am getting error.
I am getting error(Oledbexception Failure creating file.). how to import excel file that in resides on server(file is not on my local drive, i will access file through URL).
View 3 Replies
May 9, 2009
how to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
View 9 Replies
Jun 7, 2009
I am trying to create a a server and client application. All that I want to do is have a client that has a picture box. The server will send an image to the picture box and the client will display it. I have looked online to find some tutorials but most of them just show how to do a connection and usually only with a console application.
View 3 Replies
Oct 17, 2011
I have been a web developer for a number of years now and I am making the move over to form based applications. I am trying to do what I believe should be relatively simple, yet I have no idea where to start.At home I have a machine that family members tend to use P2P programs, which causes my online gaming to suffer with glitches.I want to create a server and client program.where the client app (on my laptop) consists of only one button, when the button is pressed I want the server app (my Desktop) to kill the P2P program.I already know how to kill/start the application in question.I have previously done something similar but I had used winsock (not in VS2010) and was a long time ago.
1) Sending a value/string from the client app
2) receiving the value/string on the server app
I was told to look into the system.net.sockets namespace, but I haven't found anything on the web or here that isn't a full project / over-engineered "Basic Tutorial" that helps to break this down
View 5 Replies
Mar 20, 2009
I Want To Create A Server Program On My Computer AndClient Program That Can Run On Other Computers, The Client Program Will Connect To The Server On My Computer, But I Don't Know Code To Do This.
View 1 Replies
Jul 8, 2011
Create an UDP Server/Client Application?
View 3 Replies
Jul 9, 2009
I'm trying to connect to Advosol OPC UA demo server [URL] from vb.net application I'm developing, but i can not create refernece to its service interface. As much as I understand UA specification, server is based on WCF and shold expose WSDL to create web reference to it. The problem is that I can not access that WSDL definition on service url. The only message I get is that MEX is disabled for service and list of instructions how to expose mex in appconfig. I triead all the suggestions, but mex is still disabled.
View 1 Replies
May 7, 2009
I am trying to create a server/client program in vb.net. What I am trying to do is test a battery that is running on a handheld (which runs Windows CE 5) by connecting to a "server" and sending information every 10 seconds or so. I am very new to .NET, and am not really sure how to go about doing this. I want two separate applications running, with the server-side keeping all of the data, since the battery is going to die, and I will lose any information if I keep it client-side. I am also new to networking, so I was not sure of whether I should create a Socket, or if I should try to do something else.
View 1 Replies
Jun 30, 2009
i wan't to create a tcp client and server
Client contains 1 textbox
Server contains
dim pcdetails as string
pcdetails = "Operating System Name : " + My.Computer.Info.OSFullName.ToString + " ; " + "Platform : " + My.Computer.Info.OSPlatform + vbNewLine + "Operating System : " + Environment.OSVersion.ToString + " v." + Environment.OSVersion.Version.ToString + vbNewLine + "Computer Name : " + Environment.MachineName.ToString + vbNewLine + "User Name : " + Environment.UserName.ToString + vbNewLine + "System
[code]....
View 7 Replies
Apr 1, 2009
I have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
View 1 Replies
Dec 6, 2009
Im a new in this VS2008. But i have some foundation of programming in VB6.0. So im planning to create this application using VB since im familiar in that language.I downloaded a Visual Studio 2008 and SP1 - now on its 90-day trial, and planning to buy the full version depending if it will meet my needs. I just read afterwards the conditions and how to buy it. I hope its free shipping and credit card is acceptable.^^
I need to make an application something like a reporting system, my plan application is a client-server application. Currently im reading the How to topics and some walkthroughs so far so good. Now here are some sort of details and target need to fulfill.
1. An interface from client that will input the data from the multiple-user , including images and these data will be saved in database/table remote server (center database server) LAN.
[Code]...
View 3 Replies
Dec 15, 2011
I have to create a Client/Server Application...for a project...Its not a programming class so the Professors allowing us to look code up online and just use that...Can anyone help get me started, Ive found some code but most of it uses TCPListener and Visual Studio says this is obsolete. An I can't get the IPaddress to be declared either..
View 1 Replies
Mar 23, 2003
UDP multicast client and server chat application.
View 10 Replies
Aug 14, 2011
I'm a noob to VB, so new in fact I had posted a question to the VB6 and earlier, I do believe I am using .Net Anyway, as I say, I'm new to VB and am hoping somone can help me. I am trying to pass data from an excel spreadsheet into a combo box, I've added the reference object library. Here's the
[code]...
To run this you'll need a combo box, and an excel spreadsheet added to your desktop. Of course you'll need to change the path to the spreadsheet to whatever you choose. After doing so, I get an error that I don't really understand.
View 1 Replies
Apr 19, 2011
I have a small program which is a tcp client. I send a string from this client to a device over ethernet (it acts as the tcp server). As soon as the device recieves the input string it will respond back with response data. My problem is i am not getting the entire response data back from the server. (device).
Dim serverStream As NetworkStream = clientSocket2.GetStream()
Dim outStream As Byte() = System.Text.Encoding.ASCII.GetBytes("my-cmd")
serverStream.Write(outStream, 0, outStream.Length)
[code]....
View 4 Replies
Nov 2, 2011
We would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 Replies
Nov 29, 2011
I'm using MVC2 with jquery.I'm trying to open a partial view in a jquery Dialog container, passing an itemID of an object to be deleted.What I'm doing to accomplish this is passing in an action that renders a view to jquery, which I can get to work without variables.f I try to pass in the ID of the object to be deleted, the action doesn't even trigger.
Here's my jquery code:
$(function () {
var itemToDelete
[code].....
View 1 Replies
Jun 21, 2010
We are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
[Code]...
View 2 Replies
Jan 6, 2010
However I have hit a massive brick wall with my program. My program that I'm trying (can't emphasis this word the importance of that word) to create a Client/Server chatroom using TCPClient in Visual Basic. So far I can get my client to speak to my server. However, i'm trying to get the returned data to display in a listbox which never happened, i then tried a label, which again never happened then a text box which I'm sure you can figure out how that went! I'm not great at networking programmers nor am I not bad I'm terrible but duty calls when it comes to projects.
The code I currently have was mostly taken from the net but when I have the program fully work and I understand how the software works I intend to heavily modify for it to suit the needs of what I need to achieve. where I can get my client to display the data from the server that I have already sent to the server (which displays successfully within the server).
[Code].....
View 2 Replies
Feb 26, 2010
Can you compress data being sent from client to server and etc? If so how would i do this?
View 2 Replies
Jul 12, 2011
i am creating a software that needs to transfer data between client and server. i m storing the data in client in a database. but how does server access every clients data.
View 9 Replies
Jun 30, 2011
I have a Linq query on the server side of a Silverlight 4 Ria project that returns a number of distinct items based on a time period(Month).The problem I am getting is when the client callback fires the data has been corrupted and all the items returned from the server are duplicates of the last item in the collection.
Server Call
Public Function GetBusinessHeadCountHistory(ByVal businessUnit As String) As IEnumerable(Of EngineeringHeadCountBusinessHistory)
Return From t In ObjectContext.tblTimes
[code]....
View 2 Replies
Aug 20, 2010
I have programmed a chat application in VB but as soon as I send any data from a client the server will send it to all. It should send a reply only to a particular client. This is the function I have used.
[Code]...
View 1 Replies
Nov 12, 2011
I've been working on this project for about a year now. It's a basic clientserver chat program. After a long time of improvement, I decided to test out the strength of my server.
On the client, I fired off 200 chat messages ("FLOOD# 1"... "FLOOD# 200") to the server as fast as possible. The result: Server immediately crashes. After some slight tampering, I was able to get the server to process 135 of the 200 messages before giving up. It no longer crashes, but something different happens. The data from the client is received in order, but when I pass that message to a function (myForm.OnLineReceived), The data is completely out of order. If I add a slight delay between the calling of the OnLineRecieved function, The messages are in perfect order.
Each message from the client is first encrypted, then encoded in base64. An "-" is appended to the end so that the server can easily find the end of each data "packet".
Server Code:
Imports System.Net.Sockets
Imports System.Text
' The UserConnection class encapsulates the functionality of a TcpClient connection
' with streaming for a single user.
[Code].....
View 3 Replies
Sep 23, 2009
I am going to create a gaming platform primarily with flash,flex and was also looking to create a windows client that could communicate with my server using these protocols. Could someone point me in the right direction on any possible .net libraries available that could handle the communications between client and server?
View 2 Replies
