i have to call an executable in the client machine in asp.net and get the return parameters, i been looking for an example but i couldn't find it.
it this possible to recover the output parameters from one exe in JavaScript?
i know that can i write:
var WshShell = new ActiveXObject("WScript.Shell");
var oExec = WshShell.Exec("My.exe");
but the clients executable returns 0 or 1 that values are the ones i need to collect
I have a parent page that launches a telerik radwindow and passes it an argument.
Once the radwindow is done processeing the value, I need it to return it to the parent page, and I would like the parent page to have access to this value in my code behind page.
I have tried to pass the value to a hidden field on my page and then trigger a page refresh and my code behind watches to see if the value is working.
I can't seem to get this to work. I get the return value in the parent javascript, but i can't get it from my hidden field from the code behind.
[code]....
This is my query
Dim s_Person = From Person In db.People Join ProspectStatus In db.ProspectStatus On Person.Id Equals ProspectStatus.Prospect_ID Where (Person.Organization_ID = s_Organization_ID)Select Person.
I only want to return DISTINCT values of Person.ID. Right now, it returns the same person multiple times because there are several entries in the status table.
Dim s_Person = From Person In db.People Join ProspectStatus In db.ProspectStatus
I have a text box that has values separated by a comma. I am trying to remove the duplicate values for, example this text box will have values like:
John, Adam, Mike, John, Mike
I want it to return unique values like:
John, Adam, Mike
I found a VB function and converted it to C# but it's giving me errors like newArray is a variable but used as a method. Thanks
public string RemoveDuplicates(string items)
{
StringBuilder Result = new StringBuilder();[code]....
I have been reading that a value needs to be returned by a function, otherwise the following error will occur:
"Function <function name> doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used."
The cure, I have found, is to return something (i.e. "Return 0") before exiting the function. Can I pass this return value back to the routine that called the function? If so, how do I code this?
Most of the time, however, I find I'm not needing to return a value anyway, and just end up adding "0" to the ends of all my Return statements. Does anyone have any comments on this?
Links referred to:
[URL]
How to return values from Webmethod to the client in JSON format? There are two static int values that i want to return.Do I need to create new object with those 2 properties and return it?The GetStatus() method is called frequently and i don't like the idea of creating a special object each time just for json formatting...
[WebMethod]
public static int GetStatus()
{
int statusProcess,statusProcessTotal;
Status.Lock.EnterReadLock();
statusProcess=Status.Process; //Static field
statusProcessTotal=Status.ProcessTotal; //Static field
Status.Lock.ExitReadLock();
return ...
}
On client side I catch the return value in :
function OnSucceeded(result, userContext, methodName)
(PageMethods.GetStatus(OnSucceeded, OnFailed);)
I am working on a Tag system for a news page designed in ASP.NET. For the system I require a TagExists method to check for tags within the database. The stored procedure I have written is below.
[Code]....
I have tried switching the procedure to return 0 if the tag exists and 1 if it does not and it still returns 0 despite the exact same testing conditions. I have also returned the actual select query and it has complained of the Tag "news" (my test item) not being an int on execution showing the select itself is definitely properly formed.
how to return list of values(single column values) from stored procedures in sqlserver 2005?
View 4 RepliesI have the following stored procedure
[Code]....
MOVE_MOD is defined as a float.
Yet within Dataclasses.designer.cs the function gets added as:
[Code]....
Naturally this is causing some issues as my C# code needs to handle decimal values. If I try to manually change the designer code to use floats, I get the following error
'System.Single' is not a valid return type for a mapped stored procedure method.
openDB() Dim inList As String Dim getCourses
For k As Integer = 0 To arLcID.Count - 1
If k > 0 Then inList &= ","
End If inList = arLcID(k).ToString
getCourses = "select cID,cCode,cUnit from [university].[Courses_1] where cID ='" & inList & "'"
insertCMD = New Data.SqlClient.SqlCommand
[Code] ....
This code is not returning any value, when the arraylist is removed it returns value.
I have the following in an aspx page:
<td colspan="2">
<% DisplayParties(); %>
</td>
In the code behind for the aspx page, i have this (e.g. I build HTML for the checkboxes):
[code]....
Not my proudest moment, but whatever. The problem is that when this page posts back via some event on the page, I never get these tags in the Request.Form collection.
Is this simply how ASP.NET works (e.g. only server-side control post back) or am I missing something simple.
I have a select statement in a stored procedure and want to be able to retrieve the key column value (PRODUCTID)and return it as Output when Select statement is executed on input Parameter (NAME).
addition, return two further output values (COST,TOTAL).
note the grid control expects to receive all values at once! so i need to get out these values at the same instance of execution.
Select productID,COST,QUANTITY,NAME,TOTAL,DATE
FROM PRODUCTS
WHERE NAME=@NAME
I have a web.config file with the key "mailTo" This contains multiple comma delimited email addresses.
I want to loop through these values addig the to a collection in c# but it treat is as one string rather than multiple string.
[code]...
I have a page that lists products from a table based on the querystring. So if I say foo.aspx?fam=1 all the products from family 1 will be listed. How can I make my code list all the values if query string is empty? My SQL command would have to be different...can't really see how I can do this.
<asp:SqlDataSource ID="ds_produtos" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalSqlServer2 %>"
SelectCommand="SELECT DISTINCT [IdProduct], [Name], [Description], [IdFamily], [Price], [Stock] FROM [Product] WHERE ([IdFamily] = @IdFamily )">
<SelectParameters>
<asp:QueryStringParameter Name="IdFamily" QueryStringField="fam" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
While using an insert query for a certain table, can I used a select statement to know whether there's an already existing value in the stored procedure using a return value where insert occurs? Or do I need to separate a procedure?
View 9 Replies[Code]....
for some reason it doesnt return any values.
before i've added the inner join it worked perfectly.
i couldn't find my mistake, though i passed over it several times.
I have a user table with userID, userName ...the standards. I also have a "Material" table with materialID, materialName, etc.
I combine these in another table "UsersMaterial" with userID and materialID, depending on which materials the user has chosen (between 0 and 5).
Now I need a stored procedure that returns the user information + the set of materials that is mapped to the user.
But I can't see how I can return one row of user information combined with a set of the user materials? Do I join or can I return a set + one row?
i want to return multiple(name and statusid) parameter from web method and want to retrive in javascript function how to use it.
I have attached my code.
[System.Web.Services.WebMethod]
public static string CheckPromotionCode(Int32 id)
{
string name="kausha";
string statusId = "6";
[CODE]...
validation(ie if there is no matching value in TableB),i want to show a confirm dialog box asking the user if they want to add a new entry in TableB. If user says Yes then take him to another page to do the entry else stay on the same page I have added that validation in textchanged event of the textbox.
[Code]....
Here is the javascript
[Code]....
How do i capture the return value from the javascript and based on it send him to another page.
I am trying to do a lookup in a table with a value stored in an xml column.
I tried this several ways but I can't get it to work.
Here is some code:
[Code]....
how to open a popup window and return values to the parent page
i.e passing value fom popup window to parent form.
(The child window contain textbox with a button. Once the value entered in the textbox the value entered should be updated in parent window from child window)
in asp.net web application using C# ..
In have created a Web Service which needs to be consumed by multiple environment (.Net,Java,Python..etc) hence ,I have used List<list> as an outparameter (with "OUT" keyword )in my Web service to return value. My question is Will all the application consuming my webserice able to get List as return value ? if not can anyone help me out in getting return values from asp.net webserive that will be consumed by multiple environment
eg.
bool WS_GetUser(string Name,out List<ICWS.InstanceType> instype);
Is it possible to return multiple values from a stored procedure? Basically, if I execute the stored proc on the C# side, then on the SQL side I do multiple calculations. Let's say I have 5 int values I need returned to the C# side.
View 4 RepliesI have a scenario where i want user to open a popup or other page from a web form to search contacts from database and add them to list and when done return that list back to parent form field and continue filling other fields.I have 2-3 user input which should take multiple values for each field from list of values and i wanted to implement this using pop up based search and add method (other alternative was to use dropdown with checkbox but the list is so big and it is not user friendly to use that)
Is this feasible using asp.net or is there a better architecture/method in .NET to implement this type other than popup based search and retrieval.
I am using Stored Procedure as my Insert/Update command in a FormView. The sp returns a value which I will need to use. How do I retrieve the value after doing an insert / update?
View 4 Replies
