Arjun B's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. lame....

  Well....finally downloaded it about 30 min ago and all its good for is making u mad.....doesnt know how to do anything but crash.....biggest disappointment ever. That problem has already been answered a couple of times. : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=682322&SiteID=1 ...Show All

• SQL Server Extract data from SQL Server 2005 by SMO or DMO

  I am running an old script generator using SQL-DMO. Even on SQL Server 2005 it is working fine, but the new features like xml data type are not supported. So I switched to SMO. At the first view it looks pretty cool and easy. I changed the properties in the following source a thousand times but it doesn’t script any data to the file. Is it a bug or a stupid misunderstanding Transfer t = new Transfer (db); t.CopyAllObjects = false ; t.CopyAllTables = true ; t.CopyData = true ; //t.Options.WithDependencies = true; t.Options.ContinueScriptingOnError = true ; t.DestinationServer = "PC-E221\\SQLEXPRESS" ; t.DestinationDatabase = "TestAgent ...Show All

• Windows Forms How to modifiy the language of the openFileDialog

  I am running on an English OS but I need to show a openFileDialog in French or English depending on the user. How do I do that. I have tried playing around with the current thread culture but nothing seems to work. I have noticed that Word offers that possibilty. Thanks for the help Our application is mainly used via Terminal service so end-users share multiple languages. So I what I can understand is that since my colleague installed a multiLanguage pack for Word. The filedialogues appear in french even though his OS is in english. I will continue my search. Thanks ...Show All

• .NET Development Why isn't this Select Statement working?

  I changed my code to this string createString = "SELECT * " + "FROM GeoLiteCityLocation " + "WHERE locId = '130957'" ; cmd.CommandText = createString; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { MessageBox .Show(dr[0].ToString()); } dr.Close(); From this, which worked, string createString = "SELECT *" + "FROM GeoLiteCityBlocks " + "WHERE endipNum = '67129343'" ; cmd.CommandText = createString; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { MessageBox .Show(dr[0].ToString()); } dr.Close(); and now I am getting an exception that say's Data type mismatch in criteria expr ...Show All

• SQL Server optimising a table with lots of boolean fields

  I have an application that reads a monitoring devices that produces 200 digital outputs every second and I would like to store them in a table. This table would get quite big fairly quickly as ultimately I would like to monitor over a hundred of these devices. I would like to construct queries against each of the individual digital channels or combinations of them. M first thought is to set up a table with 200 separate columns (plus others for date stamp, device ID etc) however, I am concerned that a table with 200 boolean (1-bit) fields would be an enormous waste of space if each field takes maybe one to four bytes on the hard disk to store a single bit. However, this would have the advantage of make the SQL queries more natural. The oth ...Show All

• Windows Forms Help pls: DataSet, DataGridView, DataAdapter, CommandBuilder

  Hate to submit yet another qustion on this, but no matter what I do, nothing seems to work: This is VC++ 2005 Express with Net V2.0 on Windows2K SP4. Note that using a MySqlDataReader works; the records are read from the MySql server. Just haven't seen how to use a DataSet with a DataReader. I am trying to fill a DataGridView from a MySql Database. The code is: -----Code start Xda = gcnew MySqlDataAdapter("select * from Source", XConn); XBlder=gcnew MySqlCommandBuilder(Xda); Xda->Fill(Xds, "Source"); //"Soure" parameter absemce makes no difference. ------Code emd XConn is the connection object, and is verified as open at the start of this code. Xda is the DataAdapter; Xds is the DataSet supplied as a call parameter; XBlder is a Comma ...Show All

• .NET Development Determining Primary Key When Inserting Parent Table For Foreign Key Insert on Child Tables

  I've search many postings regarding retrieving the Identity value from a table after it has been inserted. I have a slightly different situation. I am performing an insert on 6 tables within a given transaction. Table1 is the parent and the Table2 - Table6 are (so called child) tables. On Table1 we have a ID field which is the primary key (float), hence I cannot use the SCOPE_IDENTITY. I have 6 SqlDataAdapters with 6 corresponding DataSets. How do I retrieve the Primary Key on Table1 to be used as a foreign key on Tables2 - 6 using a disconnected DataSet My code looks something like this: SQLTransaction trans = cn.BeginTransaction(); Adapter1.InsertCommand = new SqlCommand( "INSERT INTO Table1(Name) VALUES("@Name ")&q ...Show All

