Search results

  1. D

    Question Catching the request failed with an empty response

    Hi Is there anyway to catch or display the request failed with an empty response message somewhere other then in a message box, for a example in a text box? Thanks
  2. D

    Question Remotely accessing db - winforms app

    I have a vb.net application, which I want to access a sql server 2005 from a remote workstation. When I run the application I get the following exception System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'. at...
  3. D

    Question Class Inheritance

    I have the following class definition Public Class Car Public ReadOnly MaxSpeed As Integer Private CurrSpeed As Integer Public Sub New() End Sub Public Sub New(ByVal max As Integer) MaxSpeed = 55 End Sub Public Property Speed() As Integer Get...
  4. D

    Sql Queries

    Hi When running such sql queries in vb.net SELECT * FROM VsrData WHERE RaceTitle Like '%{0}%'" and SELECT * FROM VsrData WHERE Venue=@Venue, what is required to perform the inverse query. Thanks
  5. D

    Identify cause of arithmetic overflow error?

    I have a vb.net application talking to a sql database, when I try to add data to the database I get a arithmetic overflow error. What is the easiest way to find the cause of Arithmetic overflow error converting int to data type numeric. It occurs when i run...
  6. D

    Question Sql Select from group by

    I have an application into which data on horse races is entered, I then click calculate to work out and save the top 3 horses into a seperate database. I am trying to find the highest value within any column in consecutive groups of 3 rows in a datagrid. The 3 rows are grouped using a flag in...
  7. D

    Compare Rows in a DataGridView

    Hi, I have batches of 3 rows, what is the easiest way to compare these 3 rows to determine which row has the highest value in a specific column within these 3 rows please? Thanks, Best Regards, BMM
  8. D

    SQL Substring Select

    How can I code sql substring select when the substring i am looking for can be of varying size and location please? At the moment I am using and I just have to modify it to work with substrings. Dim sql As String = "SELECT * FROM VsrData WHERE RaceTitle=@RaceTitle" Thanks
  9. D

    Resolved Select * from ...

    No data is returned to GridView even though matching data exists within my database. Can anybody please assist? Thanks Private Sub PsButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PsButton.Click Dim sql As String = "SELECT * FROM VsrData WHERE...
  10. D

    Question ConstraintException was unhandled

    I perform a calculation in order to add 2 or 3 rows of data to my sql server 2005 database. However I'm having problems stopping vb.net generating a exception for duplicate records. Private Sub SaveData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  11. D

    Hosting Windows Form Controls in Web Pages

    i'm trying to display a vb.net control in a web page, but all my browser (Internet explorer) displays is the placeholders with a little picture in the top left. Can someone please help? Thanks
  12. D

    Login?

    I have a vb.net app connecting to a sql database. When I run the app on the PC running Sql Server it logins ok. When I try and run the app on a different PC, I get the following error System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'. I am using the following connection...
  13. D

    Table Adapters and fillbywhere

    I'm in the process of modifying my project to work with table adapters only rather then a combination of table and data adapters. How do I set up my code so it displays data only containing the entered date? Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)...
  14. D

    Table Adapters Vs Data Adapters

    I have to access a SQL Database using a vb.net (net 2) winforms application. Would you recommend using table adapters or data adapters? Thanks
  15. D

    Saving Data Problem

    The line in red bold is generating the following error - Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. Can you please assist? Thanks Private Sub SaveData_Click(ByVal sender As System.Object, ByVal e...
  16. D

    DBConcurrencyException

    Sometimes the following code generates this exception - "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim sql As String = "SELECT * FROM...
  17. D

    System.Data.SqlClient.SqlException

    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value, Private Sub DataFilter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataFilter.Click Dim connstring As String = "Data Source=BM-PC;Initial...
  18. D

    System.Data.DataException

    Resolved - System.Data.DataException When I try to edit data displayed within my DataGrid I get the following error dialog. The Dialog Box is titled DataGridView Default Error Dialog and the message reads The following exception occured in the DataGridView: System.Data.DataException...
  19. D

    Row Count problem

    I am trying to add a delimiter to my datagrid, except instead of adding it to the desired row, it adds it to the preceding or proceeding row. Can you please assist? Thanks If (EOR_Limit = 0) Then EOR_Limit = Me.DataGridView1.Rows.Count - 2 + CDbl(RaceRunners.Text) EOR_Count =...
  20. D

    SqlException login failed

    I am new to Sql Server 2005, I am using vb.net 2005 to manually connect to the database but I am getting the following error Login failed for user 'BM-PC/B-Mustafa' Can you please advise? Thanks
Top Bottom