Marzullo's Q&A profile

• SQL Server more tables do search,please help me,sql server stored procedure problem

  i have more tables exmaple: table1(id,title,content,date) table2(did,type,title,text1,text2,requestdate) table3(subid,value1,value2,value3,value4) .......................15 tables left,some exmaple now i want use stored procedure do search for asp.net asp.net send search keyword to sql server,sql server get keywords execute search and return results to web application(asp.net) i don't konw how what write t-sql,please friends help me. because table colums is different,so need write t-sql put the temp DATA TO Temp DataTable,last return Temp DataTable to asp.net,asp.net execute split pager display data,eventable colums is different,so on asp.net links is different,need t-sql programming,hope friends can help me comp ...Show All

• SQL Server Invoking SSIS Packages from DotNet

  Hi, How can we invoke SSIS Packages from an Windows or ASP.NET Application (using C# ). Thanks Jegan Check if you have a service called MsDtsServer (display name SQL Server Integration Services). If you do not have such service, you don't have SSIS installed. Installing just Workstation Components gives you access to some SSIS aspects, e.g. designing the packages in BIDS. But it is not enough to execute the packages outside of designer. ...Show All

• Visual FoxPro How to print the current page in VFP?

  Can we do this in VFP 9 Thanks. I wish to add a new button to print just the current page. sometimes the report contains up to a hundred pages. But only one or two have corrections and need to be printed out. If you use the ReportListener, you can use Reportlistener.outputpage(1) to print the first page. The type has to be 0 or 2 for page at a time mode. See ReportListener help for code samples. ...Show All

• SQL Server Query issues

  Hello! I am having a problem with a query a co-worker wrote for me amd now hes on vacaton and I need to use it! I have no experience writing queries. this is what he left for me : EXEC FmtOnly ON spReport132 @AsOfDate, @Position and for some reason I keep getting errors when trying to create a report. I am not sure if it is the query itself,or if I am doing something wrong.....ANY ideas Thank you in advance! Sheidee Look for the passed in (or out) SQL_Variant and cast the value to the appropiate data type first. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Problem with Query Engine

  I want to generate a Crystal report from an asp.net page. When I try to execute this code: string exportpath = @"C:\PushInvoices\xxxxx.pdf"; CrystalDecisions.CrystalReports.Engine.ReportDocument myreportdoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); myreportdoc.Load(@"C:\Inetpub\wwwroot\DEV\OUTSIDE_SUBMISSIONS_2\PushInvoice.rpt"); myreportdoc.ExportToDisk(ExportFormatType.PortableDocFormat, exportpath); I get an exception thrown on the line with the myreportdoc.Load method. The .rpt file does exist on the path specified. the exception thrown is: "Failed to create the Crystal Query Engine". I've checked permissions and they seem ok. I could be ...Show All

• .NET Development Problem with select string

  Hello, I have set up a c# program that reads data from Navision tables via ODBC - connection. In Navision som fields have blankspaces like Remaing Quantity in the Item Ledger Entry table. This seems to be a problem when I execute my selectionstring. for example: // This selectionstring contains blankspaces (Aterstaende antal) and I get error. command.CommandText = "SELECT Artikeltransaktion.Artikelnr, SUM(Artikeltransaktion.Aterstaende antal) " // Here is the problem + "FROM Artikeltransaktion " + "WHERE (Artikeltransaktion.Lagerstallekod='LID') AND (Artikeltransaktion.Oppen=1) " + "GROUP BY Artikeltransaktion.Artikelnr " + "ORDER BY Artikeltransaktion.Artikelnr" ; // // This string works fine // command. ...Show All

• Windows Forms Combo boxes

  Can anyone tell me or show me a function or method that can be called to fill combo boxes. Right now I do this when ever I need to fill one. Public Sub FillPaymentTypeComboBox() ' error checking Try ' declare a new instance of the PaymentTypes class 'Dim AllPaymentTypes As New clsPaymentTypes dsPaymentTypes = clsPaymentTypes.selectPaymentTypes ' have all the PaymentType and their ID's now populate the cboPaymentTypeID ' combo box and get the total number of records in the dataset Dim MaxPaymentTypeRecords As Integer = dsPaymentTypes.Tables(0).Rows.Count Dim i As Integer cboPaymentTypeID.BeginUpdate() For i = 0 To MaxPaymentTypeRecords - 1 ' populate the combo box with i ...Show All

• Visual Studio Team System Is a separate required for MSF Agile?

  Hi, I have been struggling with this problem for weeks and cannot seem to find an answer to it: I would like to use all the MSF for Agile tools in Visual Studio Team Suite but I don't need a separate server. (I am working alone and want to design iterations, etc. I have only one machine) I installed Team Explorer but it only tries to look for a TFS. I try to open a team project, but it only tries to connect to a TFS. Is there a single-system solution Is this possible Thanks, Mark Actually, space is not my concern. I have plenty of that! The problem is that I can't install TFS on XP. It requires Windows Server 3000 and I'm working on XP. ...Show All

