Eric George's Q&A profile

• SQL Server Select Statements in SQL 2005

  I know this is probably a dumb question but I need to find a for sure answer on this. When a developer writes SELECT statements in their code will the * clause work with SQL Server 2005 We have tried to discourage such activity but has not worked. We are in the process of moving our systems to SQL Server 2005 and wanted to know if this would be a gotcha. Thanks for any advice, comments on this subject. Jeremy Jeremy: For one thing, select * leaves "land mines" in stored procedures. What happens is that the meaning of select * is determined at stored procedure compile time and not at stored procedure run time. The problem occurs when a column is added or removed. Since the meaning of SELECT was determ ...Show All

• Windows Forms Application hangs after changing display properties

  Hi, I am working on a Windows Forms app. The main form has TabControls, Panes, TreeViews,...When it is running, if I change anything from Display Properties (screensaver, desktop, it does not matter.. just pressing OK) then my app gets freezed: cannot repaint, cannot be moved, it does not respond. According to Task Manager, the task is active and the CPU and memory use seem ok. Even if I do not change Display Properties, this behavior occurs randomly. But it does not happen when I am debugging. I am using Framework 2.0. Is anybody experiencing this kind of problems Is there anything I can test to get more details about what is going wrong Any help will be appreciated. Thanks. Check this thread . ...Show All

• Windows Forms DataGridViewColumn - DropDownDataGridView

  I had an idea. I need a multicolumn combo box in a cell of a datagrid view. So I got to thinking of different ways to do this... Then it popped into my head. Why not use a datagridview for the drop down So I'm going to attempt it... I just have one question though.. I would like to expose all of the datagridview properties through the Column object. Obviously, the dropdown datagridview has to be a member of the editing control... So how do I expose all those properties in there to the column and have them pass down the column to the editing control Thanks, Aaron I struggled with this and what I ended up doing was positioning a hidden - multi column drop down above the grid cell in the datagridview rowPostP ...Show All

• Visual C# [c to c#] function with ptr to struct as parameter

  hi all, i have to use this function from a c DLL. The function need pointer to struct as parameters. [ DllImport ( "SeqManager.dll" , SetLastError = true )] static extern uint SeqManagerGetSequenceList( out SEQUENCE_INFO ppSleepSequencesList, out SEQUENCE_INFO ppMoodSequencesList, out SEQUENCE_INFO ppNapSequencesList, out SEQUENCE_INFO ppWakeUpSequencesList); the SEQUENCE_INFO structur is like this : [ StructLayout ( LayoutKind .Sequential)] public struct SEQUENCE_INFO { string szPathName; string szFileName; uint dwDuration; string szGuid; IntPtr pNextSequence; }   when i use the following code i get an unknown exception pu ...Show All

• SQL Server How to count the number of occurences of a value in a column

  I have a report, for which I want to keep track of the number of times a value is recurring. eg. Column A Column B Column C A 5 0 B 3 0 A 0 1 B 1 0 C 0 2 D 0 3 So, in this example, I want Column C to keep a running count of the number of times zero occurs in Column B. I was thinking about using a global variable and increment it whenever column B's value was 0 but I haven't a clue as to where to begin. Any help will be appreciated Thanks Use a conditional RunningValue in a table detail column ...Show All

• Visual Studio Express Editions canot debug is this VB?

  Dear all, I am an upsolute beginner in programming - somebody was so nice to write a part of the program I would like to use. And this part does what I expect when I do run it. However since i have more to accomplish I need to use this start and amment it / edit it. For this purpose i did not only import it into VB express but also tryed to debug it to unserstand each line of code. However i does not work. is this code VB to begin with regards and thanks still Hoosier IsDebug = False Set Maps = CreateObject("MSXML2.DOMDocument") Maps.load("Maps.xml") Set FSO = CreateObject("Scripting.FileSystemObject") CurrentPath = FSO.GetAbsolutePathName(".") & "\" ...Show All

