Recent content by mydisney

I tried that and get same error, the "vbCrLf" gives me blank lines in the data file. Should I try to write a blank line with "vbCr" as content after I have filled all mydata?

I still get "Unexpected EOF encountered in data file" VB: Dim content As String = ticket_date & "\t" & job & "\t" & job_phase & "\t" & tons & vbCr IO.File.AppendAllText(absolutePath, content + Environment.NewLine) SP: CREATE PROCEDURE MyJobs @PathFileName varchar(100), @Return int =0...

Here is what I have: [code] Dim content As String = ticket_date & "\t" & job & "\t" & job_phase & "\t" & tons & "\n" IO.File.AppendAllText(absolutePath, content + Environment.NewLine) [code] My sp: [code] CREATE PROCEDURE MyJobs @PathFileName varchar(100), @Return int =0 output as If...

Do I need a row terminator as well?

I'm doing a bulk insert from a text file and get error: Bulk insert: Unexpected end-of-file (EOF) encountered in data file Here is my sp: CREATE PROCEDURE MyJobs @PathFileName varchar(100) as If Exists(Select * From Information_Schema.Tables Where Table_Type = 'Base Table' And Table_Name =...

I have a datagridview that does not allow to resize columns. I have tried to set properties but cannot get it to work. Can anyone tell me what is wrong? 'DataGridView1 ' Me.DataGridView1.AllowUserToAddRows = False Me.DataGridView1.AllowUserToDeleteRows = False...

I have a windows form that displays a data grid and a crystal report. How Can I add a 2nd (new) report to the form or will this have to be a sub report off the main report? I tried to add a totally new report but it gave me errors when I tried to rebuild the project. Any litterature out there...

I just have one report and the tab takes up too much room.

Does anyone have a quick solution for disabling the "Main Report" tab?

Found the solution: MyCrystalReportViewer.DisplayGroupTree = False MyCrystalReportViewer.ShowGroupTreeButton = True

I'm using crystal report in my vb application, binding it to a data set and displaying the report. When I display the report, the left part of the report is blank (navigation section??), it looks like the report is split in two parts. This part consumes too much space of the screen. How can I...

I have an application that reads from a data base table and fills a DataSet and consequently binds to a DataGrigView. Now I need to add a Crystal Report Viewer to the same form and display the query result. I have defined my data set in the code (no user controls from tool box). When I try to...

Thank you, it worked...

I'm trying to drop a table and get error. I've tried to use the 'If Exists..." but cannot get the syntax to work Error: Cannot drop the table 'JobTable', because it does not exist in the system catalog. CREATE PROCEDURE sp_CreateJobTable as DROP TABLE JobTable create table JobTable ( job_date...

George: If I create a real table how can I preserve integrity if several users are running the program at the same time? If I create an ASCI file how will I be able to extract each field element when I bulk load it into a temp table? It seems to me that creating an xml document is the...