devinr's Q&A profile

• Visual Studio Printing without the ReportViewer

  In a Win Forms app, is it possible to print a report without using the ReportViewer control I want to provide a print button on a Form (like Outlook does) and then use an embedded Report to print the data so I don't really need the ReportViewer. I would want to display the PrinterDialog though and use the settings from here to control the printed Report. Is this possible too Regards Graham Well, I'm so close yet so far. I have found the GetPrintDocument method  on the Viewer and I thought I could do something like: All in code... 1. Create a ReportView Control. 2. Set the LocalReport properties for the report datasource and resource 3. Create a PrintDialog control. 4. Set the printDialog.Documen ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with Xna Game Studio

  I'm an Italian developer and i don't know english well. I'have a problem with Xna Game studio: I have installed xna game studio When I start Microsoft Visual C# Express, i choose the menu file and new project and I'click on the template Windows Game (Xna) for creating a new game project. The project is opened and when start the debug of the application. The IDE show me this message: "The values used in the attempt to create the GraphicsDevice were invalid." selecting the code line: this.GameComponents.Add(this.graphics); I would want to know like debugging the application without error Please help Me I start Visual C# using the na game link. For StevenAFC Thank you, I have add the code line j ...Show All

• Visual Studio 2008 (Pre-release) ComboBoxItem Popup shows behind rectangle

  My comboox popup appears only behind the rectangle: <Window xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xml:lang="en-US" x:Class="UntitledProject4.Window1" x:Name="Window" Title="Window" Width="640" Height="480" Background="{x:Null}" WindowStyle="None" Opacity="1" AllowsTransparency="True"> <Grid x:Name="LayoutRoot"> <Rectangle Fill="#FFFFFFFF" Stroke="#FF000000" StrokeMiterLimit="10" StrokeThickness="0" RadiusX="20.5" RadiusY="20.5" Margin="5 ...Show All

• SQL Server SQL Server Equivalent for Oracle System Tables/Views

  We are in the process of supporting two databases (Oracle 10g, SQL Server 2005) for our application. I want to know what is the equivalent Tables/Views in SQL Server for the Oracle System tables dba_tab_comments, dba_tab_cols Thanks in advance You could just query sys.columns or sys.all_columns from account with DBA privilege. As for the comments, you can query sys.extended_properties (with appropriate filters) or use fn_listextendedproperty table-valued function. ...Show All

• SQL Server Database Mirroring Transport is disabled in the endpoint configuration.

  Hi. I am getting this error. Msg 1486 , Level 14, State 2, Line 2 Database Mirroring Transport is disabled in the endpoint configuration. Someone please help me.It's urgent. I am using same PC with 2 different intsances. This is how i have done it: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'test@#56' GO -- CREATE CERTIFICATE PRINCIPAL_CERT CREATE CERTIFICATE PRINCIPAL_CERT WITH SUBJECT = 'PRINCIPAL CERTIFICATE' , START_DATE = '03/07/2006' , EXPIRY_DATE = '01/01/2010' GO -- CREATE ENDPOINT NAMED (EPMIRRORING) USING CERTIFICATE AND ALGORITHM CREATE ENDPOINT EPMIRRORING STATE = STARTED AS TCP ( LISTENER_PORT = 6025 , LISTENER_IP = ALL) ...Show All

