AlfonsAberg's Q&A profile

• Visual Studio Express Editions BgWorker report Proress

  Im trying to get my BgWorker to report his progress.. i do private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { progressBar1.Value = e.ProgressPercentage; } and it dont work :s *Reportprogress support is Enabled = True ---- *My BgWorker downloads a file with WebClient since i've never worked with the backgroundworker, so bare with me, perhaps place it in the same place as you had the original code (setting the value property of the progressbar) Reading the tooltips, im not sure if this will work or not as the value property is being set to the current progress in the backgroundworker, as you are doing, but performstep seems to add 1 to the s ...Show All

• SQL Server Can a non-admin user generate a create database script?

  I am trying to generate the create database script using SMO. The issue is the user account which connects to SQL server is not SA, SMO fails to generate the "Create Database" script with error User ZZZ\User1 does not have permission to run DBCC SHOWFILESTATS. Is it possible to generate a "Create database" script using SMO when you are connecting to the SQL server using NON-ADMIN account The user login is a part of db_Datareader role on the database. I tried following grant permission to the concerned account at server level Grant view any database, grant view any definition and grant view server state. Still it fails. Any idea If the production server is owned by the other ...Show All

• SQL Server Flat file to DB upload approach question

  Hi guys, Suppose I have a flat file that had columns that went like this: rackId, cdname1, artist1, year1, cdname2, artist2, year2, cdname3, year3, artist3,...cdnameN, yearN, artistN And I want to map it to a table that has the ff columns: rack_id | CDName | Year | Artist Assuming that N is constant and all rows of the flat file will have N or less values filled up per rack, how do I map the fields from the flat file such that cdname1, cdname2 and cdname3 all fall under the CDName column, year1 and so on will fall under the Year column, and artist1 and so on will fall under the Artist column If the number of columns is even across the file; you could use the unpivot transformation on the dataflow http://msdn2.microsoft.com/en-us/lib ...Show All

• Visual Studio Team System overlapping of counters in counter sets

  The IIS and ASP.net counter sets include some of the same counters, such a "% Processor Time" if I map these 2 counter sets to the same webserver, will the data recorded for "% Processor Time" be affected by the fact that the counter is mapped twice in other words: will I see the same results for "% Processor Time" if I only mapped the IIS counter set by itself, as I would if I mapped both the IIS and ASP.net to the same webserver. thanks ...Show All

• SQL Server Tell Us Your Express Story and Win $100!

  Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express We’re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate to Amazon.com! http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx On Saving Time. It was a cold and rainy December night in Canada...throwing caution to the wind, I stepped out of my computer nerd \ I.T. guy label so rudely applied by the women in the accounting department and downloaded SQL Server Express with the Advanced Features. Knowing full well that the documentation strongly suggested t ...Show All

