New to WPF/DataBinding

[bradley baker]

How do I bind a GridView to a dataset, is it even possible?  I looked iin the guide book and they all seem to binding via the code and in the ASP.NET version you can just link it to the SQL datasouce you created.  (Again dont know much of this WPF world)

Im use to the ASP.NET RadGrid and binding options but Im trying to see if I can get one of my larger applications to run in WPF.

Im using Q3 WPF and VB.  I added a DataSet and have the query I want in it.  (I just left it the default "DataSet1.xsd" with all the default values for testing.)

[Jorge Gonzalez]

Hello Bradly,

     Here's how I execute a proc from WPF and attach the dataset to the grid (I am connecting to a Sybase ASE database):

private DataSet statusDataSet;

public DataSet StatusDataSetRef

{

  get { return statusDataSet; }

  set { statusDataSet = value; }

}

AseDataAdapter aseadpt = new AseDataAdapter();

AseParameter inParam;

StatusDataSetRef = new DataSet();

            

using (AseCommand cmd = new AseCommand("<procedure name>", sybconnection))

{

   cmd.CommandType = CommandType.StoredProcedure;

   inParam = new AseParameter("@p_userid", AseDbType.VarChar, 7);

   inParam.Direction = ParameterDirection.Input;

   inParam.Value = sybcon.UserID;

   cmd.Parameters.Add(inParam);

   try

   {

    aseadpt.SelectCommand = cmd;

    aseadpt.Fill(StatusDataSetRef);

    gridname.ItemsSource = StatusDataSetRef;

   }

   catch (AseException ex)

   {

     MessageBox.Show(ex.Source + " : " + ex.Message + " (" + ex.ToString() + ")", "Execute Stored Precedure failed.");

   }

}