C# 把data的值装换成string型

来源：互联网发布：php注册登录系统编辑：程序博客网时间：2024/05/29 18:16

public string DataTableToString(string str)

{

string str1 = "";

DBClass db = new DBClass();

DataTable dt = db.GetDataSet(str).Tables[0];

StringBuilder strData = new StringBuilder();

int r = dt.Rows.Count;

int c = dt.Columns.Count;

string[,] obj = new string[r, c];

for (int a = 0; a < r; a++)

{

for (int b = 0; b < c; b++)

{

obj[a, b] = dt.Rows[a][b].ToString();

str1 += obj[a, b] += " ";

}

return str1;

}

dataset分页显示

public DataSet MyFenYe(string sql,int pageSize,int pageIndex)

{

string str1 = "";

DBClass db=new DBClass();

DataSet ds=db.GetDataSet(sql);

DataSet vds = new DataSet();

vds = ds.Clone();

int fromIndex = pageSize*(pageIndex-1);

int toIndex = pageSize*pageIndex-1;

for(int i=fromIndex;i<=toIndex;i++)

{

if(i>=ds.Tables[0].Rows.Count)

break;

vds.Tables[0].ImportRow(ds.Tables[0].Rows[i]);

}

ds.Dispose();

str1 += vds;

return vds;

}

dataset分页显示转换成string 纯自创做法，制作人：唐帅

public string MySecondFenYe(string sql, int pageSize, int pageIndex)

{

string str1 = "";

DBClass db = new DBClass();

// DataSet vds = db.GetDataSet(sql);

DataSet ds = db.GetDataSet(sql);

DataSet vds = new DataSet();

vds = ds.Clone();

int fromIndex = pageSize * (pageIndex - 1);

int toIndex = pageSize * pageIndex - 1;

for (int i = fromIndex; i <= toIndex; i++)

{

if (i >= ds.Tables[0].Rows.Count)

break;

vds.Tables[0].ImportRow(ds.Tables[0].Rows[i]);

}

ds.Dispose();

DataTable dt = vds.Tables[0];

StringBuilder strData = new StringBuilder();

int r = dt.Rows.Count;

int c = dt.Columns.Count;

string[,] obj = new string[r, c];

for (int a = 0; a < r; a++)

{

for (int b = 0; b < c; b++)

{

obj[a, b] = dt.Rows[a][b].ToString();

str1 += obj[a, b] += " ";

}

return str1;

}

0 0