Geeter's Q&A profile

• Visual C# Treeview Mimicking Windows Explorer

  I am implementing a TreeView control to closely mimic Windows Explorer behaviour. The user can edit labels and these must be uniquely named. If the user edits the name of the label to a non-unique name an error message is displayed and the label remains in edit mode until the user enters a valid name. I am using the following pattern within OnAfterLabelEdit: protected override void OnAfterLabelEdit(NodeLabelEditEventArgs e) { //Label is valid unless the user has changed it. if(e.Label==null) { return; } //Peform validation. bool IsValid=ValidateLabel(e); if(!IsValid) { //Reset label. e.CancelEdit = true; System.Wi ...Show All

• Visual Basic Upgrading an application from 2003 to 2005

  Hey guys, I just upgraded one of my applications from 2003 to 2005, and managed to do it quite easily, except for one Routine. I had the following Sub in .NET 2003 that I used to populate a DataGrid. But now, with 2005, I am getting 5 errors (marked in red) saying that 'TableStyles' is not a member of 'System.Windows.Forms.DataGridView'.......... what must I use instead Public Sub FillDataGrid(ByVal GridSQL As String, ByVal frmDataGrid As DataGridView, ByVal MemberTable As String, ByVal DGReadOnly As Boolean, ByVal AlternateColor As String, ByVal ColWidths As String, ByVal ColHeaders As String, Optional ByVal Filter As Boolean = False) ...Show All

• Architecture Architecture question - how to store local copies of data on a server

  My work order application needs to do the following: 1) User has a windows forms client on their laptop, PC, or even mobile client. 2) When they have an active connection, they can connect to a web service to view new tasks, mark the ones they want to download to their local machine, then disconnect. 3) They can then edit their local copies of these tasks, then re-synch with the server when they next have a connection. Reason being, they may often have to take work orders into the field where they will not have an internet connection. Question: How can I store these locally in a secure manner, i.e., in a format that I canno ...Show All

• SQL Server Heeeeellllllllppppppppp!!!! Replication Latency in Dist Agents

  Hi, I have Transactional Replication running and Pushed to 2 subscribers.  I am noticing that, sporadically, the latency shown on the Distribution Agnets is extreme.  This means it's taking a very long time for transactions to get to the subscribers... which in turn means that my 'High Availability' scenario is down the tubes.... which is a disaster. Usually I see latency numbers under 5000... and they are reset periodically.  Today, for example, the numbers just keep piling up and exceed 1000000 already.  I'm not a DBA... but I am  the guy that has to figure this out.  What could be causing this   How ...Show All

• SQL Server SQL Server express starting as NETWORK SERVICE!!

  Hello All, I am installing SQL Server Express from the command line using the following parameters INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=TEST After the install is done I start the service form the command prompt using start mssqlserver I see that the SQL Server service has started under NETWORK SERVICE account!!! when the documentation i Read on MSDN says it starts in Local System account Can any one explain me the possible reasons Thanks The default is Network Service which is a lower privileged account then Local System. It is a little safer by default this ...Show All

• Windows Forms Delete row and updating database through datadset

  Hi, I am using following code to bind the myControl (Some bindable control): DataSet dsTrims = new DataSet (); dsTrims = MyProvider.ExecuteDataSet(System.Data. CommandType .Text, strWhere); this .bindingdataSource1.DataSource = dsTrims.Tables[0]; myControl.DataSource = bindingdataSource1; All the data get visible to myControl when run the application. I can also update row into myControl and this update also takes place into the dataset through which myControl is bound. And from there I can easily put logic for updating database through updated dataset. I am using following code to update the database aft ...Show All

• Visual C# How to interpret void* in C#?

  I am writing a porgram to call function in a dll created by C++. this is not a com dll,so I use pinvoke . In this function,there is a parameter was the type void* how can I translate it in C# If you know that the parameter type should be a pointer to an int, just change the parameter type to ref int instead of IntPtr. ...Show All

• Visual Studio 2008 (Pre-release) Blog based on WPF - updated for Beta 2

  http://www.valil.com/Valil.Blog/Valil.Blog.xbap I'm always impressionned by seeing your work Valentin :) Thank you very much ;) BTW, do you planned to share the source ...Show All

