今天做了点东西,用到的东西比较杂,总结下,以备以后查阅:
1、首先需要将c#连数据库查出的一条记录的每个字段值取出来,我是将这条记录的字段放在了一个数组中,如下:
string[] Infos=new string[3];
public Array show2DcodeMsg(string id)
{
SqlConnection connection = new SqlConnection(strCon);
String str = "SELECT ZCCCode,ZCCAddr,OfUserName FROM tbZCCInfo WHERE ZCCCode=" + id;
SqlCommand command = new SqlCommand(str, connection);
command.Connection.Open();
command.ExecuteNonQuery();
SqlDataReader datareader = command.ExecuteReader();
while(datareader.Read())
{
string ZCCCode = datareader["ZCCCode"].ToString();
string ZCCAddr = datareader["ZCCAddr"].ToString();
string OfUserName = datareader["OfUserName&#