Joewski's Q&A profile

• Visual FoxPro small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA" and VFP process was killed after click OK in messagebox and before all trasaction bufers was stored in dbf file (2-3 seconds after click OK) I interested in "select count(*), name from dat ...Show All

• SQL Server Error: The service queue "ClientQueue" is currently disabled.

  Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error: --------------------------------------------------------------------- The service queue "ClientQueue" is currently disabled. --------------------------------------------------------------------- Which I found from looking at the Service Broker Statistics Report is true. There are 5 queues total and only the dbo.ClientQueue is disabled.   --------------------------------------------------------------------- Questions: ----------------------------------------------------------- ...Show All

• SQL Server Integer identity value handling in export / import

  Hi, I have a question regarding export / import when you have tables with  autonumber (identity) columns as primary surrogate keys. Does export / import retiain the values of these columns so that referential integriy is not broken Charles I am Hitesh. I have the same issue. While exporting/importing data (from SQL 2005 to SQL 2005) IDENTITY column values get altered..this way my referencial integrity gets broken that is not good at all....I am familier that using COPY WIZARD & Backup/Restore this can be avoided but I want to know ONLY for DTS import/export wizard....Will you please help me....it's very very very urgent to ...Show All

• SQL Server WSDL Support in WebService Task

  I have a wsdl file that SSIS says it doesn't support. What aspects of WSDL does SSIS not support. I can send the WSDL file to anyone that wants a copy, just use the contact me on my blog. This occurs with the webservice for the reporting services as well Item added to Product Feedback site http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=5c9df73a-0b04-4baf-b2d4-5db20fe5a09c ...Show All

• Windows Forms Ambiguos error...

  Hi all. I have very strange problem and make me crazy. I don't know what it is. This is the code: int id, n=0; this.treeView1.TopNode.Nodes.Clear(); for (int i = 0; i < ApplicationState.GroupCount; i++) { id = Convert.ToInt32(xml.xmlData[0].ChildNodes[1].ChildNodes .Attributes["GID"].Value); this.treeView1.TopNode.Nodes.Add(xml.xmlData[0].ChildNodes[1].ChildNodes .Attributes["GroupTitle"].Value); for (int j = 0; j < ApplicationState.ItemCount; j++) { if (id == Convert.ToInt32(xml.xmlData[0].ChildNodes[0].ChildNodes[j].Attributes["GroupID"].Value ...Show All

• Visual C# C# adding a record to an access Database

  DataRow dr = _dsComment.Tables[ "Comment" ].NewRow(); dr[ "OrdNo" ] = _Order; dr[ "Name" ] = UserName; dr[ "Date" ] = System. DateTime .Now.ToShortDateString(); dr[ "Comment" ] = frm.Comment; _dsComment.Tables[ "Comment" ].Rows.Add(dr); OleDbCommandBuilder cb; cb = new OleDbCommandBuilder (_DaComment); _DaComment.Update(_dsComment, "Comment" ); I already filled the dataset on the form load event. I am getting an error saying Syntax error in INSERT TO statement.  I thought that the commandbuilder builds those commands.   I am trying to add a new record to a database table which is in Access.  ...Show All

• .NET Development SqlDataSource/DataField Bug in 2.0 ?

  I've come across an odd situation. If someone has a table where a column name contains a space, and you generate a SqlDataSource on that column, some interesting things happen if you try to bind them. When I tried to bind, (in a GridView), the column name First Name via DataField="[First Name]", it gave a runtime error stating that [First Name] cannot be found in the sqlDataSource. Oddly enough, I took the brackets out and just sent it First Name, and got a Web Exception with only the following message: Incorrect syntax near nvarchar I've seen this posted a few times, but no real replies. I was wondering if anyone knew about t ...Show All

• Smart Device Development How do I access the command line arguments in Visual Basic?

  How do I access the command line arguments in Visual Basic when using Visual Studio 2005 and developing a PocketPC 2003 applicaiton running on Compact Framework 1.0 Ok, I got the following to work. Don't know if there is a better way. frmAppInstall is my application which contains a combo-box that will hold the value of argument(0). Public Shared Sub Main( ByVal args As String ()) Dim frmAppInstall1 As frmAppInstall = New frmAppInstall If (args Is Nothing OrElse args.Length = 0) Then Else frmAppInstall1.combxApplications.Items.Add(args(0)) frmAppInstall1 ...Show All

