A__alex10's Q&A profile

• SQL Server generate a text file from SQL Server

  Hi I need to generate a text file from SQL Server. The task automatically runs daily. The format of the text file use "/" to separate the field and the row. At the end of the file, it adds number of char  and uses "\". The number of char includes the data parts and excludes a few word of "the number of char". For example, The underline fonts mean the first row record. The Bold fonts mean the second row record. The Italic fonts mean the third row record. The red fonts mean the number of char and the end of file. 1/060222/008888/234/1/7441/2/BB/10000//////290025///// 1/060222/008888/234/1/7441/3/XX/100-//////290025///// 1/060222/008881/234/1/7442/2/BB/10000//////290025///// 161\ I am no idea about this problem. Please giv ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Scrolling a 2D Background

  New tutorial on scrolling a 2D background on my site XNADevelopment. This is the quick and dirty approach. It covers creating the project, adding images to the project and scrolling those images horizontally in a continuous loop. I've posted the tutorial and the source code if you're interested. So far, I'm SUPER impressed with XNA development and just how easy it has been. The support from the XNA developers in the forums here has just been outstanding. These guys are really going over and above helping out all of us XNA newbies as we struggle to fly and learn the ropes. I'm also just amazed at the variety and number of tutorials being put up each day by sites in the community. If you haven't been to these sites yet, I highly recommend th ...Show All

• Windows Forms UserControl custom properties

  Hi! I've looked a lot of time for the solution of the problem I came across developing custom control. Perhaps some one here could help me. I'm developing the control inherited from UserControl class. This control will have some custom properties. The problem is next: I need that the one of the custom properties of the future control supported following behaviour. If we find this property in the Properties window it should allow to developer select the possible values from the combobox, just like it done for other default properties (for example AccessibleRole, ForeColor, (DataBindings).Tag and so on). How it could be implemented I guess there is should be some attribute, but I could find it... Note: The property will takes the ob ...Show All

• .NET Development SIP phone development

  I want to develop a SIP phone (Voice over IP) and I want to know if any such components for C#. ...Show All

• SQL Server SQL For-loop stored procedures

  i want to grant exec permissions on all of my user stored procedures. but this process of writing 'grant exec sp_tblAction on public' for each procedure would take years. how can i write a query that loops through all stored procedures, checks if it is a user created procedured, and then grant exec permission for that procedure can it be done tx, Wilmar Wilmar, You could try something like this: --  ---------- BEGIN SAMPLE CODE ---------- DECLARE @SQL nvarchar ( max ) SET @SQL = '' --Add a where clause to the query below to limit which procedures are included in the grant... SELECT @SQL = @SQL + 'GRANT EXEC ON ' + [name] + ' TO PUBLIC' + CHAR ( 13 ) + CHAR ( 10 ) ...Show All

