赋值问题

Question

我是个初学者，我想从数据库中查询一条记录，同时将这个记录赋给一个Literal控件，请问该如何做，请哪位大虾给个例子或整个程序供小弟学习用，谢谢！！

Answer 1

public DataTable SearchLoanMaster(string loancode)
{
sdapub.SelectCommand.CommandText = "select tlm.projectCode,projectName,loanType,loanDate,intendAccountDate,loanUser,loanMemo,remitAccounts,loanAllMoney,TS_User.userName from TL_LoanMaster as tlm,TP_ProjectMaster as tpm,TS_User where tlm.projectCode=tpm.projectCode and TS_User.userCode =tlm.loanUser and loanCode = '"+loancode.ToString()+"'";
sdapub.SelectCommand.CommandType = CommandType.Text;
sdapub.SelectCommand.Connection.Close();
sdapub.SelectCommand.Connection.Open();
DataTable TableLoanMasterList = new DataTable();
sdapub.Fill(TableLoanMasterList);
sdapub.SelectCommand.Connection.Close();
return TableLoanMasterList;
}
SPLoan.SalesLoan.LoanPublicDB.LoanOperate GetLoanList = new SPLoan.SalesLoan.LoanPublicDB.LoanOperate();
DataTable TableLoanMasterList = GetLoanList.SearchLoanMaster(this.TextBoxLoanCode.Text); this.InputTextBoxProjectCode.Value=TableLoanMasterList.Rows[0][0].ToString();
this.InputTextBoxProjectName.Value=TableLoanMasterList.Rows[0][1].ToString();........
......

Answer 2

//定义连接字符串       
string strConnStr = "user id=sa;password=;data source=190.168.0.1;initial catalog=db;timeout=90";
//打开连接
SqlConnection conn = new SqlConnection(strConnStr);
//定义记录集用来存储查询的结果集
DataSet dsInfoList = new DataSet();
//执行查询语句
SqlDataAdapter sdaInfoList = new SqlDataAdapter("SELECT * FROM t_User",conn);
//将查询结果填充到记录集里
sdaInfoList.Fill(dsInfoList);
//绑定数据
Literal1.Text = dsInfoList.Tables[0].Rows[0]["UserName"].ToString();

Answer 3

多谢 zhangying7725(本世纪最大谎言!)  我的问题解决了，给分！！