MarkAok's Q&A profile

• SQL Server How to integrate reporting services with ASP.Net

  Hi My current situation is how to integrate my application written in asp.net to link to my report server's report  as by default anonymous user can access my report server's report without any authentication. how to configure to make the report server by using form authentication before access the reports  My Application Configuration Web application (Vb.Net) - http://192.168.1.18/mobiFO   Reporting services - http://192.168.1.19/reportserver/reports/mobiforeport DBMS - MS SQL Server 2005 developer edition + Reporting Services 2005 SP1   Thanks for your help. anything can email me at jack0726 ...Show All

• SQL Server Merge replication with dynamic filter

  Brand new to SQL Server 2005 and replication, I was able to use online books info to get a replication topology set up (using wizards) and successfully replicate an article (a single table) to a SQL Server Express database. I then cleared the subscription table and added a simple dynamic filter (colx = SUSER_SNAME()), which I can't get to work. Based on what I read, I'm thinking that SUSER_SNAME() is not returning the proper value because the merge agent is set to connect to the publisher and distributor by 'impersonating the process account'. This is on the subscription merge agent security form. However, 'using a SQL Server login' is gr ...Show All

• SQL Server SqlServer2K5_BOL.msi

  In July I obtained and installed the dvd's SQLServer 2005 Developer Edition CTP so I assume this is the June 2005 version and VS2005  Team Suite Beta 2. I tried downloading the above file for Sql server 2005 Books online and it fails saying I need .Net 2.0  (  seems VS2005 installed .Net 2.0 Beta ) I am also having trouble understanding some concepts ( I am relatively new at this ) Why do I even need this SQL Server 2005 dvd   Seems that VS2005 installed SQLEXPRESS  -  When I look at the SQL Server Configuration Manager, I see MSSQLSERVER and SQLEXPRESS among other things( only SQLEXPRESS is running and that is ...Show All

