将数据绑定到文本框作为默认c#

本文关键字：默认数据绑定文本 | 更新日期: 2023-09-27 18:00:12

我不知道如何绑定。请帮帮我，谢谢。

private void LoadtxtYear()
{
   DataSet ds = new DataSet();
   SqlConnection conn = new SqlConnection(strConn);
   string sql = "";
   sql = "SELECT  COCOPER  FROM HR11COMP  where cocode = '" + sComCode + "' order by COCPER";
   if (conn.State == ConnectionState.Closed) { conn.Open(); }
   SqlDataAdapter da = new SqlDataAdapter(sql, conn);
   da.Fill(ds, "temp");
   txtYear.DataBinding.Add("Text", ds.Tables["temp"], "COCPER");
}

将数据绑定到文本框作为默认c#

我认为你可以使用这样的东西：

using(SqlConnection conn = new SqlConnection(strConn))
        {
            conn.Open();
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = "SELECT  COCOPER  FROM HR11COMP  where cocode = @sComCode order by COCPER";
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.Add(new SqlParameter("@sComCode", sComCode));
                object cocoper = cmd.ExecuteScalar();
                if (cocoper != null)
                     txtYear.DataBinding.Add("Text", cocoper.ToString(), "COCPER");
            }
        }