这翻译成C# 要怎么写
Dim adapter As New SqlDataAdapter("SELECT Passwd FROM passwd WHERE Name ='admin'", cnn)
Dim table As New DataTable
adapter.Fill(table)

If Trim(Me.TextBox1.Text) = Trim(table.Rows(0).Item(0)) Then

特别是这句Trim(table.Rows(0).Item(0))

主要是想知道怎么从table中取一个数!

或者说是把一个数取出来

高手指教~~

[解决办法]

C# code

SqlDataAdapter adapter=new SqlDataAdapter("SELECT   Passwd   FROM   passwd   WHERE   Name   = 'admin ' ",   cnn);            DataTable dt=new DataTable();            adapter.Fill(dt);            if(this.TextBox1.Text.Trim()==table.Rows[0][0].ToString().Trim())
[解决办法]
            SqlDataAdapter adapter=new SqlDataAdapter("SELECT   Passwd   FROM   passwd   WHERE   Name   = 'admin ' ",   cnn);
           DataTable dt=new DataTable();
           adapter.Fill(dt);
           if(this.Me.TextBox1.Text.Trim()==table.Rows[0][0].ToString().Trim())