Benjamin R.'s Q&A profile
.NET Development How to write back changed datarow automatically to the database ?
I display a SQL Server database table in a datagridview. Whenever a row in the grid gets changed, it should be updated automatically in the database table. I tried to do this in several events, so far with no luck: 1) DataGridView (this would be the natural choice) Has no usefull event 2) BindingSource_CurrentItemChanged I tried it like this: private void userTableBindingSource_CurrentItemChanged( object sender, EventArgs e) { DataRow ThisDataRow = (( DataRowView )(( BindingSource )sender).Current).Row; if (ThisDataRow.RowState== DataRowState .Modified) { userTableTableAdapter.Update(ThisDataRow); ...Show All
SQL Server subtotal with duplicates
Hi everybody I'm looking for possible solution on the following issue: Given Dataset (SQL Server 2000) Job |Item |ProjectedItemCost |SubItem |ProjectedSubitemCost| ------------------------------------------------------------------------- 10 |01 |50 |01 |10.00 10 |01 |50 &nbs ...Show All
Visual Studio Express Editions Error everytime I try to run
Every time I try to run my program I get this error: http://img195.imageshack.us/img195/9966/error9mw.png No matter how simple it is, it will never work. Any help would be great, thanks. Is the compile working Can you run the program if you run it from the file system How about if you select 'Run without debugging' ( CTRL-F5, from memory ) ...Show All
Visual Studio Team System Assign Work Item to multiple people?
Hi, Could we assign a Work Item to multiple people (not group) Or say if we do such thing, could it spawn multiple WIs for every individual If there is no out of box support, could we still achieve this by extensibility Then which are the extensibility one has to use. Is there any demo or blog explaining this Thanks, Saurabh This has been discussed several times before on this forum. Here is one of the relevant threads: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=21905&SiteID=1 You will find many more by searching for "assign multiple" in the forum. -Chad ...Show All
Windows Forms print a panel
Hi I need to print a panel that consists of text and images, could someone please show me how to do this Regards ...Show All
SQL Server Report Viewer not available in VB Express?
I'm trying to use report viewer controls, but the controls do not appear in the toolbox. The file reportviewer.exe was not in the location specified in the help files, but I have downloaded it, and when I try to add it to the toolbox, I get the message 'ReportViewer.exe' is not a .Net module. Should there be a .dll somewhere Is it not possible to use this control w/ VB Express / SQLExpress ReportViewer.exe contains the dlls for the controls. You need to run it to extract the dlls, and install them in the GAC. See http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx ...Show All
Windows Forms Tear-off ToolStrips?
Is there a way to allow ToolStrips to be moved around and undocked as in Office and Visual Studio We went from being slammed in getting B2 done to being slammed in getting RTM done...we still have plans to do these samples, but I wouldn't expect any sample code to compete featurewise with third party controls on their Nth revision.& ...Show All
Visual Basic How can i use nullable (of t) to handle nulls in DateTime
Hi, As we all know the Datetime in vb.net 2003 cannot handle nulls. I see that there a system.Nullable (of t) How can I make use of this in order to handle nulls in datatime. An example will be appreciated Thanks a lot.That is exactly the kind of thing i was looking for. I will use it as a base to create generic functions. I wish there were links or books on the matter. Thanks again for taking time to answer my question ...Show All
Visual Studio Team System How to install sharepoint/team system in production server?
Hi, all. We have one server that many existing web application are running on. We have to install team foundation server and sharepoint on the server. The problem here, is that it disable all other web applications when I install sharepoint. Here, We don't need to consider team foundation server. Sharepoint itself gives me trouble. I don't want to dedicate new server to sharepoint. Is there any way I can run sharepoint (also team foundation server) with other existing web applications. We have a TFS in production, recently upgraded from RC to RTM. All have worked fine until I tried to change the TCP port for the W ...Show All
Visual Studio Team System Relationship between projects and source control
The relationship in vstfs between a project and the vstfs source control seem screwy to me, maybe I don't understand it. I have one major application and run multiple projects to upgrade different areas of the application, say three projects running concurrently. So the relationship for me is a team project with the source code sitting outside (or above) this. Vstfs seems to want me to put the source within a team project. How then do I have a separate portal as new projects come along if I'm working on the same source code This is a related topic to the relationship between source control and team projects ... I can easily ...Show All
Windows Forms Two questions about ListView
1. When I change the width of the columns of a ListView, the content of it flashes as I move the mouse. How can I cancel the ListView redraw the content while changing the column width I tried to add e->Cancel = true; in ColumnWidthChanging event, but it works not very fine. 2. I have an icon, and have added it in an ImageList. I want to set it as the ListView's StateImage. But strange that it displays as only in a very low color depth. I have set the ImageList's ColorDepth property to Depth32Bit, but it does not works. And if I set this icon as the icon of a form, it displays fine. How can I solve this problem The format of the icon is P ...Show All
SQL Server XML record from SP
There is a requirement to return a xml record using SP. The structure of the xml looks like below. <RNetOrderResponse_20 Version="2.0"> <RNetHeader> <ThisDocumentIdentifier>ORE41688745301004467924200605220825263-20060522T082502</ThisDocumentIdentifier> <ThisDocumentDateTime><DateTime DateTimeQualifier="On">Feb 24 2006 11:21AM</DateTime> </ThisDocumentDateTime> < From > < RNetPartnerInformation > < RNetPartnerName > PPG EU </ RNetPartnerName > < RNetPartnerIdentifier Age ...Show All
Windows Forms XML to ListBox or something...
Hello, I have XML database like this: <root> <user1> <item1>blabla</item1> <item2>blabla</item2> </user1> <root> I need to have this items listed in my listbox by every user (will be selected in some combo or so). What's the best way to do this using C# Or if you have ...Show All
Visual Studio Express Editions Get specific row value from DataTable
Hey there, I have a problem trying to get an specific row from a table. I'm using a DataSet that has several nums of tables created in runtime, but I need to get an specific row from each table, I'm using this code: Dim TablesResult As New DataSet 'then I call the function to store the tables into the dataset For Each Table As DataTable In TablesResult.Tables Dim Generic As Integer = CInt (Int((Table.Rows.Count * Rnd()) + 1)) 'And then here is where I need to select the specific row and get the value, 'the tables from the dataset just have one column!, Next Please help! Thanks! &nb ...Show All
Visual Studio Team System Attempting to auto assign to triage user
Under our AD we have a user called triage, created with the intent that this user will be logged in during the morning war-room meetings where dev and qa meet to discuss new bugs and what to do with them. I'm trying to set team system to auto-assign any bugs with status of New to this triage user, but whenever I try to verify the xml through the witimport tool, I keep getting the error: '[domain name]\triage' is not a valid user or group name. Now I know for a fact that the user is a valid username for this domain. It has been added to the project administrator group (I did this for the purposes of testing - it wouldn't normally have thi ...Show All