public DataTable GetUserConnections(DO_Networks objNetwork, NetworkDetails flag)
        {
            DataTable dt = new DataTable();

            conn = co.GetConnection();

            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand             = new SqlCommand("Scrl_AddEditDelMyNetworks", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;

            da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objNetwork.RegistrationId;
            da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value            = flag;

            da.Fill(dt);
            co.CloseConnection(conn);
            return(dt);
        }
        public DataTable GetDatatable(DO_Networks objNetwork, NetworkDetails flag)
        {
            DataTable dt = new DataTable();

            conn = co.GetConnection();

            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand             = new SqlCommand("Scrl_AddEditDelMyNetworks", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;

            da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value                   = flag;
            da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value        = objNetwork.RegistrationId;
            da.SelectCommand.Parameters.Add("@PageSize", SqlDbType.Int).Value                 = objNetwork.CurrentPageSize;
            da.SelectCommand.Parameters.Add("@Currentpage", SqlDbType.Int).Value              = objNetwork.CurrentPage;
            da.SelectCommand.Parameters.Add("@NotificationDate", SqlDbType.VarChar, 20).Value = objNetwork.NotificationDate;

            da.Fill(dt);
            co.CloseConnection(conn);
            return(dt);
        }