今天做了点东西,用到的东西比较杂,总结下,以备以后查阅:
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"].ToString(); Infos[0] = ZCCCode; Infos[1] = ZCCAddr; Infos[2] = OfUserName; } return Infos } |
我做的是http请求,参数获得是需要在page_load函数中提取,然后调用上面这个函数,大概后台代码是这样的:
protected void Page_Load(object sender, EventArgs e) { q_id = Request.QueryString["ID"]; if (q_id == null || q_id == "") { return; } { show2DcodeMsg(q_id); } } |