Neftali Reyes's Q&A profile

• .NET Development Multiple Inserts into Sql Server.

  Is there any way to insert multiple rows into sql server table in single query or single round trip to the server Thanks. Have you verified that you are sending the statement that you think you are sending to the server You can do this in your app by debugging or by displaying the string somewhere before you call ExecuteNonQuery. You can also use SQL Profiler to verify what is being sent to the server. There is no reason in ADO.NET why this shouldn't work. For example, test something simple like the following: SqlCommand insertCommand = new SqlCommand("INSERT INTO insertTab VALUES ('allie', 1);INSERT INTO insertTab VALUES('katie', 2)", sqlConn); insertCommand.ExecuteNonQuery(); Use your own tabl ...Show All

• Visual C# simple console question

  I have a simple console project that I want to pass 2 arguments into. Here is a simple example of the code that I have. static void Main(string[] args); { string somevar = args[0]; string somevar2 = args[1]; doSomething (somevar, somevar2); } I want to run the program like this. C:\testapp.exe "C:\documents and settings\administrator\application data\testapp\" "C:\documents and settings\administrator\application data\testapp\toBeUploaded.zip" I tried it with and without the quotation marks but it appears that the program is only getting C:\documents for the first string and "and" for the second string. How do I get arount this In your first argument, lose the final \ at the end. ...Show All

• Visual Basic How to delete custom class objects? in VB need help

  well i have several class objects with timers after some work i don't need them how can i delete them I know how it's done in C++ but in VB i can't find a way. you understood me wrong let's say i have class Public Class Example 'SomeCode End Class Public Class Form1 Private Sub Start() dim X as new example dim X2 as new Example End Sub End Class How can i delete X and X2 object's ...Show All

• SQL Server Interactive sort

  Hi, Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending Then i cld swop the 1 and the 2 around. =iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value Many thanks Dave ...Show All

• SQL Server Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare for Execute (Success) - Pre-execute (Success) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started. (SQL Server Import and Export Wizard) - Executing (Error) Messages Error 0xc02020a1: Data Flow Ta ...Show All

• Visual Studio Express Editions Somthing missing

  Hello All I have some kind of homework ...the good news: i did it but the problem is that the drawing never completes. I have to build a recursive sub to draw nested circles, but the program is that it only draws on a spesific part of the form. I need an advise how to solve the problem, to complete my HW and send it to my totur. the code is : Dim graph As System.Drawing.Graphics = Me .CreateGraphics Sub circle( ByVal x As Integer , ByVal y As Integer , ByVal rads As Integer ) Dim x1, y1, x2, y2 As Integer x1 = Math.Cos(4 * Math.PI / 180) * rads y1 = Math.Sin(4 * Math.PI / 180) * rads For t As Integer = 4 To 360 Step 4 x2 = Math.Cos(t * Math.PI / 180) * rads y2 = ...Show All

• Visual Studio VSPackage.resx in language service

  Hi, I have problem with loading VSPackage. PLK is correct (VS allows runing my package), but exceptions: --- A first chance exception of type 'System.IO.FileLoadException' occurred in mscorlib.dll Additional information: Could not load file or assembly 'D:\\Private\\Dokumenty\\Visual Studio 2005\\Projects\\M2Package\\M2Package\\bin\\Debug\\M2Package.dll' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047) --- and --- A first chance exception of type 'System.Resources.MissingManifestResourceException' occurred in mscorlib.dll Additional information: Could not find any resources appropriate for the specified culture or the neutral culture. Make sure &quo ...Show All

• SQL Server semi-additive (inventory problem)

  i have a more general question about cube design (fact table) using ssas 2005 my inventory cube should track the daily in and outs / per product as well as an inventory level should be calculated at the end of each month . how do you design the fact table only in and outs are imported in the fact table. my suggestion: # timekey # productkey inQuantity outQuantity how then is the inventory level at the end of each month calculated, given the fact that there is an opening balance at the beginning of the year (where is this measure stored ) thanx for your help!! If you were to compute the ...Show All

