C#

private void btnQuery_Click_1(object sender, EventArgs e) 
{ 
PwdSecurity p = new PwdSecurity(); 
uipc = this.Parent as UIPCMainForm; 
const string constrallowedBlockTypes = "allowedBlockTypes"; 
DAL d = new DAL(uipc.StrUserName, p.base64Decode(uipc.StrPassword)); 

DataSet ds = new DataSet(); 
ds = d.AllowedTypes(constrallowedBlockTypes); // Returns dataset correctly from method in DAL 

//New code 
BindingSource bs = new BindingSource(); 
bs.DataSource = ds; 
bs.DataMember = ds.Tables[0].TableName; 
dgv.DataSource = bs; 

// End new code 
} 

DAL: 

myConnection = 
new SqlConnection("server=PTLLBNB0DD1\\SQLSERVER2005;database=IPControl;Trusted_Connection=yes"); 

public DataSet AllowedTypes(string Type) 
{ 
string SQL = String.Empty; 
ds = new DataSet(); 
try 
{ 
SqlCmd = new SqlCommand("spGET_ALLOWED_TYPE", myConnection); 
SqlCmd.CommandType = CommandType.StoredProcedure; 
SqlCmd.Parameters.Add("@Type", SqlDbType.VarChar, 50); 
SqlCmd.Parameters["@Type"].Value = constrallowedDeviceTypes; 

if (myConnection != null) { myConnection.Close(); } 

myConnection.Open(); 
SqlAdapt = new SqlDataAdapter(SqlCmd); 
SqlAdapt.Fill(ds); 
} 
catch (Exception e) 
{ 
MessageBox.Show("DAL Layer / AllowedTypes method error. \n\r \n\r" + 
e.Message.ToString() + " \n\r \n\r" + SQL); 
} 
finally 
{ 
if (con != null) { con.Close(); } 
if (aCommand != null) { aCommand.Dispose(); } 
if (adapter != null) { adapter.Dispose(); } 
} 

return ds; 
}