My code is returning a -1 if there is a row found and a 0 if a row is not found. I want the code to return the BonusDatID of the row, which is the result of of select statement. Is this possible ?
intBonusDayID = Convert.ToInt32(cmd.ExecuteScalar())
Dim sql As String = "Select BonusDayID From BONUSDAY Where ClockNo = @ClockNo AND Status = 'Open'"
I want to send value from text on text keypress event in C# Code Behind Function. or get value from server side script function which called on textbox keypress event to C# Code Behind Function. How i do that
View 2 RepliesI added the button attribute on page load.
[Code]....
What I want to do is if the OK button is clicked, save the data and then open the grid. If the Cancel button is clicked, open the grid. The problem is when I clicked the Cancel button, it didn't do anything in the OpenGridButton_Click event.
I'm trying to do the equivalent of a "Are you sure you wish to delete?" and then if yes, return to a function in the aspx.vb code. Here is what I have:
Code:
<!-- ModalPopupExtender -->
<cc1:ModalPopupExtender ID="mp1" runat="server" PopupControlID="Panel1" TargetControlID="btnCancel"
CancelControlID="btnCancelNo" OkControlID="btnCancelYes" OnOkScript="__doPostBack" BackgroundCssClass="modalBackground">
[Code] ....
And then on the form, the btnCancel does popup the menu, with Yes / No and the text "Are you Sure?"But, even though I have a button called "btnCancelYes", I cannot get the code in there to trigger. Ie:
Code:
Protected Sub btnCancelYes_Click(sender As Object, e As EventArgs) Handles btnCancelYes.Click
DeleteRecord()
End Sub
I have created a .aspx page that contains a web form. The information in the form is submitted to a companies web site and once accepted is manipulated by the company.
This all works wonderful.
My problem is that once the data submitted to their site my page receives a response code. (1 = Member Added, 2 = Updated Member...)
How do I go about capturing this response code? Currently I end up with a blank page and a number in the upper left corner.
So I am getting this error message:
Cannot implicitly convert type 'System.Data.SqlClient.SqlParameter' to 'string' I have a stored procedure on SQL 2000 returning an email from a database table (aspnet_Membership). The email type from the table is nvarchar. I have a method (in C# in the code behind) that gets that value. But the debugger doesn't like the last line:
return returnEmail; // returnEmail is a string variable we created to capture the stored procedure's return value
I've tried doing returnEmail.toString() in several places, but still get the same error message for the last line of code (returning the email).
This is the stored procedure:
How can i create a javascript confirmation box and return the value to use in the VB.net backend code?
View 7 RepliesWhen it is bound to a datagrid. I do a grdELTCompletions.DataBind() and it shows that it's SELECTING, but returns nothing. I can execute the SP in MS SQL and it works fine. I just need know what elements of either the datasoure (sql to execute the SP) or the datagrid to find the error. Or even if there is a SQL log I can look at..
View 6 RepliesI want to return a response with type text/plain and status code 404. How do I do that? I've found that ContentResponse allows for setting response type but how do I set response status code?
View 2 RepliesI am trying to load data from an existing DataTable into a new DataTable. Not sure how to get it started. Do not want to merely copy data, I need to load it in row by row.
protected DataTable GalleryByCat()
{
// GLinks is the new DataTable I want to construct and bind to a DataList, Repeater, ListView
[code]...
I have JQuery confirmation dialog function that called by server side code (C#)how to get its return value of that function? in this case the return value would be either Yes or No.I called it in button clicked event as below:
Code:
protected void btn1_Click(object sender, EventArgs e)
{
string message = "Message from server side, please select yes or no";
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowConfirmation('" + message + "');", true);
}
my question is how to get JQuery return value, in this case the return value would be Yes or No?
Code:
=== JQuery Confirmation Dialog ==
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js" type="text/javascript"></script>
<link href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/themes/start/jquery-ui.css"
[code]....
I am using VB.NET & SQL Server. My sproc returns something like this which I need to display on my web page as below:
sproc returns:
ClientNumber ClientName Product
------------------------------------------
100SON Sony TV
100SON Sony DVD Player
100SON Sony Cell Phone
200KEN Kenmoore Microwave
200KEN Kenmoore Dryer
Now based on these data, I need to display some information like below on label in the web page:
100SON - Sony - TV, DVD Player, Cell Phone
200KEN - Kenmoore - Microwave, Dryer
I need you advice on this.What would be the best way to do this?
(1) I can work further on this data in code to generate the required data or
(2) I can work further in the sproc itself to directly return the required data
I have a cascading dropdown. After the dropdown is populated(it is in another file) i would like to return back to the original form where the control is placed. is there anyway of doing it
View 4 Replies[Code]....
I keep getting error
"'TestData._Default.InsertNewProject()': not all code paths return a value"
I am doing this in a small test application so that I can impliment it to the production app.
I have an update function in my data layer which is defined as:
public int UpdateRBTable(parameters ...) This calls a SQL Server Stored Procedure to perform an update function on the database.
The process does its job for updating the table. However, the stored procedure has a return value (which indicates how many rows were updated), but this return value is not returned to the application. The application always shows that a zero was returned from the stored procedure.
Can my WebMethod return an XmlDocument as return type?
When I try to consume the web service I'm still not getting XML. It appears as though a reference to the method is being returned rather than say a string containing XML.
<WebMethod()> _
Public Function CustomerSearch(ByVal lastName As String, ByVal firstName As String, ByVal companyName As String, ByVal city As String, ByVal state As String, ByVal email As String) As XmlDocument
' Create XML doc
Dim doc As XmlDocument = New XmlDocument()
' some more code
Return doc
End Function
how can i return 401 error from a method return ActionResult?
View 1 RepliesHow can I assign a value to the methods return var BEFORE I return the final value?
Example:
public string Example()
{
[here I want to assign a value to the return var and continue this block until the end] = "TempStr"; [code].....
How to get asp.net return drop down list to return value as int
I want to pass the value to a stored procedure as an integer. But the default appears to be as a string which is not what the store procedure is expecting.
Is there a good way to return the list values as ints?
I suspect I can you set the value on the change selection event, is there another way?
I have an approve button.on clicking on this button it should show that an inactive value is present .Onclicking yes conformation it should save the data or else clicking on no conformation should return false; how i will do that?After alert it always submit the data.Â
protected void ibtApprove_Click(object sender, ImageClickEventArgs e)
{
string otherAffiliateName = txtRequestedAffiliate.Text;
int inActiveAffiliates = new BLRating().InActiveAAffiliateChecking(otherAffiliateName);
if (inActiveAffiliates > 0)
[code]...
This is the code i used.how i wiil stay back on Confirm 'no' click?
Following is the code to insert userName from session and PageName into table to keep record that how many times a user does hit a particular page.
To avoid repitition of code I want to put the code in one class and want to inherit same code in each page.
How to get this task? Please do share with me? Here is the OK code:
[Code]....
I've the Javascript code to do a confirmation before deletion of some records
function confirmDelete()
{
if(confirm('Delete all?'))
{
return true;
}
else
{
return false;
}
}
I've the button code here
<asp:Button ID="btnDelete" runat="server" onClientClick="return confirmDelete();" onClick="btnDelete_click" />
If i've the button outside an update panel (basically i'm using RadAjaxPanel by Telerik) it is working fine. But when the button is inside an ajax panel, even if i click OK for deleting the records the server side code is not called.
I'm missing a the code browser when I create pages that have the code not placed in a seperate file. For pages with .asp.vb files I get the browser correctly.
I think it's called a code browser but just in case it's not I mean the dropdown that shows Page Events, Buttons and other controls that can be selected along with their events.
How do I turn on those dropdowns for pages with code behind that uses <script> tags in the actual .aspx page?
Included (Showing page events just under the tab):
Missing
I want to call a function present in code behind from front page (html : source code)
i want to use like this:
Source code
<a href='<%# linkAlpha("B").ToString()) %>' title="B" id="B_List" runat = "server">B</a>
Code Behind
protected string linkAlpha(string value)
{
// /market-research/<%#Eval("customname")%>/
string str = "";
if (Request.Url.DnsSafeHost == "localhost")
{ // /market-reports/<%# Eval("customname")%>/
str = "Alpha_Category.aspx?q=" + value.ToString().Trim();
// Response.Redirect("Alpha_Category.aspx?q=" + value.ToString().Trim());
}
else
{
// str = "/market-reports/" + value.ToString().Trim() + "/";
str = "/Alpha_Category.aspx?q=" + value.ToString().Trim();
}
return str;
}
how do you call code behind button click event or a code behind method
from javascript.