Click here to Skip to main content
15,908,111 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Trying to create modal dialog using jQuery Pin
indian1439-Aug-17 11:44
indian1439-Aug-17 11:44 
GeneralRe: Trying to create modal dialog using jQuery Pin
F-ES Sitecore9-Aug-17 23:11
professionalF-ES Sitecore9-Aug-17 23:11 
GeneralRe: Trying to create modal dialog using jQuery Pin
indian14310-Aug-17 13:03
indian14310-Aug-17 13:03 
GeneralRe: Trying to create modal dialog using jQuery Pin
F-ES Sitecore10-Aug-17 22:09
professionalF-ES Sitecore10-Aug-17 22:09 
GeneralRe: Trying to create modal dialog using jQuery Pin
indian14311-Aug-17 13:13
indian14311-Aug-17 13:13 
GeneralRe: Trying to create modal dialog using jQuery Pin
F-ES Sitecore13-Aug-17 22:18
professionalF-ES Sitecore13-Aug-17 22:18 
QuestionProcedure or function 'sp_getchech' expects parameter '@ID', which was not supplied Pin
samflex9-Aug-17 5:24
samflex9-Aug-17 5:24 
AnswerRe: Procedure or function 'sp_getchech' expects parameter '@ID', which was not supplied Pin
Richard Deeming9-Aug-17 8:14
mveRichard Deeming9-Aug-17 8:14 
You haven't set the CommandType property.

I'd also be inclined to make a few changes:
C#
protected void chk_Click(object sender, EventArgs e)
{
    if (string.IsNullOrEmpty(checknumber.Text)) return;
    
    int id;
    if (!int.TryParse(checknumber.Text, out id))
    {
        lblStatus.Text = "Please enter a valid ID number to check.";
        return;
    }
    
    using (var conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Constr"].ConnectionString))
    using (var cmd = new SqlCommand("sp_getcheck", conn))
    {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@ID", id);
        
        try
        {
            conn.Open();
            
            // Posted stored procedure doesn't return any records, so no need for data reader.
            cmd.ExecuteNonQuery();
            
            // No need to update the current page if we're redirecting.
            var evalue = hequipID.Value;
            if (evalue == "1")
            {
                Response.Redirect("Air.aspx?pageId=1");
            }
            else if (evalue == "2")
            {
                Response.Redirect("Land.aspx?pageId=2");
            }
            else
            {
                imgstatus.ImageUrl = "~/images/Icon_Available.gif";
                lblStatus.ForeColor = Color.Green;
            }
        }
        catch (SqlException ex)
        {
            //Something is wrong with this taxpayer's account.
            imgstatus.ImageUrl = "~/images/NotAvailable.jpg";
            lblStatus.ForeColor = Color.Red;
            lblStatus.Text = ex.Message;
            chk.BackColor = Color.Silver;
            
            // Are you sure you want to do this in a web application?
            System.Threading.Thread.Sleep(2000);
        }
    }
}




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Procedure or function 'sp_getchech' expects parameter '@ID', which was not supplied (SOLVED) Pin
samflex9-Aug-17 14:54
samflex9-Aug-17 14:54 
QuestionWhat is better solutions for complex application and databases Pin
Lakhpat-Singh8-Aug-17 7:22
Lakhpat-Singh8-Aug-17 7:22 
AnswerRe: What is better solutions for complex application and databases Pin
F-ES Sitecore9-Aug-17 0:00
professionalF-ES Sitecore9-Aug-17 0:00 
QuestionGetting Route Values in Controller Pin
Farhad Eft7-Aug-17 7:20
Farhad Eft7-Aug-17 7:20 
AnswerRe: Getting Route Values in Controller Pin
Richard Deeming7-Aug-17 10:21
mveRichard Deeming7-Aug-17 10:21 
GeneralRe: Getting Route Values in Controller Pin
Farhad Eft7-Aug-17 13:19
Farhad Eft7-Aug-17 13:19 
Questiontrying to call a WebApi method along with new Page when button clicked using jQuery Pin
indian14331-Jul-17 15:26
indian14331-Jul-17 15:26 
AnswerRe: trying to call a WebApi method along with new Page when button clicked using jQuery Pin
Richard Deeming1-Aug-17 0:50
mveRichard Deeming1-Aug-17 0:50 
GeneralRe: trying to call a WebApi method along with new Page when button clicked using jQuery Pin
indian1431-Aug-17 7:01
indian1431-Aug-17 7:01 
GeneralRe: trying to call a WebApi method along with new Page when button clicked using jQuery Pin
Richard Deeming1-Aug-17 7:24
mveRichard Deeming1-Aug-17 7:24 
GeneralRe: trying to call a WebApi method along with new Page when button clicked using jQuery Pin
indian1431-Aug-17 13:23
indian1431-Aug-17 13:23 
QuestionI would like to develope new project from scratch. I would like to use ASP.NET MVC 5.0, EntityFramework and SQL Server. Pin
Lad Kunal30-Jul-17 20:14
Lad Kunal30-Jul-17 20:14 
AnswerRe: I would like to develope new project from scratch. I would like to use ASP.NET MVC 5.0, EntityFramework and SQL Server. Pin
Richard MacCutchan30-Jul-17 20:42
mveRichard MacCutchan30-Jul-17 20:42 
AnswerRe: I would like to develope new project from scratch. I would like to use ASP.NET MVC 5.0, EntityFramework and SQL Server. Pin
indian1432-Aug-17 6:57
indian1432-Aug-17 6:57 
QuestionError message: The operation cannot be completed because the DbContext has been disposed Pin
indian14327-Jul-17 11:39
indian14327-Jul-17 11:39 
AnswerRe: Error message: The operation cannot be completed because the DbContext has been disposed Pin
Richard Deeming28-Jul-17 1:31
mveRichard Deeming28-Jul-17 1:31 
AnswerRe: Error message: The operation cannot be completed because the DbContext has been disposed Pin
Nathan Minier28-Jul-17 1:36
professionalNathan Minier28-Jul-17 1:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.