BobRS's Q&A profile

• Visual Studio Express Editions Exception error, how to solve or handle it?

  Hi, could someone tell me whats the meaning of the error and how can I solve it. Thanks. here my code: public static void ReadData() { string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\FYPproject.mdb" ; string queryString = "SELECT Sample_Number,Pump_Speed FROM 2Pumps" ; using ( OleDbConnection connection = new OleDbConnection (connectionString)) { OleDbCommand command = new OleDbCommand (queryString, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); <<Error on this line while (reader.Read()) { MessageBox .Show( String .Format( "{0} , {1}" , reader[0], reader[1]) ...Show All

• Visual Studio wrong file version on 1 user machine, all others correct

  I have vss 6 client loaded on 2 of my machines and loaded and used on several others machines. On both of my machines I log on with the same user id. On 1 machine it shows an older version of files. All the other machines in the company are showing the correct version. I have tried removing and reloading vss6 on the machine, the same old version of files show up. Thank you for any help DW $/Source/Phase 2/HTML (web prod-specific)/index.html $/Source/Phase 2/HTML (web dev-specific)/index.html $/Source/Phase 2/HTML (web test-specific)/index.html Those sure look like 3 different files. Or at minimum, 3 branches of the same file. ...Show All

• SQL Server ON DELETE CASCADE

  hello guys! Well im using MS SQL 2000 and i have over 250 Tables in one of my Database the problem is all the Foreign Key in the Table is not turn ON in ON DELETE CASCADE. The question is, is there anyway to write a script to turn the ON DELETE CASCADE on all the Tables Thanks for the reply! Novelle Nope, not really. You will just have to script your keys out, then change to ON DELETE CASCADE manually. Unless there is some tool to do it, but I don't know of it. A trick I would use is to take your database scripts (or if you don't have any, use a comparison tool, compare my full database to an empty one) and just replace all ON DELETE NO ACTION values with ON DELETE CASCADE. Then use your sc ...Show All

• Windows Forms openFileDialog (help with Declaratoin) Thxs

  ok first off here is the C# Code i have: private void button14_Click(object sender, EventArgs e) Stream myStream  = null; OpenFileDialog openFileDialog1 = new OpenFileDialog (); openFileDialog1.InitialDirectory = "c:\\" ; openFileDialog1.Filter = "txt files (*.txt)|*.txt|All Files (*.*) | *.*" ; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true ; openFileDialog1.Title = "Load Client List" ; openFileDialog1.FileName = "" ; if (openFileDialog1.ShowDialog() == DialogResult .OK) { try { if ((myStream = openFileDialog1.OpenFile()) != null ) { using (myStream) { //insert code to read the stream here } } } catch ( Exception e ...Show All

• Visual Studio Express Editions Databind recordset to Datagrid

  Hi, I am trying to assign value in my recordset queried from the DB into the Datagrid's datasource during runtime however, I am unable to do so. I tried with the following code was prompted with error. Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset cnn.Open(strCon) rs.Open("SELECT Name, Address FROM Employee ORDER BY Name", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic) If Not rs.EOF Then DataGrid1.DataSource = rs End If Error message during runtime A first chance exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll Please help, thanks! I was a VB6.0 user and I ...Show All

• Visual C# How Enable, Edit Windows Vista Infotip Style

  HI: Well since I begin to use the Windows Vista, I note that in the Notification Area, some Icons have a very cool Infotip, with Captions, text, description, Icon. So I'm tying to create an Infotip like those for my windows Application. But I cant found some information about how to enable this Infotip style in C#. Thank you for your time, I'll appreciate a lot your help. ...Show All

• Windows Forms Binding Grdview to BindingSource

  Hi, I'm trying to bind a Bindingsource to a Gridview(unfortunately without luck), can aynone please assist in helping me resolve this. Itt can't be that hard!!. <code> DataTable funeralsTable = DBAccess.GetFunerals(); <-- Calls my data class DataView dvFuneral = new DataView(funeralsTable); bindingSource1.DataSource = dvFuneral; gvFuneral.DataSource = bindingSource1; </Code> When I run this I get an empty girdview. Found my problem, it would seem that the BindingSource control will not bind to a dataview. If I change the source to a datatable all works fine.. Regards.. Peter.. ...Show All

