tashee2007

@ cgeier - I really liked your efford used to share your skill. Well i am in process of learning VB.NET & SQL 2008 application development. I came across this discussion and found out that the features which i need for my application is here. I have tried to follow …

@ by : O This is topic (http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi) is reactivated again which was posted by : Oxiegen for further information: The code is corrected but the data is not getting exported from Access database to SQL. The code is as follows : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e …

Hi, I have a problem with changing the password from Microsoft Access Database. I get an Error "[B]No data exists for the row/column[/B]". The password in the database is encrypted and when I change the password it should be decrypting the password and new password should be updated with encryption …

Hello Every One, When i run my project i get Error "There is no row at position 0", please help. Here is my code: Private Sub PopulateDepartmentHead() 'Fill data in comboBox Dim SqlDataAdapter As OleDbDataAdapter Dim DSet As New DataSet Dim strSelect As String SQLConn.Close() SQLConn.ConnectionString = oFunc.GetConnectionString(sINIFile) 'myConn = …

Hello, I would like to seek help from all experts in VB.NET (VB Language) regarding copying file from source folder to destination folder. I have a files named YYYYMMDDHHMMSS.txt. Now i want to build a small project to copy those file to destination folder. The project should work in following …

Dear Expertise, I am problem with coding to search the data from database using stored procedure and vb.net form. I am coding with vb language not the C#. Explanation: I have stored procedure named "usp_GetPayByGrade" : /* Name: usp_GetPayByGrade Description: Search the Record to dbo.hrGradePayScale table by gpsIntGrade Author: Tashi …

Dear All, I have few question regarding using Treeview in my project. The screen of my project is been attched. I can populate the data from database in treeview using following code: ~~~ vb Imports System.Data.SqlClient Public Class Tree Private Sub Tree_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles …

[code] Private Sub DataBinding() Try Dim bsTableName2 As String bsTableName2 = "dbo.hrBranchSetup" 'cboOrganization.DataBindings.Clear() 'cboOrganization.DataBindings.Add(New Binding("Text", ds.Tables(bsTableName2), "OsID")) brCode.DataBindings.Clear() brCode.DataBindings.Add(New Binding("Text", ds.Tables(bsTableName2), "BranchCode")) brName.DataBindings.Clear() cboOrganization.DataBindings.Add(New Binding("SelectedValue", ds.Tables(bsTableName2), "OsID")) cboOrganization.DataBindings.Clear() brName.DataBindings.Add(New Binding("Text", ds.Tables(bsTableName2), "BranchName")) bsOnlineYNCheckBox.DataBindings.Clear() bsOnlineYNCheckBox.DataBindings.Add(New Binding("Checked", ds.Tables(bsTableName2), "OnLineBrYN")) Catch ex As Exception MessageBox.Show("Error No : " & Err.Number & vbCrLf _ …

Hi everyone, I have a form with one combo box and text box and buttons. please refer the snapshot with i have attached. I have the following code: My Stored Procedure for inserting the data: [code] /* Name: usp_InsertBranchSetup Description: Insert the Record to dbo.hrBranchSetup table Author: Tashi Modification: Insert …

Hi ALL, Can anyone tell me how to validate the text box value? I have one class with function for validating the duplicate value of sql table. Function: [code] Imports System.Data Imports System.Data.OleDb Imports System.Windows.Forms Public Class vDesignationSetup Dim oFunc As New hrSQLConn.SQLConnection Dim strINIPath As String = Application.StartupPath + …

Hi All, I have one vb form with two textbox,one checkbox, and two buttons. I am using SQL Database as back end for this form. Controls of my form goes like that: 1. txtGenderID 2. txtGenderName 3. chkIsDefault 4. btnSave 5. btnCancel SQL Table as follows: Table Name: tblGender GsGenderCode …