nbrege's Q&A profile

• SQL Server Export SQL Server 2k/2k5 DB to SQL Mobile 2k5?

  Hi, I'm currently doing a application for a smartphone which requires me to replicate the desktop version of a db which was running on SQL 2k. From my reading, it seems that i will need SQL server 2k5 Management studio in order to convert my desktop db to the SQL Mobile version Is there any other way For now, i only have the 2k5's management studio express which came with my VS 2k5. I only notice that the express version doesn't allow me to create a SQL mobile db. Thanks!! John SQL Server Express can also create a SQLCe (Compact Edition) database. It's a bit more convoluted, but you can also download the SQL Server Mananagement Studio (Express) that can create it as well. I describe how to create datab ...Show All

• SQL Server Sampling data set via Integration Services data flow for data mining models without saving training and test data set?

  Hi, all here, Thank you very much for your kind attention. I am wondering if it is possible to use SSIS to sample data set to training set and test set directly to my data mining models without saving them somewhere as occupying too much space Really need guidance for that. Thank you very much in advance for any help. With best regards, Yours sincerely, Does the Data Mining Model Training destination offer any solution "The Data Mining Model Training destination trains data mining models by passing the data that the destination receives through the data mining model algorithms. Multiple data mining models can be trained by one destination if the models are built on the same data mining structure." D ...Show All

