Binding a child Gridview

我有一个嵌套的gridview和它的可编辑。虽然它使用访问作为其数据源的测试目的，我想部署它与mysql数据源。我意识到有些不对劲。我的Gridview必须显示当搜索被点击。这是我的原始访问数据源代码:

//This procedure prepares the query to bind the child GridView
private AccessDataSource ChildDataSource(string strCustometId, string strSort)
{
    string strQRY = "";
    AccessDataSource dsTemp = new AccessDataSource();
    dsTemp.DataFile = "App_Data/BV.mdb";
    strQRY = "Query statement";
    dsTemp.SelectCommand = strQRY;
    return dsTemp;
}

I changed to accommodate MySql users.

private SqlDataSource ChildDataSource(string strCustometId, string strSort)
{
    string strQRY = "";
    SqlDataSource dsTemp = new SqlDataSource();
    dsTemp.ID = "dsTemp";
   string sCon= WebConfigurationManager.ConnectionStrings["bv"].ConnectionString;
   dsTemp.ConnectionString = sCon;
    strQRY = "Query stament here";
dsTemp.SelectCommand = strQRY;
    return dsTemp;
}

这是我的连接字符串从web.config.

 <connectionStrings>
  <add name="bv" connectionString="server=localhost;database=cms;Connect Timeout=30;Persist Security Info=False;User id = root;password=xxxxx" providerName="MySql.Data.MySqlClient"/>

第二个代码给出错误，并说用户'root'登录失败。我的连接字符串和数据源代码有问题。我没有经验，在这方面需要帮助。