Re: Passing a Parameter to a Form when Opening

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cor (non_at_non.com)
Date: 02/18/04


Date: Wed, 18 Feb 2004 14:06:06 +0100

Hi Paul,

The best thing is first to look at the capabilities of the SQL server
version you are using.

For searching that is not for all the same and there are lot of different
possibilities.

I hope this helps?

Cor

> I have a form called frmCustSearch to search for customers against an SQL
> Server database.
>
> The form contains a simple textbox into which the Customers surname is
> typed, and a datagrid then becomes visible on the form containing the
> CustID, Surname, Forename and address of all people with that surname.
>
> The correct customer is then selected from the datagrid and I want to open
a
> new form called frmCustomer to display all the details for that customer,
> using the CustID as an argument when opening the form so that it can
> retrieve the customer record from the database during its load event.
>
> This is similar to using the OpenArgs in MS Access.
> But how do I achieve this in VB.NET?
> Your help is much appreciated.
>



Relevant Pages

  • Re: DELETE FROM - Somethings not right
    ... delete from customer where custid in ... delete from customer where custid> 2295885 ... indexing foreign keys can seriously hurt DELETE performance. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • RE: Passing a Parameter to a Form when Opening
    ... Customers surname is ... >The correct customer is then selected from the datagrid ... >using the CustID as an argument when opening the form so ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: same application on multiple schemas
    ... As for the "comparison" with Sql Server, it was not intended to ask ... why Oracle does "not" support sql server behaviour:) I know oracle (I ... For every customer that will use our application, ... will use schema "SchemaA" ...
    (comp.databases.oracle.server)
  • Re: same application on multiple schemas
    ... As for the "comparison" with Sql Server, it was not intended to ask ... why Oracle does "not" support sql server behaviour:) I know oracle (I ... For every customer that will use our application, ... will use schema "SchemaA" ...
    (comp.databases.oracle.server)
  • Re: Modeling/Constraint question
    ... there are no duplicates in the keys; ... Enter: the surrogate key. ... there is a customer number. ... SQL Server community, why should believe anything else you say? ...
    (comp.databases.ms-sqlserver)