• .NET Development Track deleted rows from dataset

  I am using Dataadapter to update the records. Call select statement to fill the dataset, Add/update/Delete rows to and from the dataset. Call update method to update the records. Now the problem is to track the deleted rows. If i check using rowstate property of the row as deleted. But i wanted to know the row items which has been deleted. If i use row[ColumnName] then it throws exception "deleted rows cannot be accessed". Is there any solution to know the items in the deleted row. Please let me know. foreach ( DataRow row in this . Tables [ Table1 ]. GetChanges (). Rows ) { if ( row . RowState == DataRowState . Deleted ) { writer . WriteStartElement ( DData . TABLE_NAME , null ); writer . WriteAttributeString ...Show All

• Windows Forms Programicaly creating a ShortCut

  In my Windows Forms application I have created a self-exracting archive (Program Installer) for my main application. How would I go about creating shortcut icon that points to my applications executable file I looked in the System::IO::File class but couldn't find anything and don't know where else I would have to look. Another quick question... What is the C# equivelant of the C++ #include statement ...Show All

• SQL Server How can i "script table as" at sql server 2005 to sql server 2000 compatibility????

  Hi, I have a sql server 2005 . But my old customers have a sql 2000 database. I want to create table script, and upgrade my custumers tables.. i script table in sql 2005 and run at sql 2000. but it doesnt work for example: sql 2005 create this 1uery on the test table: "USE [test] GO /****** Object: Table [dbo].[TBL_TEST] Script Date: 11/24/2006 13:21:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TBL_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL, [KOLON1] [nchar](10) NULL, [KOLON2] [nchar](10) NULL, CONSTRAINT [PK_TBL_TEST] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]" then i run to sql 2000, but it doesnt work. but when i convert manually this que ...Show All

• .NET Development Manipulate random number

  Hi, Is it possible to manipulate a random number which is given from the method Random() I'm making a calculation and for the minus sums i have a little problem. This is how the code (partially) looks like: case 10: int number1 = rnd.Next(0, 6); int number2 = rnd.Next(0, 6); label.Text = rnd.Next(0, 6).ToString() + " - " + rnd.Next(0, 6) + " ="; answer = number1 - number2; break; The problem is, when number1 is smaller than number2. If this is going to be the case, i'll get negative numbers. How can i prevent that The 10 represents the number which is given by the user in a textbox. Thanks in advance! Hi Brendan, Yes that did the trick. I never did that before, but it sounds ...Show All

• Visual Studio Express Editions folder viewer

  1. I need to know how to add a folder view... It works like this: *Menustrip* _____________________________ File Folder1 _____________________________ *click folder1* *Menu* _____________________________ Sub folder1 Sub folder2 _____________________________ When you click folder1 it shows what's inside that folder.. if you hover the mouse of sub folder1 it shows what's in the folder To get my lists I use a ListBox. For a list of files: ListBox1.DataSource = My .Computer.FileSystem.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.Favorites)) For a list of directories: ListBox2.DataSource = My .Computer.FileSystem.GetDirectories(Environment.GetFo ...Show All

• Visual C++ How to specify CFileDialog to target for folders?

  I've been experimenting with the common dialogs, specifically to do a File Open and Save As feature. Now i'm in a bind. I think there is a way to configure the FileDialog to target and return the folder, or path, so that i can set a working directory for my application, but i dont seem to find a flag (or dont understand which flag does that). Am i looking in the right place, or is there another option somewhere or a whole different common dialog i'm supposed to be looking at Youre right. CFileDialog has no option to do this thing. The only lead i got was from SHFolder project, found from CodeGuru and Planet Source Code. For anyone who needs this in the future, my function went like this: void CDataAcquisit ...Show All

• SQL Server Complete Execution History of a report

  Hi, I have some reports(both parameterized and non-parameterized) for which I need to have an execution history on the report server. These are not scheduled and so the history should only be for the instances when users view the report. I checked the 'Store all report execution snapshots in history' but it does not store the snapshot in history everytime the report is viewed. What do I do to achieve this Thanks SSRS supports automatically creating history snapshots for reports which are set to execute from a snapshot. Each time the snapshot is updated, it will be added to report history. That said, we do not support automatically creating history for every single live execut ...Show All

• SQL Server Maximum insert commit size

  Hi, All, if I set the "Maximum insert commit size" to 10 ( 0 is the default) in a OLE destination, what does the 10 means 10 records or 10 MB/KB of data Thanks ...Show All

• .NET Development Why are methods in internal interfaces forced to be public?

  I have an internal interface that I've defined. I've implemented that interface in a class and would like to make the method internal, unfortunately it won't compile, saying that it must be public. Why is this Example: public class A : ITest { // Complains about not being public internal void HelloWorld() { } } internal interface ITest { void HelloWorld(); } It seems unnecessary to restrict access to my entire class just to avoid exposing a couple of interface methods. Is there a good reason why the interface members do not default to the scope of the interface (or at least allow limiting to it) If no, perhaps the functionality of interfaces should be altered ...Show All

• Visual Studio Tools for Office How to migrate Outlook VBA folder based solution to Visual Studio for creating Outlook Add-in

  I have been studying the evaluation version of Visual Studio 2005 and trying to figure out how to migrate a folder based solution I have created for Outlook 2003 in VBA and VBscript to Visual Studio 2005 so I can convert my folder based solution into an Outlook Add-in. Can't find any good tutorial info and haven't been able to figure it out in self-study of VS2005. Can anybody point me in the right direction or give me a referral John, Sue's suggestion that you post more info about your proposed solution is a good one. Please let us know what you are trying to migrate, and we will try to help you. I'll close this thread at the end of the week if no news comes around. Look forward to hearing from you. John. ...Show All

• Smart Device Development Application not running...

  hi... We are trying to run our application's .exe in the system which is not having c#(.NET framework) installed. But its showing error "mscorees.dll file not found." So how i can run my application on my system which is not having .NET framework installed on my system... Thanks, Vinay ...Show All

• Visual Studio Express Editions Need help filtering Dataset table by a value

  I cant seem to filter down my dataset table by criteria in expression. Can someone tell me why I still have the same amount of rows after I use this filter select option. Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Me .WorkListTableAdapter.Fill( Me .SQLDataSet.WorkList) MsgBox( Me .AccuLogic_SQLDataSet.WorkList.Rows.Count) End Sub Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Me .SQLDataSet.Tables( "WorkList" ).Select( "DSK = '999'" , "DSK" ) End Sub have you tried to use a DataView on the dataset table Example o ...Show All

• SQL Server AmoAdventureWorks sample problems.

  Can execute the above sample (on XP Pro SP2) successfully once. Subsequent attempts result in error below(after grabbing all system resources for a few minutes). Tried deleting the database and then stop starting the server before retrying - to no avail. Kind of sapping my confidence in AMO objects. Any ideas Thanks in advance Zub -------------------------------------------------------------- Unhandled Exception: System.Data.OleDb.OleDbException: Deferred prepare could no t be completed. Query timeout expired at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbDataReader.BuildSchemaTableRowset(Object handle) at System.Data.OleD ...Show All