void UpdateAssignGeofence()
{
try
{
cmd = new MySqlCommand("select VehicleID,Geofencename ,GeofenceType,convert(varchar(8),DateOfAssign,3) as DateOfAssign,convert(varchar(8),DateofUnAssign,3) as DateofUnAssign, SlNo from AssignGeofence where UserName=@UN");
cmd.Parameters.Add("@UN", UserName);
DataTable dt = vdm.SelectQuery(cmd).Tables[0];
GrdAssignGeofence.DataSource = dt;
GrdAssignGeofence.DataBind();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this);
}
}
protected void GrdAssignGeofence_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GrdAssignGeofence.PageIndex = e.NewPageIndex;
GrdAssignGeofence.DataBind();
}
