Call Oracle Function As Part Of Parametrized Query?
Nov 19, 2010
I have a number of automatically generated data access classes to handle things like inserts & updates. These look like:
cmd.CommandType = CommandType.Text
cmd.CommandText = "UPDATE myTable set f1 = :f1, f2 = :f2, f3 = :f3 where id = :id"
cmd.Parameters.AddWithValue(":f1", _f1)
cmd.Parameters.AddWithValue(":f2", _f2)
cmd.Parameters.AddWithValue(":f3", _f3)
cmd.ExecuteNonQuery()
If I were to re-write the sql to do what I want, it would look something like
cmd.CommandText = "UPDATE myTable set f1 = pkg.getMyValue, f2 = :f2, f3 = :f3 where id = :id"
Is there any way to do this by setting _f1 to a "special" value, without changing the update SQL or the way the parameters are set? Only in certain cases will I need to set the value of f1 - most of the time, it will be null.
Using .net 2.0, and system.data.oracleclient against oracle 11.
I have a the following code to get data from an oracle database using
a parameterized query:
conn = New OracleConnection(connectionstring) comm = New OracleCommand("select name from Cust_name from Name_Table Where last_name = :lastname", conn) parmLastName = New OracleParameter("lastname", OracleDbType.Varchar2) parmLastName.Value = "Jones" comm.Parameters.Add(parmLastName)
I am trying to write an audit that will tell me what users are doing, so I would like to get the actual sql that is submitted. This is just one example of the query, there are many more so I would like to make it as general as possible. I would like to actually see "
select name from Cust_name from Name_Table
Where last_name = "Jones". I know I could just create the text
I'm using parameterized sql query to get data from database
string query = "Select * from employee where employee_city in (@value)";
strign city ="'NewDelhi','Bangalore','Mumbai'";
I'm using following code to achive this
[code]...
But this is not giving the result. If run the query in SQLServer query window as "Select * from employee where employee_city in ('NewDelhi','Bangalore','Mumbai')", records are there.
But the same query will not return any records from ADO.Net.
I have a gridview which I connect by C# and SqldataSource. I use asp.net 2.0 - 3.5.
I want to parameterized the queries and how do I do this in the C# file ? how do I set the selectparameters in C# ?. I do not want to do this in the aspx fil.
My code in C# is:
SqlDataSourceMachineName.SelectParameters.Clear(); SqlDataSourceMachineName.SelectCommand = "Select MachineName from tblMachine inner join tblLocation on tblMachine.MachineLocationID = tblLocation.LocationID where tblLocation.LocationName = 'New York' and tblMachine.StatusID = '1'";
SELECT ClientMaster.ClientName,* FROM ProjectMaster LEFT JOIN ClientMaster ON ProjectMaster.ClientCode=ClientMaster.ClientCode WHERE ProjectMaster.RefCode IN (@refcode) AND ProjectMaster.ProjectStatus=@status
@refcode should be able to contain multiple values but how should I pass value to the parameterized query?
I have tried many ways such as @refcode = 'VALUE1','VALUE2', @refcode = VALUE1,VALUE2 but to no avail?
I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT LEVEL LVL, SCH.NSCHEDULE_SL, SCH.NSCHEDULE_SL_FM, SCH.CSHED_CNAME FROM FA_SCHEDULES SCH WHERE LEVEL = 1 AND NSCHEDULE_SL_FM IS NULL AND NBRANCH_SL = 2 CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL AND NBRANCH_SL = 2
<asp:LinkButton CssClass="button" ID="btnApply" runat="server" OnClick="btnApply_Click()" OnClientClick="Apply1('btnApply')" > hi ihave this functin in .vb file Protected Sub btnApply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnApply.Click end sub
i have a question about call javascript in codebehind. my page has two parts.one part for enter information about manager and another part for usualuser.each person has mellicode.that it has speicail code.i wrote it with javascript and call it with this code:
[Code]....
when i click in btnpazireshsabt i should check mellicode for manager.i call it :
how to jquery call a other call function other class is not static
[WebMethod] public static bool Verify(string username, string password) //Do your logic with username, password here //I am just checking with admin/admin credentials Console.WriteLine("Ritu"); [code]...
Is this piece of code where I lock a part of the function correct? Or can it have use drawbacks when multiple sessions ask concurrently for the same Exam? Purpose is that client that first asks for the Exam will assemble it, all next clients will get the cached version.
public Exam GetExamByExamDto(ExamDTO examDto, int languageId) { Log.Warn("GetExamByExamDto"); lock (LockString) { if (!ContainsExam(examDto.id, languageId)) { Log.Warn("Assembling ExamDto"); var examAssembler = new ExamAssembler(); var exam = examAssembler.createExam(examDto); if (AddToCache(exam)) { _examDictionary.Add(examDto.id + "_" + languageId, exam); } Log.Warn("Returning non cached ExamDto"); return exam; } } Log.Warn("Returning cached ExamDto"); return _examDictionary[examDto.id + "_" + languageId]; }
I have a feeling that this isn't the way to do it.
I am thinking about using a DataSet to perform some operations but I wonder if it can be used as a regular table in a query. For example, I have the following code which updates a table named "listas_pre_titulos". Is it possible to use a DataSet instead? What I need is to build a "temporary" table on the fly and use it in a regular query and I do not know if a DataSet is an option or maybe I would need to CREATE such a temporary table.
I am attempting to inherit an ASP.NET RegularExpressionValidator and add some functionality to it. I inherited the control and added my custom properties. However, I would also like the client-side functionality to call a different JavaScript functionIn order to do that, I will need to supress what is happening in the AddAttributesToRender method because the name of the function is hard-coded there.
Protected Overrides Sub AddAttributesToRender(ByVal writer As HtmlTextWriter) MyBase.AddAttributesToRender(writer) If MyBase.RenderUplevel Then Dim clientID As String = Me.ClientID [code]...
I have written a sample web service, which consist of certain .aspx pages. I have written a code to consume webmethods from that web service. Now, is it possible to load the aspx page which is a part of the web service from the calling web application i.e. from another aspx page which is outside the web service.
How this scenario is;
I have one web application running with a page say Page1.aspx in browser. 2. I have created a web service which is having an aspx page say Page2.aspx. 3. There is a button on Page1.aspx. 4. Now, when client click on the button, is it possible to load Page2.aspx, which is not a part of web application, but the web service.
[code]...
What I am trying to do is, get response obtained in Gen.aspx and pass it to default.aspx page.
I am using following oracle query and using executescalar() to fetch data
sql = "select username from usermst where userid=2" string getusername = command.executescalar(); But It is showing me error "System.NullReferenceException: Object reference not set to an instance of an object" This error comes when there is no row exist in database for userid=2
How can I make this get a specific users data, Example user enters his 3 digit code in the badge text box so that only his information is shown. Can I add a where clause to the select command? or is there a better way to do this? Also is there a good book out there with information about asp.net, c# and oracle.
// string Badge = "100000" + Request.Form["xBadgeTextBox"]; in default.aspx.cs //"SELECT * FROM CLOCK_HISTORY WHERE BADGE ='" + Badge + "'"; would
I am trying to retrive the query string value and display it on the aspx page. The query string is passed from a gridview. Everything works fine except i noticed that when there is an '&' in the query string then the label on the page will display only uptil the '&' (i.e. excluding the '&'). Just so to let you know. I retrive the value of the querystring into a string variable and then assign it to the variable. I have noticed this only for '&' character but maybe there are more characters with sinmilar bahaviour that I am not aware of.if anyone has a workaround on displaying all the content from the querystring then do share.
I Getting A Problem In DataGrid's ItemDataBound Event. I Am Calling A JavaScript Function In DataGrid's ItemDataBound Which Retrun The CellIndex And RowIndex Number On Which UserClick After That I Am Re-Binding The DataGrid With jQuery Function After That ItemDataBound Event Not Working. I Want To Call The Same Function Again. Is Their Any Method To Call A Server-Side Function On ItemDataBound Event Except Client-Side Function..
I have an aspx page with two buttons, one of the buttons has an OnClick attribute to a function that should be run when clicked. When the other button is clicked there is an if statement checking if the page is a postback, if it is then I run some statements that need to be run when that button is clicked. That postback button works fine. However, the other button, when it's clicked the function it's supposed to call never executes, and the statements inside if (Page.IsPostBack) get executed instead. What can I do to fix this? Is there a way to make the button that calls a function not do a Post back?
