James Randle's Q&A profile

• Visual C++ pls some one explain each line...

   int start_byte, end_byte;  int start_bit, end_bit;  int byte_pos;  BYTE width_mask, or_mask, and_mask;  BYTE byte_value;  start_byte = pos / 8;  start_bit = pos % 8;  start_bit = 7 - start_bit;  end_byte = (pos + len - 1) / 8;  end_bit = (pos + len - 1) % 8;  end_bit = 7 - end_bit;  width_mask = (BYTE)(((1 << (start_bit - end_bit)) - 1) << 1 | 1); how to convert the ...Show All

• SQL Server Dynamic Excel Sources

  Please help.... I have different files that are sent from our vendors. Some are TXT and some are XLS. Some will have the same structure. I plan on grouping these together as best as I can. My main problem is that I would like to go from one source that matches a group of files to a single SQL table. I'm still learning about SSIS and its capabilities. If I can get pointed in the right direction or have an example to work from, that would be ...Show All

• SQL Server How do I get AdventureWorks to show in sql2005.

  How do you make the AdventureWorks sample show up (June ctp)   I already installed it using the msi file: "C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi" But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step).  What's missing Right-click Database Engine , point to New , and then click Server Registration . The New Server Re ...Show All

• Visual C# Trying to import a 3rd party C++ DLL into my C# code.

  Hi, Trying to import a 3rd party C++ DLL into my C# code. I have an entry point that is defined in C++ as: bool TSysCall(int id, int param, void *ex) I am having trouble trying to figure out how to define and use it in C# since the 3rd parameter of the function call is a void pointer and can be a pointer to an int, a pointer to a byte and a pointer to a structure in some cases. Here is what I am trying to use: [DllImport("MySys.Dll", EntryP ...Show All

• Windows Forms Security Pane

  Hi, Whenever I click on the Security Pane in the Project Designer, I get the following error. I am using Whidbey Betat 2 on Win XP SP2 machine. Is this a beta bug I know i can configure it using Mage, but just wanted to see the Security Pane. --------------------------- DataGridView Default Error Dialog --------------------------- The following exception occurred in the DataGridView: System.ArgumentException: Value does not fall within the expe ...Show All

• Visual Studio Team System Newbie: Understanding work items

  I'm in the process of evaluating TFS and VSTS on an isolated network with an eye towards upgrading our development. We're a very small shop, so we should be able to get along nicely with 5 client licenses and using minimal process (eventually upgrading our process model as we grow). I'm trying to understand something about work items and I can't seem to find the precise scenario I'm wrestling with covered anywhere. First, I want to record enhanc ...Show All

• Visual Studio The suggestion of 2 gentmen

  I recently met a problem in my GET operating. When I GET my applications via the Source control of VC6.0, some files of the projects wasn't be get down to my workfolder and it need me to enter the VSS get them manually by myself. Sometimes, there just are several files needed get manually and sometimes it is a hard task to get because of the number of files is so large. Besides, I had to BUILD my application in VC and then GET the non-get file i ...Show All

• SQL Server Encryption By Passphrase

  I am investigating methods of encrypting data in a large number of databases. It seems to me that encrypting by passphrase would be optimum because it would prevent me from having to create all those database and symmetric keys on the various databases (there wil lbe dozens of them). Can anyone give me any advice as whether or not using encryption by passphrase is a good secure method of encrypting sensitive data in a large-scale production envi ...Show All

• Visual Studio Want a difference between Visual Studio 2003 and 2005

  Hi all i want a complete differenct between Visual Studio 2003 and 2005. For eg in 2003 the successful ASP.NET dll files are stored in the bin directory but in 2005 it stored in some other place. like this i want to know all the differences. Are you looking for a general overview of the differences between 2003 and 2005, differences between the versions of ASP.NET, or differences in the programmability model (what this forum is about) Cr ...Show All

• Visual Studio Express Editions VB6 to C# Conversion using VB2005 Express

  I convert VB6 using VBUpgrade in VB2005 and paste all controls to C#. All properties are the same from VB2005 to C#. My problem is...my controls (e.g. labels) are not aligned in VB6 when I compare the VB6 form and C# form by setting the two form location to 0,0 then switch to one window to another ( Alt + Tab ). Please help me on how to formulate that problem. -bachie bachelor_1919@yahoo.com from the forms designer manually ...Show All

• Visual Studio Team System help with wiqlQuery

  Hi All, I am learning wiqlQuery but I have an urgent requirement to get the following info: Finding SUM(Completed Hours) for a person between a date range for all projects( or a given project) Actually we want to derive the utilization of a resource..... Please help me with the query, its urgent Unfortunately this version of WIQL does not support aggregate functions like sum, avg, etc. Thanks, Alex ...Show All

• Windows Forms Change default printer when printing many pdfs

  I'm writing an application which prints out many pdfs at once (hundreds) according to a list the user makes.  i.e. they pick what they want to print from a listbox. I'm using the following code to print the pdfs which works great:     ...Show All

• .NET Development Big Problem: "First Chance Exception" with insert Decimal into SQL Table with ADODB

  Hello all, i'am trying to be simple. 1. I've a view on a SQL Server ==> VIEW1 2. I've a table on the same DB ==> TABLE1 ==> The fields match the fields in VIEW 1 3. With ADODB..., i populate TABLE1  with Data from VIEW1 in Visual Basic .Net. One of the fields is a DECIMAL Size=9, Scale=4 and Precision=18... here the definition in Visual Basic .Net     oCmd = New ADODB.Command     oCmd.let_ActiveCon ...Show All

• SQL Server Group By Expressions

  I'd like to dynamically create a group by expression. I have select sourcecd FROM dbo.ITMV_ScanCardHistory GROUP BY dbo.fn_GroupBy (@GroupBy) Where: @groupby = sourcecd and fn_GroupBy = CREATE FUNCTION dbo.fn_GroupBy (@ColumnName Varchar(55)) RETURNS Varchar(55) AS BEGIN RETURN @ColumnName END I keep getting this error message: Server: Msg 164, Level 15, State 1, Line 48 GROUP BY expressions must refer to column ...Show All

• Visual Studio Express Editions P: Update to DB with VBE & SQLE; Q: Where is the problem or what is missing?

  Pre: - WinXP En SP2; latest patches - VBE installed - SQLE installed & running on same machine Scenario: 1. Start VBE 2. Create new WinApp 3. Add new DB; complete Wizard; crated DB & DS is empty 4. Open DB; create a Table with three Columns ("idUser",int,Ident Spec = Yes,DBNull = No;"Firstname",nvarchar(50),DBNull = No;"Lastname",nvarchar(50),DBNull = No) 5. Open DS, drop created Table from DB Explorer to ...Show All