ADO.NET :: Using LINQ, How To Execute The TSQL LOG() Function
Mar 25, 2011I have a SQL view that uses the LOG() function. How can I do the same in a LINQ query?
View 6 Replies
Similar Messages:
Iis - Execute A Dll Function In Bin Not Working?
Apr 24, 2010I am developing a remote control application where a client (aspx page in a browser) can request a server to "launch a notepad" (for testing purpose, for real life, turning off a light bulb, etc). So I created a dll with a simple function for launching the notepad (on the server side) and dropped this dll in the root bin folder.
It worked fine when the aspx page is running under ASP.NET development server (launched from Visual Studio). But when I tested the same aspx page under a FireFox browser, it did not work (launch the notepad) even though it did call for the same function (I stepped through in debugger).
Is this a permission issue? How do I set this up in IIS manager, or even better in web.config?
C# Wait For A Function To Execute And Delay?
Mar 21, 20111. How can I create a delay in C#.I know Thread.Sleep(0) but it is blocking my GUI.2. Also I need to pause the execution of the normal flow until a function return a result.
View 13 RepliesMVC :: Best Way To Execute A Controller Function From Javascript?
Feb 14, 2011How can I launch a function on the server(in a controller) from javascript?
View 5 RepliesExecute JQuery Function When DOM Is Visible
Dec 17, 2010I have a page with some custom validation which displays a result in a validation summary. I would like to reposition this validation summary to the bottum of the page without causing the page to scroll with the length of the validation summary. I have a jQuery function which does this very nicely, however, I need to execute this jQuery after the validation summary is displayed and i'm not sure which event to trigger.
$(document).ready(function(){
$("#<%= vsmSummary.ClientID %>").change(function(){
var newTop = $(window).height() - $("#vsmSummary").height();
var newLeft = ($(window).width() - $("#vsmSummary").width()) / 2;
$("#vsmSummary").css(
{
'position': 'absolute',
'left': newLeft,
'top': newTop
}
);
});
});
In my custom validation method I build this string and register with the RadScriptManager...
Dim scriptText As String = "$(document).ready(function(){ " + _
"$(""#<%= vsmSummary.ClientID %>"").ready(function(){" + _
"var newTop = $(window).height() - $(""#vsmSummary"").height();" + _
"var newLeft = ($(window).width() - $(""#vsmSummary"").width()) / 2;" + _
"$(""#vsmSummary"").css(" + _
"{" + _
"'position': 'absolute'," + _
"'left': newLeft," + _
"'top': newTop" + _
"}" + _
");" + _
"});" + _
"});"
RadScriptManager.RegisterClientScriptBlock(Me.upSCPPage, Me.upSCPPage.GetType(), "DynamicVSM", scriptText, True) This works!! I had no clue that I could call this from my code behind!! I will be doing this much more in the future!
Web Forms :: Execute A Js Function In Vb Code Behind?
Sep 9, 2010I use a js function in a source page as below
<a href="javascript:;" onclick="openwin('Sample.aspx?DID=<%#Eval("UID") %>', '', '700','300','yes'); return false ">
I need to excute this function from vb.net code behind page .
Web Forms :: Execute C# Function On Click?
Aug 14, 2010I have a flashcontrol that downloads a file. Around this flashcontrol I have put a <div>. What I am trying to do is to execute a click event in C# when this flashcontrol is clicked but the function in C# (func1) is not executing. How could this be possible to do ?
[Code]....
Execute Function On Specific Key Stroke In VB?
Sep 23, 2010I'm developing a web application that displays items from a work queue to a user. When an item is selected I have the app lock that item out so no other user can select it. By hitting the back button in the app it unlocks the item.
I want to be able to unlock the item if the user hits the backspace key. I know what code I need to unlock it. I just need to know how to make the code execute on backspace key stroke.
Web Forms :: Execute Function From HyperLink?
Feb 28, 2011I'm creating a HyperLink dynamically in my code behind based on a database table. What I'd like to do, is that whenever someone clicks the link, a function is executed that then does some processing before rerouting them to the linked page.
Is there a way to do this? I don't want the look of a button, even though I suppose that's the functionality I want.
ADO.NET :: Trying To Execute A Stored Procedure In LINQ?
Feb 25, 2011I am trying to execute a stored procedure in LINQ. When run in SQL Server it returns several fields, mostly integer and float fields. But when I call the stored procedure in LINQ, all it returns is 0. Here is how I am calling the stored procedure :
[Code]....
And here is the stored procedure :
[Code]....
Web Forms :: Execute C# Function After Page Loads
Aug 16, 2010I have a page that calculates some stuff and then displays it to the user. Because the calculation part takes a while I would prefer to have the entire page load with empty data and only after that call the calculation and the display data function.
View 7 RepliesWeb Forms :: How To Prevent Function() In JavaScript To Execute
Mar 31, 2010I only want to execute this JavaScript function runEx() if publicVarFromCodeBehind != "abc".
I am setting the publicVarFromCodeBehind = "abc" in the Page_Load event but anyway the runEx() function is executing. I wonder how this works and how to prevent runEx() from executing though I need to catch the logic from C# and pass on the variable to the JavaScript.
[Code]....
SQL Server :: Procedure Or Function Has Too Many Arguments Specified When Execute
Sep 27, 2010When i execute this SP in DB, it works fine. But when i execute from asp.net app it is throwing error: Procedure or function ... has too many arguments specified
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[sp_Customer]
@brchID char(40),
@brchName VARCHAR(50),
@userID VARCHAR(50)
AS
BEGIN
TRANSACTION
DECLARE @req_pk int
DECLARE @customer_org_pk int
IF EXISTS(SELECT * FROM [customer] WHERE [org_id] like @brchID)
BEGIN
SELECT [org_pk] FROM [customer] WHERE [org_id] like @brchID
END
ELSE
BEGIN
EXEC sp_get_next_control_no 'organization.org_pk',@customer_org_pk out;
INSERT INTO [customer] (org_pk,[org_id],[org_name])
VALUES(@customer_org_pk,@brchID,@brchName)
SELECT [org_pk] FROM [customer] WHERE [org_id] like @brchID
END
--Address Book Entry
IF NOT EXISTS(SELECT * FROM [address_book] WHERE [prsn_id] like @userID)
BEGIN
exec sp_get_next_control_no 'person.prsn_pk',@req_pk out;
END
IF (@@ERROR <> 0)
BEGIN
-- Rollback the transaction
ROLLBACK
RETURN
END
ELSE
BEGIN
COMMIT
END
Here is my asp method:
public static string Customer(string brchId, string brchName, string userId)
{
string spName = "st_Customer";
SqlParameter OrgPk = new SqlParameter("@org_pk", SqlDbType.Int);
OrgPk.Direction = ParameterDirection.Output;
OrgPk.Size = 50;
try
{
SqlHelper.ExecuteNonQuery(Config.ConnectionString,
CommandType.StoredProcedure, spName,
new SqlParameter("@brchID", brchId),
new SqlParameter("@brchName", brchName),
new SqlParameter("@userID", userId),
OrgPk
);
return Convert.ToString(OrgPk.Value);
}
}
JQuery :: Execute Code Behind Function In Javascript?
Sep 29, 2010I had a custom confirm box Using Jquery....In that It crates two buttons Yes and No. I need to execute my code in Yes click.....how?
View 6 RepliesJQuery :: How To Execute Code Using JavaScript Function
Jun 11, 2010I have downloaded a jquery tool which creates overlay windows so here is the code which I want to trigger by calling a javascript function instead of a button or link.
The CSS
[Code]....
The HTML note the overlay is executing when i click the button i want this to be triggered on javascript function)
[Code]....
[Code]....
All i want to do is call a function lets say "ShowOverlay()" from my code behind using ClientRegisterScript() and it should do the same as it is doing on button.
How To Execute Code Behind Function Using JavaScript Keypress
Jul 22, 2011how to execute the code behind function using JavaScript keypress ?
The reason is that the keypress that I'm referring to will be used in searching record so I want that every keypress a result will be shown in the gridview immediately.
Web Forms :: Execute Code Or Function Every Minute
May 7, 2015i want to execute some code every one minute like i select * from customers , now for each row, i want that each row will execute after 1 minute , in asp.net web application not in windows application.
View 1 RepliesWeb Forms :: How To Execute Javascript Function On Page Load
Apr 23, 2010I have created javascript function as mentioned below to hide/show some control. I am calling this script on dropdown on 'onchange' method. In dropdown first item is "-- Select --". I want to execute it on Page Load function, so by default it will be hidden. I tried to call like this on Page load, but it is not working.
ddlEmpType.Attributes.Add("onchange", "HideDD('-- Select --');");
[Code]....
Execute A Javascript Function When Textbox Is Populated In JQuery?
Jan 4, 2010How do I execute a function in JavaScript when a text box is populated with text? The text box with be hidden from the user. It will be populated by a USB magnetic card swiper.
Pseudo code:
<script language="javascript" type="text/javascript">
function MyFunction() {
//execute this function when MyTxtBox is populated
}
</script>
<asp:TextBox id="MyTxtBox" runat="server" Visible="false" />
Execute LINQ Query Using Properties Of Child Entity Set
Nov 25, 2010I am having a meltdown over something that seems so simple and yet isn't working. Here's my scenario.
I have an object structure of tEvents, which contains properties of an event like a run of concerts. tEvents in turn contains an entity set of tEventOptions, which include properties like EventDate, Cancelled etc. I would like to query a list of tEvents using properties of the tEventOptions, for example filtering by date.
My pageis using a calendar object to show event dates. So I am trying to find if any tEvents in the List coming back from the database match the date of the day element being rendered in my Calendar control like so (in this snip 'data' is List and results from a db query):
[code]....
Except r, my query result var, is always true no matter what data it receives. I have tried the sub query using other properties of tEventOption and get the same 'true' result each time. I know that the data does not reflect this result so I clearly have a problem with the structure of my query, but for the life of me I cannot find a way to resolve it.
C# - Execute LINQ Query When The Tables Name Stored In A Variable?
Jul 30, 2010I want to do execute a LINQ query, and I have the name of the table to query stored in a variable:
string tableName = "SomeTable";
DataContext db = new DataContext();
var vResult = from t in db.tableName where t.Id = ....
Execute A JavaScript Function When Textbox Is Populated And Focus Is Still Set In JQuery?
Jan 5, 2010How do I execute an JavaScript function right when an ASP.NET text box control is populated and focus is still set? The onChange event will not work because I need to programmatically move focus to the next form element after the JavaScript function has executed.
Is is very similar to this question. The marked answer is correct for the context on the question, but after some more testing it did not exactly solve my current issue.
Pseudo code:
[code]...
Forms Data Controls :: How To Execute Javascript Function From Datagrid Row
Sep 15, 2010I need to execute a javascript function when a row of a datagrid is clicked. I am not sure how to do this.
I have tried adding a template column with a button
<asp:TemplateColumn>
<ItemTemplate>
<asp:Button
ID="myButton"
Text="Insert
collection"
OnClientClick="putData();"
runat="server"
/>
</ItemTemplate>
</asp:TemplateColumn>
And then attaching the javascript to it:
myButton.Attributes.Add("onclick",
"putData()")
But it produces an error.
C# - Can Execute A Stored Procedure Using Linq In A Background/alternate Thread
Feb 4, 2011In my app I am using the open xml sdk to generate a word document and write the file to the response.output stream for the user to download.
At the time that the letter is generated I also need to call a SP via linq data context to update a row in my db.
I think that I need to execute this SP in a seperate thread so that I can simultaneouly write the file to the output. my method looks like this...
protected void btnPrint_Click(object sender, EventArge e)
{
//call sp to update
//create letter and send to client
}
Is this feasible or should I avoid seperate threads?
DataSource Controls :: LINQ Query Takes Too Long To Execute?
Jun 6, 2010There is a table contains thousands of records. when I run this query:
[Code]....
The application stucks...it takes too much time to execute this query...
What might be the reason for that?