• SQL Server Report Server Setup when query against terabytes of data

  Hi all, Can anyone point me to a resource on the best way to setup and use SSRS 2005 when reporting on tables that could have 1 billion rows. The database in question will have mulitple schema's each being at least 1 terabyte in size. Thanks -JW The size of the database matters much less than the size of the data you want in the report. My advice is to push as much filtering and sorting logic as you can into the back end database and return only the result set you want to display into SSRS 2005. Assuming you filter the data down to 20-100 page reports, going against billions of rows and terabytes of data is not difficult. Thanks. Donovan Smith ...Show All

• Visual Basic Service dosen't want to copy from network/vpn

  Hello, I have a small problem with a windows service that I am trying to make. The program needs to copy I file from a network path to the local computer if the file changes. The code runs fine as a program but when I try to make a windows service then I get errors about FileSystemWatcher and a error that the path not could be found. I know that the problem is that windows services are running on a different account but but is there a way to have the service running as the authenticated user This is the source code: Imports System Imports System.Threading Imports System.IO Public Class PollingService ' Keep track of worker thread. Private m_oPollingThread As New Thread( _ New System.Th ...Show All

• Visual Studio Express Editions How do I change Location of an item when something happens?

  How do I change the locaton of an item when a event happens I tried this and it didn't work: Panel1.location = new location (1,1) And how do I chang the picture(image) of a Picture box I tried this: PictureBox1.Image = New Image 'I dont now where to put the url and it says something 'like a event something Help You should probably stop guessing. Panel1.Left and Panel1.Top are the properties you can set, I believe. That, or X and Y. A Bitmap can be loaded with Bitmap.FromFile, like this: PictureBox.Image = Bitmap.FromFile("c:\myBitmap.bmp"); for example. ...Show All

• Windows Forms Arrow Keys on a User Control in .Net 2.0

  If I have a form and want to trap keyss, I can use the KeyDown event to trap and detect which keys are used. This includes the arrow keys. However when I want to do the same with a UserControl placed on the form, all keys are detected except the arrow keys. 1.Why do the arrow keys not generate the even on a UserControl 2 Is there a way to make arrow keys generate an a KeyDown or KeyPress event on a UserControl 3. If not, what event if any is generated by the arrow keys on a USerControl Thanks Steve My control now derives from the Control class to achieve the above. However I still have one remaining problem regarding keys/focus. If I host a RichTextBox  on a form, th ...Show All

• Visual Studio c# Project template with linked file

  I exported a Project template from a working class library project, which has the following linked file element:     <Compile Include="..\DalBase.cs">       <Link>DalBase.cs</Link>     </Compile> This works fine in the original project, but when I create a project from my template the include path ends up pointing to some temp folder, such as: C:\Documents and Settings\bradk\Local Settings\Temp\5oohnkvn.04c\DalBase.cs The linked file is obviously broken then, and the project won't compile. Is there any way around this I tried a custom parameter with the relative path in it, and the same problem persists. Hmm, a ...Show All

• SQL Server Grouping in Cube's dataset, Please Help

  have a measure called [Person COUNT] and an Attribute called [Injury Class] Injury Class has four members [Injury A] [Injury B] [Injury c] [Injury d] I want to get the Person count for each one individually, in seperate columns. So it would look like this [ Person Count A] [Person Count b] [Person Count C] [Person Count d] 125 254 4 1245 441 11 21 24 454 57 12 42 I want this all in One single Dataset. So that when i put it into a table, i dont get errors about being outside the scope, also everything will be lined up correctly. Please keep in mind, im new to mdx, i tried some code, but the stuff i tried didnt work. Is there a way to do this as a cal ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Single letter prefix before a variable

  I was wondering if anyone can point me towards some information on having a single letter prefix before AND after a variable name. Is that a standard practice I have come across this in a number of different programs, yet still a bit unclear why they are used. Any info would be appreciated. Some examples of what I have seen: aFireball.Value.Source mWizard = new Sprite.... rotation_angle += .03M; My opinion: Java and C# have published standards - I see no reason to deviate from them, given the benefit of everyone working the same way. In some ways having these standards is a godsend - it is far easier to agree to all conform to 'the standard' than get 20 developers from different ba ...Show All