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