well, in variable strsql1 you have sql query string for the sql server, not the result :)
2009/7/8 gagandeep sharma <[email protected]> > 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. > > >
