yuryk's Q&A profile

• SQL Server Programmability of parameter bar(layout/items)?

  Hi all, does anybody of you know how to code and customize the parameter bar of the SSRS reports I know about putting code behind expressions but how is it with parameters How is it possible to... 1. define the layout of the parameter bar and the positions of the parameter items 2. make the parameter items user-specific Is it possible to define a report with the report designer and hand over data (parameters) by code-behind or a referenced assembly Thanks a lot for any help Best Regards Marc Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection ...Show All

• .NET Development .NET avoiding function within event handler?

  I'm pretty new to .NET i must admit, but i'm stumped by this.  It's on a pocket pc but i dont see how that makes a difference. This is in regard to handling SerialPort DataReceived event.  The event fires ok (well mostly sometimes it hangs up for a few seconds). "void onReceiveData(object sender, EventArgs e)         {             String str;             Regex reg = new Regex("(.*\\r\\n) (^\\$( <String>.*)\\r\\n)*( <Excess>.*) ", RegexOptions.Multiline);          & ...Show All

• Visual J# Create Class Designer values

  I’ve created a class in the Class Designer (VS200 beta 2) that contains four parameters.   Three of them are strings and one is a date. When I click on Create Instance and go to enter the parameters I can’t find a date format that it will accept.   What is the format it requires No for Whidbey, even in next release this would be supported rather we will provide quick way of creating new object(s). Note that OTB is v1 product and we are expecting more feedback from our valued customers and users to enhance this feature. Please feel free to send your inputs on this. Thanks, ...Show All

• SQL Server how do i empty the transaction log

  good day to everybody I have here again encountered the problem that the transaction log came too big that it consume my 10 gig hardisk. How do I empty this in a simplest way. I follow the error message to backup the transaction log to empty the table, but i think it's still the same. I did not see the difference, in short nothing happens. it doesn't empty the transaction log. So what I did is make another database with different name (ex. tempdatabase), and import the tables including the record on the original database... then delete the original database which the transaction log got too big, and after that make a new database with the na ...Show All

• SQL Server Problem with CASE Expression

  Hi, all here, I have a problem with CASE expression in my SQL staments. the problem is: when I tried to just partly update the column a , I used the CASE expression : set a=case when b=null then 'null' end the result was strange: then all the values for column a turned to null . so what is the problem tho Thanks a lot in advance for any guidance. The issue is with your comparison of the column value against NULL using equality operator. By default, <any non null value> <> NULL unless you set ANSI_NULLS to off and this affects few operations in the server. You can check the Books Online for more detail ...Show All

• .NET Development Data Access Application Block for .NET

  Does MS have plan to release a newer version My preferred functions are Include support of customized timeout value Include support of SqlDataAdapter.Fill(DataSet, startRecord, maxRecord), so that I can get only portion of data. They are part of the enterprise library application blocks for visual studio 2005 http://msdn.microsoft.com/library/ url=/library/en-us/dnpag2/html/EntLib2.asp   ...Show All

• .NET Development use a try-catch block

  I am new to C# tell me how to take input from user of int variable in console.   Thanks Hi, You can do this: Console.WriteLine("Place a number"); int x = int.Parse(Console.Readline());   cheers, Paul June A. Domag ...Show All

• SQL Server combining 2 select with count and datediff into 1 select. need help.

  I have created two select clauses for counting weekdays. Is there a way to combine the two select together I would like 1 table with two columns: Jobs Complete Jobs completed within 5 days 10 5 ------------------------------------------------------------------------------------------------- SELECT COUNT(DATEDIFF(d, DateintoSD, SDCompleted) - DATEDIFF(ww, DateintoSD, SDCompleted) * 2) AS 'Jobs Completed within 5 days' FROM dbo.Project WHERE (SDCompleted > @SDCompleted) AND (SDCompleted < @SDCompleted2) AND (BusinessSector = 34) AND (req_type = 'DBB request ') AND (DATEDIFF(d, Datein ...Show All

• Visual Studio Express Editions Can Visual Studio 2005 express be used to create Win32 applications or for future .net versions?

  Hi, two questions: * Can visual studio 2005 express (as in like VB and C++) be used to create Win32 applications If not, why and which program (or which SDK do I need) should I use to develop for Win32. That is, for an audience without having .NET installed. *Lastly, I read in the faqs that Visual Studio 2005 can ONLY be used to develop applications for .NET 2, well then, what about .net 3 when that comes out or for that matter, even for .NET 1.1  If not, why. If it can only be used to develop apps for .NET 2, well, when .NET 3 comes out wouldn't VStudio 2005 be 'obsolete' That sounds like a bad investment of money for me if thats the c ...Show All

• Visual Studio Just Completed a Conversion From an Imake-based Build System Over to MSBuild

  Some stats up front, the old system was comprised of 37 Imakefiles with 2333 lines altogether.  The msbuild system has roughly the same number of MSBuild project files (.csproj and a single .targets) with a total of 2022 lines.  The cool thing is that even though none of these are C# projects I can use a .csproj file and trick VS 2005 into building the MSBuild projects for me.  WRT build times, MSBuild appears to be a bit slower but then again it is still in beta.  The build system builds: yacc files, objective C, C, C++ and managed C++ source files. Overall the port has gone really well and I have to say that c ...Show All

• Visual Basic Get Index to Key in a Collection

  I have a Collection with several items. Now i want to get the index of an item i know the key of. Code: dim a as new collection fill_collection_with_data(a) msgbox (getIndexOfKey("the_key_i_know", a)) 'should now output the index to entry with key named "the_key_i_know" /Code I hope someone could tell me how to create a good getIndexOfKey-function. The collection will hold a lot of data (around 100k entries), so just going through the items and count till i found the matching value would be too slow. Or does anyone know anything else to intead of using a Collection-Object I only want to store strings with an identity k ...Show All

• SQL Server "Replication" between two servers which do not have connection at all

  Hello, Heros of The Programming World! How it is possible to perform "replication" between two databases using technological means of MS SQL Server 2005 if two servers do not have a connection at all. The only thing is possible - is transfer of data for the replication on a CD. What is the best way to do it if central database has a hundreds of such "subscribers" I'm not quite sure I understood why I need to manipulate with master database... As far as I understood from the book about a replication, I need to use schema with one publisher, one distributor and several subscribers. Some of subscribers wil ...Show All

• Visual C++ Web Browser

  Hi, I'm Robert, and I'm new to C++.  I am using Visual C++ 2005 Express Edition Beta and I'm creating a web browser.  My layout is, for the most part, done, now, I have to implement all of the functions.  I need to find out how to make the File | Edit |View | Favorites (My version of "favorites is different, I just used that name so everyone would be familiar with it) |Tools | Help..... As well, I need to make the browser's buttons work, like Go, Refresh, Back etc AND I've tried to send what I've done so far to people, but it won't work for them, and I'm guessing that I have to put in certain dll files or something, how d ...Show All

• SQL Server Failed install of SQL Server 2005 Developer Edition on Win XP Pro

  I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation." This is the bottom of the SQLSetup0001_<machine name>_SQL.log Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14 ...Show All

• Visual C# Custom Scrollbar

  I want to customise the look of the HScrollBar, what is the best way of doing this Extending System.Windows.Forms.HScrollBar and overriding the OnPaint() method This is my first time trying to create a custom control. Thanks for you quick replies! I've overloaded the OnPaint function however it still draws the default scrollbar! it even does this when my OnPaint function is completely empty with no call to the base OnPaint function of HScrollBar. How is this happening ...Show All