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...
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...
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.
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.
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.
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.
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?
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.
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...
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...
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...
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?
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.
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.