Question

ASP.NET c# 调用数据库问题

在下是初学者，盼指教,CS代码如下：
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
MySqlConnection Conn = new MySqlConnection("DataSource=localhost;DataBase=ncs;UserID=root;Password=123456");
string strSQL = "SELECT * FROM cdb_attachments where aid=59146";
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(strSQL, Conn);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet);
MySQLDataGrid.DataSource = myDataSet;
MySQLDataGrid.DataBind();
string mystr;
//如上代码，查询到的表cdb_attachments中有几个列
//现在我想取查询到的这一条记录中一列“filetype”的数据
//并赋值给“mystr”，这里应该怎么写？
}
}

Answer 1

mystr=myDataSet.Tables[0].Rows[行]["列名"].ToString();
//行从0开始算