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...
...PrivateSub Form10_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load
Dim Table_Name AsString
SQLSTRING = "SELECT * FROM Requisition WHERE delete_status='No' AND badge_no='R000001'"
DAdapter1 = New SqlDataAdapter(SQLSTRING, SQLConnection1)
Table_Name =...
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"...
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...
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%'"
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.