Metodo C#.net

SqlDataAdapter da;

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand();

SqlConnection con;

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

BindData();

}

}

public void BindData()

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["ALZAMIENTOS"].ConnectionString);

cmd.CommandText = "SELECT * FROM ALZAMIENTOS_BANDEJA";

cmd.Connection = con;

da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Open();

cmd.ExecuteNonQuery();

Grid.DataSource = ds;

Grid.DataBind();

con.Close();

}

...