---
title: "How can i use SetDataBinding method in Visual Studio 2010 Ultimate????"  
description: "How can i use SetDataBinding method in Visual Studio 2010 Ultimate????"  
author: "mohan kumar"  
published: 2011-12-21  
updated: 2011-12-22  
canonical: https://www.mindstick.com/forum/370/how-can-i-use-setdatabinding-method-in-visual-studio-2010-ultimate  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# How can i use SetDataBinding method in Visual Studio 2010 Ultimate????

How can i use SetDataBinding [method](https://www.mindstick.com/forum/166/webservice-method) in [Visual Studio](https://www.mindstick.com/articles/12378/visual-studio-for-mac-is-out-of-beta-preview-now-officially-available) 2010 Ultimate???? Actually my [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) goes like this..\
\

```
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.Common;using System.Data.ProviderBase;using System.Data.SqlTypes;using System.Data.Sql;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page {    SqlConnection conn = new SqlConnection("Data Source=CTS\\MSSQLSERVER2008;uid=sa;pwd=home;Initial Catalog=Northwind");    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack)        {            loadMyGrid();        }    }    public void loadMyGrid()    {        conn.Open();        SqlDataAdapter sda = new SqlDataAdapter("select EmployeeID,FirstName +"+"' '+"+"LastName as Name,Title,Address,City,Region,Country from employees", conn);        DataSet ds = new DataSet();        sda.Fill(ds);        DataViewManager dvm = new DataViewManager(ds);        dvm.DataViewSettings["Employees"].RowFilter = "Country='USA'";               dataGrid.SetDataBinding(dvm,"Employees"); \\ This SetDataBinding( ) is not available in VS 2010        GridView1.DataSource = ds;        GridView1.DataBind();        conn.Close();    }}
```

\
What [namespace](https://www.mindstick.com/articles/12552/namespace) should i [import](https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code) in [order](https://www.mindstick.com/articles/12276/how-timely-order-deliveries-can-improve-customer-experience) to run this code successfully??? Help me out guys...\
Thanks in advance...

## Replies

### Reply by Anonymous User

Hi Monhan Kumar,

You can use the DataTable concept instead of DataViewManager and DataViewSettings.

check this code,

```
DataTable dt = ds.Tables[0]; DataRow[] dr = dt.Select("Country='USA'"); GridView1.DataSource = dr;  GridView1.DataBind();
```

It might be resolve your problem.


---

Original Source: https://www.mindstick.com/forum/370/how-can-i-use-setdatabinding-method-in-visual-studio-2010-ultimate

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.