Andrew Mayorov's Q&A profile

• SQL Server Question On How to get the Table object to filling blank space on page???

  Greetings, I have reports which use a table object with various groupings and this table object has a footer row w/ a sub report that displays dynamic address information based on the groupings. I would like to have the address information located at the bottom of each page. Based my interpretation of following solution taken from the RDL Specification {see bellow excerpt} I have moved my table object within a rectangle object which is sized the page size but the table does not grow to the rectangle size…Can anyone tell me what I am missing here RDL Specification (2003) excerpt: Q: How can I indicate that my table should grow to fill the blank space below it (rather than preserving the blank space) A: Group the tabl ...Show All

• Visual Studio Tools for Office Define function in .NET and call from Excel

  Hi all, I wonder if it is possible to define a function in .NET and use it as Excel calculation. I mean for example I define a function in .NET as follow public double CaculateDV(double a, double b) { // do some calculation return abc; } Now in the Excel spreadsheet I'd like to be able to type =CalculateDV(A1, A2) in one of the cell, hit Shift-F9 and it should call .NET passing the correct argument. Is this doable Cheers, Victor Victor, First - Did You manage to solve the issue here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1181639&SiteID=1 Second - I suggest that You take a closer look into Eric Carter's blogpost about writing UDFs for Excel in .NET: http://blogs.msdn.com/e ...Show All

• Visual Studio Express Editions Fuzzy search on DB field contents

  Hi, How would I code to search for any word within a DB field. For example: I have a column called Description and have the following info saved in one of the fields for this column, Computer Display Flatscreen. I would like to search for any of the words contained in this columns field, say Display, and fill a table with all records found. Can this be done Any help appreciated Ron Thanks Guy's I have a new question Using SQL Server Management Studio Express I can write the following SQL script which allows me to search the description column for data that contains the word "display". The declare @filter nvarchar(5) lets me set a fuzzy search level, how many characters ne ...Show All

• .NET Development Embedding DLL in Web Page and trying to Access Client machine from web Page

  I have an DLL(Windows Control Library) for media player developed in C#.net.I embedded this DLL in my web page.I have to create and save an Audio file in the Client machine from my web page. Using web service later i upload Audio files from my client machine. This is what i am trying to do !!! But Problems arises in Scenarios like : Scenario 1 : In development System Control appears in Web page but when i try to access from other Client System i am not able to view Control in Web page.I have used I/O functions in my DLL.Since I/O operations in Client machine are Security issues. Operations which i Performed to Execute but Output is not obtained as mentioned above : - I Created Strong Name for DLL and imp ...Show All

• .NET Development help: Update Records In a Database

  I'm not using sql. All I've done is placed a dataview grid on the form and set up a datasource. Then I set up the text boxes so when you click on one of the records on the dataview grid it will shows the rest of the data from that set into the textboxes (That works). Then when I click an add button a new row appears (This also works) and then I am able to type into the textboxes with the information as required (this works). Then I'm stuck to actually update the database file because as soon as you close the form the new data is lost. I have tried using this code construct (not included all textboxes though) DataSet .tablename.column = textbox1.text; this .tablenameTableAdapter.update( this .dataset.tablename); The error ...Show All

• Visual Studio Express Editions multithreading nightmares

  I'm having some trouble multithreading even after reading articles, so I'll ask my questions here if it's okay. Most of my problem lies from here: For i As Integer = 1 To num thread = New Thread(AddressOf worker) thread.Start() Next i and the worker thread: Private Sub worker ' update a textfield Threading.Thread.sleep(sleepTime) End Sub Ultimately the job gets done;however, the program freezes up and then updates the textarea information all at once at the end. I have two questions: - How can I make it update the textarea simultaneously and without freezing the application - In the loop, how can i wait until the previous thread has finished (I've tried having the Threading.Thread.sleep() statement in the loop, but ...Show All

• SQL Server Custom Code for a Parameter

  I'm using a GAC-installed assembly as part of a Reporting Services (2005) report. The code does not need any permissions beyond execution. All it does it take today's date and calculate last week's start and end date. It's all just datetime manipulations. All methods are static. In the VS2005 report designer, I can do everything fine. The code runs as expected and defaults the parameters to the right date. When I upload the rdl to the Report Server, I get the message "Error during processing of ‘Start’ report parameter. (rsReportParameterProcessingError) ". If I override the "Start" parameter, it doesn't give me that error anymore. Start should be the Sunday of the previous week. I have deployed the signed ass ...Show All

• SQL Server Complex Query question. Using Sum and CAST operation.

  Hi Can onayone tell me what is wrong with the below code. Thank you, SELECT P.FirstName, P.LastName, P.PortfolioID, P.PortfolioDescription, SC.Description, SC.SecurityID, SC.SecurityTypeID, SUM(T.Quantity) AS TQuantity, CASE SC.SecurityTypeID WHEN 11 THEN CAST(SUM(T .Quantity)) WHEN 2 THEN CAST(SUM(T .Quantity * (SELECT Price FROM dbo.SecurityPrices AS SP WITH (Nolock) WHERE T .SymbolID = SP.SecurityID AND PriceDate = '1/24/2007'))) / 100 ELSE CAST(SUM(T .Quantity * (SELECT Price FROM dbo.SecurityPrices AS SP WITH (Nolock) WHERE T .SymbolID = SP.SecurityID AND PriceDate = '1/24/2007'))) END AS Amount, P.AccountNumber, P.Acco ...Show All

• Smart Device Development WAV to WMV conversion

  Hi I want to convert a WAV file to WMV file to reduce the memory size. Whether there is any API is there to do this Or it is necessary to install DirectX SDK. Throw some light on this issue. Thanks in advance Hi, This forum is primarily monitored by Visual Studio for devices group. Please check this link for more appropriate forum for this type of queries. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 Thanks Srikanth Bogadapati,. ...Show All

• Visual Studio Express Editions Ressource editing is not supported...

  Hello, New to MS Visual Studio 2005 Express, I was trying to migrate an application made with MS VS 2003 Pro .NET. After installing MS SDK express edition and modifiing the properties of my projects, everything ran fine, I was able to build and run my application. But, I needed to modify something in the .RC file, and was surprised to see a message: "Ressource editing is not supported on the Visual C++ Express SKU" What I can do is there any option to turn on, or any additional software/package/plugin to install Or do I need to upgrade this Express version to a non-Free version Thank you in advance for your answers, Thierry ROBIN PS: for those who asked themselves why such a need, it's because I'd like to co ...Show All

• Visual Basic All Caps to Title Caps

  Hi I need to create a macro that will start at the begining of a Word document and select all sections of text that are in ALLCAPS. It then must change the instances of all caps to title or proper caps. However there are specific two letter codes that must remain as all caps. Is this possible Basically, a mail merge that uses a database query as the datasource is importing address and name details in allcaps. To maintain professionalism, it is desired that these items are in proper caps. However, the letter contains two letter 'class codes' that must remain in all caps (eg. BI, FH, LF, NM). I am only just learning VB and can only get the macro the select the whole document and change it to proper caps. Manually selecting the requi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Editing Textures programmatically

  Is there anyway for a program to alter a texture after it's been loaded With C# forms, it's possible to call .createGraphics on a component so that you can draw lines and images, etc. on it. I was wondering if there's anything similiar for textures Have you tried these http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=713123&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1048301&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1067445&SiteID=1 ...Show All

• Windows Forms Poaching application's controls

  Is it possible, after including reference to Access, to work down the Access object structure it's data grid (Sheet View) and insert that into a form. Bigger question is is it possible to insert other application's controls into a form Thank you for pointing me in the right direction. But still up a blind alley, can you point me to an example, anything involving the use of an externally referenced .net control, and I will adopt it from there. So long as I can use the control whilst running Visual Studio I do not need to distribute the resultant compiled code. Thanking you in anticipation, Nameoor ...Show All

• Community Chat Visual Studio and Design Patterns

  Is there a tool to develop, in an automated way, design patterns from Visual Studio 2005   Thanks a lot. I'm not certain there is a FREE tool for such ... but there is this: http://www.dofactory.com/Framework/Framework.aspx ...Show All

• SQL Server What is wrong with this connectionstring

  Dear readers, I have a .Net function witch gets data from a Cube. This function is called from a Report. when I preview my report from my computer it works fine. But when I deploy the report to the server on wich also the cube is processed I get the following error: Either the user, NL01\SRV03-GC-10$, does not have access to the Invoicing database, or the database does not exist. NL01\SRV03-GC-10$ is not a user in my system, so I'm stunned with this strange error. This is my connectionstring: string connstring = "PROVIDER=MSOLAP;DATA SOURCE=SRV03-GC-10;INITIAL CATALOG=Invoicing" ; I even replaced the servername( SRV03-GC-10 ) with localhost, but I stll get the same error. I would appriciate any reply on this. ...Show All