kart's Q&A profile

• Windows Forms Validating data in a bound datatable

  I want to validate data for a datatable bound to a datagridview. To cancel an edit for bad data, from what I can tell from the MS docs, I can set the columnerror or throw an exception in the handler for the columnchanging (or rowchanging) event. I tried throwing an exception and that works fine when I do the edit programatically. Ie, try > add a row of bad data > catch exception. But where do I catch the exception when bad data is entered into the DGV The dataerror event of the DGV gets errors from ConstraintException, NoNullAllowedException, and ArgumentException - this works fine. Is this supposed to get the exception that I throw too I am throwing an ApplicationException. Is this right I can catch the exception right afte ...Show All

• SQL Server SQLEv & blobs

  I want to store message database in SQLEv. Each message contains fixed header and a body. Body is UTF-16 encoded text. Average size of the body is about 700 symbols. Standard deviation about 1000 symbols. Maximum size - 200K symbols. Total count of the messages is up to 2 millions. The only type I can use for body is text or binary blob. But blob larger than 256 bytes store in separate pages. Because of most message bodies lager than 256 bytes, each message take avg. PageSize / 2 not used for storing data, but occupied space. For 2M messages this space will be 4096 / 2 * 2M = 4G. But SQLEv has 4G limit for database size! Is it any way to store such data in SQLEv more efficiently I see... Well, pe ...Show All

• Visual Studio Express Editions disappeard items in designer

  I have a program with a menu-bar and a statusbar. Ther were a lot of items in these bars, but suddenly they have disappeard. In Designer you can't see them, but in the Code you can still use them and while compiling, there isn't a fault. In debugging-mode they also have disappeared. How can I get all these items back Thx! I had the same problem numerous times and I have discussed a solution for it in one of my posts. Even if you're already rebuilding the project I'll leave here my solution for reference. In the Form1.designer.vb file, you should have this piece of code for the MenuStrip (the names and values may differ): ' 'MenuStrip ' Me .MenuStrip.Location = New System.Drawing ...Show All

• SQL Server Visual Studio Debugging Issues

  I am using Visual Studio 2005 Professional Edition I open it up, Connect to a SQL Server, expand through to the stored procedure I want, Right Click and ...... There are no options for stepping into the stored proc. Could I have missed something on the install. Please Help!!! ...Show All

• SharePoint Products and Technologies SharePoint 2007 - Access in Read Only to a folder

  Hi, I have a folder. A Group A can access on it only in Read. It's seems ok because the buttons "New" and "Upload" dont appear anymore. But another problem appears : when a user open a file, and edit it, it seems that he's able to edit it and save it without any problem !! How can i manage this problem I dont want to allow them to edit documents. Thanks for help. hi, ive enable the check-out option. But another problem appears, when the user load the file in the editor and try to save it, in fact microsoft word does'nt allow him to save it with the same file name but il allows the save under another name I dont want to allow this kind of user to edit or add files... How can i do ...Show All

• Visual Studio 2008 (Pre-release) Installation Issue

  Hey gang. I have installed the August CTP so I can try some of the code generation but I am not seeing the template in my project listings. I am running on Vista. Any clues Any help would be greatly appreciated. Please tell me a little more about your environment. Which build of Vista are you running Which version and build of Visual Studio There is a chance that this is due to an incompatibility between Vista and VS 2005. One thing that we can check is to see if the template files were installed correctly on your hard disk. Please look at: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ProjectTemplates\CSharp Do you see the ADO .NET vNext project template folder ...Show All

• Gadgets OT: Posts are appearing out of order

  Not sure if anyone else has noticed this, but posts are starting to appear out of order. eg. Bruce's reply here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1145168&SiteID=1 and Menthos's reply here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1149010&SiteID=1&PageID=1 Maybe it has to do with which "reply" button you push I might have replied to my own, immediately-preceding message, instead of the last one on the thread. Even if that's so, its still seems wrong - you can't just scroll to the bottom of the thread to see the latest comments. ...Show All

