rattatosk's Q&A profile

• Visual Basic Value assignment problem

  I have a function that is supposed to find where a label should be placed to be in the center, but I get a code error. The code looks something like this: Public Class Form1 Dim screensize As Rectangle = My .Computer.Screen.Bounds Sub New () InitializeComponent() Label1.Location.X = centerLabel(screensize, Label1) End Sub Function centerLabel( ByVal rect As Rectangle, ByVal label As System.Windows.Forms.Label) As Integer Return (rect.Width / 2) - (label.Width / 2) End Function End Class The Label1.Location.X part is underlined in blue and the error says "expression is a value and therefore cannot be the target of an assignment". What am I doing wrong here ...Show All

• SQL Server How to Schedule and Run a SSIS package

  Hi Does any one know how to run How to Schedule and Run a SSIS Package for certain time intervals I have created an application which will do some data transfering from one database to another databse based on the start time and end time values(Which is been already configured in some tables). What I am exactly looking is that my application should do data transffering Based on only the time intervals(Startime and End Time) I wanted to execute my package only these time intervals. How to do this Can any one help please. Thanks & Regards Deepu M.I It sounds like you have a custom application that runs the packages at certain intervals. If that's the case, th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Debugging shaders with Visual Studio C++ Express

  I have installed August 2005 SDK. It installed also DirectX extension for "Visual Studio .NET 2003", but not for "Visual Studio 2005 Express", so inside this IDE there is'nt the menu item Debug -> Direct3D -> .... I must install this extension manually for VS Express And if yes, how Thank you for your help. Bye Toni Visual Studio 2003 was the last version of Visual Studio to support shader debugging. Instead, you have to use PIX (from August 2006 SDK), and capture at least one frame's worth of rendering. Then go into the stream, move to a rendering command, and debug your vertex or pixel shader. For a vertex shader, click the "mesh" tab beside the "render" tab, right-click a vertex (pre- ...Show All

• SQL Server Database Help

  Hi, I have a question about setting up a couple of database tables. I'll try to explain using an example: We have a customer (stored in a customer table) CustomerCode: JDOE (Primary Key) CustomerName: John Doe Address: 123 Cherry Lane City: Dubbo State: NSW PostalCode: 2830 Who was sent an invoice for an order he placed. That invoice was sent to his current address at the time (123 Cherry Lane). Let’s say he moved to a new address. We would update his customer record accordingly. CustomerCode: JDOE (Primary Key) CustomerName: John Doe Address: 987 Apple Road City: Dub ...Show All

• Visual C# Properties.Settings.Default.Save(); does not save a user.config file.

  I have settings that are in the user scope and I can update them at runtime. When I call the save method,nothing gets saved. Any ideas Did you ever get this figured out I am having the exact same problem and none of the solutions provided have helped. Thanks ...Show All

• Visual Studio 2008 (Pre-release) How to make window corners round in XAML?

  Hi all, I have been trying, to no avail, to make the corners of my application's window round. There are no RadiusX and RadiusY properties. I even tried a border and specified its CornerRadius but then the border appears inside the outer window and the rectangular corners and edges of the primary window are still there. Does anybody know how to achieve that Thank you in anticipation! Kevin June CTP introduces native support for transparent Windows in WPF. You need to specify AllowsTransparency="True" WindowStyle="None" Background="Transparent" . Lauren has a post on how you can use this to get the rounded corners you wanted. ...Show All

• SQL Server Database save and restore

  Hello, A database EntryForm has a MenuStrip. How could the Menustrip implemented that it would have a Save and Restore data to the database for backup purposes What is the Menustrip for None of the standard Items seems to work. What can be printed or previewed This question is NOT about how to save the data into the database from the EntryForm. Thanks for any answer, Hi Cesar, If i understand properly, you may use SQL DMO to restore/backup database, their is a sample directory from where your SQL Server folder resides in your installation drive, refer http://www.codeproject.com/vb/net/SQLDBBackup.asp Hemantgiri S. Goswami ...Show All

• .NET Development faster way of accessing CSV files

  hi, I am handling CSV files as database. each CSV got 40,000 - 60,000 lines. I have to do the joining, subquery and other complex tasks here. the problem is, my query execution time too high, 2-3 mins. how can I reduce the time I saw there is no way of declaring keys for CSV files in Schema.ini. I am using OleDb. another thing, can anyone tell me what should I use to this heavy task is there any good replacement of OleDb please let me know. I should have added an example. Say you have linked server in SQL 2000/2005 named TEXTFILES... You can read the data into a temp table in TSQL, then create index on it like so: select * into #temp1 from textfiles . pubs . dbo . authors -- say you have text file with authors tabl ...Show All

• SQL Server Database Diagram Migration

  Hi, I got information how to make work of Database diagrams in SQL Server2005, But i have a requirement that the DB diagram which i was using in Sql2000 can be transferred to SQL2005. Is it possible is there any link showing the details of this issue in BOL Mat Hi Mat, This is the pointer to the topic that describes how to update your database diagrams - http://msdn2.microsoft.com/en-us/library/ms171975(VS.80).aspx . Cheers, Bill Ramos [MSFT] ...Show All

• SQL Server Word Mail Merge

  What is the best way to do a report or a mail merge in SQL can someone point me in the right direction. Thanks You can do this with SQL Server Reporting Services along with the third party tool SoftArtisans OfficeWriter: http://officewriter.softartisans.com/msreporting.aspx -Chris ...Show All

• Visual Studio Team System Having trouble deploying to the report server

  Tried every combination with and without SSL, using reports and reportserver - cannot get it to deploy. Tried target folder the same name as my report project and the same name as my team project - still no luck - what am I missing TITLE: Microsoft Report Designer------------------------------A connection could not be made to the report server https://vstudio01:8143/reportserver.------------------------------ADDITIONAL INFORMATION:The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)------------------------------The remote certificate is invalid according to the validation procedure. (System)------------------------------BUTTONS:OK------------------------------ ...Show All

• SQL Server 2005: Disabled SQL Login

  Is there something that would cause a SQL Login to get disabled automatically The login was used successfully yesterday but today we were getting an error: Login failed for user '<sql login>'. Reason: The account is disabled. [CLIENT: ipaddress] Perhaps someone accidentally disabled this but that sounds unlikely. I didn't see anything in the log about the account getting disabled. Michelle Logins are not disabled automatically and the action of disabling a login does not issue a log entry. Someone must have explicitly disabled the login. Was this login created by some application or was it a regular user login Thanks Laurentiu ...Show All

• SQL Server Cannot connect to server

  Hi, I am using sql server 2005 sp1 developer edtion. I have looked at the install logs and all ok, but when connecting to my server (LAPTOP) i get the following error below. I have not changed any of the xml config file, if anyone can help me i would be very grateful. Thanks in advance kered TITLE: Connect to Server ------------------------------ Cannot connect to LAPTOP. ------------------------------ ADDITIONAL INFORMATION: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data) ------------------------------ The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data) ------------------------------ The type initiali ...Show All

• SQL Server Setting expressions in Datareader's SQLCommand property dynamically

  Hi all, I have been playing with integration services for a few days and at the moment, its up there with my list of software that I find ......painful. What I am trying to do is read different tables from my one SQL database, then populate my Access database with its data. I have put a foreach loop which goes through a collection SQL statements that I have entered into it. It first assigns it to a string variable called tablenameVar which contain statements such as "Select * from Terminals". Then the datareader is supposed to execute it based on the connectstring which never changes, and the SQLCommand value which I passed using the variable @[User::tableName]. However when I try to run it, I'm getting this error. TI ...Show All

• SQL Server How to enable "Force Encryption" for SQL Server 2005?

  I need to enable "Force Encryption" for SQL Server 2005 by API instead of by hand, but I don't know which API can do it. I need to operate remote SQL server , so I cannot operate registry directly to do it. Who can help me You might find what you're looking for here: http://www.microsoft.com/technet/archive/winntas/maintain/security/c2secgde.mspx mfr=true Buck Woody ...Show All