chris29's Q&A profile

• .NET Development Add new Record in VB 2005

  I used to program with VB 6 and had no problems with it. Now I started with VB 2005 and I'm a bit lost yet. I want to add a record to an ms access database. I've the following: I've a form on my project; I've a "ReportITDataSet" on it; On "ReportItDataSet" I've a Table named "Scrap" with fields "Tipo_Peca" and "Qtd"; When I click a button on my form I want to insert a new record on table "Scrap"; Can someone please help me with this. I've tryed so many ways that I found on the Internet but nothing is completed. Thanks, JohnnyP34 Thread moved to the appropriate forum there are many topics on the forums, try a search and you shoul ...Show All

• Visual Studio Tools for Office MDX query to filter the cube

  I have to populate a pivot table using VSTO. I am using source of the pivot table as an analysis cube. I am using pivotCache.CommandText = "<name of the cube>" ; pivotCache.CommandType = Microsoft.Office.Interop.Excel. XlCmdType .xlCmdCube; but my requirement is to show a filtered cube. I think an MDX query as commandText can do this. But I am not being able to write the correct MDX that can give a filtered cube which I can use to populate pivot table I have used MDX query as "select from <cube name> where <filter condition(s)>" . But it is showing that no column found that excel can use. Plese help me to prepare the MDX query. I think your ...Show All