• Visual Studio Express Editions NEW to prgramming/VBE

  OK I'm having a hard time trying to get a program together, I thought I was clever enough to cut and paste here and there and to get the thing done. Well, I'm clever enough to see that I can do it, all the books and articles I've found aren't of much help, because I'm starting from scratch, don't care about the web and I have loads of string manipulations to do, basically I'm trying to build a custom log_files interpreter. So here is the questions: Were can I find decent documentation/books that I can source, document myself and get going THX to all that can answer or provide guidance PAOLO     Yeah but Carsten..... that's called Fortran IV :( Actually, I ...Show All

• SQL Server How to drop a Queue Reader Agent ?

  Hello, by mistake I added an queue reader agent to a distribution database. But how can I drop the queue agent. There isn't a stored proc 'sp_dropqreader_agent'. The only way I found (apart from dropping the whole distribution databse) is to stop and disable the generated job! Is there any other way to get rid of the queue reader agent Wolfgang Only supported way I know of is to run sp_dropdistributiondb. I haven't tested this, but as dbo or 'sa', maybe you can manually delete the job ...Show All

• .NET Development Storing and retreiving Files (e.g. pdf's or word documents) in a varbinary(max) column ..

  Hi together, in my database application I need to store files in a column named FileData, which I realize with the OPENROWSET BULK command Dim strCommand = "Update [DB1].[dbo].[Table1] SET [FileData] = (Select * FROM OPENROWSET(BULK N'testfile.txt ', SINGLE_BLOB) AS FileData) WHERE [ID] = 1" Dim cnn As New System.Data.SqlClient.SqlConnection Dim cmm As New System.Data.SqlClient.SqlCommand cnn.ConnectionString = "Here comes the connection string" cnn.Open() cmm.CommandText = strCommand cmm.Connection = cnn cmm.ExecuteNonQuery() cnn.Close() So far so good - the file seems to be stored correctly in the db-Table. But how can retrieve the file, or find out the ori ...Show All

• Smart Device Development XP Pro Local Smart Card Logon

  I was wondering why it is not possible to log on to a Windows XP Pro machine locally using a Smart Card. I have looked in the Local Security Settings console and have found this under Local Policies > Security Options. "Interactive logon: Require smart card" It does now state that you have to be on a domain in order for that to work. I have even tried using NetSign to force my system to prompt for Smart Card in order to log on locally but it keeps prompting that there is no smart card present when inserted at the logon screen. I even forced Ctrl+Alt+Del to be pressed to log on and it still prompts for smart card to be inserted even after I have inserted it. Is there any software out there that can force Smart Card to be ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Could C# be the future of gaming?

  Since XNA is using C#, and is is a more intuitive language than C++, is it possible that in the future that C# will dominate, espessially in AAA titles. Could XNA be ushering a new way of programming in the main stream QuantumMischief wrote: Since XNA is using C#, and is is a more intuitive language than C++, is it possible that in the future that C# will dominate, espessially in AAA titles. Could XNA be ushering a new way of programming in the main stream I think, before XNA released,C# isn't the primary gaming language but,since XNA will be released, it's said that in the FAQ,C# will be the important gaming language. hehe ...Show All

• SQL Server Running Value (Chart in a Table)

  Hello I have a report with a Table, in the table I have SubReport1, in Subreport1 I have a Table1, inside table1 I have another table2 and Subreport2. Subreport2 has 4 different type of charts, depending on the passing parameters from the second subreport 1 of the 4 charts is displayed. In one of the chart I'm using the Running Value function, works fine ONLY the first time the chart is displayed, after that the charts shows no values. I'm using a series group, which changes for every row, for what I understood the value should be reset everytime the series changes (100,101,102), but that is not the case. Group level values are 1/10, 2/10, 3/10 etc up to 10/10. Series level values 100,101,102 etc. Thank you ...Show All

• SQL Server Using CTE in data paging

  I explore a possibility of using Common Table Expression (CTE) instead of temporary table in data paging. But the problem is that it looks like I can reference CTE only once in my script. I need to return data for a current page as well as the row count for entire selection. Here is my script: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_name, first_name), first_name, last_name from contacts where last_name like 's%' and first_name like 'm%' ) select row_num, first_name, last_name from names where row_num between 41 and 60 -- 3rd page order by row_num select count(*) from names go It selects 20 records, however it displays an error when it tries to execute select count(*): ...Show All

• SQL Server bcp error - restricted access datatype violation

  I got my bcp in and out to work, and also the format file creation. Now, when i'm importing some of the more strange tables, I get: SQLState = 07006, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation I can barely find anything on this by searching on the web - and not anything I can see relevant on MSDN. I'm guessing the problem is because there are all sorts of float fields in the table, but I don't know, and I don't know how to fix it if it is... Help! My code works on smaller, less complicated tables, but not on the bigger monster. When it fails, does the table have any Text, NText, or Image columns And are any of these fields Null in 1 or more rows Is the field t ...Show All

• Visual Studio Express Editions cannot convert from string to integer

  I am having some difficulty with my code. When I run the program, the Sub tells me the values(ie: RECash2,3,4,&5) are "". Only RECash1 is "0". When I change the values during debugging and continue, the program runs fine. My problem is that I cannot get the values to save after changing them, or to change them before running the program. Any help would be appreciated. The code I have is: RECash1.Text = "0" RECash2.Text = "0" RECash3.Text = "0" RECash4.Text = "0" RECash5.Text = "0" RECash6.Text = "0" RECash7.Text = "0" RECash8.Text = "0" RECash9.Text = "0" RECash10.Text = " ...Show All

• Visual Studio Express Editions Database problem

  Hello to all: I have a database program that is supose to let the user select a date from a DateTimePicker control or I can use a text box but then again maybe a combobox might be better, don't really know. Anyways, the program must display the first and last names of all members who joined before the selected date(1992 to 2005). My problem is that I do not know how and what to install in the Date timePicker or textbox control or combobox. Please note that I already have the grid complete with the lastnames, first names, phone and date joined. Any code examples and help are welcome well you can use the datetimepicker and look at the date they chose using the Value property then perform your query against the database based o ...Show All