Your stored procedure is wrong!
It should be shorten to:
ALTER proc [dbo].[P_GetComBankDetailsBYId]
@combankid int
AS
SET NOCOUNT ON;
SELECT combankname,comaccnumber,combranchname,combankadd,combankIFSC
FROM tbl_com_bankdetails
WHERE combankid=@combankid
END
Then, you need to get data from database:
Dim sqlConnection1 As New SqlConnection("Your Connection String")
Dim cmd As New SqlCommand
Dim reader As SqlDataReader
DIm dt As New DataTable()
cmd.CommandText = "StoredProcedureName"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = sqlConnection1
sqlConnection1.Open()
reader = cmd.ExecuteReader()
dt.Load(reader)
If dt.Rows.Count()>=1 Then
txtcombankname.Text = dt.Rows(0).Item("combankname")
End If
sqlConnection1.Close()
For further details, please see:
How to: Execute a Stored Procedure that Returns Rows[
^]