• Windows Forms FixedToolWindow Locked

  It's my understand that the locked property should prevent the user from moving a child window. With this property the user is still able to adjust the location of the FixedToolWindow. Is there any property or event I should be setting to prevent this Some developers have suggested setting the window border style to none and then adding a label as the window title, but thought I would see if a better solution exists. Thanks in advance. The child form is also set dockable by the parent form. If i set the position I belive I would lose the dockstyle attribute. The below move function does'nt work like I expect either. Any other thoughts Private Sub Form1_Move( ByVal sender As Object , B ...Show All

• Visual C# How to access the Windows Register?

  Hello, what functions, controls or 'usings' do I need to talk to the Windows Register regards, Henk Hi, Here is a good sample to get you started: http://www.informit.com/articles/article.asp p=26957&rl=1 Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server SQLCMD VS BCP

  Hello, I have the following BCP bcp.exe "SELECT * FROM LAW.dbo.A" queryout "C:\Test\Test.txt" -c -q -C1252 -T -S "SEA2-LawrenceB1" -t "," ResultSet Seattle,Lawrence,1 New York,Jeanette,2 However, my issue is that BCP DOES NOT include Header in ResulSet. Ideal ResultSet (first row is Header) City,Name,Num Seattle,Lawrence,1 New York,Jeanette,2 I would like to use SQLCMD to include Header info. However I am not able to find the correct switches to accomplish this. The current format which I DO NOT desire includes - "..........." on the second time, "<rows> are effected" message is returend. Let me know if any of you could help me with this ideal format in ...Show All

• Visual Studio Tools for Office EXCEL : data import problem

  hello, while importing data from an excel file to an excel file there is some cells where the data is not picked up properly. Some of the columns only pick number data and not alphanumeric, while others do the exact reverse. Can someone please suggest what should be done to overcome this data import error so that the data imported is exact copy of the source data. thanks namrata Hi Namrata This will happen if you're using an ODBC or (more likely) an OLE DB connection to read the data, and the columns contain what is being interpreted as mixed data types. The Excel ODBC driver / OLE DB provider scans the first few rows of a column and assigns a numeric or alphanumeric data type, based on that content. It then suppresses ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I can't see the Graphics "pictures/ships/back" in MySpacewar Kit, why?

  I was installed XNA and tried to start off with the MySpaceWar starter kit, but when i stated to play the Evolved version, the ships were not displaying nor the background when you start playing. The boosts and the score displays fine. I didn't mess with the code what so ever. What's wrong The symptoms you are describing seem to be the same ones as in this thread. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=683797&SiteID=1 or this thread here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=697321&SiteID=1 From what they discussed it seems like your issue is being caused by your video cards inability to handle the shaders properly. Also, remember to search a forum first before p ...Show All

• .NET Development How do you skin the ReportViewer to allow control of styles?

  Hi there, Does anyone know the right syntax to put in a Skin file to allow controlling of style attributes for the ReportViewer control. I have successfully done this for other .NET server controls but not this one. This control has a different tag "<rsweb:ReportViewer" to other .NET controls e.g "<asp:GridView", and is reported as not valid by the compiler if added using the usual Skinning rules. I have found nothing on the Web or on Microsofts site, so far on how to go about this, which I would of thought was a pretty fundemental feature. Cheers Mike Jones The forums as http://forums.asp.net will be better equipped to answer this message. Thanks. ...Show All

• .NET Development Best Practices: Creating an Access Database at Runtime

  I'm trying to create an Access Database at runtime which will contain two tables: Users and Transactions. I've gotten so far as to use the ADOX.CatalogClass to create the empty database. Now, for creating the tables, I see two options: use SQL or a DataSet to create the tables. There may be other options, and I'm open to them, of course. I'd tried keeping a binary copy of a skeleton database file compiled into my application, but that just doesn't seem right... Can someone provide input on the best approach for this Using the DataSet is certainly more progromatic, but using SQL seems easier. Thanks! hi, i don't know how the dataset can create Access database, yes you can use ADox to create the database you can also use (ADO or ...Show All

• SQL Server Can not deploy calculation...

  Hi, I had a calculated measure which simply tries to create a Margin Profit. This is the simply Measure divided by another measure. The problem is that when I try to deploy this measure with a Parent Hierarchy of measures it will not deploy I get the error like this: Errors and Warnings from Response MdxScript(SSAS) (7, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified. Rgds., I've seen the error you specified occur when the cube collation sequence has "case sensitivity" set, and the name of the measures dimension in the MDX expression didn't match the case of measures as specified in the cube. As an example: measures.[A Measure Name] = resulted in ...Show All

• Visual C++ mangled name

  Is there any API to retrieve the address of a method (private/public) using the mangled name. the method is supposed to be a class member. we can know the mangled name from the .map file in VC++ 6.0 Please also suggest a method of using this in GCC. You can use the undname command line utility to un-mangle the name, if that helps. It's not clear to me whether you want to get the symbol address from another DLL, another static library or within your main project. ...Show All

• Visual Studio Problem installing .NET Framework 2.0 Beta 2

  Hello: I hope that I'm posting to the correct area... I'm trying to install Visual C++ 2005 Express Beta 2 and the installation process fails.  The failure occurs after the download is complete and the installation of the .NET framework has commenced.  No error information is displayed, other than the notificaton that the error has occurred.  I've turned off Spybot, for what that's worth.  Any ideas on how to proceed Thanks! Hi Ayman: Thanks for the reply.  No, there is no existing .NET framework.  I saw that possible explanation listed on the Visual Studio web site FAQs.  I've gone over all the FAQs and troubleshooting information on the Visual Studio site ...Show All

• Visual Basic Code Snippets - Surround With

  Using VS2005 Professional. Have an issue with inserting "surround with" type code snippets. I can right click and insert a regular code snippet without any problem. However, if I select several lines of code in the code editor then right click I don't get the "Surround With" snippet option. Have tried using keyboard shortcut CTRL+K CTRL+S but VS2005 beeps and in the status bar says "surround with command not available". Can anyone help     wemba -  Are you working in a C# code file   The surround with code snippets are only available for C# so you'll get the behavior you're describing if you try this in a VB file. HTH, Karen ...Show All

• Visual Basic need help on 'restore down' button in Winforms.

  What mechanism do I have to provide or what event do I have to handle for the "Restore Down" button to work on the Windows form Minimize works as expected. When I click on that button, the form minimizes to the app's icon in the taskbar. Clicking on that icon restores the form to the full size. When I click on "Restore Down" the window closes as it does in Minimize but now I have to perform a right button click on the icon in the tray at bottom and select 'Maximize" to bring it back to full size. I want to be able to "Restore Down" to a size that does not fill the whole screen and be able to move the app over to my other monitor in a dual monitor environment. Thank you, -Greg ...Show All

• Visual Studio 2008 (Pre-release) Help with type when doing "select new"

  public List< >MyMethod() { var query = from tr in kontekst.TellimuseRida join t in kontekst.Tellimus on tr.Tellimus equals t join k in kontekst.Klient on t.Klient equals k select new {t.KlientID, k.Eesnimi, k.Perenimi, tr.Kogus}; return paring.ToList(); } What would be the return type of this method Is it possible to write such method Is there any reason type inference with anon. types couldn't be offered at a method level, at least with non-public methods i.e. private var MyMethod() ... On an unrelated note, I'm not sure a join's needed for this type of query... i.e. you can re-write this: var qu ...Show All