merge two datasets (hard one)

freez3 · Apr 28, 2012

i use a procedure to search the table issues in my database for issues that have a certain string in the array searchParts occuring in one of their fields. for every string that's part of searchParts i get the right issues, so far, this works. but when you take 2 strings, some issues are displayed (through a datagrid) twice. what i would like to know is if there's a way to merge the datasets each time so only one remains that has all the issues (but each issue only once) that match all the criteria (AND function, or if that's impossible, some of the criteria, that would be an OR...). basically, an issue can only occur once... public DataSet SearchIssues(string[] searchParts) { // Create Instance of Connection and Command Object SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("SearchIssues", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet myDataSet = new DataSet(); // add parameters to SPROC foreach (string searchPart in searchParts) { SqlParameter parameterSearchPart = new SqlParameter("@searchPart", SqlDbType.NVarChar, 20); parameterSearchPart.Value = http://aspmessageboard.com/archive/index.php/searchPart; myCommand.SelectCommand.Parameters.Add(parameterSe archPart); // Execute the command myCommand.Fill(myDataSet, "Issues"); // remove the parameter to add a new one the next foreach is performed myCommand.SelectCommand.Parameters.Remove(paramete rSearchPart); } // Return the datareader result return myDataSet; }

merge two datasets (hard one)

freez3

New Member