• Visual Studio 2008 (Pre-release) Setting EventTrigger's SourceName to C# Object?

  I have an event trigger who's routed event is DoubleAnimationUsingKeyFrames.Completed. The actual DoubleAnimtionUsingKeyFrames object is created in the xaml's code-behind file in C#. What's the proper syntax for setting the event trigger's sourcename property to that C# object I've tried a straight-forward SourceName="myDAK" but the app throws a runtime error with the following message: 'DoubleAnimationUsingKeyFrames.Completed' value cannot be assigned to property 'RoutedEvent' of object 'System.Windows.EventTrigger'. Value cannot be null. So I'm guessing the problem is it can't find "myDAK". Suggestions Here's the xaml code... <Rectangle x:Name="myRect"> <Rec ...Show All

• Visual Studio Team System VS2003 against TFS

  Hi, I have migrated VS2003 project from VSS to TFS. I have installed MSSCCI Provider for connection with TFS from IDE VS2003. In IDE VS2003, I have connected to TFS. When I checked out some file under Source Control, then I changed it and Checked in, this file, project and solution kept in check out state. And I might to do undo check out. Sometime, this action made the problem, by rolling back the actions, which I did. I have also noticed that, TFS made double folder structure to local folders (It was copying parent folder to new folder which had the same name as parent folder), because TFS added new mappings to current workspace. It's expected behavior And what can I do instead of undo check out Thanks Janko Hello ...Show All

• Visual Studio Team System 'Custom' parameters in queries

  Hello, Is there a way to add a custom parameter to a query so it will be prompted to the user when he/she double-click the query to open it. To give you more details, we are looking for creating a query that will accept a list of work item IDs and return all the issues that matches these IDs. A convenient way will be for us to specify this kind of condition when building the query: ... And ID In @myIDList ... We tried that, but it seems to be not supported. Thanks for your help, Gaetano. Responding to the last few posts... The input you've provide is great. Its helpful to know *why* you would use a feature, so we can implement it correctly. I'll make sur ...Show All

• SQL Server Writing huge files from CLR

  Hi Coming straight to the problem - I need to write text files of the size more than 1GB! First thought of doing this with BCP but then fetching data from stored proc was taking too long (more than one hour) and so BCP did not seem to be the right option as we have less flexiblity in terms - handling errors, knowing the status as to what point the writing has been complete etc. Most importantly getting such a huge amount of data did not seem to be a one time job! So I am now thinking about writing a CLR procedure which fetches smaller amount of data at a time and writing to file. Something like - open connection, get data, close connection, write to file and continue in cycles of this till whole file is written. Does this makes sense ...Show All

• Visual Studio Express Editions Saving decimal in SQL Data Base

  Hi, When I save a decimal number, forexample 1.23, the database is rounding it to the nearest whole number 1. I need the DB to retain the value sent 1.23. Ron hi One more thing, I am writing the data to the data table as follows. The Cdec(m_unitcost) is the field in question When in debug mode the m_unitcost displays the correct value of 123 If addstock = True Then AddStockTable.AddstockRow(m_partNo, m_Description, CInt (m_qty), CDec (m_unitcost), totalcost, CInt (m_min), picture, m_location) AddStockAdapter.Update(AddStockTable) Ron ...Show All

• Visual Studio Analyze is not repairing the problem

  I run the analyze utility it says project log 'wedaaaaa' has a delete record for item 'Online_help.gif' , but that item wasn't found in the project. The project contents as rebuilt from the log 'wedaaaaa' does not match the project's actual contents. How can I remove this problem so analyse does not report it again I have tried all sorts of switch combinations and removing the backup folder but to no avail I still keep getting this error. Anyone have a solution on this Thanks Could you please explain what is involved by the following : "you have to call Microsoft PSS (Product Support Service) to get it". Do I have to ring anyone Is there webpage I could look up to ...Show All

• Visual Studio Team System source control

  does visual studio team system for database professionals incude source control if yes, is the source control at the database level meaning if someone goes into Management Studio will they "see" that a stored procedure is currently checked-out and then they cannot modify that sp. Hi, I do agree with the above strongly (see one of my previous posts "VSTS4DBP could be dangerous"), but I also feel it's also a question and policy of discipline. Assuming that no one want's to intentionally damage the DB the point would be to get VS to the status that for development work it is equally good and fast to use as SSMS. With DataDude we've taken a big step and I assume t ...Show All