• Software Development for Windows Vista Dot Net Distributed Application by using COM+ (MTS server)

  Hello, we want to build Dot net Distributed application. means we want place our Logic DLL (Dotnet Assembly) in different mechine as hosted by COM+ server. and want access this in client side (in UI layer). How we can access it without using Remoting or Webservices. Is it possible How we can develop a Dot net Distributed application only using by COM+ (Enterprise) services. For remote access to a COM+ component, you need to do 3 things: 1. Your ServicedComponent needs to be a Server Component (i.e. ActivationOption.Server) 2. Using COM+ UI (Component Services MMC), you can export an application proxy for that specific ...Show All

• Visual Studio C# Express 2005 and Report

  Dear All,   I am using C# Express 2005 and SQL Server Express 2005 as well. I am planning to use no-touch deployment as well. At the moment, I am stuck as I cannot find any report designer to make my report work in the enviroment of C# Express. Is there any way or extension that I can include into the C# Express so that I can use to build the report Highly appreciate your advice.   Regards,   LG Install Visual Web Developer 2005 Express Edition ( http://msdn.microsoft.com/vstudio/express/vwd/download/ ). Then install the Report Designer and Report Viewer control from http ...Show All

• Visual C# Validation Philosophy

  I am working with a Winform in VS 2005. I have been reading some books lately that say that using the error provider and checking it when you save or exit a form is a better, (less intrusive) way of doing validation than putting up dialog boxes. I see the wisdom to it but I wonder what should happen when you have many records in a form That is, lets say I have a winform with the Standard menu and toolbar on it that VS creates automatically, but lets also say that this form (a detail form) has many rows. With regard to validation, how should it be handled Should I wait until save or exit is selected If so, telling the user that there a ...Show All

• Visual Studio Express Editions ; after every line in int main() {}

  I read in a tutorial that at the end of every line in the int main() {} . But then I had a bunch of problems coming up with this code and one of the main problems was the fact that I put semicolons at the end of every line in the int main function. Here is the code: #include <iostream> using namespace std; int main() { int choice; cout << "Enter the number 1 if you want the color blue \n"; cout << "Enter the number 2 if you want the color red \n"; cout << "Enter the number 3 if you want the color green \n"; cout << "Enter the number 4 if you want the color orange \n&qu ...Show All

• Windows Forms DataGridView and ContextMenuStrip

  Hello all, 2 questions about using ContextMenuStrip in conjunction with DataGridView: 1. How can I get a ContextMenuStrip to open only if the user right-clicks on a cell, and not a cell header/row header/background/etc My current solution is to associated the CMS with the columns, and not the DataGridView, i.e.: datagridview1.ContextMenuStrip=Nothing For Each c As DataGridViewColumn In datagridview1.Columns c.ContextMenuStrip = dgvContextMenu Next Is there a better way 2. How can code handling a click event on the CMS determine what cell the cursor was over when the context menu was activated I have a partly-working solution, which ...Show All

• Visual Studio Adding new VSS DB (Internet) in VS.NET, why provide local srcsafe.ini path?

  I don't understand why you have to provide the UNC path to a srcsafe.ini file when you're trying to add a VSS database via the Internet.  Any news on this I'm sorry, I found my answer here: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=115726 I was assuming the share given had to be accessible from the client's PC.  I didn't realize this share was expecting to already be logged into the server and more of a "security check" that you know where to look if you were on the system. ...Show All

• Visual Basic Filling Part time (Data) to Dataset ?

  Dear Team   if there is a project working on for ex: orders and ordersdetail   after some time filling dataset will slow the performance cause the data mayby    lot ... and no need to update old Commited data ......so   How should filling the dataset for only the last 3 monthes or specific period   any idea   i made the SQLadapter from the designer and from its proprties in the select   for ex : Select id,name,....   where getdate() - Orderdate = 3    but Nothing retern atall      any idea   Thank you very much Mr HuyN    Thank you ve ...Show All