Is there any alternative i want the For...loop continues until end of the record? But once the system delete a particular rows, it will return an error message. May i know how to solve it? Thank you.
How to delete a particular DataRow when it meets a condition? The following code will check through the Row but i don't know how to specify the current row, which is needed to be deleted.
Dim DRow As DataRow
For Each DRow In Employee.Rows
If (DRow("emp_no") = "1") Then
'Delete the row...
After the user logins with his account, privilege will be granted according to the user's role. And from there, it will limit their right on viewing reports and performing database transactions. May i know how to implement this idea into system development? Thank you.
I have Visual Studio 2005 installed in my computer but i realized that the crystal report is not there. May i know where can i download the crystal report tool that supports Visual Studio 2005? Thank you.
I have made used of the dataset to generate report. Now i want to generate a department report, the content of the report includes department name, location as well as the monthly revenue of each and every department. The sum of revenue can be generated by summing a few different type of...
Now i use the following way of generating the report, there is a relationship between employee and requisition tables.
May i know how to form the table structure in the report and display the data? Apart from that, may i know how to generate a group of data belong to another data? For...
I used the following to clear the default selection on row but when i executed the application, the first row of the DataGridView was still selected. I want nothing to be selected when the form is loaded. May i know how to do it? Thank you.
If DataGridView1.Rows.Count > 0 Then...
I tried the following to change the fontstyle of a particular column but it didn't work. Thank you.
Column.DefaultCellStyle.Font.Style = FontStyle.Bold
I tried to generate the report with dataset. I have already established the connection between crystal report and database and drag relevant fields of some tables. When i come to join on tables, why some of the fields of the table are missing and actually they are the fields needed for join...
DataGridView1.Columns(0).DefaultCellStyle.ForeColor = Color.Indigo doesn't change the font color, i think the reason is because it is a LinkColumn, i have tried the same for TextBoxColumn and it worked well. May i know how to set the color for LinkColumn? Thank you.
The following code is done by referring to the MSDN sample code, the code from the MSDN is about how to add the DateTimePicker into DataGridView and i tried to modify the code so that the row only displays time in hh:mm:tt. I added the update statement to update the time in database and when i...
What is the command for selecting a record with not null value on particuler field? I have tried to achieve the following
OleDbCommand1.CommandText = "SELECT DATALENGTH(portrait), portrait FROM Emp_Profile WHERE delete_status='No' AND emp_no='" & emp_no_search_string & "' AND NOT NULL(portrait)"
Now i am able to display the data from the dataset. First, i select which table i am going to make use under database expert and then you can drag any data field of that table you want to display from Field Explorer. Apart from that, i coded the SQL query which retrieves the appropriate data and...
I have already set the datasource for the crystal report but i dont know how to extract the emp_no from the database and display it using the crystal report text object called Employee_No. Thank you.
CrystalReportViewer1.ActiveViewIndex = 0
CrystalReportViewer1.BorderStyle =...
The crystal report part that i have completed in company cannot be executed at home, i think the problem is because of the reference of crystal report not found. So i checked the References under My Project, the path information are displayed as "The system cannot find the references specified"...
I understand but how to create a crystal report and save in a specified location. I want to do something like this, when the user select a row of the datagridview and press print, it will generate report and allow user to print the report of that selected employee. Now what i have done is only...
Is that what you meant i can't generate the primary key for them? However this is part of user requirements, for example they need the emp no. to be E00001 and so on. So the system will just count the record stored in the database in order to generate an unique primary key. When the user delete...
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.