justicefish's Q&A profile

• .NET Development INSERTing multiple values with OleDbCommand

  Can someone tell me how to insert multiple rows into a database when use the OleDB* classes I can easily insert one row... string queryString = "INSERT INTO People (firstName, surname, dateOfBirth) VALUES (@firstName, @surname, @dateOfBirth)"; OleDbCommand comm = new OleDbCommand(queryString, conn); comm.Parameters.AddWithValue("firstName", person.FirstName); comm.Parameters.AddWithValue("surname", person.Surname); comm.Parameters.AddWithValue("dateOfBirth", person.DateOfBirth); comm.ExecuteNonQuery(); ... but how can I insert multiple rows, using the same method, without hav ...Show All

• Visual Studio Team System Unable to generate a model from the OLAP datasource

  I have generated a model from the TfsReportDS datasource and I can write reports with that. If however I try to generate a model from the TfsOlapReportDS I get the following error: SQL Server Reporting Services Error An error occurred while generating model. (rsModelGenerationError) Get Online Help An error occurred during the generation of semantic model : [Create mapping between cube dimensions and database dimensions]Unexpected error occurred : Schema indicates that cube dimension '[Team System].[Agent Machine]' is based on dimension 'Machine', however, the entity representing 'Machine' cannot be found.. [Create mapping between ...Show All

• Smart Device Development File random access, writing in specifical positions

  Hi, I’m developping an application with VB.net for PPC. It creates a log of buttons that the customer taps and time of the event. If there is a button tapped by error it records it in a different file. Then the last line in the log file must be modified with the correct button (when tapped). I use streamwriter and streamreader to write and to read the log file. Tried to use seek/position to specify the point where the string must be writen but it gives me an error. Searched up and down all the help system and not joy. Surely some body here as sorted it out, could you share it with me Regards, Jose Adell ...Show All

• Visual Studio Team System Create a custom web based bug tracking tool for VSTS.

  Hi all and happy new year ! Hope 2006 will be a great year for VSTS. Before the holidays, I've been asked to look(most probably create) for a web based bug tracking tool for VSTS. I've googled a bit and found teamplain ( http://www.devbiz.com/teamplain/ ) but this seems to be more of a web interface of the entire VSTS. I'm just interested in allowing our customers to enter bugs using a simple web form. Now, I'm aware that I can create my own custom aspx files with a <form>...</form> and invoke the TFS web service so that it enters the values of the custom <form> into the proper database but I have not ...Show All

• Smart Device Development Help Need

  i am New to smart Device application development. i want to learn how to create a new application using VC++. Please Help me. Following will help http://msdn2.microsoft.com/en-us/library/b20d48w3.aspx Regards Gaurav ...Show All

• Smart Device Development help, fail to connect web service ?

  in my IE of ppc brower the server's web service that content alwyas old.however, it is newest in pc. on well connection status fail to connect server's web service all day.but other days before was right. i guess that problem occured deployment could i set the instance 's url property of Web Service object from a .xml file sample like : MyService.Service1 ws = new MyService.Service1(); // Global.WebServiceUrl read from xml ,for deploy web service dynamic. i don't know it is right ws.Url = Global.WebServiceUrl; if(IsConnectable(ws.Url) == true) { // to do ws.Login("userName","Password"); }el ...Show All

• Visual Studio Express Editions database saga

  I am at my wits end. I am trying to create a program that will add users to a database. I have read the various posts regarding the output file and have changed the Copy To Output File to Copy Never. I have also tried Copy If Newer. The database still does not retain my changes/additions. The code I have used is shown below. Code Here... Private Sub AddUser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddUser.Click Dim newUserRow As Database1DataSet.Table1Row newUserRow = Me.Database1DataSet.Table1.NewTable1Row newUserRow.Name = nameBox.Text newUserRow.Password = Password.Text Da ...Show All

• .NET Development Quick SQL question

  I am trying to build manually the UPDATE, INSERT and DELETE strings of my OdbcDataAdapter because the ones generated by the OdbcCommandBuilder are not going to be adequate. I will still be starting from the generated strings and build on them. To understand better what they do, I need to interpret a specific SQL predicate, and I am having trouble with an expression within. The following SQL command is supposed to ensure that a row in a table is deleted only if the data hasn't been changed (in OBDC style, parameters are designated by question marks): DELETE FROM MyTable WHERE ( (ColumnIndex = ) AND ( ( =1 AND TextColumn IS NULL) OR (TextColum ...Show All

• SQL Server URGENT ERROR PLEASE HELP US.

  We are installing the final release of SQL 2005 On our main SQL server. 1) We have uninstalled the SQL 2000 version. 2) We have reboot the server 3) We have lunched the SQL2005 installation. this is the error during the installation of SQL reporting service : Error Code: 29556 MSI (s) (84!DC) [13:10:19:359]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 29528. The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Errore irreversibile durante l'installazione. Error 29528. The setup has encountered an unexpected error while Setting reporting service and sh ...Show All

