问题不难 有懂得朋友请指点一二(ASP.NET 调用存储过程）

存储过程方法

public DataSet useProc(string DepartureCityName,string ArrivalCityName)
{
if(sqlcon == null)
{
sqlcon=this.GetConn();
}
sqlcom=new SqlCommand();
sqlcom.CommandType=CommandType.StoredProcedure;
sqlcom.Connection=sqlcon;
sqlcom.CommandText="selectFlight";

sqlcom.Parameters.Add(new SqlParameter("@DepartureCityName",DepartureCityName));
sqlcom.Parameters.Add(new SqlParameter("@ArrivalCityName",ArrivalCityName));

dataSet = new DataSet();
sqlda = new SqlDataAdapter();
sqlda.SelectCommand=sqlcom;
sqlda.SelectCommand.ExecuteNonQuery();
sqlda.Fill(dataSet);
return dataSet;
}

调用方法
private void Button1_Click(object sender, System.EventArgs e)
{
try
{
sqlcon = dba.GetConn();
sqlcon.Open();
this.DataGrid1.DataSource=dba.useProc(this.ddlDeparture.SelectedItem.Text.ToString().Trim(),this.ddlArrival.SelectedItem.Text.ToString().Trim());
this.DataGrid1.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally
{
dba.closeConn(sqlcon);
}
} --------------------编程问答-------------------- 参数要类型的吧？ --------------------编程问答-------------------- { 
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("@DepartureCityName",DepartureCityName)); 
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了?

--------------------编程问答-------------------- 表都可以查出来就是DataSet里面是空的
因为DataGrid里都有表头了

补充：.NET技术 ,  C#