techguy52's Q&A profile

• SQL Server Cant's shrink tempdb in sql2k5

  Hi, tried to shrink 190gb tempdb but got following message: DBCC SHRINKFILE: Page 1:24027896 could not be moved because it is a work table page. Anyone know why The tempdb is almost empty, just doesn't release free space. Thanks for the info, but they don't address my issue. The problem I have is that tempdb has lot of free pages in internal object reserved page pool, but sql2k5 doesn't use those free pages when create new internal object. It expands tempdb to get more pages instead, so causes tempdb to keep growing. I got the page number of so called work table page and checked it with dbcc page to get object id it belongs to, but have no way to check if the object is still be used in the tempd ...Show All

• Visual Studio Express Editions Display a form

  Hi, I am having some trouble displaying a form, I have done it many times before but this time it is not working: here is my code: helpform frm = new helpform(); frm.Show(); and come up with the following errors: Error 1 The type or namespace name 'helpform' could not be found (are you missing a using directive or an assembly reference ) Error 2 The type or namespace name 'helpform' could not be found (are you missing a using directive or an assembly reference ) Any Help I noticed that you have written helloform in small letters in Image1. C# is case sensitive, so you must write helpform in small letters in all places. In Image 2, you see that you have written it "HelpForm", it is not the same thing as ...Show All

• .NET Development Is JScript.Net dead?

  Is Microsoft still working on JScript.Net Does anyone even use it Will it ever have Visual Studio support ...Show All

• Windows Forms Client Area of MDIParent should not be sunken

  Hallo, i have an MDI Application in which all Childs are plugged in the MDIParent without Border. Now i want to change the look of the MDIParent client area without raised border and not sunken. Did you have an idea how i could manage this. Thanks Arnold You can use Interop to turn off the WS_EX_CLIENTEDGE style. using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; namespace FlatMdi { public partial class Form1 : Form { public Form1() { // Specifically add the mdiClient to the form so // that you don't need to search for it at runtime. this.mdiPanel= new MdiClient(); this.mdiPanel.BackColor = System ...Show All

• Visual Studio Express Editions Help Clearing All Textboxes and All Comboboxes

  Greetings: I found this helpful code elsewhere on the forum, but it is only working on the Combo Boxes and not the text boxes on my Form1. Currently I have 4 textboxes and 3 comboboxes on my form. In the editor, when I hover my mouse over "ComboBox" it says "Class ComboBox" and when I hover my mouse over "TextBox" it says "Interface TextBox." Any ideas or help is greatly appreciated. Thanks Glenn Public Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click For Each c As Control In Me .Controls If TypeOf c Is TextBox Then ...Show All

• Visual C# Access data from vector from one class to main program class

  I have a C#.Net program that once a button is clicked it goes to a public class(called Tal) and gets data in a vector, then exits the class, and goes back to the main form(program). I will do this task over and over. I want to take the data ,do many(over 20) calculations, and go back to the program. How can I get access to the data array(vector) from the main program I keep getting different errors and have tried so many different ways. Thanks in advance. Code: { Mainfrm tal.talbars(); } Public Class tal // get vector array Price[] closes = row["SETTLE"] == null null : row SETTLE"].PriceVectorValue; int first_element = elements - 5; // to get 5 back for (int i = first_element; i < elements; i++) static void talbar ...Show All

• SQL Server Can the @subject arguement of sp_send_dbmail (sql server 2005) contain a result of a query?

  I am trying to include more detail on an email that is sent using sp_send_dbmail. Does anyone know if the @subject arguement of sp_send_dbmail (sql server 2005) contain a result of a query Reagrds, Elaine ...Show All

• Visual C# getting a string from dll & printing it on richtextbox...

  Hi... I want to read a string from a dll & i want to print it in a rich text box on windows form. How can i do this... How i can define a function which will return a string in dll file so that i can call that function from my form class & get the string to display on form... Thanks, Vinay Can you be more specific than "read a string from a dll" Is the string in the resources Is the string retrieved through a class method in the DLL Or do you simply want to read the DLL as data, extracting strings from the file ...Show All

• Visual Basic Accessing Object by Name:String

  Ok, now I know how to check if an objext exists, the next step should be to obtain this object. Therefor I read the VS-Help of Reflection, but found no answers as in google too. What would I like to Do class myObjectsClass dim myObject1 = new system.windows.forms.button myObject1.text="OK" dim myObject2 = new system.windows.forms.button ....... public function getObjectByName(ByVal objName as String) as system.windows.forms.button ' This function should return the requested Object ' in case getObjectByName("myObject1") should return myObject1 end function end class Does someone has an idea how to do that A list/Dictionary/hastable/etc. is the way to go. Also consider this, even though you may access the ...Show All

• SQL Server SQL 2005 Management Studio Timeout expired

  I get the message - "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" - when working with large tables in Management Studio. I have tried changeing the following: 1) Selected Tools -> Options 2) Expanded the "Query Execution" node 3) Clicked on "SQL Server" 4) Set value for "Execution time-out" to 0 and various numbers up to 1800 Also checked the following 1) In Object Explorer I right-clicked on the server and selected "Properties" 2) Selected the "Advanced" page 4) Set the value for "Query Wait" under "Parallelism" to various values from the default of -1 up ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Implications of Keyboard.GetState() returning a KeyboardState structure.

  The KeyboardState object is a C# structure - meaning that it's a value type not a reference type. Calling Keyboard.GetState() returns a copy of the KeyboardState structure. This KeyboardState structure appears to be about 32 bytes in size - determined via a call to System.Runtime.InteropServices.Mashal.SizeOf(). Is there a particular reason why KeyboardState is a structure rather than a class type Correct me if I'm wrong but I would have thought returning a class reference would be much more efficient than returning a 32 byte structure. If it was a class, it may be easier for you to access individual parts. But a 32 bit byte block is probably easier/faster to deal with for unmanaged low level codes (bit op ...Show All

