SMILEMan's Q&A profile

• SQL Server Importing / Exporting Tables and data along with relation and default value information

  Hi, Good day! Previously with SQL 2000 and DTS it was quite easy to export tables and their data from dev sys to prod sys along with relations and default values intact. But when I try exporting with SQL 2005 using 'export data...' wizard for the same purpose it only exports the tables structure and its data without any contraint / relation / default value details. I guess there should be a way to accomplish the same using the export wizard without going to customizing packages. Can anyone let me know how this can be done Thank you. ...Show All

• Windows Forms Instant Messenger Developkment

  I've been kicking around the idea of writing an Instant Messenger application as a "see if I can do it project".  Can't seem to find any good articles on getting started (plenty of articles on Chat Rooms, which I would assume is similar).  Would anyone have any good links to how to get started on this  Or a template to get started f ...Show All

• Visual Studio Opening a project from VSS is missing references?

  First, we are using VS 2003 w/VSS 2005. I have an existing project that I added to the source control. When another developer accesses it, there are 2 references that do not show up. Am I supposed to add those a different way It was my assumption that when the other developer opens the project from VSS all the files necessary are there to build the project. Let me know if I'm missing something. Thanks for your time!! Ian Hi Ian, Usually, the VSS does not check-in the BIN folder of a project, therefore, when you add a reference to a local file, the file is not checked-in to the VSS. If ...Show All

• Visual Studio Team System User name in a workitem

  When we have fields related to users in a workitem (ex.: assigned to) it shows his Login Name at team explorer. Here, we use ID numbers as Login Names (things like 10001, 140345...). This is obivious hard to track, so we use the Full Name attribute instead of Login Name in our day by day. Sadly, I couldn't find a way to configure this in team explorer. It shows only the Login Name of the users. What can I do Change Login Name of our users is not an option, but list just the ID's is really ugly and hard to work with. Thanks in advance, Max Andrade Found it http://forums.microsoft.com/MSDN/ShowPost.aspx PostID= ...Show All

• SQL Server Dynamic statement in variable - parseerror

  I am trying to use this statement in a variable, including another variable: "SELECT * FROM my_table WHERE CAST([timestamp] AS INT) > " + @[User::LastTimestamp] But the variable value insists on giving me this error: The expression for variable "VariableName" failed evaluation. There was an error in the expression. I cast the columntype "timestamp" to int, and the variable "LastTimestamp is stored as int32, and has a default value of 0. I simply can't grasp what it is I am missing. Is it because the expression is part string and part integer If so, how is that avoided Thanks in advance ...Show All

