I have a zipcode database in mssql which has the zipcode, lat and long. I need to write a query in my asp.net using vb.net to show all records with a zipcode within a certain number of miles.
I have seen calculations to show the distance between two zipcodes but I need to find the ones within say 10 miles or 25 miles.
Let's say I have a LatLng , is there any way of checking if it represents a possible location within a city? How can I get the limits of a city? I'm using Google Map.
View 1 RepliesI've got a web method that is sending an email - and it's just taking too long to do the email. Anything I can do with multi-threading to have this code run without blocking the web method from returning the POST to the browser?
I do not care about the success of the email - I'm not passing that status back to the browser.
Code:
Private Function SendEMail(ByVal wholist As String, ByVal emailcontent As String) As Boolean
Dim emailSuccess As Boolean = False
Try
Dim strEMails() As String = wholist.Split("~"c)
[Code] .....
I have sql server table which consis customername and address. I want to create a page where user will enter address and select radius in miles from a pulldown and click on search, so it will return the list of addresses near by entered adress and entered radius miles.
View 6 RepliesFollowing the series of question, this is the code as of now has been developed and working fine. Now need to make some more tweek with this
1. Instead of distance from source to destination in KM can we have it in Miles
2. I need to show the distance between source and destinace only if destination falls under 25 mile radius from source else need to show the label message that no record found.
Here is the code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="sqlmap.aspx.cs" Inherits="sqlmap" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] ....
C# file
-----
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
[Code] ....
I installed MS SQL Express 2008 with Advanced Services including Management Studio 2008. When I connect to the SQL server of my provider (shared hosting - one SQL server for many customers), it takes very long (up to serveral minutes) until all DBs are displayed in the object explorer (from which I then have to choose my DB). Somebody told me, the long waiting time occurs because Management Studio first checks rights (whichever rights that may be) with every DB that runs on the server.
But in Management Studio 2005 the behaviour is different - the DB Tree in the object explorer expands immediately! No waiting time! Does anyone know a solution for this? I don't want to install two separate versions of Management Studio just because of that!
I've developed a web application to accept video file uploads and then pass them to a backend service on an external server. The application runs without error on the visual studio debugging webserver, but once on a production iis 6 or 7 server, yields a timeout error at about a consistent amount of time into handling a large upload. Specifically, it errors in the middle of transferring the video file to the external server, once the application has successfully received it from the client. I'm aware of several timeouts to be configured related to the problem, and have done so. The application's web config has been tested with one or both of the following settings
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
and
<configuration>
<location path="default.aspx"> (the page at issue that's timing out)
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
</location>
</configuration>
And within the initialization of the webrequest made to the external server to send the video received from the client browser:
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
httpWebRequest.ContentType = "multipart/form-data; boundary=" + boundary;
httpWebRequest.Method = "POST";
httpWebRequest.Timeout = System.Threading.Timeout.Infinite;
So with the execution time limits on both the webform as a whole and the connection made to the external server, I'm at a loss for what timeout is left unconfigured, or how to determine such, when I continue to get the following error: Unexpected error executing Brightcove Upload:...........................
Im trying to take the example from this website http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-2008-proximity-search-with-th and make it work on my site. Its this part im having troubles with
[Code]...
here is my code from my function that doesnt work.
[Code]...
Any suggestions on how to get it to work? it fails at rdr = cmd.ExecuteReader(); im also worried it will also fail at ZipCodes.Add(rdr["h.*"].ToString());
My exception handler is written like so:
Code:
Try
LoggerWrite("EX - Message: " & Ex.Message.ToString, "ErrorLog")
Dim myDE As DictionaryEntry
If Ex.Data.Count > 0 Then
For Each myDE In Ex.Data
LoggerWrite(" EX DictionaryEntry: Key = " & myDE.Key.ToString & " Value = " & myDE.Value.ToString, "ErrorLog")
[code]....
The user is getting a 500 internal error occurred. What he is trying to do is create a datagrid. The error only happens when there are a lot of data used to build the grid. But why exactly is it too much data? And can I increase a buffer or set something in a config file to allow all the data? The data come from a web service.
I am trying to update SQL 2008 to SQL 2008 R2 but it is asking me for my product key, which I don't know where its at. Is there a way to find it in the server, or something?
View 3 RepliesI have a dropdownlist in my eidtItemTemplate of my formview which gets displayed in a modalpopup.
I try to get the ddl object like this:
Code:
Dim rateddl As DropDownList = CType(Me.fvTimeSheetDetail.FindControl("ddlRateType"), DropDownList)
but I get nothing. weirdly I can find a textbox like this:
Code:
CType(Me.fvTimeSheetDetail.FindControl("txtNewTSTimestamp"), TextBox).Text
howcome the ddl doesn't get detected? what am I doing wrong? the ddl is definitely there and it gets populated
Have a Tab Container with 3 Tab Panels and trying to find the event that is fired when clicking the different tabs.
Tried to use "TabContainer1_ActiveTabChanged" but it does not seem to enter this event (tried with debug point but no hit).
In Visual Web Developer 2008, creating new sqldatasource connection, I not find ".NET Framework Data Provider for MySQL". I have already installed MySQL Connector/Net 6.2. I could add a reference to MySql.Data. Why!
View 3 RepliesI'm use to programming in vb.net and doing MsReports.I will add a DataSet with a datatable and then I will add a report.I will populate the report screen with the columns from my dataset which will be available in my toolbar on the left-hand side of my screen. It is a basic drag and drop action.I followed my usual steps in asp.net, but when I try to draw the report, I can't find my dataset.
Why is this?The dataset is named: "dsReport.xsd".The toolmenu where I should see this dataset is labeled: "Website Data Sources"
How do I find the windows path of an web site Application in .NET 3.5, and also the http path? I found a solution on the web but it didn't work, it seems to be slightly different for different versions of .NET.
View 1 Replieswhen i highlight and press CTR+F in visual studio te highlited word doesn t appear in find what
insie the pop up find and replace
I have installed VS 2008 and then i installed sql server 2005 with reporting services. But i couldn't find the Business intelligence projects template in VS 2008. Suprisingly i could find the Business intelligence project template in VS 2005 which was installed automatically when i installed Sql Server 2005 and there ware no other project types like Visual C# etc.show me a way to get the Business intelligence projects template in VS 2008.
View 1 RepliesThis is sudhir i am trying to work on business intelligence and i installed the visualstudio 2008 and sqlserver 2005 .But i am not bale to find the business intelligence template in the visualstudio 2008.
View 1 RepliesWhere can I find the expiration date of SQL Server 2008 Evaluation Edition? It's not in Help >> About and I don't see it in the server properties either.
View 7 RepliesI'm implementing an AJAX autocomplete feature where the user types into a textbox and the webpage generates suggestions (pretty much like how Google's search box works). I got the AJAX part to work right, but for some reason, my database query does not.Let's say I want to find "Chicago". Using the following query does not find it.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chi*')But using this query does.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chicago')By the way, "citynames" is an ntext type field and I'm using SQL SERVER 2008.Does anyone know why my first query can't find "Chicago"? I've been staring at that query for hours, yet can't find anything wrong with it. Something wrong with the database maybe?
View 2 RepliesIf VS 2008 and VWD 2008 are both installed on the same machine, will they both use the same Projects folder to keep my projects in?If so, can I open the projects and run them interchangeably with VS2008 and VWD 2008? This is the folder that is located at " User>Documents>Visual Studio 2008>Projects
View 1 RepliesI am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI want to change the text of the user name text box which is inside a log in view on selected index chaged event of a drop down list.
this is my code:
[Code]....
but both ddl and tb are null
Anyone knows how can I find the controls in code behind?
guess it's straightforward. On page load, i wanna check the group of which a particular belong to. Say, someADNameeckham belongs to Account. In that case, I only wanna get "Account". But I have no idea how to get the group name of a particular user belong to. It's for LAN web portal so I guess security is not a very big concern here.
View 5 RepliesWhat are your most successful ways of running a long process, like 2 hours, in asp.net and return information to the client on the progress.
I've heard creating a windows service, httphandler and remoting can be successful.