Comments by Priyavadhanam

Priyavadhanam 5-Mar-13 12:49pm View

Anurag,
Thanks for your suggestions. I tried up writing a complex for loop processing the AND, OR Key words using SubString, IndexOf methods. but this again failed when I have a "Where" clause inside the Sub Query with a multiple AND, OR key words.

So, should try for some other approach...
Anyways, thanks for your comment..

Priyavadhanam 2-Feb-12 11:49am View

Hi, Th statement "Details_grd = New GridView" was the real culprit in my code.
On removing the statement the above code worked fine.
Thanks for the solution :)

Priyavadhanam 2-Feb-12 11:46am View

Yeah, u r correct Kreagan..
the new object creation for the Grid view was causing this problem, on removing that statement i got what i was expecting.. thanks for your comments.

Priyavadhanam 31-Jan-12 12:24pm View

No Arun, it didn't turn fruitful.
Guess something is missing somewhere..

Priyavadhanam 31-Jan-12 11:54am View

Kreagan,

Yeah, the gridview named as 'Details_grd' is displayed in a web page.
I have placed the gridview in the aspx file which needs to be populated with the proc result set. I have placed this code under button click event in aspx.vb file.

There shouldn't be an issue with this design flow, am I?

Priyavadhanam 26-Jan-12 12:53pm View

Hi,
I encounter the similar problem,To explain in detail, I have placed a grid view in the aspx page with 3 bound columns and the datasource for the gridview is the result set of a stored procedure.

Below is the sample code,

Dim cmd As New OracleCommand()
Dim DA As New OracleDataAdapter(cmd)
Dim DS As New DataTable
Details_grd = New GridView
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "SP_Name"
cmd.Parameters.Add(New OracleParameter("Services", OracleType.VarChar)).Value = RadioButtonList1.SelectedItem.Value
cmd.Parameters.Add(New OracleParameter("result", OracleType.Cursor)).Direction = ParameterDirection.Output
DA.Fill(DS)
Details_grd.DataSource = DS
Details_grd.DataBind()
con.Close()

the stored proc returns the dataset which i verified while debugging.

guess, somewhere i missed up something. may be overlooking for something very basic, will appreciate ur help.

Thanks..

Comments by Priyavadhanam (Top 6 by date)