Re: Typed dataset - how to I alter SelectCommand

Cor - here's the method I tried but it isn't working - the query should
crash this code (because it doesn't exist) but the code runs fine. Can you
advise where I alter the command before filling the dataset?

Thanks,

DG
using System;

using System.Data;

using System.Data.SqlClient;



namespace NorthwindDataAccess.CustomersDataSetTableAdapters

{

public partial class CustomersTableAdapter

{

public void UpdateSelectCommand()

{

SqlConnection conn = new
SqlConnection(NorthwindDataAccess.Properties.Settings.Default.NorthwindConnectionString);




SqlCommand cmd = new SqlCommand("customer_qry", conn);

cmd.CommandType = CommandType.StoredProcedure;



this.Adapter.SelectCommand = cmd;

}

}

}

And try to call this code from Form1 as follows:-

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using NorthwindDataAccess.CustomersDataSetTableAdapters;

using NorthwindDataAccess;



namespace NorthwindGUI

{

public partial class Form1 : Form

{

CustomersTableAdapter m_Adapter = new CustomersTableAdapter();

CustomersDataSet m_Customer = new CustomersDataSet();

public Form1()

{

InitializeComponent();

}



private void OnFormLoad(object sender, EventArgs e)

{

m_Adapter.UpdateSelectCommand();

// This shouldn't work as there is no 'customer_qry'
stored proc in the database

// - but it does...

m_Adapter.Fill(m_Customer.Customers);

...etc...

}

The 'UpdateSelectCommand' doesn't have any effect on the adapters select
command.
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:Ob5xvwWfGHA.1272@xxxxxxxxxxxxxxxxxxxxxxx
DG,

You can at any moment before the fill change the Command (which is the
SelectCommand) in a DataAdapter

Cor

"DG" <djg2002@xxxxxxxxxxxxxx> schreef in bericht
news:e4q4pt$eq$1$8300dec7@xxxxxxxxxxxxxxxxxxx
Hi,

Can anyone advise how I alter the SelectCommand in an auto-generated
typed dataset programmatically? The select command would be part of a
search condition built by user inputs in the GUI.

Thanks,

DG





.

Relevant Pages

  • Re: Typed dataset - how to I alter SelectCommand
    ... you advise where I alter the command before filling the dataset? ... public partial class CustomersTableAdapter ... And try to call this code from Form1 as follows:- ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed dataset - how to I alter SelectCommand
    ... Be aware that the strongly typed dataset class from 2.0 does look in nothing ... process to alter the table adapters using partial classes. ... you advise where I alter the command before filling the dataset? ... public partial class CustomersTableAdapter ...
    (microsoft.public.dotnet.framework.adonet)
  • Problem with linked forms
    ... Say I have Form1 with six fields and Form2, ... Form1 using an ID field, ... fields are common to both Form1 and Form2. ... command button to open Form2, ...
    (microsoft.public.access.forms)
  • bug or feature ?
    ... a form (Form1) with a command button ... Dim frm As New Form2 ...
    (microsoft.public.vb.general.discussion)
  • Re: After hide model form, parent form may change z-order(may not
    ... easier), then after click button1, show form2 as modal dialog. ... You will find something like form1 become transparent-like for 0.2-2 ... public partial class Form1: Form ... private void button1_Click ...
    (microsoft.public.dotnet.framework.windowsforms)
Loading