Hello Friends,
i have store procedure that retrieve date from database here is SP :-
public DataSet GetOrderList(int OrderID, DateTime OrderDate, string OrderStatus)
{
Database db = new SqlDatabase(this.ConnectionString);
using (DbCommand objcmd = db.GetStoredProcCommand("dbo.GetOrderList"))
{
if (OrderID == null)
db.AddInParameter(objcmd, "@OrderID", DbType.Int32, DBNull.Value);
else
db.AddInParameter(objcmd, "@OrderID", DbType.Int32, OrderID);
if (OrderDate == null)
db.AddInParameter(objcmd, "@OrderDate", DbType.Date, DBNull.Value);
else
db.AddInParameter(objcmd, "@OrderDate", DbType.Date, OrderDate);
if (OrderStatus == null)
db.AddInParameter(objcmd, "@OrderStatus", DbType.String, DBNull.Value);
else
db.AddInParameter(objcmd, "@OrderStatus", DbType.String, OrderStatus);
DataSet ds = db.ExecuteDataSet(objcmd);
return ds;
}
}
now i bind data like that but :-
private void BindData()
{
DateTime? dt = null;
try
{
BindData(null, null, 0, null, null);
}
catch (Exception ex)
{
lblerror.Visible = true;
lblerror.InnerText = ex.Message.ToString();
}
}
private void BindData(string SortExpression, string SortDirection, int OrderID, DateTime OrderDate, string OrderStatus)
{
DatabaseHelper db = new DatabaseHelper();
DataSet ds = db.GetOrderList(OrderID, OrderDate, OrderStatus);
if (SortDirection != null && SortExpression != null)
{
DataView DView = new DataView(ds.Tables[0]);
DView.Sort = SortExpression + " " + SortDirection;
GrdOrder.DataSource = DView;
}
else
{
GrdOrder.DataSource = ds.Tables[0];
GrdOrder.DataBind();
}
}
now what i pass when i datetime is null..
Any one other way to bind the data..with this arguments.
Thank You To All