SQLScott's Q&A profile

• Visual C++ wincon.h missing SetConsoleDisplayMode()!!!

  BH Im using Windows XP Home. I installed Microsoft Platform SDK 2003 R2, and already adjusted the directories with my VC++ 2005 Express. (p.s. should I really use this sdk, or the 2003 sp1 ) When I try to make A win32 console window to full screen, using SetConsoleDisplayMode(HANDLE, DWORD, PCOORD), the compiler complains that the identifier is undeclared. So I opened wincon.h and indeed it does not have the declaration of SetConsoleDisplayMode()! I checked MSDN, and the function is still listed! said to be included in wincon.h! http://msdn.microsoft.com/library/default.asp url=/library/en-us/dllproc/base/setconsoledisplaymode.asp Whats going on is there a alternative better way to set full screen ...Show All

• Visual Studio Express Editions Problem getting value from the DataGridView component?

  How do I get the value from an selected row with the DataGridView component to an Label component Example Add a datagridview with a two columns. Use this code. At some text in the cells and then start chnaging the selections. Public Class Form1 Private Sub DataGridView1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.SelectionChanged Label1.Text = Me.DataGridView1.SelectedRows.Item(0).Cells(1).Value End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect Me.DataGridView1.MultiSelect = F ...Show All

• Visual Studio Team System Custom team project creation failed on RTM with TF30162

  Hi all, We upgraded to team foundation server RTM (from TFS beta 3 refreh) single server deployment couple of weeks ago. The upgarde went fairly smooth. We have a custom process template on our team project (based on the MSF agile). After the upgarde we managed to create a new test team project based on this custom template. Today when I tried to create another one (again based on the custom template) the project creation wizard fails with the message "Actual reporting settings for the field System.Title are different from those specified in the XML. Changing these settings is prohibited" (as detailed in the creation log attached). We hav'nt changed this field in the customization but it's possible we changed its reporti ...Show All

• SQL Server Dead End...

  Hi, I want to register a new server,  I go to Server Management Studio -> Right Click Database Engine -> New -> Server registration Make up a server name and test Apears the  "..sql server does not allow remote connections..." I go to surface area configuration for services and connections, but it doenst have any components, because i have to make a server registration first! I dont understand... If you please help me... Thanx Best Regards You need to either log in to the console of the server machine or use remote desktop to log in. Then you can run the local SAC tool on the server machine to start SQL Server if it isn't running and to configure SQL Serv ...Show All

• Smart Device Development Change the time on the device

  Hi is it possible to change the time on the device thru c# code It's allowed to use a dll. grtz Annihil8 I've allready have found it. It can be done by SetLocalTime() you can find a good example at www.pinvoke.net in the kernel32 dll. You can use this example for winforms, on CF you must use coredll instead of kernel32 Grtz Annihil8 ...Show All

