Using VB.Net and Sql Server Query
[Code]...
The above query is showing error as "Incorret syntax near a" What is problem with above query, whethere like condition is used properly or not.
i want to filter row and put it in a textbox and filter another row in another text box vb.
ex.
ID--------- Date -------- msg_num ------------ Message <<
10001 -- 01/01/2012 ------ msg1 ------------- Blah! Blah![code].....
Using SQL Server 2005 When i insert the date it should compare the date in the table. If it is equal with other date, it should display a error message and also it should allow only to insert the next date.For Example
Table1
Date
20091201
20091202
Insert into table1 values('20091202')The above query should not allow to insert the same value Insert into table1 values('20091204') The above query also should not allow to insert the long gap date.The query should allow only the next date. It should not allow same date and long gap date.How to insert a query with this condition.Is Possible in SQL or VB.Net
I cannot figure this one out.. I have a background worker that will perform a task streaming data from some webpages. this data is then passed back and displayed in a gridview. It has been working fine.
I've recently implemented a listbox, which its values will be passed into the function that the background worker will perform as parameters, originally i had taken a single value from a textbox.
Now, I thought maybe it had something to do with the listbox, so I used a static value, just a simple String, as the parameter, and again, I get the TargetInvocationException was unhandled.. There's no difference in how I perform the task I'm trying to have the backgroundworker complete, the only difference is where it exists in my if condition statement:
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles ScrapeSites.DoWork
Dim results As ArrayList
Dim worker As System.ComponentModel.BackgroundWorker = DirectCast(sender, System.ComponentModel.BackgroundWorker)
[Code]...
When two computers are connected through TCP, and one of them closes and breaks the connection, it throws error 10054 "Remote host forcibly closed the connection".I want to handle this error because I know it will happen more often than not with the application I'm building. In System.Net.Sockets.SocketException, there is an on the error code. But when I run the program, the exception that is being thrown is System.IO.IOException, and the GetType for IOException is the socket exception. I don't know how to handle the socket exception if it's not the root cause of the exception.
Here is the code for my Try Catch block:
For infiniteCounter = 1 To 2
infiniteCounter = 1
[code].....
posted again but this time its regarding both the webclient and the web reuqest giving me this error :S
View 1 RepliesI have an ASP.net web page with VB code behind linking to an MS SQL DB. On the web page I have 4 DropDownLists and 1 GridView. Each DDL is populated with a SELECT DISTINCT query on 4 corresponding columns from 1 table in the DB. What I would like to be able to do is: when any of the DDLs have their selected item changed the other DDLs are updated. Crude example:
[Code]...
I'm using Visual Studio Development Server (Visual Basic 2010) and it works fine. Now I've enabled NTLM Authorization because I want to test the website using a different user account. Now when I try to access the website I always get the following error page:
Server Error in '/' Application.
HTTP Error 403 - Forbidden.
Version Information: ASP.NET Development Server 10.0.0.0 .I'm using a test account which is a normal user within our domain. I've already set the access rights in my project folder to Full Access for this user but it does not help.
When I deployed my project on a server, in certain circumstances, I get an error page that indicates I should create a custom error page. I was wondering how exactly I would implement this custom error page the server asks for to give me a precise and helpful message or preferably, how I would get the error to just display on the main page?This is the error message I got below
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
I am trying to set the criteria for a data view row filter but I am getting this error:
[Code]...
I am working on an app where a user can do various calculations for a number of different tasks, each task has its own unique Item ID.The calculations are done in dgv's and all calculations get captured in the one datatable.I wanted to filter the datatable based on multiple criteria, if possible, and bind it to the dgv so that the user is only working on the calculations pertaining to that particular task.From what I have read, a bindingsource would allow me to filter my data in this way.In the code below, I have binding source that I am trying to filter and then present that filtered view in a datagridview.I keep getting a syntax error at the bindingsource.filter line that says Syntax error: Missing operand after 'ID' operator.It's the first time I have tried this and I don't know what is causing it
View 1 RepliesI am trying to copy upload files to remote server i get below exception.[code]...
View 1 RepliesI have several programs that I wrote in Visual Basic.net 2003 that I run from a server at work. We upgraded to Visual Studio 2008 recently and I converted my code to that version. I rebuilt the .exes and tried to run it from the server. It said I needed to upgrade the framework on the server, which I did. Now when I run the .exe file from the server I get a runtime error:
Runtime Error!
Program: d:...
This application has requested the Runtime to terminate it in an unusual way. Please contact the applicaiton's support team for more information.
These programs are very important to the day-to-day operations of the company I work for. I did backup the software before converting it, so we're running normally right now, but there are modifications and upgrades I need to make as soon as possible, but cannot due to the programs crashing when I run the on the server.
I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
[code]..... ...
the remote server returned an error: (503) server not available m getting this error...wen i m trying to extract email id from a webpage...
View 2 RepliesI m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
remote server returned an error:(503) server not available-vb.net
View 5 RepliesI'm trying to filter my access database and when I "search" by name, it works, but when I search by policy number it doesn't seem to work.
Here's my code:
If RadioButton3.Checked = True Then
Form3.Show()
Me.Close()
[CODE]...
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
View 5 RepliesI am running my application and at random times when it is unable to connect to the database I get an error saying "A Transport-level error has occurred when receiving results from the server. (provider, TCP Provider, error: 0- The specified network name is no longer available.) How can I stop this pop up from coming up? It comes up every once in a while and I want to disable that.
View 6 RepliesI am trying to upload a file to Mainframe machine from my VB.net application. I am getting the following error.The remote server returned an error: (501) Syntax error in parameters or arguments
[code]...
the next issue, that is only shown when the server is a Windows server 2008 machine , this is the information that I've found
[Code]...
Using vb.net 2005 - FtpWebRequest for ListDirectory always gets 550 error The remote server returned an error: (550) File unavailable (e.g., file not found, no access).
On both FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectory
FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectoryDetails
[Code]...
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) error: 26 - Error Locating Server/Instance Specified.
This error is doing my head in.I have a client running Windows XP SP3 logged into a domain. It is running MS VB 2010 Express to access the server.I have a Server called dataserver3 which from the client, I can do a start, run "\Dataserver3" and it comes up and yes I can browse to the Test.mdf file, which is a new database that was created using MS SQL Server 2008 R2 Standard edition.
[Code]...
When I tried to read the data of a http link using VB.net, an error occur. The error is:The remote server returned an error: (406) Not Acceptable.This error is only occur for some links.
View 2 RepliesI want to filter a text in all columns in a datagridview. So I use Like % in the filter text. However, I found that the text(strFilter in my code) may contain % sometimes. So it have a syntax error. How can I use filter with like clause when the filter text contains %?
Private Sub PassFilter(ByRef dataTable As DataTable, ByVal strFilter As String)
Try
Dim dataview As DataView = dataTable.DefaultView
[Code].....
I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
I bind a WPF datagrid to an ICollectionView. I want to filter my grid, so I am looking at the .Filter property. However I am getting an error on this line myColl.Filter = New Predicate(Of Object)(AddressOf Contains) and the error is: Specified method is not supported. My Contains Method looks like this
[Code]...