一直想实现省市地区三级联动的一个功能,找了很久资料不是很全,偶然看到:https://www.cnblogs.com/netshuai/archive/2007/09/14/892292.html,因为缺了一个dataclass类,看了源码调试了很久还是失败了,于是重新写了dataclass 部分,与学C#的共享,完整代码如下:
dataclass部分:
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
/// <summary>
/// </summary>
public class DataClass
{
public static SqlDataReader GetDataReader(string sqlstr)
{
string strConnect = "";
strConnect = ConfigurationManager.ConnectionStrings["K3AcctConn_formal"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(strConnect);
if (sqlConnection.State != ConnectionState.Open)
{
sqlConnection.Open();
}
SqlCommand objCommand = new SqlCommand(" ", sqlConnection);
objCommand.CommandText =sqlstr;
//dr = objCommand.ExecuteReader();
SqlDataReader dr = objCommand.ExecuteReader();
return dr;
}
需要完整代码的可以下载:
https://download.csdn.net/download/jiekingcbx/10607877
}