• Software Development for Windows Vista How to manage FillBufer function in source filter from application ?

  Hi I receive stream with video (h.264) and other data (values from sensers) via one USB. I must separate video and ather data in order to send video stream to render and process data. I can write simple source filter which send h.264 video data to video decoder and render filter. But when I receive stream with multiple data I must separate data. I don`t know where to separate date (in source filter ) maybe in apllication What way would by the best Separate data in sample graber would by correct If I separate data in application how to transmit video data to FillBuffer function in source filter Best regards Tomys This was also posted to microsoft.public.win32.programmer.directx.audio Please ...Show All

• SQL Server IIS Compression for Report Manager

  Hi, We've been playing around with IIS compression to maximize the performance of Report Manager. We've discovered that we can dynamically compress AXD just like ASPX, although when we do this, the Export functionality causes the default file name for export to become: ReportViewerWebControl.axd.<ext> Any comment on this Should we just avoid compressing AXD I've noticed that responses from the server with AXD extension are a bit big in terms of byte size when it's not compressed. Thanks. ...Show All

• .NET Development get data from access and save it into a new excel file using vb 2005

  Can some1 give me a small sample of how to do this Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [Excel 8.0;DATABASE=c:\Test Files\Book1.xls;HDR=NO;].[ExcelSheetName] from [AccessTableName]", AccessConn) Sorry the code does not work,   is the { ExcelSheetName] from [AccessTableName]",  a table name in the data base This is the my modified version Dim AccessConn As New System.Data.OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\Temp\db1.mdb" ) AccessConn.Open() Dim AccessCommand As New System.Data.OleDb.OleDbCommand( "SELECT * INTO [Excel 11.0;DATABASE=c:\Temp\Book1.xls;HDR=NO;].[ExcelSheetName] f ...Show All

• Windows Forms Steam, Runtime error

  --------------------------- Microsoft Visual C++ Runtime Library --------------------------- Runtime Error! Program: C:\Program Files\Steam\steam.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. --------------------------- OK --------------------------- Can anyone explain this to me and maybe give me a solution please Thanks Ken I'm sorry, but I have no idea, I'm afraid to say that only Steam will be able to help you. That error message means very little without access to the source code, and only Steam has that. ...Show All

• Visual Studio Unbound Fields

  How do you send a value/variable in code to an unbound field I have not been able to find any code what-so-ever regarding this issue. Any help is appreciated as well as code samples to show how this process is done. Thank you Ok. Thought i would post the result i have come up with for VB programmers. Private Sub DisplayReport() Dim rpt As New CrystalReport1 Dim root As CrystalDecisions.CrystalReports.Engine.TextObject rpt.Load() root = rpt.ReportDefinition.ReportObjects("Text1") root.Text = "Italy Wins!!" CrystalReportViewer1.ReportSource = rpt End Sub The problem i was having earlier was due to the fact that i was not casting the ReportObject as a TextObject. ...Show All

• SQL Server Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• Windows Forms Saving Record with datagridview

  Hi all, I desperately need help saving records to my database using a datagridview. I have created a store procedure running on oracle database. I have four text fields and a datagridveiw control. I am able to insert records from the textboxes using data from the textboxes as parameters to the procedure. This works fine, but I cannot save the data in the datagridview as I do not know how to access the individual columns/cells and passing them as parameteres to the procedure. I come from oracle forms background and completely new to VB.NET. I am really struggling to get this to work, can some please help. Any sample code or a link to some tutorials will be greatly appreciated. Below is the code I am trying to use Private Sub tsbtnSave ...Show All

• SQL Server query help

  Here is a simplified example of what I need to accomplish. I have a table that keeps track of plastic balls in tubs.  Based on a bit column the record is either defining balls added to a tub or taken away.  When the record is defined as adding balls to a tub it will say how many and what color, but when the flag says they have been taken away from a tub I only know the number removed and not the color. There are multiple tubs and multiple colors. So say tub1 has 20 balls in it (50% red, %25 green, and %25 blue). Also say tub2 has 10 balls in it (100% red).  This is our starting point. Now on day one, 5 balls from tub two are put into tub one. So we know that 5 balls of 100% red are put into tub o ...Show All

• Visual Basic GetDevicePowerState

  Hello all out there! My Goal is this: I want to determine if the star USB strip printer is powered on and in the ready state before i print to it. So far: I am using the Printer_Info_2 status (buffer(18)) to get the status. This works fine except for when the printer is powered off. Then the function returns a status of zero which is equivilant to the on line and ready status. This is a USB printer. I have observed that there is a printer driver detail in the device manager whose name is "Current Power state" . When all is well, it is 'D0' . when the printer is powered down, it is gone or blank. Therefore the potential is there to accomplish my goal. The information i am seeking to get, is located in the Device ...Show All

• SQL Server problems with SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

  I configured everything like written in the redme file, then installed SQL Server 2005 Reporting Services Add-in for SharePoint Technologies. But when i try to access any Sharepoint site, i get this error in browser. Can anyone help me to handle it The website declined to show this webpage HTTP 403 Most likely causes: This website requires you to log in. What you can try: Go back to the previous page. More information This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage. For mor ...Show All