Its really not that hard...... System.IO Perhaps? And technically you cant delete a file and then move it to another folder. Lloyd J. Atkinson

Yes, but std::sort() algorithm is faster than qsort! A C++ programming language novice, but striving to learn

j = -3; int k = 0; for (i=0; (i < 3) && (j > 0); i++) { k = j + 2; if((3 == k) || (2 == k)) { j--; } else if (0 == k) { j += 2; } else { j = 0; } if(j <= 0) { j = 3 - i; } }

You are welcome. I Love T-SQL "Don't torture yourself,let the life to do it for you."

See here. "Love people and use things, not love things and use people." - Unknown "The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

DataGridView is the replacement for DataGrid, but they are not the same. The DataGridView doesn't support displaying data in a hierarchical manner. The code you used to populate the DataGrid should work just fine to populate the DataGridView. ----------------------------- In just two days, tomorrow will be yesterday.

You need to look into using the CDatabase[^] class. Below is come code to read some records from an Access DB which can be easily modified for MS SQL Server. Using those two classes you can update, read, create, etc. I believe I got much of this original code from CP but I cannot for the life of me remember where so I can't credit the author. CDatabase m_database; // Our database CRecordset *m_recset; // Pointer to a record bool Read() { CString SqlString; CString sVideoName, sFileLocationRelative; CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)"; CString sDsn; CString sFile = "Database\\VideoDB2.mdb"; // You must change above path if it's different // Build ODBC connection CString sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile); TRY { // Open the database m_database.Open(NULL,false,false,sDsn); // Allocate the recordset m_recset = new CRecordset( &m_database ); SqlString = "SELECT * FROM VIDEOS"; // Execute the query m_recset->Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly); // Loop through each record while( !m_recset->IsEOF() ) { VideoRecord tVideo; CDBVariant vID; CDBVariant vRunTime; CDBVariant vName; CDBVariant vImagePath; CDBVariant vVideoPath; CDBVariant vDescription; // Copy each column into a variable m_recset->GetFieldValue("VIDEO_ID", vID); m_recset->GetFieldValue("VIDEO_RUN_TIME", vRunTime); m_recset->GetFieldValue("VIDEO_NAME", vName); m_recset->GetFieldValue("VIDEO_IMAGE_PATH",vImagePath); m_recset->GetFieldValue("VIDEO_PATH", vVideoPath); m_recset->GetFieldValue("VIDEO_DESCRIPTION",vDescription); tVideo.iVideoID = vID.m_iVal; tVideo.lRunTime = vRunTime.m_lVal; tVideo.stVideoName = *vName.m_pstring; tVideo.stImagePath = *vImagePath.m_pstring; tVideo.stVideoPath = *vVideoPath.m_pstring; tVideo.stDescription = *vDescription.m_pstring; m_vVideos.push_back(tVideo); // goto next record m_recset->MoveNext(); } m_recset->Close(); } CATCH(CDBException, e) { // If a database exception occured, show error msg AfxMessageBox("Database error: "+e->m_strError); return false; } END_CATCH; return true; } By the way, that VideoRecord structure was just a part of my program

" CREATE Database Mydb ON (Name = mydbdat. FILENAME = 'N:\Mydbdir\mydb.mdf', SIZE = 5MB, MAXSIZE = 10MB FILEGROWTH = 1MB) Log On (NAME= MydbLog, FILNAME = 'N:\Mydbdir\MyDb.ldf', SIZE =1MB, MAX SIZE = 5MB, FILEGROWTH = 1MB)" TO move an existing database: "sp_detach_db Mydb; GO --Physically move the full-text catalog to the new location. --Attach the myDbdatabase and specify the new location CREATE DATABASE Mydb ON (FILENAME = 'N:\Mydbdir\MyDb.mdf'), (FILENAME = 'N:\Mydbdir\MyDb.ldf'), FOR ATTACH; GO

I do not quite understand how to add the microsoft.office.interop.excel. Guys the examples I have found when searching through google were those for asp.net or vb.net. I am only interested in the C#.net part of it. Can anybody show me how to make the first step, the rest i can follow. Please phokojoe

Yep! Thank you for responding. You are great. Actually I have already found where the problem was. I passed the array refence not the actual column name. I changed the dr[0] to dr["columnname"] and it poped up every row that meets the if statement conditon. And in the System.Convert.ToInt32 i changed that to ToInt16 and the condition wokrs fine. However I will aging write if I have a problem because I have to test for many columns against others. Once agin Thank you. phokojoe

Right click on your desktop, select arange icons by->show desktop icons.

