由于DataSet用的不多,一直对DataSet的数据操作不熟练,现在开始,尝试着对DataSet数据的处理
public
class
UserProxy:UserConn
... {
public UserProxy()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
public DataView GetUser()
...{
DataSet ds = new DataSet();
IList<UserNameInfo> name = new List<UserNameInfo>();
UserNameInfo userInfo = new UserNameInfo();
string sql = "select * from aspnet_Users";
try
...{
ds = RunSql(sql);
ds.Tables[0].Columns.Add("Order", typeof(string));
DataTable dt = new DataTable("UserName");
ds.Tables.Add(dt);
ds.Tables["UserName"].Columns.Add("Name", typeof(string));
ds.Tables["UserName"].Columns.Add("Word", typeof(string));
int num = ds.Tables[0].Rows.Count;
for (int i = 0; i < num; i++)
...{
DataRow dr2 = ds.Tables["UserName"].NewRow();
DataRow dr = ds.Tables[0].Rows[i];
string u = dr["UserName"].ToString();
string o = WordTransform.Transform(u);
dr2["Name"] = u;
dr2["Word"] = o;
ds.Tables["UserName"].Rows.Add(dr2);
}
ds.Tables["UserName"].DefaultView.Sort = "Word";
return ds.Tables["UserName"].DefaultView;
}
catch ...{ return null; }
}
//public DataTable GetUser()
//{
// //for (int i = 0; i < 26; i++)
// //{
// // string name = "temp_" + i.ToString();
// // IList<string> name = new List<string>();
// //}
// IList<UserNameInfo> name = new List<UserNameInfo>();
// UserNameInfo userInfo = new UserNameInfo();
// string sql = "select * from aspnet_Users";
// SqlDataReader rdr = RunReaderSql(sql);
// while (rdr.Read())
// {
// string userName = rdr["UserName"].ToString();
// string word = userName.Substring(0, 1);
// name.Add(new UserNameInfo(userName, word));
// }
//}
}
public class UserNameInfo
... {
private string _UserName;
private string _Order;
public UserNameInfo() ...{ }
public UserNameInfo(string userName, string order)
...{
this._UserName = userName;
this._Order = order;
}
public string UserName
...{
get ...{ return _UserName; }
set ...{ _UserName = value; }
}
public string Order
...{
get ...{ return _Order; }
set ...{ _Order = value; }
}
}
... {
public UserProxy()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
public DataView GetUser()
...{
DataSet ds = new DataSet();
IList<UserNameInfo> name = new List<UserNameInfo>();
UserNameInfo userInfo = new UserNameInfo();
string sql = "select * from aspnet_Users";
try
...{
ds = RunSql(sql);
ds.Tables[0].Columns.Add("Order", typeof(string));
DataTable dt = new DataTable("UserName");
ds.Tables.Add(dt);
ds.Tables["UserName"].Columns.Add("Name", typeof(string));
ds.Tables["UserName"].Columns.Add("Word", typeof(string));
int num = ds.Tables[0].Rows.Count;
for (int i = 0; i < num; i++)
...{
DataRow dr2 = ds.Tables["UserName"].NewRow();
DataRow dr = ds.Tables[0].Rows[i];
string u = dr["UserName"].ToString();
string o = WordTransform.Transform(u);
dr2["Name"] = u;
dr2["Word"] = o;
ds.Tables["UserName"].Rows.Add(dr2);
}
ds.Tables["UserName"].DefaultView.Sort = "Word";
return ds.Tables["UserName"].DefaultView;
}
catch ...{ return null; }
}
//public DataTable GetUser()
//{
// //for (int i = 0; i < 26; i++)
// //{
// // string name = "temp_" + i.ToString();
// // IList<string> name = new List<string>();
// //}
// IList<UserNameInfo> name = new List<UserNameInfo>();
// UserNameInfo userInfo = new UserNameInfo();
// string sql = "select * from aspnet_Users";
// SqlDataReader rdr = RunReaderSql(sql);
// while (rdr.Read())
// {
// string userName = rdr["UserName"].ToString();
// string word = userName.Substring(0, 1);
// name.Add(new UserNameInfo(userName, word));
// }
//}
}
public class UserNameInfo
... {
private string _UserName;
private string _Order;
public UserNameInfo() ...{ }
public UserNameInfo(string userName, string order)
...{
this._UserName = userName;
this._Order = order;
}
public string UserName
...{
get ...{ return _UserName; }
set ...{ _UserName = value; }
}
public string Order
...{
get ...{ return _Order; }
set ...{ _Order = value; }
}
}