• Visual Basic Array Help!!!!

  Hi, This may be a very basic problem but im haveing real trouble with it and its driving me crazy!!!!!!! I have created a class called Class1 I can create a new object by calling Dim test2 As New Class1 I can change its attrributes by test2.summary = True test2.is_stage = False etc..... Now what I want to do is store this class in an array. I have tried the folowing code but it doesnt seem to work Dim proj_tasks(10000) As Class1 proj_tasks(counter) = test2 This keeps erroring and I dont know why! Can somebody help me out! Also if your feeling very generous could you please adivise me on how I could make this a dynamic array rather than having to set the array to a huge size in the first place ...Show All

• SQL Server Converting Data Types

  I have a table with a field of Char(10) Data type this field contains records of work time Attendance in a decimal format Ex. I attend today for 8.30 this means eighthours and thirty mintutes the main problem faced me to make some calculations on those records (sum, subtract, etc) so I want to convert the data from char type to decimal or real using the next code but it doesn't work select (cast (satreg, decimal) + cast (satot, decimal)) from timecard can u please help me in the main issue how to sum char type records or at least how to convert them to decimal Regards this can help: it breaks your 8.30 to 8 and 30 SELECT substring ( test , 0 , ( patindex ( '%.%' , test ))), substring ( te ...Show All

• Visual Studio Team System Team Suite vs. Team Foundation Server

  Hi! I am new to this so my question must sound stupid. What is the difference between Team Suite an Team Foundation I presume that I cannot even compare them Is team foundation included in TS When I get TS, do I get also Visula Studio 2005 and Team Foundation Is there any need to install Team Foundation when you have TS installed A lot of questions... sorry. As I have said, I am new to this and do not know the difference between does two products. Thank you! Hi Vince, I can see that in your Company as you said "PS: We are a small company here(less then 10 people) but we are using TFS and VS Team Suite because we use the Source Control and the workitems and the testing capabilities so you ...Show All

• .NET Development ftp sockets in c#

  hello sir, iam using ftp server(c#), thru my client ftp program is connected to remote server ftp. but iam unable to access like listing files in the remote host, uploading and directory creation and removing . Is that do we need any permissions for doing above operations. well sounds like a permissions issue. you have to give it the credentials to use when connecting/performing the action you want. What .NET Framework version are you using Can you also show us the code you are using ...Show All