| Sender |
Macson
|
| Recipient(s) |
Macson
|
| Date |
25 Sep 2009
|
Problem in follwing cde
|
public DataSet executeAndGetDataSet(string strCommandText, Hashtable arParam)
{
DataSet ds= new DataSet();
try
{
SqlCommand cmd = new SqlCommand(strCommandText);
cmd.Connection = con;
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
if (arParam != null)
{
foreach (DictionaryEntry objParam in arParam)
{
cmd.Parameters.Add(objParam.Key.ToString(), objParam.Value);
}
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
cmd.Dispose();
cmd = null;
}
catch
{
}
finally
{
con.Close();
}
return ds;
}
|