yeah it helps me and it works fine thx sir
On Thu, Jul 9, 2009 at 4:30 PM, Jay Dan <[email protected]> wrote: > How would you like to call? You can use Response.Redirect("2ndpage.aspx"); > from 1st page. > > > On Thu, Jul 9, 2009 at 3:56 PM, gagandeep sharma > <[email protected]>wrote: > >> once again thx for ur reply sir >> >> sir there is one more problem, pls hepl me if u know >> >> myproblem is how to call second aspx page from first aspx page >> >> On Thu, Jul 9, 2009 at 1:30 PM, Jay Dan <[email protected]> wrote: >> >>> Yes, you are certainly right he might have declared at the beginning of >>> the code snippet which he hasn’t pasted. All I tried just to show him the >>> path I expect he should be able to carry on with the solution and implement >>> the other checking’s which are absolutely required like checking for Null. >>> >>> On Wed, Jul 8, 2009 at 11:47 PM, Cerebrus <[email protected]> wrote: >>> >>>> >>>> I think you are mistaken in your assumption(s). I believe that the OP >>>> has already declared the "SqlRS" variable as an SqlDataReader (but did >>>> not insert that in the presented code). It wouldn't even compile >>>> otherwise. >>>> >>>> The solution you present will work, however, it will throw an >>>> exception in case any of the column values contains Null. I do not >>>> normally recommend calling ToString() on ANY unchecked variable. >>>> >>>> On Jul 8, 3:33 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- Hide quoted text - >>>> > >>>> > - Show quoted text - >>> >>> >>> >>> >>> -- >>> Regards >>> Jay Dan >>> >> >> >> >> -- >> 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.