• SQL Server F7 Key : Summary -> Object Explorer Details

  Hi, Where is the F7 key that in the past showed the Summary The Summary has been changed to 'Object Explorer Details' but is no more accessible by pressing the F7 key :-( Why did you do that MS With keyboard sheme SQL Server 2000. F2 for renaming doesn't work. I am not all happy with that sheme..., looking forward for a real fix or better walk-around. ...Show All

• Windows Forms Object Data Source

  Hi, Can anybody give me some example of Object DataSource with VB.NET Code. btw, i have other doubts 1.What is Detailed View 2.What type of Data Controls willbe used in real development world (Web) Thanks This forum is for windows forms databinding please ask asp.net questions in the asp.net forums . ...Show All

• Visual Basic making a trial version

  hi, i am making software, but I want clients to be able to experience a 15 day trial of it before deciding to purchase it. Can anyone tell me how i can do this thanks, isaac Thanks but I can't seem to find the kit to make a 30 day trial. Can you please tell me which one you had in mind Anyone else have some more ideas Thanks again. -Isaac ...Show All

• Architecture High availability application

  Hi Everybody! We are starting a project to develop a mission-critical web application (therefore, availability,reliability and scalability are major concerns). We are thinking about using a SOA approach, using WCF services hosted on IIS (using a cluster in order to provide the required availability, scalability and reliability). My questions are 1) I've seen that WCF can be hosted on IIS or as Windows Services. I'd like to know the advantages and disatvantages of each approach (considering specially performance and development/deploy effort issues) 2) Is there any reference we could use in order to estimate the hardware requirements to support the solution (the information we can use to estimate it a ...Show All

• SQL Server Issue with SQL Parameter when used with % character.

  Hi all, is there a known issue when using a SQL Paramater in a SQL string that uses a '%' character for wildcard string searches For example, if I used the following... SQLCeParameter pKeyword = new SQLCeParameter("@Keyword", SQLDbType.Char); pKeyword.value = "Some Text"; string strSQL = "SELECT * FROM tbl_Keywords WHERE (Keyword = @Keyword%)"; This just never returns and results. But if I run the query in a query analyser window replacing the @Keyword% with "Some Text", I get results. I guessing that the placing of the character '%' in the string is the cause maybe... >>This just never returns and results. << What does this mean It returns nothing Or it takes forever ...Show All

• .NET Development Computed Columns in TableAdapters

  Hello, I'm very frustrated with the TableAdapter created by the dataset designer in Visual Studio 2005. Here's my problem: My select statement is just a select * from X. Some of the columns are computed columns, and should not be included in the update or insert commands. However, they are. I can't seem to get it to not include these columns in the update and insert commands without removing them altogther. This problem did not exist in 2003. Any advice Thanks, Bryce Hello CAnil, you're right, he has to change the insert and update statements of the tableadapter, if he is using computed columns in his database (like I described above). But I dont understand why VS2005 does not recognize that ...Show All

• Visual Studio Team System Machine rename makes webservice unavailable?

  Last week i built a TFS VM running win2k3 etc from a vhd. I think it's a standard demo image. When joining to Redmond i renamed it uniquely. The original name was tfsrtm. Now i can't hit the webservice despite trying many things. Logged in as the admin specified in the readme that came with the image, i added my Redmond account and installed 55 updates. I also renamed the TFS website uniquely, the same as the machine, in IIS. The machine can be pinged but the TFS webservice status page yields "Service Unavailable" in IE. Of course then neither the server be added to the server list via Team Explorer (TF32001 on host TE & TF32005 on vm TE). That's what i need to get started! So here's what i've tried: Working on jus ...Show All

• SQL Server passing a boolean parameter to a package

  hello at everybody well i have a problem. with in a package i defined a bollean variable with the name "x" and with a default value FALSE. i created a configuaration file that contains the variable "x" as [user::x]. when i deploy the package to a server and i try to execute the package putting to the set values TRUE fror the x variable it doesnt work. what can i do thnxs kats wrote: hello at everybody well i have a problem. with in a package i defined a bollean variable with the name "x" and with a default value FALSE. i created a configuaration file that contains the variable "x" as [user::x]. when i deploy the package to a server and i ...Show All

• Smart Device Development Help discovering devices (obex.h)

  Hi, I would like to connect to a device but i don't know its name or address. I have only 2 informations abut the device, they are the class of device (0x52020c) and the name of the service provider for its services. I use an asynchronous discover method, but when i read the PropertyBag's i receive i can't read any of these two informations (service provider or class of device). I can only read Name, Address, Transport, Port and ServiceUUID. Does anyone know how to get more information about the device or its services ...Show All