No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
13 Posted Topics
 | wanna ask. where should i placed the validation. i mean the code to check whether the record is exist or not Public Sub doSave() Dim con As New OleDb.OleDbConnection(My.Settings.KK3DB) Dim com As New OleDb.OleDbCommand Dim adap As New OleDb.OleDbDataAdapter Dim ds As New DataSet con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\backup project\KK3MailingSystem\KK3MailingSystem\KK3MailingSystem\db\KK3MailingSystem.mdb;Persist … |
| | can anyone help me to show steps in creating crystal report? |
 | |
| | can you help me how to save new data in datagridview. let say, i'll fill data in other form then it'll save and display into datagridview. |
| | how to get the current row after save and editing row. what code should be addded after this code below con.Open() a = strn.ExecuteNonQuery MsgBox("Updated") adap = New OleDbDataAdapter("select * from Parcel", con) adap.Fill(ds, "1") ParcelDataGridView.DataSource = ds.Tables("1") |
| | Dim MaxVal As Integer For a = 0 To DataGridView1.RowCount - 1 If MaxVal < DataGridView1.Item(DataGridView1.ColumnCount - 1, a).Value Then MaxVal = CInt(DataGridView1.Item(DataGridView1.ColumnCount - 1, a).Value) End If Next MsgBox("The Optimum Value is " & MaxVal, 1, "Optimum Choice") |
| | anyone can help? i want to check whether the data has been exist or not. but its shows some error in this code. error :No value given for one or more required parameters. Public Sub doSave() Dim con As New OleDb.OleDbConnection(My.Settings.KK3DB) Dim cmd As New OleDb.OleDbCommand Dim adap As New … |
| | anyone can help me? my login doesnt work smoothly. i want to login based on Username, Password & Category. So that, if the user is Admin all data can be access, while if user is Staff, only few data can be access. Public Sub DoLogin() Dim strsql As String Dim … |
| | Hye, i got problem while saved the record. here is my code. Imports System.Data.OleDb Imports System.Data Imports System.Configuration Public Class Form2 Shared STAFF As Form2 Function GetInstance() If STAFF Is Nothing Then STAFF = New Form2 ElseIf STAFF.IsDisposed Then STAFF = New Form2 End If Return STAFF End Function Private …  |
| | i have problem with query the database. i want to add data into two table that share same Primary key. here my code error message :The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the …  |
| | need help! Public Sub emailNotification(ByVal strTo As String, ByVal strFrom As String) Try If strTo Is Nothing Then MessageBox.Show("Please Check Email") Else Dim [to] As New MailAddress(strTo) Dim [from] As New MailAddress(strFrom) Dim message As New MailMessage([from], [to]) message.Subject = "Parcel Info No: (" + txtTracking.Text + ")" message.Body = …  |
| | Re: Need Help hye! since i'm a new members, can anyone help me. what query should i used to join the table example LOGIN table with REGISTRATION table. then where should i store the query? im using vb 2010 + microsoft access 2003 here's the details about my data table. ** LOGIN : …  |
| |
The End.