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(); }