Problem with ref cursor - ASP.NET Discussion Boards

I found few in my first glance search in code project:

ASP.NET MVC Quick Start Tutorial - Create a Small ASP.NET MVC application step by step[^]
http://www.codeproject.com/KB/aspnet/webformmvcharmony.aspx?artkw=Asp.net MVC
BDD using SpecFlow on ASP.NET MVC Application[^]

You could google it. You will find a lot more. Smile | :)

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

You can start from here[^].

It contains lots of videos and guidelines.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

I have a button outside the grid....datagrid has 4 columns named "Empid,Empname,designation and DOJ"....if user clicks the button i wanto create an empty row in the datagrid and using edit option update command i like to update of entry in to the database, means it should update in the grid as well as database...how to do this..

Find following links useful which solves your purpose.

http://www.daniweb.com/forums/thread72925.html[^]

http://aspnet.4guysfromrolla.com/articles/021203-1.aspx[^]

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Hi all,

I am using third party tool in my web site.

Its running fine on my dev. PC.

but when I upload it to server it says

"System.Security.SecurityException: That assembly does not allow partially trusted callers."

when I read about this error, many suggest to get it set trust level to high by admin because developer can not

overwrite this.

Is there any other solution of this problem.

Thanks

Bajrang Singh
Using .net 2.0 (VS2005)

Add following line in your project's AssemblyInfo file, either at top or bottom.

[assembly: AllowPartiallyTrustedCallers]

This will resolve your issue.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Thanks Jindal for reply.
I've got this solution from many site but I didn't find assemblyInfo file in my web site and I didn't get any option to add it ( I think it added automatically). I created website as ASP.NET AjaxEnabled Web Site and AssemblyInfo file was not there)

Could you pls tell me what is the option to add AssemblyInfo file.

Thanks

Bajrang Singh
Using .net 2.0 (VS2005)

Hello,

I am using Oracle 10.2.0.1 and working on a web application using MS VS 2005. Here it is my oracle code :

CREATE OR REPLACE PACKAGE rollsearch AS
  TYPE t_cursor IS REF CURSOR;
  Procedure rol_cursor(c_rol in varchar2,c_cnm in varchar2,c_fnm in varchar2,
  c_mnm in varchar2,d_dob in date,n_year in number,c_exam in varchar2,c_main_supp in varchar2,
  io_cursor OUT t_cursor);
  END rollsearch;

CREATE OR REPLACE PACKAGE BODY rollsearch AS
  Procedure rol_cursor(c_rol in varchar2,c_cnm in varchar2,c_fnm in varchar2,
  c_mnm in varchar2,d_dob in date,n_year in number,c_exam in varchar2,c_main_supp in varchar2,
  io_cursor OUT t_cursor)
  IS
  v_cursor t_cursor;
  v_sql varchar2(1000);
  begin
  ...
  ...
  end rol_cursor;
  end rollsearch;

At oracle level, no error; it is working fine (in SQL Plus).

