Re: Typed dataset - how to I alter SelectCommand
- From: "DG" <djg2002@xxxxxxxxxxxxxx>
- Date: Wed, 24 May 2006 00:30:57 +0100
This is the problem I'm having - it isn't altering the query so the whole
thing executes fine. I'm trying to alter the select (insert/delete/update)
commands within the table adapter generated along with the typed dataset but
I don't know how to 'break in' to the code.
I'm sure I must be missing something blindingly obvious but there's no
middle ground in the books I've read - either you use ADO directly to create
untyped data tables/sets (I'm comfortable with this) or you use the wizards
to created typed datasets/adapters. Nowhere seems to explain the process to
alter the table adapters using partial classes.
Much appreciated,
DG
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:uATWghifGHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
DG,
This looks crazy are you sure that the method is executed, at least there
should be an error in my opinion.
Cor
"DG" <djg2002@xxxxxxxxxxxxxx> schreef in bericht
news:e4t0nu$rme$1$830fa79d@xxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Typed dataset - how to I alter SelectCommand
- From: Cor Ligthert [MVP]
- Re: Typed dataset - how to I alter SelectCommand
- References:
- Typed dataset - how to I alter SelectCommand
- From: DG
- Re: Typed dataset - how to I alter SelectCommand
- From: Cor Ligthert [MVP]
- Re: Typed dataset - how to I alter SelectCommand
- From: DG
- Re: Typed dataset - how to I alter SelectCommand
- From: Cor Ligthert [MVP]
- Typed dataset - how to I alter SelectCommand
- Prev by Date: SqlBulkCopy permissions
- Next by Date: DataRowView changes when DataView re-ordered
- Previous by thread: Re: Typed dataset - how to I alter SelectCommand
- Next by thread: Re: Typed dataset - how to I alter SelectCommand
- Index(es):
Relevant Pages
|
