Pini's Q&A profile

• SQL Server Help with Delete statement/converting this select statement.

  I have 3 tables, with this relation: tblChats.WebsiteID = tblWebsite.ID tblWebsite.AccountID = tblAccount.ID I need to delete rows within tblChats where tblChats.StartTime - GETDATE() < 180 and where they are apart of @AccountID. I have this select statement that works fine, but I am having trouble converting it to a delete statement: SELECT * FROM tblChats c LEFT JOIN tblWebsites sites ON sites.ID = c.WebsiteID LEFT JOIN tblAccounts accounts on accounts.ID = sites.AccountID WHERE accounts.ID = 16 AND GETDATE() - c.StartTime > 180 You don't really need the LEFT JOINs in the query above if you want to select the matching rows for an account. You can do the DELETE statement like: DELETE tblC ...Show All

• SQL Server Error when I try to copy components and tasks

  Hi everyone, Everything's fine or I think so but when I try to copy/cut components to another SSIS of to own. I get this error: Error al copiar objetos. El Disenador SSIS no pudo serializar los objetos de tiempo de ejecucion de SSIS. No se pudo copiar el objeto 'Tarea Secuencia de comandos ActiveX' al Portapapeles. (Microsoft.DataTransformationServices.Design) Tranlasted into English (more or less): Error copying objetcts. SSIS designer was not able to serialize run-time SSIS objects ActiveX Script task was not copied to clipboard NOTE: this behaviour doesn't happen in the own server only from client (xp pros sp2). Nothing has been changed I don't know if install again or not. ...Show All

• .NET Development url rewriting in ASP.net

  Hi, I am Ravindra, presently trying to implement url rewriting in ASP.NET. I found the articles in msdn.com,15seconds.com . But not able to understand clearly, as I am at Begginer stage in ASP.net. So,please help....................... Ravindra Hello Ravindra, This forum is for Network Programming in .Net so its not correct forum to post your question and you may not have a luck here. I would suggest you to post your question on http://forums.asp.net and wish you best of luck to get your quick answer on appropriate forum! Best Regards, Rizwan ...Show All

• Visual Studio 2008 (Pre-release) Problem uninstalling orcas march ctp

  When trying to uninstall the orcas installation from march ctp I get the errormessage "The application data folder for visual studio could not be created". What am I to do Thanks for your reply, Chrichton Did the same as u mentioned but nothing / no good as the reg key still was fine  Tried another guys theory of doin this   "%programfiles%\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" /setup in cmd prompt it ran the VS8 but than when closing it wouldnt open jus through start and program files etc.. any else got any ideas..  Bassically all i am doing is copying a user profile to domain and i dont want to install the whole app over again i just want to be ab ...Show All

• Visual Studio Express Editions Can some one tell me how to find the default icon please.

  Hello. Can some one tell tell me how to show the default icon in a ListView box please Av only bean learning programming about 3 or 4 weeks now, and am stuck on the this. Am making a cleaning program, the files and the path show in the Listview box, but I want the default icon to show as well. Your help will be very much apresiated. Hears wishing every one a merry Christmas and a happy new Year, and may 2007 be a good year for you all. Thank you The more i look into the history folder the more complicated it seems to get. Thanx again for your help Tall Dude. Chrs. ...Show All

• .NET Development SQLBULKCOPY DATE FORMAT PROBLEM

  Hi guys, I have come across an infuriating problem. I have an excel spreadsheet with formatted data. I also have a SQL Server table with 17 columns all nvarchar(255). I have been trying to use SQLBULKCOPY to import the data from the worksheet to the table. This worked with only limited success as it seems to ignore certain values and insert nulls. I converted my excel spreadsheet to a CSV file and tried the same. Now it imports most of the values but seems to be very VERY odd in its handling of what it perceives to be data in date format. In certain cases it ignores the value altogether and inserts NULL, in others it inserts the value but formats it into a datetime format instead. I don't want it to do this, I simply want it to save ...Show All