• Windows Forms Cross-thread exception (beta2) / deadlock (release)

  I have a method where one control adds another control to its control collection. It looks something like: void Add(Control control) {    Debug.Assert(control.InvokeRequired == false);    Debug.Assert(InvokeRequired == false);    .    .       .    Controls.Add(control); // exception/hang } This routine will occasionally throw a cross thread exception in saying that 'control' was accessed crossed thread (on beta2) and it will hang/deadlock on the release bits with the call stack ending at SendMessage (partial stack at the end of this mess ...Show All

• Windows Forms How to display a MessageBox as topmost window

  Hi, I'm looking for a way to display a MessageBox as the topmost window. Any Ideas on how to do this using .NET / WindowsForms Thanks, Erik Thanks for your research and giving use a good information... ...Show All

• SQL Server Send Muti-Values to Stored Proc?

  Hi all, I am not too sure whether someone asked this question before, but I am thinking is there a way to send multi-values (selected from a multi-value parameter) and send it to a stored procedure from a DataSet in reports Anyone have any idea how to go about this please help out. Thanks in advance. Daren If the data source type is "SQL Server" or "Oracle", binding a multi value report parameter to a query parameter of the stored procedure will pass in the selected values as comma-separated concatenated string query parameter value. E.g. selecting "A" and " ...Show All

• SQL Server Stored Procedure taking too long

  I have a stored procedure that is taking too long to complete. I'ved narrowed the problem down to the following code. Is there any reason why this should take long to complete for about 40,000 records UPDATE Entries SET EntryStatus = 1 , reason = 'code entered more than once' WHERE TimeSubmitted > @StartOfPeriod AND TimeSubmitted < @EndOfPeriod AND TimeSubmitted <> @t and ShortCode = @ShortCode AND verbatim = @v Thank you for your suggestions. I've looked at query plans before but don't really know what to do with them. Will have to do some research ...Show All

• .NET Development unable to get IIS 5.1/.NET 2.0 to connect to a remote SQL Server 2005 instance

  Hello all, I'm not new to developing web apps with data access, but I am new to the Microsoft world, specifically Visual Studio 2005 and SQL Server 2005. I have two machines: Machine A (WinXP Pro SP2 with all the latest updates) has SQL Server 2005 and Visual Studio 2005 and .NET 2.0.50727.42 (and no earlier versions of .NET) Machine B (WinXP Pro SP2 with all the latest updates) has IIS 5.1 and .NET 2.0.50727.42 (and no earlier versions of .NET) On machine A I can develop a simple web app, with no database access, deploy it to machine B and run it without problems.  Likewise I can develop a simple web app on machine A ...Show All

• Visual Studio Express Editions Code Snippets Manager (under Tools) does not work.

  Visual Basic 2005 Express: Code Snippets Manager (under Tools) does not work. I cannot load any of the code snippets. There is a new version of the snippet editor that works with vb express in the gotdotnet website . ...Show All

• Visual C# RS232, convert string to hex string

  Hi all, I have my device that put out to RS232 port by hex format. I try using write code to receiver its information and when it display in string format, i can understand , such as : " Uay <00>€€€€<00><00Uay<00>€€€€<00><00> Uay <00>€€€€<00><00>Uay <00>€€€€<00><00> Uay I€€€€<00><00>UUay €€€€<00><00> Uay <00>€€€€<00><00> Uay<00>c€€€€<00><00>‥Uay E€€€€<00><00>EUay€€€€<00><00> Uay <00>€€€€<00><00> Uay <00>€€€€<00><00> Uay <00>€€€€<00>< ...Show All

• Visual Studio VS 2003: Not enough disk space solutions?

  My coworker is finally moving from VC6, but only has a 2GB C partition.  There's not enough room for the prerequisites, such as the .NET framework.  I tried changing the default Common and Program Files directories to another drive, via Regedit, but the setup program is still trying to place stuff on C:. Other than reinstalling his OS with a far larger C:, is there anything else I can try Thanks FWIW lots of people have historically created small c partitions and installed all of their apps on a data drive with a whole lot more room... It is a common way of separating data and the ...Show All

• Visual Studio 2008 (Pre-release) Nothing works....

  OK, I've installed WPF, and I can create a project, and it will run. But I'm finding the designer hard to use ( no copy/paste, no automatic line up of controls, etc ), and if I go to the XAML view, I can't type into it, it shows a character I typed every 30 seconds and never accepts < or >. If I type the text into Notepad and paste it, it builds and runs, what I am typing is valid. What am I missing The design view creates really ugly XAML, and is too fiddly, I'd prefer to just type it in and go to the design view to see how it looks, but it won't let me. The XAML designer is very early. I think it was released as a CTP befor ...Show All

• Visual Basic Using the same structure in multiple objects

  I have the same structure of data (customer name, location, status, etc.) that I want to use in multiple objects within an application (one to read the data from a file, one to display it, one to create a new or updated version, and one to save it), and I'm not sure what's the "correct" way from an object oriented point of view of how to define the same structure across all of the objects. Currently, I've got the structure defined in the MainForm class, and then I define the input variable in the input object by doing: Dim InputDataStructure As MainForm.DataStructure = New MainForm.DataStructure and in the output ...Show All