• Visual Basic is it allowed to install Visual Studio 2005 non-express editions on more than 1 PC?

  At the moment I'm using VB 2005 Express. I'm considering upgrading to the standard or professional edition. However, now I'm able to use the express version on, for example, a pc at work and a laptop at home. Does this also apply to the payed versions Note: I'm the only programmer, so only one edition will be used at a time. Regards, Eric Dangerous, maybe that wasnt the best choice of the words but what I'm trying to get at is that taking a single line of a EULA and using this as your justification is not always a wise choice as some other statement in the EULA may negate or this line. Legal documents are often full of these little caveats here and there, because they are written by lawyers and not no ...Show All

• Windows Forms How to find version of file programatically in .Net 2005?

  Hi, I wanted to know how I can find the version of a file programatically using C# .Net2005. I am using FileInfo[ ] info = Directory.GetFiles() to get all the files in the directory.But I am not able to get the version attribute of the file. Any help is highly appreciated Regards, ~nhd Hi nhd, Then try the unsafe code in the article . (example 3). It gets the product version of the file. ...Show All

• SQL Server OLE DB Source using table name variable

  I have a package-level variable [User::viewName], type = string, containing a view name. I want to setup an OLE DB source to use this variable value as the source, so Data access mode = "Table name or view name variable". The Variable name dropdown contains [User:viewName], so I select it. When I click OK to leave the edit dialog I get the error: The variable User::viewName is required to be of type "VT_BSTR". Only variables of type String occur in the Variable name dropdown; if I try changing it to a type other than string it doesn't occur in the dropdown. What is VT_BSTR and how can I change the variable type to it I've never seen VT_BSTR in my life, that isn't a data type that ...Show All

• Windows Forms Problems refreshing data/maintaining state in a grid

  I'm using Framework 2.0 I start out populating a grid (GridView) on a page using the DataSourceID to point to an ObjectDataSource which references a method that's used to build the recordset by calling an SP (SP1) and using its results as a source for the grid. On the page, I also have a search area, where the user can fill in search criteria, hit a button, and the contents of the GridView will change. The SP that's called in the search (SP2) is different than the initial SP1. The grid allows Paging. When I re-populate the grid after a search, the grid is being repopulated with the results of SP2 and and the page indexing is updated to reflect the new number of records spread across the pages. Everything works as expected up ...Show All

• Visual Basic search with at least 2 criteria

  I'm starting with Visual Basic 2005 express edition and i've got difficulty with searching the database with at least 2 criteria. I'm learning basing on Northwind database and all works perfect so far there is only 1 criterium. Below is my code for the search button: Private Sub btnFind_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click Dim filteredView As Data.DataView = New Data.DataView(NORTHWNDDataSet.Customers) filteredView.RowFilter = "CompanyName Like '%" + TextBox1.Text + "%'" And "City Like '%" + TextBox2.Text + "%'" Dim rowsFound As Int32 = filteredView.Count Select Case rowsFound Case ...Show All

• SQL Server Questionnaire processing script

  I am not sure how to create a query (or script) to populate a table (tbl_Report, please see below) with data from a view (vue_Response, please see below) in a database for a questionnaire system. Here are a few relevant facts: Each question may or may not have items (like a, b, c...). If the question has items, only its items have answers, but if the question does not have items, then the question itself will have an answer. If a question has items, then the question needs to show a rollup for its items in tbl_Report. Questions with items can have any number of items, but these are usually no more than 5 or 6 items. All answers are either Yes, No, or Not Applicable When the user runs the report, they can select a num ...Show All

• Visual C++ tabs in mfc

  i want ot use a tabbed view in a mfc mdi project. i used CFormView and CTabCtrl, but from what i could find in the documentation i can make new tabs but i can't add a resouce to them like i'd do with a proprietypage, and all it did was add tabs at the top of the window, but nothing more. how do i solve this www.codeproject.com/tabctrl/mditabs.asp ...Show All

• SQL Server Parameters: How to set null value

  Hi, I have a problem. I have two parameters: Group and Selection In the first I have 2 choices: Total and Day And the value of the second parameter is dynamic and is sets to allow null value The behaviour I want is this: If a user select Total in the first parameter, the second must be set to NULL, if the selection is Day, the second must be set with a data set. How I can set the value of the second parameter with null, I tryed Have anyone an idea Not sure exactly how you are passing in a dataset as a parameter but looks interesting. Instead of null perhaps you could use "SELECT null as DateID" instead Or maybe an empty string The syntax for getting dbnull is to use System.DBNull.Value ...Show All