Member Avatar for tashee2007

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
 Modification: Update

 Description Date Changed By
 Created Procedure 27/10/2011 Tashi
 */
 CREATE proc [dbo].[usp_GetPayByGrade]
 (
 @gpsIntGrade varchar(50)
 )
 WITH ENCRYPTION
 AS
 SELECT 
gpsGrade,
 gpsIntGrade,
 gpsMinPay,
 gpsIncrement,
 gpsMaxPay,
 gpsGISGroup,
 gpsGISCont,
 gpsSWSCont,
 gpsSWSPercentageYN,
 gpsRetirementAge
 FROM [dbo].[hrGradePayScale]
 WHERE gpsIntGrade =@gpsIntGrade

when i run this store procedure in SQL its giving me correct result.

I have a form named "frmGetPayByGrade" with:

  1. Textboxes:
    gpsGrade
    gpsIntGrade = in this textbox user will enter the value
    gpsMinPay
    gpsIncrement
    gpsMaxPay
    gpsGISGroup
    gpsGISCont
    gpsSWSCont

  2. buttons:
    btnSearch
    btnClose

    When user enters the value at "gpsIntGrade" textbox and hits the "btnsearch" it should run the stored procedure and fill the stored procedure result in respective textbox.

    I have been trying to search but could not get the proper solution.

    CAN ANYONE HELP ME???????

Edited by Dani because: Fixed formatting
  • 3 Contributors
  • 2 Replies
  • 740 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by kRod
Member Avatar for G_Waddell
  1. Open Google
  2. Type "SqlCommand Class Vb.Net"
  3. Click Google Search

This is basic VB.Net in particular ADO.Net

Member Avatar for kRod

As G Waddell said you should look around. On this very website Click Here

This is also a good place to begin Click Here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.