• .NET Development DataTable is loaded very slow if there are two threads doing the same thing

  Hi, Here is my problem very short: Loading an oledb table data takes a fair amount of time, if there is only one thread that loads a table with data. If there are two of them, each loading its own table, loading takes unacceptable time. Now very long: I've written an oledb supplier (ATL) for a proprietary data source (it's not a database, it a server that exposes data on the network using an xml protocol). So far so good. I tested the oledb supplier with various methods, including a C++ program (not .net, mfc and ATL for oledb) that launched 10 threads to query the same data. It worked without problems. Now my job is to make a client program that does something with the exposed data. Unfortunately I have to use C# to do that, and of cour ...Show All

• Visual Studio Team System Organizing Team Projects

  We develop software for several customers. Most customers have one or more completely independent projects with other persons, dokuments, tasks etc. My question is now, what would be the best way to organize my projects in Team System. The only wayI found by now, is to create a new Team Project for every of my projects. But there are a lot of them and I'd prefer to group the Team Projects by customers. For exmaple in Visual Source Safe we had a hirarchy Customer / Project / Module which was very handy. But I found no way to create a structure like tghis in Team System. I found a possibility to create different folders in a Team Project, but I cannot create a Team Project for every customer and then place the differen projects in d ...Show All

• Visual Basic why my data grid control doesn't show any tooltip text that I set.

  Please help to fix on why my data grid does not show my tooltip text that I made using VB.NET 2005. refer to the following forum post to show tooltips for DGV http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1092075&SiteID=1 ...Show All

• Windows Forms Adding a TableAdapter to DataSet

  Several questions: 1) If I have a Typed Dataset as part of my project, is there anyway to add a Table Adapter to an existing DataTable in the visual designer It seems to be greyed out. 2) I would ideally like to separate my dataset and tableadapters in separate classes. It there any way to do that using the visual designer 3) I drag a stored procedure onto the dataset and it creates a table and a tableadapter. I then add columns to the datatable which are going to be filled in by the user. I tI dfg 1) If you have not done so install Visual Studio 2005 Service pack 1 2) You can not change how the table adapters are generated. The table adapter and the typed dataset are already separate classes in the same ...Show All

• Visual Studio 2008 (Pre-release) XAML Xml Binding

  Is it possible to work a master-detail where the detail gets it's Xml data from a different part of the tree and not a direct child of the original master element. For example, I want to show a category list, and selecting a category will show me the reports in that category. However a report can be in more than one category. Ideally I don't want to duplicate the report information so I want Xml that looks like: <reports> <categories> <category name="cat1"> <reports> <report key="rep1" /> <report key="rep2" /> </reports> </category> <category name="cat2"> <reports> ...Show All

• Gadgets Gadget for my site...

  I would like a gadget for my personal site that would be able to pull dynamic content from a message board and list the 'hot topic' or top 5 topics in a seperate little window when you click the gadget. I click it...the window opens...and the selected content is displayed... Thanks, Chris Yeah...sorry after re-reading I see what you mean..:) I would like to figure it out myself with a little help. I use phpbb software for my forums and though I don't know if RSS is in the software itself I know there are MODs for it that deal with RSS. I will look into that a little more. I pull code direct from my DB on my main page for visitors with php right now. I would assume all I need to make the gadget do is ...Show All

• .NET Development Is this a good plan? VB Express and remote SQL SERVER DB

  18 months ago I re-wrote an entire order entry system with an Access 2002 front end (original the system was all Access) and SQL Server stored procedures for all data retrievals, updates, etct. This was to prepare for a time when I could re-write the front-end in VB.net and use all of the existing stored procedures. So, I started down the path of moving the system to .NET a week ago. In my experimentation, I wrote some code like the following to call a stored procedure, then read through the results and parse the results for values in the form controls, just to see if this will work: Private Sub btnGetPersonID_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetPersonID.Click Dim strConnectionString As St ...Show All

• SQL Server Log Shipping Failover / Failback Question

  Hello all, I'm about to setup Log Shipping in our SQL Server 2000 environment. I will have the primary server, one standby server, and the witness server in this setup. I understand the process of failover and the stored procedures needed to make this happen, but my main question is about failback. Once the standby server has assumed the primary role, will log shipping be automatically configured to start flowing from the new primary server to the old primary server, or will I have to go back and setup log shipping from the new primary server to the old primary server Thanks for any help or insight you can provide on this subject! Eric I'm sorry. Unfortunately, log shipping changed significantly ...Show All