I am trying to get the html response of a Kayak.com query using a WebRequest object, however more often that not the site returns no results, i just get an empty Kayak page, i have to try the request around 5 times before i get a result back. What can be the cause of this? [Code]
View 1 Replies
I am developing an ASPX web page to return results from two SQL stored procs via VB. When I execute these two stored procs, they both return valid data. But for some reason, when I run this report it doesn't return any errors, however, it doesn't return any records/data either!
Also, I can't debug it for some reason, although I can set breakpoints! This is using VS 2008, but I think reason I can't debug is I believe this is a limited version that just works for SSRS and SSIS.
[Code]...
Could the problem be due to the fact that this web page uses the same SQL connection for both stored procs? The first proc should be returned initially, and the second proc after this screen. So I don't need both stored procs information simultaneously, so I would think I could reuse the same SQL connection.
OK, I found where the problem is located. If I just comment out the Level statement in the Where clause, it does return data. So only thing I changed was that one line in my SQL code and it works. This means missing data must be due to datatype incompatibility, no? What is the problem?
Alright so I have a webrequest on my program and it requests a login page, and I use the streamreader to read the webrequest and I set a textbox text as the text that I get from the site after the webrequest. The text I get is something like this:{"Code":null,"ConfirmationId ": 3023,"Description":null,"MessageType":"Success")I am wondering how do I get it to only get the text confirmation id (in this example it's 3023) and not the whole page.
View 2 RepliesI'm trying to make an executable in VS2008 that will read a webpage source code using a vb.NET function into a string variable. The problem is that the page is not *.html but rather *.aspx.I need a way to execute the aspx and get the displayed html into a I have tried the following code, which works properly for html pages, but generates the wrong source code with "access denied" for the page title when I pass in the above aspx page.
Dim myReq As WebRequest = WebRequest.Create(url)
Dim myWebResponse As WebResponse = myReq.GetResponse()
Dim dataStream As Stream = myWebResponse.GetResponseStream()
[code].....
I would like to create a vb form with a combo box (with song title), a text box (for song lyrics), and a button (to submit or refresh). It is linked with an access database. The combo box is populated with the songTitle field in the db (this part works fine). The text box is populated with the lyrics that go to that song The first updates fine but I can not figure out how to run a query to pass to the text box's text property. I want the user to be able to select a song from the combo box, click the button, and have the text box populated with the new song's lyrics.
Any suggestions on how to accomplish this, or a good place for a tutorial that explains the necessary elements for having vb query a database and return the results?
I'm trying to return a single object from an array of objects with linq.[code]...
View 2 RepliesI have been trying to get the Alert Code from my printer at work to see what exactly is happening however each time I send an SNMP query it doesn't return any results. I am using SimpleSNMP references. The printer is a Canon iR-ADV C5045.
This is how I call the function:
Dim strAlertCode As String = SNMPQueryGet("1.3.6.1.2.1.43.18.1.1.7")
This is the function:
Private Function SNMPQueryGet(ByVal OID As String)
Dim strResult As String = "True"
Dim host As String = "192.168.1.202"
[Code] .....
So the exact site I'm trying to login to is GMail. I can send the POST data to login fine, but after that GMail performs an authentication (the redirect URL contains 'SetSID?'). Now with my HTTPWebRequest I don't see a way to enable support of HTTPs requests. Is there a way to get around this and successfully login?
View 4 RepliesHow can i select using linq from a datatable where the the only results I want back (ID's) are contained in a list of integers?
View 7 RepliesSo basically, I am running through my selected path recursively and returning the results to an array.. I think.
vb.net
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim path As New FolderBrowserDialog
If path.ShowDialog = Windows.Forms.DialogResult.OK Then
Me.TextBox1.Text = path.SelectedPath
[Code] .....
I was told that to return the search to an array, I add the return toarray() at the end.
Now obviously Im not getting errors, but I am also not polling the results that are in fileslist.toarray(). I've looked at arrays quite a bit, I see their functionality if they are defined like myarray(4) with 5 declared array values... its an array with 5 value places. And to read from any one of the 5, you'd say something like msgbox(myarray(3)) to call the 3rd place in the array.
Well, as you can tell from the code, I am putting a variable amount of information into the array, How can I call that information? If I scanned a folder with 300 files, how can I call the results of that array and put them in a text file, or console, or messagebox through them? And assume I am doing it through a button click event. So, button click to read all input in the array to console or something like that.
Currently I have a gridview bound to a datatable which is populated with groups from the AD. I need to be able to add search functionality so users can type in part of a group name and have the results display only groups that fit their search criteria.
Here's what I have so far.
<asp:TextBox ID="searchParam" runat="server"></asp:TextBox><asp:button ID="btnSearch" runat="server" Text="Search" />
<asp:GridView ID="dgSearchDLs" runat="server" AutoGenerateColumns="False" DataKeyNames="cn" DataSourceID="ObjectDataSource1">
<Columns>
[code]....
I'm using Visual Studio 2005, and I have a datagrid connected to a table from an Access database.
I added 4 textboxes so the user can type search filters to search within the table and a "search" button.
Then, I created a query using the "add query" tool on the datagrid. I wrote it like: select field1, field2, field3, field4, field5, field6 from table where field1=? and field2 like "%"+?+"%" and field3 like "%"+?+"%"
and field4 like "%"+?+"%"
Both field5 and field6 aren't search criterias, so I didn't add them to the query. Once the query was created, I replaced the parameters inside the procedure with my textbox1.text, textbox2.text, textbox3.text, textbox4.text and then cut and pasted the whole thing inside my SEARCH button click event, so the query is executed when the user clicks on the button.
Now the problem is: when I search using the first field it goes ok, but when I try to search by any of the other fields it returns zero results, even though I double-checked I had written the words correctly. I don't know why it does this. I already tried deleting the datagrid and creating it again.[code]...
I have a linqtosql dbml where I dropped a stored procedure into the designer interface.
Stored procedure name:
GetUser(@userid int)
Select * from users_tbl where userid=@userid
[code].....
I am running a query in a thread but I can't figure out how to get the result back to the calling function. I am doing something like this:
Threading.ThreadPool.QueueUserWorkItem(AddressOf RunThread, "some query string")
Private Function RunThread(ByVal stateInfo As Object) As String
Dim myQuery As String = stateInfo.ToString
[Code]....
[code] BUT, in code, watching the locals window for rec.EOF and rec.BOF both return true and therefore no results.Why does this work in VB Query Designer but not in code? If I remove the WHERE statement than the results return fine as expected.But its returning ALL of the results which is no good.
View 1 RepliesThe following code works just fine:
Dim wksSheetNames(0 To xlsWB.Worksheets.Count - 1, 0 To 1) As String
Dim i As Integer = 0
For Each Wks In xlsWB.Worksheets
Wks.Activate()
wksSheetNames(i, 0) = xlsApp.ActiveSheet.codename
[Code] .....
What is the best vb.net based search method that would permit me to search for i.e. "Sheet2" and be able to obtain "Cats"? I attempted to ascertain the index number of "Sheet1" with:
Dim SheetArrIndex As Integer = Array.IndexOf(wksSheetNames, "Sheet1")
Then obtain the value "Cats"
wksSheetNames(SheetArrIndex, 1)
But I received an error message:
Code Line ->>>> "Dim SheetArrIndex As Integer = Array.IndexOf(wksSheetNames, "Sheet1")"
Error msg ->>>> "Only single dimension arrays are supported here.:
Obviously I do not know how to Search and Return the results of a 2D array.
Sorry for new thread--i have this code, basically a loop to ping a list of ip's return the results and save them to an access db:
[Code]...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
Trying to find some code to assist with accessing a web service. I am a newbie when it comes to web services and don't quite get the whole how to submit the request and then read the results. I know from searches that people request a copy of the WSDL file so I have attached (SystemManagementService.wsdl)
[Code]...
I have the following page and what I'd like to be able to do is that when the user clicks on the clear button that it disposes of the results of the datagridview and reloads the page.
Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub whosoncallButton_click(ByVal sender As Object, ByVal e As System.EventArgs) Handles whosoncallButton.Click
[Code] .......
im just wondering does anyone know how to prnt a page of results, and get a print preview using visual studio 2010 and asp.net 4.0.Im pulling students exams results into a gridview and have the class averages etc showing in a label on the academics page. However i need it to print this page, and also to have a print preview.
View 1 RepliesI have a working code that exports the datagrid into XLS. However, the datagrid results does not show on my aspx (html) page. It only shows on the page when I comment out the part that exports it to xls. I am not sure whether it should show by default when exporting.Basically, what I want to have is when I click my export button, it should display the datagrid on the page as well as popup an excel "open, save, cancel" window for the export.
Here is my function for referece:
Public Sub Convert(ByVal ds As DataSet, ByVal Response As HttpResponse)
Dim attachment As String = "attachment; filename= ExportPRFs_" & Today() & ".xls"
[code].....
x = 4.2 - 0.1
vb.net gives 4.1000000000000005
python gives 4.1000000000000005
Excel gives 4.1
Google calc gives 4.1
What is the reason this happens?
i have an Ajax ActionLink which normally just returns a PartialView (which is just a UserControl ascx file) however, my needs have changed and i want to return another PartialView (so a total of two PartialViews) that occupy different areas of my page... of course i can't call " return PartialView("UserControl.ascx") " twice in a row consecutivelly... so my question is what would be an elegant work around for this?
how can i return two PartialViews WITHOUT wrapping these two PartialViews up in a larger parent view? i hesitate to do this because both items are in a different part of the html table which would require me to include practically the entire page in the parent view due to the structure of the table, and in this case lots of html data unnecessarily would be sent to the browser at each request - defeating the purpose of an ajax call/partial update (correct me if i'm wrong).
I have a main page. How can I open a new web page (Url assigned in code) and get the return URL back in VB event when the page is closed.I have used a regular Button control to open the page with desired url: Button1.Attributes.Add "onclick", "window. showModal Dialog('" & url & "')")but I don't know how to get the REtURN URL from this page.
View 1 RepliesIm trying to create a software which can post into yahoogroups.I've done trying to log in yahoomail but my problem is when I am going to post in yahoogroups, I am turning back in to yahoo log in page.
Here's my code so far:
Quote:
Imports System.IO
Imports System.Net
Imports System.Text
[code]....
I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?
View 1 RepliesI have a text input in textbox1 in tab page 1 and i want that text from textbox1 will be displayed in textbox2 in tab page 2.
View 3 RepliesI wrote a page Page method in my aspx page. in web service method I need to call FindControl method return textbox and get text box value. But my findControl will take MasterPage object to iterate.
see my code
<script type = "text/javascript">
function ShowCurrentDateTime() {
$.ajax({
[Code]....
How to pass Master Page object or Page to Page method?. So I can use in Sared method.
Is there any way I can access Textbox value directly in Page method? I need access couple of controls in Page Method.
HOW TO RUN THE JAVASCRIPT FUNCTION ON PAGE ONLOAD EVENT IN CONTENT PAGE OF MASTER PAGE.? means i have masterpage and the content page of master page namely default.aspx in vb.net.i wanna run javascript function in Default.aspx and i have called the function body onload in master page.when i run my website it shows the error "" Microsoft JScript Runtime Error : Object Expected ""
View 4 RepliesI need sample vb.net code to save single windows form as many page and reload the page whenever i call that page...
View 1 Replies
