Phonics3k's Q&A profile

• Visual Studio 2008 (Pre-release) SQL2LINQ

  Does a tool like this exist Baiscally something to encapsualte all of the complex business rules/logic of the LINQ syntax. Actually, there isn't a tool that shows you the LINQ syntax starting from a SQL statement; sincerely, I can't figure out why you need to programmatically convert SQL into LINQ's query because when they are analyzed by LINQ to SQL, they are transformed back to SQL... Maybe you desire a tool showing you what you have to write in your code to perform a particular query. In this case, at this time, you have to learn LINQ query syntax studying the official documentation, watching webcasts, reading books, and so on. No other chances. Best, Fabio Ferracchiati's LINQ Blog: http://www.ferracchiati.com ...Show All

• SQL Server External scheduler for reports

  Hi, here is my problem: Because of some usability terms, I need to use SSRS scheduler to determine reports creation frequency (minimum frequency is once a day) I need to use an external scheduler to SSRS in order to launch reports creation daily, after some other batch tasks execution that must be completed before launching report creation. And I have no idea on how to do that properly. Can somebody help me Thanks! Thanks for the answer. I think I expressed myself in a bad way. Creating my reports needs some batch tasks to be completed. These batch tasks are planed by a company scheduler. So, my problem is that I want to be able to change report creation time (e.g. from 2am to 3 or 4am) with this company scheduler to ensure that a ...Show All

• Visual C++ vs2005 intercepts cl.exe output

  Hi, We have a custom build system that call cl.exe. From within the vs2005 IDE we call our custom application (as an NMake command) to compile. The custom application redirects the cl.exe output to a file, and at the end of the application, the complete file is fed to the IDE. This worked fine in vs2003, but in vs2005 it seems that the IDE 'steals' the output from cl.exe, so that our own application does not see that output anymore. Is there anything we can do to avoid this thanks, eli The call looks a bit like this, and the problem is that the file cpp1.log remains empty in vs2005, but in vs2003 this worked fine: _tsystem("cl.exe ... >> cpp1.log 2>>&1"); ...Show All

• Visual Basic Listview remove multiple items

  I everyone... i've got this code to remove all selected items in a listview... but i like to know if there is any more simple code to do this ... My code: Dim i As Integer With frmMain.FeedsList For i = 0 To .Items.Count - 1 Try If .Items(i).Selected = True Then .Items.RemoveAt(i) i = i - 1 End If Catch End Try Next End With Thanks "Dont take this the wrong way, but you need to do a little experimenting and background reading on information being provided - and not expect us to spoon feed you with the exact answer for you exact piece of code you are writing." I appreciate u'r comment, and belive that before i post ...Show All

• Visual Studio Tools for Office Set default signature in Outlook with Outlook Addin

  I'm writing an VSTO2005SE Outlook 2003 addin that creates email signatures. Signature data is imported from Active Directory and saves templated signature files to the Signatures folder. However, I don't know how to set Outlooks default signature for creating new email and replying to email. The addin is written i C#, but code examples in VB.NET is okay to. I'm thankful for any help I can get. // Johan There definitely are tools that read user data from Active Directory to populate the user's signature and apply it at the server. See http://www.slipstick.com/addins/content_management.htm ...Show All

• Microsoft ISV Community Center Forums ISV Royalty Program - OA2007

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end customers   6) If I was to have a techincal problem with a soultion and I can not get in touch with the ISV that sold me the soultion will Microsoft be able to help me       7) What are the benefits from buying solutions from an ISV to an end user ...Show All

• Visual Studio included version versus paid developer crystal reports program.

  I can only find the most basic information on the included reportviewer tool. Do all the real developers just buy crystal reports developer edition or is there some additional documentation around. I have looked in multiple books and they only include the most simplistic samples. So how do I make advanced reports and use multiple types of graphs ...Show All

• Visual Basic Pass data from a selected row in a DG to a new form

  Hello all. I have a datagrid in my form which displays basic information about open purchase orders. When I select a row in that grid, I want to pass the data in that row (actually only the SQL record ID) to a new form, which on load will fire a stored procedure that will populate the the new form fields. I can't figure out how to pass the cell value of the selected row to the new form. Any help would be appreciated. Mike First we will get the current row then we get Id from its column then pass it to the second form -- sorry the code C# but it may help you private void btnPurchase_Click( object sender, EventArgs e) { DataRowView rowView = this .purchaseBindingSource.Current; i ...Show All