• Smart Device Development MouseDown like event in Windows Mobile 5.0 for Poket PC

  Dear All, My application should consists of 1 Button that akts as follows: if user holds the Button pressed during 2 seconds then method pressed() should be executed if user clicks this button then method clicked() should be executed My Problem: If I create a Windows Mobile 5.0 Poket PC then Button object does not have the MouseDown event. I can register and use MouseDown event for the Form object: myForm.MouseDown += new System.Windows.Forms.MouseEventHandler(myForm.Form1_MouseDown); How can I achieve the same for Button Dear Figo, Thank you very much for your help. I managed to run it for WindowsApplication: public class CustomButton : Button { protected ...Show All

• Visual Studio What caused creation of THOUSANDS of tmp files in SourceSafe users directory?

  I'm using Visual Studio 2005 and VSS 6.0d. Visual Studio and VSS were getting slower and slower, and my entire computer was too, if those apps were active. To make a long story short, the culprit was this: there were 65536 0-byte *.tmp files in the VSS <database>\users\<username> directory. That's, right 65K 0-byte files. This wasn't in the <database>\temp directory, but in a directory for users .. the one with the ss.ini in it. Anyway, I deleted 'em and all is well. But I'm a guy who likes to know 'why'. Anyone know -BillyB Alin, First lemme thank you for the reply. I don't seem to be getting email replies, even though when I click on the 'Alert Me' button. Sigh. Anyway, your explanation seems very p ...Show All

• Visual Studio Express Editions How to use the USA msdn samples in Japanese version of VC#2005EE?

  (First of all, sorry for my poor English but thanks for reading my message ) Problem is that I can't use the samples, which is on the USA version of msdn website, in Japanese version of Visual C# 2005 Experss Edition. (Note : I can use the samples, which is on the Japanese versoin of msdn website.) First Case : Using XXXX.lns file I downloaded the HelloWorld sample ( http://download.microsoft.com/download/3/0/e/30e98265-29ad-4c32-9f0a-d4076f2fa2e4/AbsBeg01CS.msi ) from http://msdn.microsoft.com/vstudio/express/visualCSharp/learning/#beginners . When I open the project, HelloWorld.sln, and click start in C# IDE, then VC# gives me the error message which says "build error ..." and gives me the compile error whic ...Show All

• Visual Basic Menustrip

  Hi, I was hoping that somebody could tell me how to program a "new" function for a menustrip. I want this to reload my program. Private Sub NewGameToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewGameToolStripMenuItem.Click Dim Monopoly As New Monopoly Monopoly.Show() Me.Close() End Sub That is what i have so far the only problem is that it opens a new program then closes the both of them. How do i distinguish the new form from the old or is there a way around this Don't know what are you want to do excatly. But why don't you reload the current form I mean what the form does when it is loading should do it again with the "NEW" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed Direct3D 10

  Since XNA only supports DirectX 9.0 Where is Managed Direct3D 10 I hope there will be Managed wrapper for Direct3D 10 thanks Well, I think it is pretty clear that MS takes MDX seriously. They are moving game developement toward MDX using XNA. Eventually MDX will become the main focus. Even though they didn't say it out loud, they are doing it. It is just that they have to focus on DX10 right now. If they can't make a good DX10, what's the point to make MDX for DX10, it will be junk anyway But it will cool if they can release MDX along with DX in the future, or at least in a 6 months time frame. ...Show All

• Windows Forms Adding multiple controls at runtime

  Hi all, i am new in visual basic, so any help would be appreciated. I want to create a form where user could input a number in a textbox and after clicking on a button, there would be adde on the form as many textboxes as user has filled in the original text box. Additionaly, i would like these new controls to have the same name with a counter at the end, i.e., first textbox name= Criteria1, second textbox name= Criteria2 etc. i tried the For...Next, Do While/Until and stuff like that, but i haven't manage to create anything more than one and only one control at runtime. I would also be interrested in how could add new controls on form every time a button is clicked. Trying the following code, Button1 Click procedure ...Show All

• SQL Server Building Custom Component - marking all inputs

  I have been building a custom component with the default GUI. I want to have all the input fields selected to be passed through to outputs without having to explicitly check each one in the GUI. Is there some method or property to set on the input to do this I would normally do this in the UI itself, but that would be a custom UI, not the standard UI you get for free, as you cannot extend that one at all. You could do this in ReinitializeMetaData, such that if no columns are found, and you have forced RMD to build the input/output columns for the first time, when adding you also select the columns as you create them. How you select the column, the equivalent of selecting a column in the UI, will dep ...Show All

• Visual C++ CRichEditCtrl Problem

  Hi, This is done in VC++ MFC I have created a vector vector<CRichEditCtrl*>RichEditBox; CRichEditCtrl *r1 = new CRichEditCtrl; r1->Create(WS_CHILD|WS_VISIBLE|ES_AUTOVSCROLL, CRect(x1,y1,x2,y2), p, 1); r1->SetEventMask(ENM_CHANGE | ENM_SELCHANGE ); RichEditBox.push_back(r1); With the above code I get n cricheditboxes on a window . How do I navigate within these boxes using Up Down Arrow Keys Pritha Hi, I think you can use "TabOrder" property of these controls, so you can navigate them by "Tab" key. If you want to use up and down arrow you must receive a "KeyPress" message and then set focus on CRichEditBox control. Regards. ...Show All

• Windows Forms View File Descriptions

  Hi I need to be able to make a program that runs in the system tray and when you push f5 or whatever it will open a window that you can browse to a folder and see all the files in it. The trick is that i want to see the description of the file below the icon rather than the file name.... by description I mean that little discription message you get if you hover over a icon for a few seconds. If anyone has any tips such as just how to access that datafield it will help alot.. thanks Your question has many part 1- Create System try Application you can use NotiffyIcon to create system try application for example look at system tray application 2-you want your application handle HotK ...Show All

• Visual Studio Team System Quality Indicators Report

  I'm feeling mad, no where can I find an help / doco / explanations for the TFS Reports. Specifically, I have questions about the "Quality Indicators" report. It looks bloody lovely & useful; it is working superb for "Code Churn", "Code Coverage", "Tests Past", "Tests Failed" (Nighly Build). ... but... "Active Bugs" is always zero. Yet if I look at the default Active Bugs WorkItem Query, we definately have some. "Tests Inconclusive" is always zero. Yet I have no idea how to affect this. If anyone can give me some pointers to the doco or perhaps bash me into the right direction I would be really most grateful. Mos ...Show All