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.
