Calling temp table from sqlserver in asp.net showing errors

[EDN Admin]

Im running crs.vb class for db connectivity in asp.net 4.0 . My problem is when im creating temp table in sqlserver it works fine.

If I m selecting their records , im getting errors like invalid object name #temp<br/>

Using this code
in asp form.
dim con as new crs.crs
having sql server procedure named "getdata"<br/>


select * into #temp from mytable
select * from #temp

in button click
con.select("exec getdata","mytbl")
It is working now when im trying to run below command
con.select("exec getdata","mytbl")
con.select("select * from #temp","mytbl1")
showing error "invalid object name"
<br/>
crs.vb
Imports System<br/>
Imports System.Collections.Generic<br/>
Imports System.Linq<br/>
Imports System.Text<br/>
Imports System.Collections<br/>
Imports System.Data<br/>
Imports System.Configuration<br/>
Imports System.Data.SqlClient<br/>
Imports System.Web.UI.WebControls<br/>
Imports System.Net.Mail<br/>
Imports System.Net.Mail.MailMessage<br/>
Imports System.Runtime.InteropServices<br/>
<br/>
<br/>
Namespace crs<br/>
Friend Interface bbank<br/>
Sub [Select](ByVal query As String, ByVal tablename As String)<br/>
Sub Insert(ByVal query As String)<br/>
Sub Delete(ByVal query As String)<br/>
Sub Update(ByVal query As String)<br/>
Function cnfrm_username_password(ByVal name As String, ByVal password As String) As String<br/>
<br/>
End Interface<br/>
<br/>
Friend MustInherit Class bank<br/>
Implements bbank<br/>
Public conn As New SqlConnection()<br/>
Public dadapt As New SqlDataAdapter()<br/>
Public dset As New DataSet()<br/>
Public sqltrn As SqlTransaction<br/>
<br/>
Public MustOverride Sub [Select](ByVal query As String, ByVal tablename As String) Implements bbank.Select<br/>
Public MustOverride Sub Insert(ByVal query As String) Implements bbank.Insert<br/>
Public MustOverride Sub Delete(ByVal query As String) Implements bbank.Delete<br/>
Public MustOverride Sub Update(ByVal query As String) Implements bbank.Update<br/>
Public MustOverride Function cnfrm_username_password(ByVal name As String, ByVal password As String) As String Implements bbank.cnfrm_username_password<br/>
Public Shared username As String<br/>
Public Shared password As String<br/>
End Class<br/>
<br/>
Friend Class crs<br/>
Inherits bank<br/>
<br/>
Public Sub New()<br/>
<br/>
conn.ConnectionString = "server=chetansqlexpress;uid=sa;pwd=NOKIA;database=fabiochk"<br/>
<br/>
conn.Open()<br/>
End Sub<br/>
<br/>
Public Overrides Sub [Select](ByVal query As String, ByVal tablename As String)<br/>
dadapt = New SqlDataAdapter(query, conn)<br/>
dadapt.Fill(dset, tablename)<br/>
<br/>
End Sub<br/>
<br/>
Public Overrides Sub Insert(ByVal query As String)<br/>
sqltrn = conn.BeginTransaction<br/>
Dim comd As New SqlCommand(query, conn)<br/>
comd.Transaction = sqltrn<br/>
comd.ExecuteNonQuery()<br/>
End Sub<br/>
<br/>
Public Overrides Sub Delete(ByVal query As String)<br/>
sqltrn = conn.BeginTransaction<br/>
Dim comd As New SqlCommand(query, conn)<br/>
comd.Transaction = sqltrn<br/>
comd.ExecuteNonQuery()<br/>
End Sub<br/>
<br/>
Public Overrides Sub Update(ByVal query As String)<br/>
sqltrn = conn.BeginTransaction<br/>
Dim comd As New SqlCommand(query, conn)<br/>
comd.Transaction = sqltrn<br/>
comd.ExecuteNonQuery()<br/>
End Sub<br/>
<br/>

Public Overrides Function cnfrm_username_password(ByVal name As String, ByVal password As String) As String<br/>
For Each row As DataRow In dset.Tables("Login").Rows<br/>
Dim n As String = row("User").ToString()<br/>
Dim p As String = row("Password").ToString()<br/>
If name = n AndAlso p = password Then<br/>
bank.username = n<br/>
bank.password = p<br/>
Return "match"<br/>
<br/>
End If<br/>
<br/>
Next row<br/>
Return "notmatch"<br/>
End Function<br/>
End Class<br/>
End Namespace<br/>



View the full article