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