string db = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("~/App_Data/db.mdb");
OleDbConnection strcon = new OleDbConnection();
strcon.ConnectionString = db;
strcon.Open();
OleDbCommand strcom = new OleDbCommand();
strcom.Connection = strcon;
strcom.CommandText = sql;
OleDbDataReader dr = strcom.ExecuteReader();
if(dr.Read())
{
string numID;
int i=0;
int[] rr = new int[10];
怎样把dr["ID"]循环的付给数组rr??
达到这个
rr[0]=x;rr[1]=y;rr[9]=z;
x!=y!=z
}
OleDbConnection strcon = new OleDbConnection();
strcon.ConnectionString = db;
strcon.Open();
OleDbCommand strcom = new OleDbCommand();
strcom.Connection = strcon;
strcom.CommandText = sql;
OleDbDataReader dr = strcom.ExecuteReader();
if(dr.Read())
{
string numID;
int i=0;
int[] rr = new int[10];
怎样把dr["ID"]循环的付给数组rr??
达到这个
rr[0]=x;rr[1]=y;rr[9]=z;
x!=y!=z
}
解决方案 »
- C#连接SQL server出错
- SQL Server 数据库怎么批量添加?
- c#的方法中动态选择变量是用哪个关键字???
- 求在VB6中制作标准DLL的步骤方法。我想在VB6中将一些现有的函数制作成DLL,然后在C#中调用这个DLL中的函数。
- 我只有BLEND 2中文版, 请问如何编辑Silverlight 2? SP1英文版补丁打不上。
- 小妹求救啊!!求救啊!两个时间之间差几分钟!
- 子页刷新父页的问题!
- DataGrid 动态绑定 Dropdownlist 的问题 ,高手们帮帮忙,急!!! 谢谢
- 各位帮帮我,我已经烦恼好长时间了!是关于dataset里tables里如何给一行动态增加值(在线等)
- 求救!!!关于word的宏问题
- C#中的索引问题
- AD中用Group还是OU来对用户账号进行划分
int i=0;
if(dr.Read())
{
rr[i]=dr["ID"];
i++
}
int[] rr = new int[];
while (dr.read())
{
rr[i]=Int.Parse(dr[id].ToString());
i++
}
OleDbConnection strcon = new OleDbConnection();
strcon.ConnectionString = db;
strcon.Open();
OleDbCommand strcom = new OleDbCommand();
strcom.Connection = strcon;
strcom.CommandText = sql;
OleDbDataReader dr = strcom.ExecuteReader();
List<int> list = new List<int>();
while(dr.Read())
{
list.Add(Convert.ToInt32(dr["ID"]));
}
int[] rr = list.ToArray();
while (dr.read())
{
array.Add(dr[id].ToString());
}
int count=array.Count;
int[]rr=new int[count];
for(int i=0;i<count;i++)
rr[i]=int.Parse(array[i].ToString());
while (dr.read())
{
array.Add(dr[id].ToString());
}
int count=array.Count;
int[]rr=new int[count];
for(int i=0;i<count;i++)
rr[i]=int.Parse(array[i].ToString());
CSDN怎么回事啊?回复的代码莫名其妙地不完整了。
这不可能取不到,应该是:
int i=0;
int[] rr = new int[100];
while(dr.Read())
{
rr[i] = Convert.ToInt32(dr["id"]);
i++;
}
while(dr.read())
{
rr[i]= Conver.ToInt32(dr["ID"]);
i++;
}
OleDbConnection strcon = new OleDbConnection();
strcon.ConnectionString = db;
strcon.Open();
OleDbCommand strcom = new OleDbCommand();
strcom.Connection = strcon;
strcom.CommandText = "select top 10 ID from tableTest order by ID desc";
OleDbDataReader dr = strcom.ExecuteReader();
ArrayList array = new ArrayList();
while (dr.Read())
{
array.Add(dr["ID"].ToString());
}
int count = array.Count;
int[] rr = new int[count];
for (int i = 0; i < count; i++)
rr[i] = int.Parse(array[i].ToString()); min=rr[9];
max=rr[0];
rr[9]=rr[0]输出来
max=rr[0];
前面加一句:
Array.Sort(rr);