Here it is my button click code :

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim Ds As New DataSet()
    Dim Oraclecon As New OracleConnection("Data Source=orcl;User ID=exam2;Password=exam2")
    Oraclecon.Open()
    Dim myCMD As New OracleCommand()
    myCMD.Connection = Oraclecon
    myCMD.CommandText = "rollsearch.rol_cursor"
    myCMD.CommandType = CommandType.StoredProcedure
    myCMD.Parameters.Add(New OracleParameter("c_rol", OracleType.VarChar, 7)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("c_cnm", OracleType.VarChar, 30)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("c_fnm", OracleType.VarChar, 30)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("c_mnm", OracleType.VarChar, 30)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("d_dob", OracleType.DateTime)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("n_year", OracleType.Number, 4)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("c_exam", OracleType.VarChar, 1)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("c_exam_supp", OracleType.VarChar, 1)).Direction = ParameterDirection.Input
    myCMD.Parameters.Add(New OracleParameter("io_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output
    myCMD.Parameters.Item(0).Value = Trim(TextBox5.Text) 'Roll Number
    myCMD.Parameters.Item(1).Value = Trim(TextBox1.Text) 'Candidate Name
    myCMD.Parameters.Item(2).Value = Trim(TextBox2.Text) 'Father Name
    myCMD.Parameters.Item(3).Value = Trim(TextBox3.Text) 'Mother Name

    If TextBox4.Text <> "" Then
        myCMD.Parameters.Item(4).Value = Convert.ToDateTime(Trim(TextBox4.Text)) 'Date of birth
    End If

    If Left(DropDownList1.Text, 1) = "S" Then
        myCMD.Parameters.Item(5).Value = 0  'Exam
    Else
        myCMD.Parameters.Item(5).Value = Val(DropDownList2.Text) 'Year
    End If

    If Left(DropDownList1.Text, 1) = "S" Then
        myCMD.Parameters.Item(6).Value = ""  'Exam
    Else
        myCMD.Parameters.Item(6).Value = Left(DropDownList1.Text, 1) 'Exam
    End If

    If Left(DropDownList1.Text, 1) = "S" Then
        myCMD.Parameters.Item(7).Value = ""  'Main Supp
    Else
        myCMD.Parameters.Item(7).Value = Left(DropDownList3.Text, 1) 'Main Supp
    End If
    'MessageBox.Show(myCMD.Parameters.Item(0).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(1).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(2).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(3).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(4).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(5).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(6).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Item(7).Value, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    'MessageBox.Show(myCMD.Parameters.Count, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    Dim MyDA As New OracleDataAdapter(myCMD)
    Try
        MyDA.Fill(Ds)
    Catch Myex As Exception
        MessageBox.Show(Myex.Message, "Xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
    End Try
    datagrid1.DataSource = Ds.Tables(0)
    Oraclecon.Close()
End Sub

I am not understanding the cause of :

System.Data.OracleClient.OracleException was unhandled by user code
  ErrorCode=-2146232008
  Message="ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'ROL_CURSOR'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
  Source="System.Data.OracleClient"
  StackTrace:
       at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at _Default.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Rollsearch\Default.aspx.vb:line 62
       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Please let me know, where i am wrong. Kindly let me know, if i am unclear in question and/or neet more clarification.

Thanks & Regards
Girish Sharma

I am tryng to create a Bitmap completely in memory (Bitmap BMP = new BitMap(300,300)) and later with GDI create a complete image based on mathematical calculations, and later show the result in the ASP .Net page, but I don`t know which control use for it because all the ASP .Net image control that I find include an URL string property for stablishing the source image, but I don´t find any control which accepts an in memory image as source like pictureBox does in Windows Forms, but I find pages doing it, could anybody tell me how is it possible in ASP .Net.

Best Regards

There aren't any built-in controls that will render an image from memory. You'll have to create you own server control, but there are numerous examples here and elsewhere.

I know the language. I've read a book. - _Madmatt

Could you please give any link talking about this Server Control creation.

Best regards

You need to learn how to find information on your own.

I know the language. I've read a book. - _Madmatt

Hello,

I have a Javascript function that needs to be thrown several times in the code-behind(C#) for user navigation.

I wanna know if calling the function by the method ScriptManager.RegisterClientScriptBlock is a good practice to resolve this issue.

Thanks.

What kind of method? Does it matter to you when it gets processed during page load? Is there a reason you aren't creating one function that makes all the necessary calls and registering that?

brunoseixas wrote:
a Javascript function that needs to be thrown several times in the code-behind(C#)

You can't call a JavaScript function from code-behind. You can however write the JavaScript to the output stream. The best way would be to execute the script from the client-side load event such as

<body onLoad="MyFunction">

or with JQuery

<script>
$(document).ready( function() { MyFunction(); });
</script>

I know the language. I've read a book. - _Madmatt

Yes, there is a reason.

This page uses a free javascript code called niceforms (http://www.emblematiq.com/lab/niceforms/), it has several bugs and needs to be recharged several times. And the problem is that it does not reload correctly if called at events such as onLoad or EndRequest in html (I do not know why). So, I created a static method in BasePage application that contains a method that performs this function across the ScriptManager.

The solution I found was this, and I'm just calling it in Page_Load when is postback.

Thank you.

brunoseixas wrote:
The solution I found was this...

No the solution is to use code that isn't buggy and functions appropriately.

I know the language. I've read a book. - _Madmatt

Yes, of course. Tell that to the dummies of the commercial area. Haaaa

Laugh | :laugh:

Hi,

I am debugging through a web application that was written in C#. When the app loads it gets some values using static methods. Whenever I stop the debugging and run it again then it doesn't go into these static methods again as they are static. I want to kill this static variable instance so that I can debug through these methods again. I have stopped the web server in VS2010, but it doesn't work. I hope I am making sense? Smile | :)

Thanks

That isn't what static methods mean. Static means that they do not rely on an instance of the object. If you call the method it will be executed every time it is called. If you aren't hitting your breakpoints in the static method then something else is going wrong.

Thanks for the reply.

I'm actually testing a singleton that was written to retrieve global values. It's the first time I am working with singleton so I am debugging to see how it works. The first time I ran it I got the instance of the singleton object, then I stopped it. I ran it again, and it doesn't go into the property where it returns the singleton's instance. I am using VS2010.

Thanks

Too many pronouns. When you ran "it", is "it" an exe, a method? If "it" is a method I would not expect a singlton to run the code to create an instance more than once. That is what makes something a singleton. Your description of the situation is far too vague to really give you any concrete answers.

Because the content pages can have different size so I am having problems of positioning the content pages inside the Master, and the Master Elements don`t keep an strict position, Because it must be a normal problem I think that it shall have a normal solution, but I don´t know it, so could you please tell me if is there any rule or way of keeping the Master elements unchanged independently of which content page is located in.

Best Regards

1. Use Flow layout
2. Use html tables in your master page to design your UI. This would keep your master controls intact and a specified placeholder for your content page.

The only problem is that my Master page also paint an lower icon bar for all the pages, so the content page comes in the middle and depending of it´s size it makes the Master change it's appearance, but I´ll check about Flow Layout