• Windows Forms Rowfilter method

  Hi I have a DataGridView, DataView, txtbox and button. If I enter a text in the textbox it have to search in de datagridview when i press the button. I found th next code: Me .DataView1.Table = Me .MarnikDataSet.Tables( "Contact" ) Me .DataView1.RowFilter = "FirstName= 'Me.TxtSearch.Text'" But how can i go to the record that is found example: I enter in the txtbox: Peter, I press the button and it has to find Peter in the colmumn(FirstName) and then it has to highlight that record. Pls help thx in advance Marnik Hi, Marnik Van Hileghem Use the DefaultView property instead.As: private void button1_Click( object sender, EventArgs e) { string id = ...Show All

• Visual Basic Suposing I want to create a method to Update Data

  A question, please: Supposing I want to create a method (in an own class) to Update Data. What should the method give as result. A boolean, if the update was fine or an integer if the update was fine and that allows me recover the number of update records, or another thing (suggestion) Thanks for the suggestions.... Generally in object-oriented design you raise an exception when there are exceptional errors. If, for the most part, your method will always succeed under normal circumstances then throwing an exception to indicate error is the suggested design. If you're expecting your method to return failure a good portion of the time and don't want to incur the overhead of throwing exceptions yo ...Show All

• Visual Basic VB.net connection to SQL server and inserting data

  SqlConnection = New System.Data.SqlClient.SqlConnection("workstation id=VANPC62757;packet size=4096;integrated security=SSPI;data source=MTLASR74;persist security info=False;initial catalog=vanLMS") SqlAdapter = New System.Data.SqlClient.SqlDataAdapter( ) i m trying to connect to a table in the Sql server lets say the table is called SQLTABLE do i need a dataset in order to insert stuff into sql server can someone show me a few sample line of how to insert data(or datatable) into the table in SQL server thx in advance No - you can create an ADO.NET command object and then simply call it with the SQL Insert Statement.   http://samples.gotdotnet.com/quickstart/ ...Show All

• Visual C# Constraints in generic clases

  Hello, I have the following problem and I can not figure out how to solve it in the best C# style: I need a class with 2 methods: Hi, If I misunderstand you anyway, pls tell me. You want create methods with Byte, UInt16, UInt32 and ULong as their param, right If so, you can define the methods as I previously described, additionally add a custom attribute to each method. At least, the definition in your above code does not make sense. Thank you for discussion. ...Show All

• Visual Basic TCP/IP clients, listener, and servers

  I was wondering if anyone had a good example of a TCP/IP server VB.Net application using TCPclient and TCPListener that you could send me. I need to develop an application that acts as a TCP/IP server waiting for TCP/IP client connections. All of the connections have to be maintained and any received command has to be processed and status information needs to be returned to the clients. Tony Is the protocol something you can modify It looks like the protocol is giving you some difficulty. For example, if a client connects, looks at the status, and disconnects, this should be a specific protocol pattern that the server knows about, and knows that the client will disconnect. This protocol is similar to, s ...Show All

• Visual C# documentcomplete event

  I've got a really weird problem with my application; it works on some pc's, and it doesn't on some others. What I've got: A Visual C# 2005 console application with references to MSHTML and SHDOCVW. I use mshtml to get a list of currently open browser windows, and attach events to it to edit the list when a new browser window is created or closed. I attach a documentComplete event to each open browser window and handle it the event there (let's say it prints out the url where is navigated to). So when I run this program, it should detect when I open a new browser window, when I close one, and it should print out the url of a site when it is done loading it. And there's my problem. On a few pc's, it all works perfectly. But o ...Show All

• Windows Forms Ascii problems with RichTextBox

  I have a problem when i save/load information from a RichTextBox, when i save the information into a text file every character that has larger number then 127 in ascii-table becomes strange, so the character O will be \\'d6 and character a will be \\'e5 and so on. And that is a big problem when i later tries to insert the text into the sql database. This character ' is causing problems in my sql query. So, the thing i want to know is, how can i save the information in such a way, that it won't convert every character that has bigger ascii number then 127 into strange character formation. One more thing, i have to save the information in RichText format becuse im using pictures in the RichTextBox. //Mario ...Show All

• Visual Studio 2008 (Pre-release) Frame Control/Window AllowsTransparency?

  Hej allihopa!.. I’ve come across something very strange.. There's a way if you give up transparency and only go for regions: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1141200&SiteID=1 ...Show All

• Windows Forms Datagridview not displaying correct value

  Hi all, I have a tabcontrol on my form that is bound to a dataset, with each tabpage is a child datagridview. When insert a new record, I retrieved the latest MAILNO (which is autonumber index primary key for the master table) using a stored procedure and set the MAILNOTextbox.Text to this. When I want to insert a new row for the child datagridview, the MAILNO column displays the old value, and thus, is not correct. For example, a scenario: The last record MAILNO in database is 5. Record no. 6-8 is deleted before this. When I click Add in the bindingnavigator, the MAILNO displays 6 (whereas should display 9 for a new record). I've fixed this using the stored procedure to retrieve the correct value. When moves to the next tabpage, I made th ...Show All

• .NET Development Attempted to read or write protected memory - Fonts-

  I am receiving the following error message in a non-reproducable and seemingly random fashion in my ASP.NET, C# application: System.AccessViolationException was unhandled Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. The only steps I can take to reproduce the error are to run the offending function many times, and at some point, this error occurs. The function that I believe to be causing the error is as follows (well, actually I think that GDI+ using this functions output is the cause): public static Font GetFont(HttpServerUtility Server, string FontName, int Size, bool Admin) { //Check if it's in the PrivateFontCollection //If not then it is a system font ...Show All