Search results for query: *

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...

May i know how to retrieve combobox item with index? 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)"

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"...

How to right click on any row of databagridview and call a menu which consists of delete and update? Thank you.

May i know how to store image for example .jpeg in database? I have already set a column datatype to image in my SQL Server but now i have no idea how to use dialogbox to select a image file and import it and store into database. Besides that, how to retrieve the image and display in imagebox or...

Anyone can help me to check the following underlined code? The VB.NET 2005 can't recognize the underlined object. I will really appreciate if you can provide me some good Crystal Report web tutorials or information. Thank you. Dim CrystalReportViewer1 As...

I am currently developing a multi user VB.NET 2005 application and this is my first time to involve in multi user application. Anyway, i know that multi-user application is not as easy as standalone application. I need to take care of the database stability for each and every user. My concern is...

How to change a font size, font color of single column as well as the alignment of the column title? Thank you

How to change the x,y location of the label? Thank you

How to check the a double value whether it is positive or negative? Thank you.

May i know how to clear the default selection on first row? I don't want anything to be selected when i execute the application, thank you.

Sorry for asking a beginner question, may i know what is the difference between the following two codes since both of them can show the form properly? Thank you. Dim DisplayForm AsNew Form1 DisplayForm.Show() Form1.Show()

Currently, i have start time and end time stored in database, the start time and end time format are h:mm:tt, is there any way for me to find the difference between the start time and end time? Thank you.

I tried to pass the textbox.text to a SQL string for query but it doesn't work, the code is the following. Thank you. SQLSTRING1 = "SELECT emp_no, emp_name, nric_no, dept FROM Emp_Profile WHERE emp_name LIKE '%ToolStripTextBox1.Text%'"

How to trigger an action when i change from TabControlIndex to another? Thank you.