• Visual Basic Problem With Automating Outlook

  I was having a problem, but I am wondering if there is a an alternative to CreateItem... I should tell you that I am using the 2003.net Standard Edition which may not have all the bells and whistles of the professional... Now here is what I want to do... Public Class Form1 Inherits System.Windows.Forms.Form # Region " Windows Form Designer generated code " Public Sub New () MyBase .New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose( ByVal disposing As Boolean ...Show All

• SQL Server DTExecUI - Package Execution Utility Error

  Hi, when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error. The Product Levelis insufficient for component "Flat File Source(1)" the package design is FlatFileSource ----> OlEDBDestination what could be the solution for this Thanks Jegan You need to install SSIS on this machine. Most likely you've installed Workstation Components, but to run packages outside of designer environment you need to install SSIS (separate checkbox on one of first setup pages). ...Show All

• SQL Server Problem while deploying Report on server

  Deploying to http://localhost/ReportServer Deploying data source '/Report Project1/cnt_SDS_REQUEST'. The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. I have changed this in reportserver's rsreportserver file to reflect < WebServiceAccount ><machine_name> \ASPNET </ WebServiceAccount > another confusing part - looks like we cannot use localhost but rather need to use the computer_name to run reports Also - being new to 2.0 framework - for some reason it seems to be adding the port number to run file like -http://localhost:2794/ReportServer/Pages/ReportViewer.aspx ...Show All

• SQL Server Rebort Builder Access

  Hi, Hope someone can assist Does Report Server allow access to Report Builder in an extranet setup We intend to use the report builder functionality to prove basic report creation for users over the internet, these users would be outside or corporate network. Is this possible security issues many thanks Simon. Should work. See here for further information on installing on non-domain users machines. http://blogs.msdn.com/bobmeyers/archive/2006/09/28/775584.aspx and more info on troubleshooting http://blogs.msdn.com/bimusings/archive/2005/11/07/489968.aspx Note that it requires .net 2.0 framework on client PC. Have a look at other 3rd-party report bu ...Show All

• Windows Forms How do I update the changes from my DataGridView into my SQL table?

  Hi all, having a hard time to understand the relation among Dataset, tables, Dataviews,etc... I am trying to update my SQL table after I do some modifications in my DataviewGrid(or table ). See code below: ... string strConn = "Data Source=(local);user id=sa;password=xxx;Initial Catalog=UpgradeClient;"; da = new SqlDataAdapter("SELECT * FROM STBData", strConn); table = new DataTable("STBData"); da.FillSchema(table, SchemaType.Source); dataGridView1.DataSource = table.DefaultView; da.Fill(table); ... private void btnUpgrade_Click(object sender, EventArgs e) { string strAccountId, strSTBid, strSTBType = ""; Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewEl ...Show All

• Visual Studio Team System Evaluating Check-in Policies during Shelveset Creation ..

  Is there any way to *require* that the check-box for "Evaluate policies and check-in notes before shelving" is selected when a shelveset is created Additionally, is there a way to detect (even by inspecting the Shelveset object programmatically) that when a particular shelveset was created, whether the check-in policies were evaluated or not I see that the Shelveset class has a property named "PolicyOverrideComment", and I guess this property allows me to detect whether any policy was overridden. However, how do I find out if the polcies were evaluated in the first place We receive certain code submissions from distributed teams via shelvesets and would like to know whether they have passed the policy evaluation p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA - Redistributable License Clarification Please

  Hi all, Hi all, I realise the XNA is only beta form, but I would like to make 100% sure that we would be allowed to distribute the xna dlls ourselves with any game we made. In my case this isn't for a commercial venture, rather there are a couple of development competitions I'm interested in, particularly at gamedev.net and xbox360homebrew.com - that I would like to enter a game based on xna for. For the xbox360homebrew.com competition, the rules are lax and the audience is basically other people messing with the XNA too. The gamedev.net 4E5 competition however is more strict as far as what has to be installed on an end-user machine to get a game working. I expect demanding them to download and install the 100s ...Show All