{
if(sqlcon == null)
{
sqlcon=this.GetConn();
}
sqlcom=new SqlCommand();
sqlcom.CommandType=CommandType.StoredProcedure;
sqlcom.Connection=sqlcon;
sqlcom.CommandText="selectFlight"; SqlParameters[] pa=new SqlParameters[]{new SqlParameter("@DepartureCityName",DepartureCityName),
new SqlParameter("@ArrivalCityName",ArrivalCityName)};
pa[0].value="";
pa[1].value="";
sqlcom.Parameters.AddRange(pa); dataSet = new DataSet();
sqlda = new SqlDataAdapter();
sqlda.SelectCommand=sqlcom;
sqlda.SelectCommand.ExecuteNonQuery();
sqlda.Fill(dataSet);
return dataSet;
}
if(sqlcon == null)
{
sqlcon=this.GetConn();
}
sqlcom=new SqlCommand();
sqlcom.CommandType=CommandType.StoredProcedure;
sqlcom.Connection=sqlcon;
sqlcom.CommandText="selectFlight"; SqlParameters[] pa=new SqlParameters[]{new SqlParameter("@DepartureCityName",DepartureCityName),
new SqlParameter("@ArrivalCityName",ArrivalCityName)};
pa[0].value="";
pa[1].value="";
sqlcom.Parameters.AddRange(pa); dataSet = new DataSet();
sqlda = new SqlDataAdapter();
sqlda.SelectCommand=sqlcom;
sqlda.SelectCommand.ExecuteNonQuery();
sqlda.Fill(dataSet);
return dataSet;
}
sqlcom.Parameters.Add(new SqlParameter("@ArrivalCityName",ArrivalCityName));
每参数应该要有具体值,如上面说的那样
pa[0].value="";
pa[1].value="";
public DataSet useProc(string DepartureCityName,string ArrivalCityName) pa[0].value=DepartureCityName;
pa[1].value=ArrivalCityName;这样就OK了?
因为DataGrid里都有表头了