• Visual Studio Express Editions Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.t

  Hey Can some one help me in solving this problem Actually i am getting problem in this line this.da.Update(tbl); And this is the code private void btnDelete_Click(object sender, System.EventArgs e) { try { con=new SqlConnection("workstation id=CHETAN;packet size=4096;user id=sa;data source=DOTNET;persist security info=False;initial catalog='N&NSys'"); da=new SqlDataAdapter("Select * from tblattendance",con); // SqlCommandBuilder scb=new SqlCommandBuilder(da); DialogResult dr=MessageBox.Show("Are you sure you want to delete this row ", "Confirm deleting", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr ==DialogResult.Yes) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpriteBatch Source Rectangle

  I am drawing my sprites using a single texture and cutting them with the sourcerect feature, however, this causes my screen to flicker if I move the sprites using a float number with decimals, because they have to be converted to (int). My question is: Is it possible to draw(even if having to code a new batch class) using a different struct other than Rectangle that uses floats instead of ints Here's how I create each Tile: public Tile [,] ToArray( Tile [,] TileArray) { for ( int i = 0; i < this .mapHeight; i++) { for ( int j = 0; j < this .mapWidth; j++) { TileArray[i,j] = new Tile ( new Vector2 ( this .TileWidth * j, this .TileHeight * i), new Rect ...Show All

• Windows Forms ClickOnce Deployment Issue - File Has Different Computed Hash Than Specified In Manifest - Urgent!

  Hello, originally posted this in the VB General forum - didn't get much response, so I thought I would post it here. I'm trying to deploy a ClickOnce Windows app. I have successfully installed it in the past. I made some changes to the .mdf file I have referenced in my application (I made the changes in SQL Server). When I published the app on another machine, I started receiving the error message "File ....mdf, has a different computed hash than specified in manifest". I tried a number of different suggestions that people have made on these forums, but no luck - I tried building the app twice, then deploying; I tried manually updating the revision number; I tried creating a new Test Certificate; I tried signing the assembly; I t ...Show All

• Visual Studio 2008 (Pre-release) Model generation wizard working backwards or is the programmer backwards? :)

  I have a table (again, using the video game stuff as my sample to play with): ID Title Description Rating (int, refers to the ID column in GameRatings) Type (int, refers to the ID column in GameTypes) Rating and Type both have foreign keys that point to the source tables GameRatings and GameTypes respectively. I have Associations in my Entity model that have produced classes called FK_VideoGames_TitleRatings and FK_VideoGames_VideoGameTypes. That all appears fine. However, I don't appear to have any navigation ability to allow me to do things like: game.Type.Name or game.Rating.Name Is there something I missed in the DB to allow for this automatic member generation, or, if the wizard doesn't do it, what do I have to do to my pre-generated ...Show All

• Visual FoxPro how to pause scan endscan

  I have a scan endscan, which opens a form. I would like to pause the scan from executing the next line after opening the form. How can I do code sample: select somecursor go top scan gather information from somecursor open a form (wait until the form closes) execute another line endscan You can make the form a modal form. There is a property on the form: WindowType = 1 If your form is a class loForm = createobject("YourForm") loForm.Show(1) ...Show All

• Windows Forms Closing multiple forms

  I assume there is a relatively simple answer to this but I'm relatively new to programming and can't quite figure out how to do this. I've got a main form which is opened automatically when the application is opened. I then make a choice (by selecting a radio button) and click on a button to open another form, hiding the original form. I then make another choice and open another form again hiding the previous form. I now want various options :- to close a form and show the previous form to close all forms and close the applications to close two forms in the chain and go back to the main form I'm not looking for a solution but examples of how to pass references to the previous form would be appreciated. There are sev ...Show All

• Visual Basic System.Net.Mail and BCC

  I have an application written in VB 2005 that uses the System.Net.Mail namespace to send e-mail messages using BCC. I was running into an issue getting the friendly names to work and started searching for guidance and ran upon something startling. The link below states that the BCC functionality within the .NET Framework 2.0 is not really blind. Can anyone confirm that this is the case Has it been fixed in an update to the .NET Framework The application I am working on is for a medical facility and is used to e-mail patients reminders, etc. I was going to use BCC so that our ISP doesn't block outbound e-mails thinking they are spam or a mass-mailing worm. A couple of times per month the system will be sending out messages to at leas ...Show All

• Windows Forms Using DataGridView with Objects

  Hi I am having trouble using the DataGridView and I have not found the online help to be that helpful with what I want to do. I have created a class that is a list of specific objects: public class OrdersList : System.ComponentModel. BindingList < Order > This is then populated with Order objects which I have populated from the database. The Order object has some primitive data fields made from Strings and int's etc and it has 2 object data fields, these objects are made up from primiotive types. I have placed a datagridview compomnent on a form and then set its datasource progmatically to the populated list. myDataGrid.DataSource = myOrdersList; It appears to be showing the correct number of rows but the c ...Show All

• Windows Forms How do I get these buttons to work?

  I have made a simple form and have two buttons at the bottom. One of them I would like to be a reset button, the other I would like to set up to be a submit button to either send me the info in an email or to save the into to a file that I can access. You'll find lots of examples when you search the VB General forum for SmtpClient. ...Show All