|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DEALING WITH NULL QUERY RESULTSInvalid attempt to read when no data is present. email = Request.Form.Item("demail") sifre = Request.Form.Item("dsifre") Dim durum As Object rs = New SqlClient.SqlCommand("ST_CHECKUSER @email='" & email & "' , @sifre='" & sifre & "'", baglantim) xx = rs.ExecuteReader durum = xx(0) If IsDBNull(durum) Then Label1.Text = "YOK" Else Label1.Text = "VAR" End If How to handle NULL query resultset in my codebehind after executing my SP which can return null resultset.. Your error is caused by not calling the Read method of the DataReader.
xx = rs.ExecuteReader If xx.HasRows Then xx.Read diri, = xx(0) .... End If
Make font Bold
Iterate through page controls How to put a Word/Excel file into a database Impersonation help with SQL 2000 needed Register DLL for COM interop Performance testing tools for VB.NET application Job title: $300 flat for job in perl, cgi, Visual Basic/Asp.Net, whatever online project A couple of easy datagrid questions wav files in programs show form into splitcontainer.panel |
|||||||||||||||||||||||