Fidel delgado Mojica's Q&A profile

• Windows Forms export data

  How can I export data from a Datagrid to an Excel file I know how to do in ASP.NET, but I want to do the same operation in a WindowsForm application. Thanks in advance Sure, you can get them <a href="http://www.microsoft.com/downloads/details.aspx FamilyID=c41bd61e-3060-4f71-a6b4-01feba508e52&DisplayLang=en">here</a>. ...Show All

• .NET Development Please help me ...

  Hi all ...  I am writing some kind of Dental Office Manager program both for fun & money there would be two versions, one using MDB databases for standalone use and another with MsSQL 2000 server for a centralized perspective ..!  but i've just ran into a problem, I am using Microsoft VS.NET 2005 Professional and VB.NET 8, but when I want to ExecuteNonQuery using the OleDbCommand I don't get any error and no exception is thrown but when i check the database, It is not updated at all, I'm sure that i've forgot something but I couldn't figure out what was it ...  So here comes the code ... ...Show All

• .NET Development XML Schema - Trimming

  I'm using an XML schema in SQL Server 2005 that has 'include' directives in it, and because SQL 2005 doesn't support 'include' directives, i've had to merge all the schemas into one to overcome this. The schema itself works fine, but my problem stems from the fact that the schema itself ends up about 2MB (50,000+lines) and includes far too many elements/types that I don't need, but were in the included schemas. Stripping them out by hand takes hours, and I have about 15 to do. My question is, can anyone give me some hints, how, in code, I can specify an element name, and then extract from a schema that element, it's child elements and ...Show All

• Windows Forms Ticker Control

  Hi, I am developing a Ticker Control.  It is not a smooth ticker but rather a vertical scrolling ticker. Let's assume the control fills the form and the form is as follows (assume that '.' = space): --------------------------------------------------------- | 10:00  Item 1 .. Item 2 .. Item 3 .. Item 4 .......| | 10:01  Item 5 .. Item 6 .. Item 7 ..&nbs ...Show All

