CODEWITHSUNDEEP
c#asp.net
Gopal
Gopal

Reputation: 11982

How to get a runtime control id

Using asp.net and c#

Asp.net code

<asp:Button ID="btnAddNew" runat="server" Text="Add New" 
        onclick="btnAddNew_Click" />
    <div id="divAdd" runat="server" style="display:none" >  
    <table width="100%">
        <tr>
            <td colspan="1">First Name :</td>
            <td colspan="1" align="left"><asp:TextBox ID="txtFName" runat="server" ></asp:TextBox> </td>
        </tr>
        <tr>
            <td colspan="1">Last Name :</td>
            <td colspan="1" align="left"><asp:TextBox ID="txtLName" runat="server" ></asp:TextBox>  </td>
        </tr>
        <tr>
            <td colspan="1">Date Of Birth :</td>
            <td colspan="1" align="left"><asp:TextBox ID="txtDob" runat="server" ></asp:TextBox>  </td>
        </tr>
        <tr>
            <td colspan="1">Age :</td>
            <td colspan="1" align="left" ><asp:TextBox ID="txtAge" runat="server" ></asp:TextBox> </td>
        </tr>
        <tr>

            <td colspan="2" align="center">
                <asp:Button ID="btnSave" runat="server" Text="Save"  OnClientClick=" return validate()" type="submit"   />

                <asp:Button ID="btnClose" runat="server" Text="Close" OnClientClick ="return clear()" type="submit" />
            </td>
        </tr>
    </table>
    </div>

C# Code

static void Insert()
    {
        try
        {
            string connectionString =
                "server=JEBW1011ZAHID;" +        
                "initial catalog=employee;" + 
                "integrated security = true";             
            using (SqlConnection conn =
                new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(
                    "INSERT INTO [NyhedTB] ([NyhedDato], [NyhedTitel], [NyhedTekst]) " +
                    "VALUES (@NyhedDato, @NyhedTitel, @NyhedTekst)", conn))
                {
                    cmd.Parameters.AddWithValue("@NyhedDato", txtfname.Text);
                    cmd.Parameters.AddWithValue("@NyhedTitel", txtlanme.Text);
                    cmd.Parameters.AddWithValue("@NyhedTekst", txtage.Text);

                    int rows = cmd.ExecuteNonQuery();  // Inserted rows number
                }
            }
        }
        catch (SqlException ex)
        {
            //Log exception
            //Display Error message
        }

    }

Showing error as txtfname does not exist.

Need code help

Upvotes: 0

Views: 351

Answers (2)

Ramesh Rajendran
Ramesh Rajendran

Reputation: 38683

Remove the static in your method

Put this code public void Insert() instead of static void Insert()

Upvotes: 0

Darin Dimitrov
Darin Dimitrov

Reputation: 1038810

You Insert method is static. It doesn't have access to any page elements. I would recommend you passing those values as parameters to the method instead of coupling it with your UI:

static void Insert(string fName, string lName, string age)
{
    try
    {
        string connectionString =
            "server=JEBW1011ZAHID;" +        
            "initial catalog=employee;" + 
            "integrated security = true";             
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            using (SqlCommand cmd = new SqlCommand(
                "INSERT INTO [NyhedTB] ([NyhedDato], [NyhedTitel], [NyhedTekst]) " +
                "VALUES (@NyhedDato, @NyhedTitel, @NyhedTekst)", conn))
            {
                cmd.Parameters.AddWithValue("@NyhedDato", fName);
                cmd.Parameters.AddWithValue("@NyhedTitel", lName);
                cmd.Parameters.AddWithValue("@NyhedTekst", age);

                int rows = cmd.ExecuteNonQuery();  // Inserted rows number
            }
        }
    }
    catch (SqlException ex)
    {
        //Log exception
        //Display Error message
    }
}

and then when calling this method from your code behind you could pass whatever values you want:

protected void SomeButton_Click(object sender, EventArgs e)
{
    Insert(txtfname.Text, txtlanme.Text, txtage.Text);
}

Now your Insert method is a little more reusable as it is no longer coupled to your UI.

Upvotes: 6

Related Questions