日期:2014-05-18 浏览次数:20568 次
public DataSet DisCustLanguage(string fst_language)
{
SqlConnection myConn=new SqlConnection(Connstr.ConnectionString);
DataSet ds = new DataSet();
try
{
SqlCommand command =new SqlCommand("Display_Cust_languages", myConn);
command.CommandType=CommandType.StoredProcedure;
SqlParameter Param;
Param=new SqlParameter("@fst_language",SqlDbType.NVarChar,50);
Param.Value=fst_language;
command.Parameters.Add(Param);
myConn.Open();
SqlDataAdapter myda = new SqlDataAdapter();
myda.SelectCommand=command
myda.SelectCommand.CommandTimeout = 1000;
myda.Fill(ds, "ds");
}
catch (System.Data.SqlClient.SqlException e)
{
throw(e);
}
finally
{
if(myConn.State==ConnectionState.Open)
{
myConn.Close();
}
}
return ds;
}