• Visual C# is it possible to bring machine on domain through a program?

  Hi All I use to work with multiple VMware and VPC images i.e. win2k,xp,windows 2003 servers all editions that also for multiple languages from French to Chinese.. Whenever I install my agent on those machines to communicate with server I need to bring machine on specific domain,or to be precise i want to change machine name and bring it to different domain to communicate with server, Is it possible to have a  program(preferably in c#) or script   which will bring that (client) machine on domain automatically with random user name Or there is any other workaround to achieve this.. Thanks in ad ...Show All

• Windows Forms How to create a Wizard with Windows Forms?

  Hi i want to create a simple wizard for an application consisting of a series of windows that take date from the user and store it in a file. I wonder if its possible to create a wizard with Windows Forms I use Visual Studio 2003 and Visual C# standard edition. Thanks in advance Yes it's possible. There are a few articles online about creating Wizard so have a search around. But I'll cover the basics here. When you program a form you tend to put most of the logic behind the form. For example, on button click do x, y and z. With a wizard approach you'd might think of putting code behind each n ...Show All

• SQL Server A "not in"-lookup?

  Hi, This may be an easy one, but I can't seem to crack it: What would be the best way to implement a "not in"-loopkup. I want all the rows in my dataflow, where the key is not found in a specific table, to proceed in the data flow. I could modify my data source only selecting the rows I'm interested in. However I don't like this solution as it is not very transparent. I could also just use a Loopup transformation and then just use the Error Output for the rest of the flow. I don't like this solution either as it is a reverse approach. Is there a third, and better, solution or will I have to go with one of the two above Regards, Sune ...Show All

• Visual Basic Windows Media Player

  Where can I find a tutorial/information on using Windows Media Player in VB 2005 My particular question is with the URL - How do I code a "navigate" to an internet address and how do I "navigate" to an mp3 file that I want to include with the compiled application I can easily do this in VB6 but am lost with 2005. Thanks You can use the MediaPlayer control in VB 2005 pretty much the same way you did in VB6. Here's what I did: 1) Add the control to the Toolbox by right clicking the Toolbox, selecting "Choose Items...", picking the COM Components tab, and checking the box for the Windows Media Player control. 2) Drag/drop the Windows Med ...Show All

• Visual Studio changing the sql query of the crystal reports programmatically

  this has been eating me up lately. suppose i designed a report which selects all the fields of 'Credit' Table in Xtreme sample database. now i can easily display the data columns using a query embedded in the report. but say i want to cutomize the report and say i want to display the credit amount of customer with Id=1 or say display all the customers with credit amount greater than $500. how can i do this without using paramter fields. can i change the query embedded in the report without altering the database fields but altering the criteria of record selection fron the code programmatically. really need ur help on this. Why not use a ...Show All

• Windows Forms Problem with selected node in TreeView control

  I'm experiencing a problem with the selected node property in the tree view control. I have a context menu setup with the control and if you right click on a node in the treeview it appears to select the node and bring up the context menu which I have displaying different actions you can do to the selected node.  Unfortunately even though the ...Show All

• Visual Studio Tools for Office Prevent creating duplicate calendar items

  I'm working on this tool that among other things creates an item on the users outlook calendar. I would like to prevent creating duplicate items, that is the tool should check to see if the calendar item exists before creating it. Anyone have any thoughts on what the most effective way to do that is Hello, How would you consider an item as a duplicated item By the subject, start/end time and message Anyways, you should be able to create an event sink, check for duplicates before commiting the change. You should be able to find more information on how to do this from MSDN. This forum is mainly for ...Show All

• SQL Server BUG: SSIS imported package errors with 'Guid should contain 32 digits with 4 dashes'

  I have imported a package using SSIS into the Maintenance Plan folder from another server. It imports fine, but when i Modify the package then click save I get the following error : 'Guid should contain 32 digits with 4 dashes'. This has been reported on other forums without resolution. Pete I’m receiving the same error of ’Guid should contain 32 digits with 4 dashes' when modifying the package and try to save it. The server that I exported from is SQL standard. The server that imported on is SQL Ent. Both servers are 32bit. Gene ...Show All

• .NET Development Making VB.net 2003 SqlDataAdapter work

  First, I should note that I am using the Northwinds DB that came with the book I am using(ADO.NET Step-by-Step).  I add the SqlDataAdapter and the Wizard pops up.  I added my connection.  Choose Use SQL statements.  I use the query builder to select several fields from one table, then click next.  On the final page of the Wizard . I get the following: The wizard detected the following errors when configuring the data adapter "SqlDataAdapter1". " Symbol " - this is the symbol before the statements "Check"     Generated SELECT Statement "Check"     Generated Mappings "Warning"   ...Show All

• Visual Studio ReportViewer LocalReport Export File type limitation(VS.NET 2005 beta 2)

  I need export the report to Excel,PDF,CVS,TXT format,but the LocalReport  Export File type only one: Excel . I know the RemoteReport (SQL Server Reporting Services) support many export file types, but the ReportViewer need License , so I didn't try the RemoteReport. The following material come from VS.NET 2005 Beta 2 MSDN: ReportViewer Controls in Visual Studio 2005 ... Remote processing mode requires a licensed copy of Microsoft SQL Server 2005 Reporting Services. This requirement applies to all scenarios that involve a report server.   Will the LocalReport Export File type limitation  be overcome And how & w ...Show All

• Windows Forms 2 Questions about databases in .NET

  Hi, I have 2 questions about databases in VS.NET. 1) How can I add text I typed in a textbox in a database ex: I type in txtname George, and how can I add George to the column Name in my database 2) How can I print my entire form (layout and filled in textboxes) I've made a connection to my database, I have a dataset & an OLEDB DataAdapter for the Costumersdatabase. Please help... Hi, 1.Below link should help you add text from a textbox to database. Link: http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx 2. Below link should help you printing form. Link: http://www.codeproject.com/csharp/ReportPrinting.a ...Show All

• Visual C# How to resize an image programmatically?

  How can I programmatically enlarge an image with the original image placed at the left bottom corner, and the enlarged area filled with specific color Thank a lot. You can use the Bitmap.SetPixel method but this is a slow method, you can also unsafe process an image wish is much faster! Take a look at this article at MSDN. ...Show All