• .NET Development Updates are not written to the database - please tell me why!

  I am at my wits end! I am creating a simple web application in Visual C# 2005 Express Edition Beta 2 by dragging a table from a data source onto a windows form. I have reread numerous articles on MSDN but with the exception of adding a try block this is as far as I can tell all I need to do to create a working form. When I run it all looks good, I can edit fields and click on the save (disk) icon. But when I look in the database again - it is unchanged. No exceptions are thrown. As far as I can tell from stepping through the code it is doing everything that it should - except that the update method   ...DataObjectMethodAttribute(...Dat ...Show All

• Windows Forms can mdi form raise double click event?

  can mdi form raise double click event  in a mdi form ,I override the DoubleClick event,but it doesn't work,i can't understand  can anyone help  thanks!!! ...Show All

• Visual Studio Express Editions VC# 2005 beta crashing - please help

  Hello everyone! Im a newcomer to .NET and C# and recently (about a month back) I had started using visual C# express edition 2005 beta . It worked just fine uptil about a couple of days ago. Two days ago, I started vc# express and chose 'New Windows Application' under File->New->Project. (1)Now, earlier this would have meant that the design view would have showed up. However,now vc# just opens a new project,displays the property window for the new project's form and does NOT display the form at all . If I choose form1->designer view , then vc# crashes with the following message- "An error report is being collected.This could take s ...Show All

• SQL Server Problem generating error file using BULK INSERT or BCP thru xp_cmdshell.

  BCP thru xp_cmdshell from stored procedure: EXEC sp_configure 'show advanced options', 1; RECONFIGURE EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE EXEC xp_cmdshell ' bcp database.dbo.table in c:\scheduled.csv -S SERVER\SQLEXPRESS -T -t, -r\n -c -e "error.txt"'; This is returning the following error code. I even tried placing the command in a seperate command file and calling that with no success. If I run this from the command line the error file generation does work. ================================================================= SQLState = HY000, NativeError = 0 Error = [Microsoft ...Show All

• SQL Server Trigger for Update

  I need help with a trigger(this is sql2000), So I have a certain table with a bunch of columns(ex table A [col1, col2, and col3] i need to validate that only values of col2 can be updated, if the user tries to change the values of the other columns... then rollback.. raiserror. So this is part of the code: CREATE TRIGGER TRU_ServiceDetails ON ServiceDetails FOR UPDATE AS BEGIN DECLARE @ErrNr int, @ErrMesg varchar(255) --Updates only can be made for the clomun Price IF EXISTS(SELECT * FROM Inserted I, ServiceDetails SD WHERE I.ServiceId=SD.ServiceId AND I.ServiceTypeID=SD.ServiceTypeID AND I.EmployeeID=SD.EmployeeID AND I.Service ...Show All

• Windows Forms How to create a DataGridViewImageCell - Ranking Column, like in Windows Media Player ?

  hello, i would like to know how to simulate the behavior of the ranking column in media player 10, like when you hover it, stars are on or off, and allows on the fly editing. the cell values are something like : 0; 75 ; 150; 200; 255 there are 5 values for 5 stars my question is: how can i consider it i mean do i have to create 5 columns , one for each star or is there a way to insert multiple image items in one cell, I found nothing about it or shall i simply use 6 versions of image that will not be editable   thanks a lot Hello, I don't understand how can i use this VB c ...Show All

• Windows Forms How to disconnect the data in DataGridView?

  I have a DataGridView which is being populated during the form load event. private void PopulateEventLog() { SqlParameter [] arParms = new SqlParameter [1]; arParms[0] = new SqlParameter ( "@LoanApplicationId" , SqlDbType .Int); arParms[0].Value = LoanApplicationID; SqlHelper .FillDataset( DBService .SQL_CONNECTION, "GetEventLog" , _dsEventLog, new string [] { "EventLog" }, arParms); //dgvEventLog.DataBindings.Clear(); //dgvEventLog.DataSource = null; dgvEventLog.DataSource = _dsEventLog.Tables[ "EventLog" ].DefaultView; } After the fo ...Show All