I just re did my question and added a few other scripts needed to pull everything together This is the small script I am using to receive the post and push the data into the SQL Server (2008 if that matters):
[Code]....
this is my code right now:
[Code]...
I have the following code which I mashed up from several sources:[code]This works great until I add another POST parameters to query, like "client=mgdf&version=100".No errors are thrown, the program doesn't crash, nothing. It simply stops working. How can I POST multiple values to my server?
View 1 Repliesi would like to ask for help, im trying to login to a server by httpresponse and http request. My code should get cookies and redirect to home page as login user, but for some reason i can't make it for.[code]
View 3 Repliesi have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 Replies<edit on 10th March 2010.>
Changed thread type to QUESTION. I was then able to mark AS ANSWER the relevent post which now also immediately follows this post and so it is easier to find as suggested by forum user j2associates .
<edit> It is also my 3rd post in this thread, the 8th one up, of my posts, from the bottom ( for now ), as the forum format has changed yet again.I will leave the rest of this post( as is ) purely for historical reasons. I have been on these forums long enough to see 3 forum changes. <edit> 19th May, 2010> Link added to a video on the next line of text.
[code]....
I have a VB.net app (which I will turn into a webform soon), my app generates a datatable of values (3 columns and on average about 1000-3000 rows).What is the best way to get this data table into an SQL Server? I can create a table on SQL Server no problem but I've found simply looping through the datatable and doing 1000-3000 insert statements is slow (a few seconds). I'd like to make this as streamlined as possible so was wondering is there is a native way to insert all records in a batch via ADO.net or something.
View 2 RepliesI'm trying to insert data onto a SQL server database. The Database connects up fine and retrieves data but I'm having difficulty inserting new data. [code] The query works if I run it through the table in database explorer and value of dim h shows 1 (rows affected). However, nothing gets updated.
View 13 Replieshow to insert some data on SQL Server database?i've tried this code, but it not works for me..here's the code:
Dim constring As String = "Data source=.sqlexpress;attachDbFilename=|DataDirectory|Database1.mdf;integrated security=true;connect timeout=30;user instance=true"
Dim connection As SqlConnection = New SqlConnection(constring)
[code]....
how to insert and update data into cache database which is setup as a linked server on sql server 2005.I mean to say insert / update query statement.
View 2 RepliesI would like to import the excel in to the sql server using vb.net. how can i do it? Another question is how can i execute the DTS using vb.net
View 6 RepliesI have small application in vb.net
I have one table in msaccess, which is having around 20,000 records,
now, I want to insert these records to remote server of mysql,
I tried as below code, it takes around 3-4 hours to insert data, dst in code is having all records from ms Access
[Code].....
INSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
[code]....
In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?
I have insert a data which is in binary format into sql server database table Column type of table is Image Type. I have to read this column from a XML file,I am able to read but
[Code]...
I have exported data from a SQL Server table into a XML file and the output looks like this:
Filename = 11190.xml
Table name = LRTest
<NewDataSet>
[Code].....
Now I want to save the above XML file into my SQL Server 2005 table
With the same columns using vb.net windows forms, in every exported xml file there are 100 to 200 records. .
is there any way i can do this? As normally you can use a BB code on the post. But when using POST string it says error. i'm not sure if its because of the characters in the URL which are giving it an error but i've added in front of " etc [URL ="http://url"]LINK[/URL] is the BB Code, how can i make this work please? as i'm currently using this in a text box then postings it.
ive tryed
[URL =""http://url""]LINK[/URL]
[URL ="http://url"]LINK[/URL]
*Had to add space before "="
How to correctly insert image data from XML file to database table using sql server CE and openxml,XML file is written by vb.net DataSet.WriteXml method?image data is stored in database table is :
0x89504E47.my XML file Content after written by WriteXml method is :
<?xml version="1.0" standalone="yes"?>
<Data>
<Table>
<image>iVBORw0KGgoAAAANSUhEUgAAAcIAAAGuCAYAAAADLg..</image>
</Table>
</Data>
but after inserting with openrowset and openxml using stored procedure to another database table its value changes to this :0x2F0039006A002F00340041004100510.and is not the first value and raises an error in vb.net for opening image from database.
Click and see this link if you are interested.url...Click this link to see the NEW way of how to insert a picture into a forum post.
View 2 RepliesI've been googling for some VB.Net code to authenticate to a web server with the POST method, receive a session ID in a cookie, and then send this cookie along with all GET queries... but all I found is half-working code or C# code, ie. difficult to use for a VB.Net newbie.
View 2 RepliesI'm using .Net. Is it possible for a web form to upload an image from a web or FTP server? The files I need to submit are on the web.
View 1 RepliesI've been trying to get this to work for days now, but I fail I have a very small HTTP Web Server using TCP sockets listening on port 80. I can connect and display html to the browser, parse GET parameters; but what I can't get is getting POST data. When I get a POST request, the headers and everything else come in fine, but the POST data is missing:
[Code]...
How can I send a POST HTTP request to a server (in Visual Basic 2010) and then receive the reply into a string.
View 1 RepliesI have a thumbnail generation routine that I created using WIC for a .NET app. It has been working fine for the past year, but we just migrated to a new server.
[Code]...
I have checked and the picture data is valid data. The exact same picture works fine if I run the code on the old server.
I'm trying to port an old VB.NET application to an Android application, but due to my lack of Java experience I am unable to find this one out. I have tried multiple solutions but to no avail.The idea is basically to do a POST request to 'url...' and getting the response cookies.[code]
View 2 RepliesWebsite dat have samples codes on HTTP GET/POST from a device server?
View 3 RepliesAccess <asp:table> table rows added by javascript in asp.net webform . Apologies for the duplicate question but I'd really like an explanation why this is the case. It is probably due to my lack of understanding on how browsers process HTML tables on submission to the server.If I have a <HTML> table or an <asp:table> control on an aspx page and I add rows to it client-side using JQuery / Javascript, why can I not include these added rows in a post-back to the server?
I've been trying to get this to work and it looks like I can't do it based on the answer to the previous question. But can someone explain why this is the case? The table itself can be returned in the post-back but the only rows present are the rows that were part of the table when it was sent to the browser originally - it does not include the rows added by the browser.there was a way to include these new rows in the post-back, the same as any client-side user input?
I am trying to send an HTTP Request to a server using a POST method. The problem comes from the PostData, which needs to be in Bytes form to be used by the UploadData function.
[Code]....
I want to know how to accept data from user? I want to accept about 10 datas from user. Before this I use Input box, but it is not a best way for user to key in 10 times data that required. What should I do and what the appropriate way to accept 10 data from user in 1 screen?
View 2 RepliesI've code this code below:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim hwrRequest As HttpWebRequest = HttpWebRequest.Create("http://www.example.com/web-service.php")
[Code]....
The MsgBox() at the end shows the response, which as I've added to my script, echos the result from the $user and $pass variables which are supposed to retrieve those details being written to the stream above, but they show up empty.
I'm retrieving those values by doing: $user = $_POST["user"]; $pass = $_POST["pass"];
I've found a scale, Detecto AS-350D [URL].. that hooks up to a computer. I was hoping someone could help me figure out how to get the information (weight) from it. I've looked around but can't seem to find any information on it. I've never wrote a program where I accepted data from a device likes this so kind of confused where to look.
Update: I'm coding in VB, and the device connects to the computer via serial port.