Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: IT4EVR
  • Order by date
  1. IT4EVR

    more connection questions for Access on a server-

    However, since this is a web app, you'd probably want to store it in the App_Data folder of your virtual directory. Then you can use syntax similar to the example Isadore showed. I'm not understanding why people are trashing Access. I've used it for applications up to 50 concurrent users...
  2. IT4EVR

    more connection questions for Access on a server-

    If you want to connect to an Access database on a server, it's simple. You just use the \\servername\foldername notation. So if the server name is called companyserver and the database is located on the database folder... \\companyserver\databases\Personnel\Substitute\substituteFE.mdb And...
  3. IT4EVR

    WinForms multithreading

    There is also a BackgroundWorker control you can place on a form that allows you to run a process in the background on a different thread from the user interface. The DoWork method is where you would run your code for the background thread. This is new for Visual Studio 2005.
  4. IT4EVR

    Crystal Report Problem after Deployment (w/ .msm's)

    I base my reports off of datasets if I have to use an Access database. I put the actual database in an App_Data folder within the application. Then the report is based on the dataset. The report is then not coupled to an explicit file location.
  5. IT4EVR

    Is there a way to execute multiple pl/sql statement in c#

    The BindArray feature of ODP.NET will allow you to run a batch of commands as if they were one statement to the database.
  6. IT4EVR

    Insert into Access db and optional fields

    And some argue you shouldn't allow nulls into your tables. That you should always specify a default value. The idea is that checking for nulls complicates your queries and stored procedures and also makes tables less efficient.
  7. IT4EVR

    Insert into Access db and optional fields

    Good point and if you really want to get into semantics, there is no such thing as a "null value". Null represents a case where there is no value or the value is unknown. I think I was thinking in terms of Oracle, where an empty string resolves to null.
  8. IT4EVR

    Insert into Access db and optional fields

    Actually I think you can do this: If objCmd.Parameters("@red") Is Null objCmd.Parameters.AddWithValue("@red",String.Empty) Else objCmd.Parameters.AddWithValue("@red", txtRed.Text) End If Why are you passing in the bold into the parameter?
  9. IT4EVR

    Master Detail

    In Visual Studio 2005 there is a project type of Excel Workbook. I have no idea whether this would help you or not. But it might be worth investigating.
  10. IT4EVR

    Resizing a form to fit resolution

    Actually I think I figured it out for myself. This worked for me. The mistake I made was to configure the settings within the child form. You need to configure the maximized when loading the child form from the parent. reportForm = new frmAllScannedData(); reportForm.MdiParent...
  11. IT4EVR

    Resizing a form to fit resolution

    How does that work with MDI applications though? I have a child form that I set to Maximize and it doesn't resize to fit the screen.
  12. IT4EVR

    threading

    You can create a multi-threaded application by using the System.Threading.Timer. You can specify the timer interval and a callback method that actually runs the code. This would allow you to run 10,15, whatever processes in parallel I believe rather than in succession.If you enclose this in a...
  13. IT4EVR

    Crosstab can grow

    Ok, I was able to stage the data on the server so that it displays in crosstab-like fashion BEFORE I send it to Crystal Reports. Now this should be an easy one but I want to apply borders around cells whether they are null/empty string or not or whether they have data or not. Right now it only...
  14. IT4EVR

    Crosstab can grow

    That being the case, I'm probably going to have to setup the data in a crosstab type format BEFORE I load it into Crystal/
  15. IT4EVR

    Crosstab can grow

    Thanks for getting back to me. That may or may not work for me. Can you programmatically increase the row height ? Also, I have a column field where I have specified the order that the columns will display in the crosstab. Is there a way to specify certain width of individual columns?
  16. IT4EVR

    Crosstab can grow

    In one of the columns I have text that could span 1 or more lines. I don't want to have all rows default to 5 lines of text to account for the possibility that some rows will have that much text. I just want it to grow if there is more than one line.
  17. IT4EVR

    Crosstab can grow

    For some reason the Can Grow property is disabled on all the column and row fields in my crosstab report. Is there a way to make a particular field expand if necessary. Also, is there a way to format a particular column field? Because in the designer there is only one placeholder for the...
  18. IT4EVR

    Interview

    Franky anyone who continues in the IT industry must remain a lifetime student. So it's like college revisited. For me, I have to read 5-10 books a year, if not more, as well as technical white papers, tutorials, etc to "keep up". That's akin to being a permanent part-time student. I wish...
  19. IT4EVR

    Timer Event

    I don't believe there is a Timer control from the Toolbox for a web app, however, you can use the System.Threading.Timer object you can use in code.
  20. IT4EVR

    These job qualies crack me up

    It gets worse for developers/programmers. Here is a list of must-haves for a position. Of course 2+ years experience in all. C# 2.0 XML SQL Server 2005(DBA-level) Javascript OOP HTML UI Design UML Graphics Design CSS ADO.NET ASP.NET Infopath Sharepoint Computer Science Degree or equivalent

Part and Inventory Search

Back
Top