• Visual Studio Team System More attribute parameter stuff

  Mike recently suggested some code for looking to find attribute parameters (especially the WebMethod EnableSession parameter). He suggested the following code snippet, inside an attributes and expressions iteration: if(currentMethod.Attributes .Expressions[j].Type.Name.Name == "EnableSession") {     // Do something } However, the Expressions .Type.Name.Name is just set to boolean in each case... Any further hints Cheers, James. That's exactly what we do - I wasn't aware of how the compiler / runtime handled attribute parameter being passed as constructor overrides. I was just looking into ...Show All

• Visual Studio Express Editions Need help on setting up a query page using MenuItem, GridView, AcessDataSource components

  Hi, I'm a college student with an homework assignment to do. I'm developing an website where there is a menu with several items. Each item is configured with an unique ID "idsubcat": < asp : MenuItem NavigateUrl ="Consulta.aspx idsubcat=1" Text ="Espumantes" Value ="Vinhos"></ asp : MenuItem >   The AcessDataSource object should receive that info and display the desired data on a GridView object:  < asp : AccessDataSource ID ="AccessDataSource1" runat ="server" DataFile ="~/inspektordb.mdb" SelectCommand ="SELECT [foto], [marca], [ds_produto], [preco] FROM [produt ...Show All

• Visual Basic Problem with SQL Connection

  Hi, I installed the AdventureWorks database, and can connect with SQL Express Manager or Visual Studio 2005 data tools to this database. The problem is that while writing the follwoing code: Dim connectStringBuilder As New SqlConnectionStringBuilder()connectStringBuilder.DataSource = ".\SQLEXPRESS" connectStringBuilder.InitialCatalog = "AdventureWorks" connectStringBuilder.IntegratedSecurity = True connectStringBuilder.UserInstance = True Dim ds As New DataSet() ' Open connection to the AdventureWorks database Using connection As New SqlConnection(connectStringBuilder.ConnectionString) connection.Open() it fails ...Show All

• SQL Server Parameters will not Default

  Greetings I am using SQL 2005 Reporting Services and I have a problem with parameters. If I leave 3 of the 4 values as non queried in the Available values section and mark them as a Default Values: of NULL, then the report works fine. However if I set the Available values to a query I have written and leave the Default values as NULL, when I view the report in either preview mode or on the reports server, it wants me to specify a value from the boxes and the tick box for NULL has disappeared. Allow NULL value is ticked inthe first section, Properties. Anybody got any suggestions If you have available values, then the allowable v ...Show All

• Windows Forms GUID and Datagridview

  I have a primary key column in my database that is set as a GUID column. Is there any way when adding new rows to a datagridview, or the dataset for that matter, that the GUID is automatically filled in, with out having to specify to create a GUID and set the rows ID to it I'm also interested in this exact scenario. Will post more if/when I come across anything of interest. ...Show All

• SQL Server Push Merge snapshot fails with Data is Null message.

  Hi, I'm converting a replication script from SQL 2000 to SQL 2005. I am getting an error with push merge with no way to figure out what is wrong. I've configured replication on a single XP server in SQL 2005 RTM version. I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility. The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok. The snapshot for B to C fails with this message: Message 2006-03-09 17:30:35.94 --------------------------------------------- 2006-03-09 17:30:35.94 -BcpBatchSize 100000 2006-03-09 17:30:35.94 -HistoryVerboseLevel ...Show All

• Visual Basic Just for Fun

  I would like to do a visual effect when i'm saving a database. I use a progress bar at the moment which is boring! I rather like the effect when you save in WORD where you get a box outline that shrinks down to nothing. How would i do that Or maybe you will Have some better ideas Mike I've always thought 'keep it simple' works best. Providing feedback during the save (ie, a save progress bar) is a good thing.  If do it on a backgroundworker thread, even better. Adding anymore effects, is only going slow the application down.  I'm sure there's lots of pretty visual effects you can add, and even find pre-made online.  Ju ...Show All

• SQL Server SQL Express and Bulk Insert

  Does SQL Express support bulk insert   If not is there any suggestions of alternative way to get data from a text file to SQL Express in a manner that can be automated   Thanks Tom ...Show All

• Visual Studio 2005 debugger is very slow

  I hate to admit it, but I am starting to build my app and then run the program from the command line or to run the "start without debugging" command to "visually" test code changes instead of stepping thru the code. Now I find that other programmers I work with are doing the same. The reason is that the 2005 debugger takes a lot longer to start up our program than the 2003 debugger. It appears to me that the problem is that the new debugger is very slow when it comes to loading the pdb files. Debugging the 32 or 64 bit version of the program is slow so its not just the remote debugger that slows things down. We d ...Show All

• SQL Server Comparison on SQL Server 2000 and SQL Server 2005

  Hi all, I would like to ask if any research conducted on comparisons of SQL Server 2000 and SQL Server 2005 If yes, where can I find them Thanks a lot! Gabriel That's a pretty open-ended question! This web page lists a bunch of info on SQL Server 2005. http://www.microsoft.com/sql/prodinfo/news.mspx If you still have specific questions after reading everything there please ask again but remember that this particular forum is focused on Setup and Upgrade so there may be better places to ask, depending on the questions. Paul ...Show All

• SQL Server Transactional Replicating hanging SQL Server 2005

  Hi, It appears that every 5 or so days, my transactional replication is hanging.  I see that I have a couple thousand undistributed commands and this number keeps growing.  It forces me to generate a snapshot in order to sync up.  When generating the snapshot, I will get frequent messages like "waiting for a response from server...".  So I will keep stopping and starting syncronization.  Eventually the snapshot will go out, with a delay after generation.  Has anyone experienced this   Your help is much appreciated. Thanks, Nick What do you mean "hang"   ...Show All