int i =0; string test; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if(i==21) test = myReader["字段名"].ToString() i++; }
int i =0; string test; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { if(i==21) test = myReader["字段名"].ToString() i++; }好像不对啊.i不是一直都是0的吗.
while(yourreader.reader()) { if(your condition) { //TODO your code } }
[C#] public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders"; SqlConnection myConnection = new SqlConnection(myConnString); SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection); myConnection.Open(); SqlDataReader myReader; myReader = myCommand.ExecuteReader(); // Always call Read before accessing data. while (myReader.Read()) { Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1)); } // always call Close when done reading. myReader.Close(); // Close the connection when done with it. myConnection.Close(); }
string test;
myReader = myCommand.ExecuteReader();
while (myReader.Read()) {
if(i==21)
test = myReader["字段名"].ToString()
i++;
}
string test;
myReader = myCommand.ExecuteReader();
while (myReader.Read()) {
if(i==21)
test = myReader["字段名"].ToString()
i++;
}好像不对啊.i不是一直都是0的吗.
{
if(your condition)
{
//TODO your code
}
}
public void ReadMyData(string myConnString) {
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
SqlConnection myConnection = new SqlConnection(myConnString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myConnection.Open();
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
}