• Smart Device Development 0xC0000005 Access Violation

  Hi, i'm developing an application on embedded Visual C++ 4 sp4 under windows CE.NET, and everithing works fine, but after a while the program crashes in the next line dataBloqueptr->data = new unsigned __int8 [total]; telling me that an 0xC0000005 Access Violation has happenned, the strange thing is that by the time the program crashes the line and the function that contains it have been executed a lot of times without problem. So please, can you tell me how to debug this problem, and what does it means the error, i think there's a problem with memory allocation, but i have checked over and over and i'm pretty sure that i'm not ...Show All

• Software Development for Windows Vista i can not open the link

  i am using with xp pro system and i have 2 problems. 1. in explorer if i want to open link in new open windows by the rigth click mouse 2. in outlook express if i get mail with link into. i try to fix with antiviryus and spy programs but it is not successful . what i need to do       Hi avishay_y, This forum is for questions related to Windows Workflow Foundation..you should probably repost the question in a Windows XP forum and add a little more detail regarding your problem. Thanks, Arjun ...Show All

• SQL Server Problems with decrypting columns

  Hi! I want to encrypt a whole column in my table and I do this with this SQL code: OPEN symmetric key Sym_Key DECRYPTION BY certificate My_Cert GO UPDATE [My_demo].[dbo].[My-DemoList] SET [Test_crypt] = encryptByKey(Key_GUID('Sym_Key'),[Test]) GO CLOSE all symmetric keys GO And this seems ok but when I want to decrypt it with the view I have created it seems that I get a "rubbish" character between each "real" character. So my questions is: What am I doing wrong Because if I do an insert like this OPEN symmetric key Sym_Key DECRYPTION BY certificate My_Cert GO INSERT INTO [My-DemoList] (Test_ ...Show All

• SQL Server Troubles with XML Bulk Load

  Hi: I have the following xml file: <countries> <country> <code>004</code> <description>Spain</description> <iso2>null</iso2> </country> </countries> i need that when i'm doing the bulk load the value of iso2 element would be stored at BBDD like null value and not like 'null' string. somebody could help me Bulkload does not support this type of transformation. You could either transform your data before bulkloading so as to remove those elements that are null, or you could bulkload into a temp table, a ...Show All

• Windows Forms How to display "&&" characters in Menu Items using .Net

  I am using .net version 1.1. I want to add the menu items dynamically. If the menu item having the text "char &&&&&& &&&&&&", it is displayed as char &&& &&&. How to display the character as normal text. I knew Mnemonic function avoiding the underscore to display. Please help me. Hi, Thanks for the solution. ...Show All

• Visual C# How can I restore the main window after minimize the main window? Thanks!

    I use the code below to make the program ran only one time, I hope the main window can be restored automatically when you try to launch the program for the sencond time.   [STAThread]   static void Main()   {    bool createNew;    Mutex m=new  Mutex(true,"SuperCoolPhotoOnlyOneTime",out createNew);    if (createNew)    {     Application.Run(new FormMain());     m.ReleaseMutex();    }                  &n ...Show All