asp.net C#中怎樣接受SQL 返回select受影響的行數

asp教程.net C#中怎樣接受SQL 返回select受影響的行數

'執行個體二

OleDbCommand command = new OleDbCommand(select count(*) from biao where name="張三" ,conn);
  OleDbDataReader reader = command.ExecuteReader();
   
  if (reader.Read())
  {
  strValue = (string)reader.GetValue(0);
  }

  reader.Close();

 
'執行個體二

public static DataSet Query(string SQLString)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
                    command.Fill(ds, "ds");
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                    throw new Exception(ex.Message);
                }
                return ds;
            }
        }

DataSet ds = new DataSet();
ds = Query("select * from tbname");
int count = ds.Tables[0].Rows.Count;

'執行個體三

 SqlConnection con = new SqlConnection();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "select count(1) from stockout";
        con.ConnectionString = "server=10.10.66.232;database=uerp;uid=uerp;pwd=uerp5678";
        con.Open();
        int returnValue = (int)cmd.ExecuteScalar();
        Label3.Text = "有" + returnValue.ToString() + "條記錄";
        con.Close();
  

'最後總結一下

1、返回update、delete、insert的行數
int rows = cmd.ExecuteNonQuery(); 
return rows;
2、返回查詢的記錄數
OleDbCommand command = new OleDbCommand("select count(*) from biao where name=張三" ,conn); 
OleDbDataReader reader = command.ExecuteReader();
   
if (reader.Read()) 
{ 
  strValue = (string)reader.GetValue(0); 
} 
reader.Close();