Database

CREATE PROCEDURE GetProducts (<br />
@Name varchar(20),<br />
@Status int = NULL,<br />
@FromTime datetime = NULL,<br />
@ToTime datetime = NULL)<br />
AS BEGIN<br />
SELECT<br />
[Name],<br />
[Status],<br />
[RegistrationTime]<br />
FROM [Products]<br />
WHERE [Name]=IsNull(@Name, [Name])<br />
AND [Status]=IsNull(@Status, [Status])<br />
AND [RegistrationTime]>=IsNull(@FromTimestamp, [RegistrationTime])<br />
AND [RegistrationTime]<=IsNull(@ToTimestamp, [RegistrationTime])<br />
ORDER BY [RegistrationTime]<br />
END;

public DataSet GetEntries()
{
  string sql = "SELECT TOP 5 * FROM [HJ_BLog] ORDER BY Date DESC";
  string ConnectionString = ConfigurationSettings.AppSettings.Get("connString"); 
  SqlConnection conn;
  DataSet ds;
  SqlCommand cmd;
  SqlDataAdapter da;
 
  try
  {
    conn = new SqlConnection(ConnectionString);
    cmd = new SqlCommand(sql, conn);
    da = new SqlDataAdapter(cmd);
    ds = new DataSet();
    da.Fill(ds);
  }
  catch (Exception ex)
  {
    // do something...
  }
  finally
  {
    if (da != null) da.Dispose();
    if (cmd != null) cmd.Dispose();
    if (conn != null) conn.Dispose();
  }
  
  return ds;
}

Do you want to know more?

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

cmd.Parameters.Append cmd.CreateParameter("Entry_ID", adInteger, adParamInput, , lEntry_ID)<br />
cmd.CommandText = "SELECT * FROM Entry WHERE ID = ?"