Please help me with the above thread. Help is urgently needed. Actual, I am writing a code to validate my survey results whichI have used MS sql server 2000 as the backend and VB as the front end. Or can anybody help me with which is the appropriate software to use to validate the dataset. phokojoe

To clarify Table1 az azz 1 23 . 56 2 .. 3 76 You want the output to look like this: Table2 a1 a2 a3 a4 1 23 . 56 2 .. 3 76 There is no obvious logical relationship between table1 and table2 other than rows 1 and 2 from table 1 become row 1 of table2 and rows 3 and 4 from table1 become row 2 of table2. Databases are set based (there is no intrinsic order of the rows in the database - obviously there appears to an order due to the implementation, but that is, strictly speaking, an illusion) so there needs to be some element in the source table that can be used to describe order. phokojoe wrote: after running the stored procedure wich takes the columns in table az union azz into table2, I get 4 rows instead of the 2 rows as shown above. What am I doing wrong. Without seeing your code I cannot tell you what you are doing wrong. However, I don't think I'd use a union to pivot the values in a table. Please show us your code and describe the relationship between the first and second table. "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

Can anybody help me with that! phokojoe

You are unioning a different set of columns on the same table so it sees them as distinct. If you were unioning the same set of columns then it would remove the duplicate rows. If you do not want the same row being represented twice then you need to put in a WHERE statement to each to define what is permitted and what isn't. Alternatively you could perform two INSERT statements*. e.g. INSERT INTO table2 SELECT [id], A11 AS A1, A12 AS A2, A13 AS A3 FROM table1 INSERT INTO table2 SELECT [id], A21 AS A1, A22 AS A2, A23 AS A3 FROM table1 RIGHT OUTER JOIN table2 ON table1.[id] = table2.[id] WHERE table2.[id] IS NULL However, you still need to define conditions as to what is acceptable and what isn't for these two inserts as the second INSERT will currently not add anything as each row will already be represented. Also, table2 needs a primary key that is shared with table1. I've assumed that to be a column called [id], you may need to change that. * DISCLAIMER: I've not tested this so it may not be 100% correct. I tend to get my right and left outer joins mixed up My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Selecting from multiple tables requires more grip on SQL. I have simplest way which I mostly apply when I use Access for Backhand. In access, establish relationship between tables. You might me aware. Run Query Wizard. Select Both tables in the query window. In the bottom grid select desired fields form desired table. Run the query will give you some result about selected or filtered data. In the View Menu, Choose SQL View. SQL Query in the standard format will appear in a textfield to copy it to any where. This query can be used in ADO.

I notice that you are putting things like SELECT 'a1' AS A1... SELECT 'a2' AS A2... Remember this is UNIONing all these into one set so it might confuse it* if you give all these different column names, they are supposed to be returning the result into a single column So, my first suggestion (and its a long shot) is to ensure that the A1, A2, A3 are all the same column name (If I remember I said ColumnName) DROP PROCEDURE dbo.GetEmptyColumnNames CREATE PROCEDURE dbo.GetEmptyColumnNames @id numeric AS Select 'a1' as ColumnName FROM hhdata WHERE (a1 IS NULL Or a1='..') AND refno = @id UNION Select 'a2' as ColumnName FROM hhdata WHERE (a2 IS NULL Or a2='..') AND refno = @id UNION Select 'a3' as ColumnName FROM hhdata WHERE (a3 IS NULL Or a3='.') AND refno = @id phokojoe wrote: where 043701137010041 is a record in the refno and of course there are many records in the refno column, I thought it will return all the column names in that 043701137010041 which are null or '..'. Infact that is what I want to see. I'm getting confused by your terminology. "043701137010041 is a record in the refno" --> a column value in the refno column?? "there are many records in the refno column" --> there are many rows with the same refno??? (A column does not contain records, it contains values) * DISCLAIMER: I've never thought of putting different column names here, so I don't know what the result would be, but it could explain why you only get the first result back. My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Each INSERT statement creates the number of rows selected - 1 in the case of an INSERT...VALUES statement, the number of rows returned by the SELECT in the case of INSERT...SELECT. To put all the data in a single row, you simply need to select all the data you need for that row: INSERT test (a, b, c) SELECT SUBSTRING(aa, 1, PATINDEX('%,%',aa)-1 ), SUBSTRING(aa, 3, PATINDEX('%,%',aa)-1 ), SUBSTRING(aa, 5, PATINDEX('%,%',aa)-1 ) FROM table1 Stability. What an interesting concept. -- Chris Maunder

Thank you. it worked:) phokojoe