C# Databinding

I'm just looking round but I think you need to set the DataMember to just be "FirstName" I'll try and get some code together if you need it.

Just tried that suggestion...

datagridview1.DataMember = "FirstName";

but got "Child list for field FirstName cannot be created."

Would of made my day if it was just that lol, cheers anyway

You can add bound field to GridView just as below:

Here DataField needs to be specified as column name in your dataset.

BoundField boundField = new BoundField();
boundField.DataField = "FirstName";
boundField.HeaderText = "First Name";
datagridview1.Columns.Add(boundField);

Select allOpen in new window

Hi,

I think your missing the : GridView1.DataBind(); in ONE.

or

there is another solution:

in the HTML:TWO
there you have one datasource that have a methode to get the date you need.
then the gridview that get populated with this datasource.

in the C# code:THREE
there you have, the object data source, with its parameters and the methode it use to get specific data from your database,
here, an Employee (Highly Typed object) created for the occasion.
With the Id the methode return an employee.
And then populate the gridView.

Hope this will help.

protected void Page_Load(object sender, EventArgs e)
 
{
 
 
 
string strSQLconnection = "Data Source=dbServer;Initial Catalog=testDB;Integrated Security=True";
 
SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
 
SqlCommand sqlCommand = new SqlCommand("select * from table1", sqlConnection);
 
sqlConnection.Open();
 
 
ONE:
 
SqlDataReader reader = sqlCommand.ExecuteReader();
 
        
 
GridView1.DataSource = reader;
 
GridView1.DataBind();
 
}
 
TWO:HTML
<asp:GridView ID="GridView" runat="server" AllowPaging="True" AutoGenerateColumns="False"
        DataSourceID="MyDataSource"></asp:GridView>
 
<asp:ObjectDataSource ID="MyDataSource" runat="server" SelectMethod="MyMethode"
        TypeName="Ctrl">
        <SelectParameters>
            <asp:Parameter DefaultValue='' Name="EmployeeId" Type="String" />
            <asp:Parameter DefaultValue="false" Name="IsWorking" Type="Boolean" />
        </SelectParameters>
    </asp:ObjectDataSource>
 
THREE
 
          MyDataSource.SelectParameters["EmployeeId"] = new Parameter("EmployeeId");
 
public Articles MyMethode(string EmployeeId, bool IsWorking)
    {
        Employee employee = new Employee();
        employee.GetEmployyeById(EmployeeId, IsWorking);
        return Employee;
    }

Select allOpen in new window

ExpertsSoul and Kelevra...is the DatatBind and Bound part of the System.Web.UI.WebControls used  to dynamically bind an  gridview in ASP.NET? i have a winform using a datagridview control
Im new to C# so could be wrong ?

I used the following:

namespace ExpertsExchangeWindowsCode
{
    using System;
    using System.Data;
    using System.Windows.Forms;
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            var ds = new DataSet();
            ds.Tables.Add(new DataTable());
            ds.Tables[0].Columns.Add(new DataColumn("FirstName"));
            ds.Tables[0].Columns.Add(new DataColumn("LastName"));

            var dr = ds.Tables[0].NewRow();
            dr[0] = "FirstName";
            dr[1] = "LastName";
            ds.Tables[0].Rows.Add(dr);

            textBox1.Text = ds.Tables[0].Columns[0].ToString();
            textBox2.Text = ds.Tables[0].Columns[1].ToString();

            dataGridView1.DataSource = ds.Tables[0];
        }
    }
}

Thats great execpt but i have already created the datagridview through the designer, the above example is created through code and puts the actual word "Firstname" and Lastname in the txt box's and datagridview which is a good example exept i just need to kow how to pass the  SQL result into the datagridview? does that make sense?

Below will bind the DataTable to the GridView - you'll need to 'tweak' the command text for the parameter value and connectionstring. The previous code was just a piece to create a DataSet without connections etc and bind it.

Once you have DataSet you can use textBox1.Text = ds.Tables[0].Columns[0].ToString();
            textBox2.Text = ds.Tables[0].Columns[1].ToString(); // or something similar to get the txt boxes populated

var conn = new SqlConnection(@"Data Source=ftc-dev-sql02\sql2005;Initial Catalog=EcommerceTest;Integrated Security=True");
            var comm = new SqlCommand("Select * from tutor");
            var da = new SqlDataAdapter();
            var ds =new DataSet();
            comm.Connection = conn;
            da.SelectCommand = comm;
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];

Select allOpen in new window

i see. Will give it a try later today, but yes from waht i can see this looks like it will sort it

Ok did a bit of tweaking, well more like shoe horning! (I will tidy it up once i got it nailed) lol but i got it kinda got it working except the grid is returning everything in the vew, So for example the Counter object comes back to the Main form, populates the txtCustomerName, txtCustomerAddress, txtPostCode and txtCustomerTel as it should, however ,the datagridview also brings these items back ,as well as firstname, Lastname etc. Is there a filter or something? Getting there so thanks for that.

System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection();
                    var conn = new SqlConnection(@"Data Source=<InstanceName>;Initial Catalog=<DataSource>;Integrated Security=True");
                    var comm = new SqlCommand("SELECT CustomerName, Address, PostCode, MainTelephone, FirstName, LastName, Telephone, Mobile, Department, Position FROM vwCustomersandContacts WHERE CustomerCounter = " + form.Counter + "");                    
                    var da = new SqlDataAdapter();
                    var ds = new DataSet();
                    comm.Connection = conn;
                    da.SelectCommand = comm;
                    da.Fill(ds);
                    datagridview1.DataSource = ds.Tables[0];
                    System.Data.SqlClient.SqlDataAdapter recordAdp = new System.Data.SqlClient.SqlDataAdapter();
                    conn.Open();
                    recordAdp.SelectCommand = comm;
                    SqlDataReader reader = comm.ExecuteReader();
                    while (reader.Read())
                    {
                        txtCustomerName.Text = (String)reader["CustomerName"];
                        txtCustomerAddress.Text = (String)reader["Address"];
                        txtPostCode.Text = (String)reader["postCode"];
                        txtCustomerTel.Text = (String)reader["MainTelephone"];
                    }
 
                    reader.Close();
                    comm.Dispose();
                    cnn.Close();            

Select allOpen in new window

Sorted it, your example works a god damn treat! Thanks for that