thx for ur reply sir
\
and actually after submit my problem to dotnet groups
i solved my problem
initially i write the statement as
Label1.Text = strsql1
which causes error
but after when i write it as
Label1.text=sqlrs("node")
i did it, and there is no any error
and last thx for ur reply sir
On Wed, Jul 8, 2009 at 4:03 PM, Jay Dan <[email protected]> wrote:
> I think you are new in .net. You might me migrating from ASP 3.0.
>
> First of all there is no recordset concept in .net.
>
> SqlRs = sqlcmd.ExecuteReader()
>
> ExecuteReader will return a reader so declare a SqlDataReader
>
> Say
>
> SqlDataReader reader;
>
> Now
>
> Reader= sqlcmd.ExecuteReader();
>
> Check if the reader contains data
>
> If(reader.Read())
>
> Now read the number of columns returned in your case it should be 3.
>
> reader["EST_NAME"].ToString();
>
> reader["OFF_NAME"].ToString();
>
> reader["node"].ToString();
>
> multiple rows might be returned depending upon the query if the number of
> results returned is one do this to print on the label
>
> label1= reader["EST_NAME"].ToString()+”, ”+reader["OFF_NAME "].ToString()+”,
> ”+reader["node "].ToString()
>
> On Wed, Jul 8, 2009 at 11:30 AM, gagandeep sharma <[email protected]
> > wrote:
>
>> strsql1 =
>> " select EST_NAME + ',' + OFF_NAME + ',' + DIS_NAME as node from
>> grievancedetailscomplete where (EST_CODE='" & PEN_EST_CODE & "' AND
>> GRV_CODE=" & PEN_GRV_CODE & ")"
>>
>> dbcon =
>> New SqlConnection(ConfigurationManager.ConnectionStrings(
>> "PGConnectionString").ConnectionString)
>>
>> sqlcmd =
>> New SqlCommand(strsql1, dbcon)
>>
>> sqlcmd.CommandText = strsql1
>>
>> sqlcmd.CommandType = CommandType.Text
>>
>> dbcon.Open()
>>
>> SqlRs = sqlcmd.ExecuteReader()
>>
>> Label1.Text = strsql1
>>
>> sqlcmd.Dispose()
>>
>> dbcon.Close()
>>
>>
>>
>> --------------------
>>
>>
>>
>> in the above code i want to give the result of select statement to a
>> lable1, but i failed
>>
>> if anyone know that, then pls help me
>>
>>
>>
>> --
>> GO and LEAD from Whereever You are.
>> Think Big and Think Fast.
>>
>>
>>
>
>
> --
> Regards
> Jay Dan
>
--
GO and LEAD from Whereever You are.
Think Big and Think Fast.