• Smart Device Development Assign emulator network settings using code?

  Hello All, I am looking for a way to set the network hostname, IP address, netmask, gateway, WINS and DNS using code. I am looking to launch an emulator, set the network settings and run application tests. Thanks in advance for any ideas :) Bob Hanson Dear Bob, All the settings on the network will only take effect the next time when device starts up. APIs for register that you can use are: RegOpenKeyEx, RegQueryValueEx, RegCreateKeyEx, RegSetValueEx, and etc; For code example on how to use them, you can get a lot when searching the right key word in google. Regards, Zero Dai - MSFT ...Show All

• SQL Server Setting a filter in the SELECT-statement

  Is it possible to set a filter in the SELECT-statementpart Normaly you the filter is set in the WHERE-statementpart, but that is too late for me in my statement. Right after the SELECTing the field I want to set a filter to the query Is it possible My statement looks like this now: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price], [DatabaseName$Sales Price HAG].[Starting Date], [DatabaseName$Sales Price HAG].[Starting Time], [DatabaseName$Sales Price HAG].[Sales Code] (<== here on this item I want to set a filter) FROM [DatabaseName$Item] INNER ...Show All

• SQL Server Help! SQL Express, Standard or Enterprise? or Access?

  I'm not a developer and would like your input to compare against what a sales rep is telling me. I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed. The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search. That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input. Thanks very much! Tricky part I found on that is that the ...Show All

• SQL Server SQL Express install error on Windows 2k Professional SP4...please help

  Hello all, This is my first time posting, so be gentle as I'm not exactly sure what the protocol here is regarding posting errors. I'm encountering an issue with an installation of SQL 2005 Express (SQLEXPR_ADV.EXE) on a Windows 2000 Professional SP4 machine (Intel P4 1.8 Ghz). The following error is what I receive: Setup.exe - Entry point not found: The procedure entry point _create_local could not be located in the dynamic link library mscvr80.dll < OK > The following is what I see in the error log (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files): SQLSetup0007_SQL2005TEST_Core.log Microsoft SQL Server 2005 Setup beginning at Wed Dec 06 11:28:08 2006 Process ID : 452 c:\98b179fcf69 ...Show All

• SQL Server Design/load question

  Hi. I am redesigning a database to be more normalized. There are 4 columns that appear in many of the tables that I plan to add to a new table. Here is what the database looks like now: table1 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. table2 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. table3 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. If I add a 4th table with the columns that are the same in each of the tables, I'd have this: table1 uniquecolumn1 uniquecolumn2 uniquecolumn3 uniq ...Show All

• Windows Forms Fill ListView?

  Hi, I can figure out how to add items to the first column, but how do I add items to the second, third... columns Thanks, Somthing like this: ListViewItem item = listView1.Items.Add( "1.1" ); item.SubItems.Add( "1.2" ); Yours Markku ...Show All

• Windows Forms My row headers won't display.

  I'm playing with the DataGridView. I have a form with a blank DataGridView (no predefined columns) and a button. Clicking the button executes the logic that fills the DataGridView. Basically, there are 10 columns and 10 rows. The column headers and cell values are displayed but I can't get the row headers to show. In debug I can see the values for this->dataGridData1->Rows[0]->Headcell->Value being set properly but they don't display. array<String^>^diffPressRow = gcnew array<String^>(10); for( int i = 1; i <= 10; i++ ) { for( int j = 1; j <= 10; j++ ) { double flow = 100000.0 / j; diffPressRow[ j - 1 ] = flow.ToString( "F2" ); } this->dataGridView1 ...Show All

• SQL Server Distributed App, Technology Question

  Hi Everyone. I am trying to get ideas for a possible technology we could use for a certain scenario. In a nutshell we want to run a distributed application at hundred of remote stores, anything that happens at the store must be propagated to a central sort of hub server. Now i have already thought about replication, but maintaining replcation across hundreds or even a thousand remote instances would be a nightmare.Also the App must work offline so if no link exists the app must still work and sort of reliably queue the transactions. So i been experimenting with service broker, to write transactions, that then queue on to service broker to the central hub, therefore enabling remote stores to continue to work even if no comms exi ...Show All