Fetching values of same field from database in different textbox

dreamsde...

SOLVED CLOSED ACTIVE ANSWERED
User: dreamsdesign.in01
Posted: on Oct 08, 2013 02:14 AM
Forum: Data Controls
Answer: 1
Views: 2831

I have one page on which there are 6 labels and six text box for subject apart from this there are 2 to 3 other text box and label for studnt information. i want to do in such a way that if i enter student enroll no i get his/her name ,dept,sem,all subjects on 6 labels and marks related to subject in text box.

In table there are fields

Marks_Entry

Student_Enroll Student_Name Sem Program subject Marks

1 sss 1 BCA Basic Communication Skills 75

1 sss 1 BCA Mathematical Foundation 85

1 sss 1 BCA Digital Computer Architecture 88

1 sss 1 BCA Programming concepts & Algorithms 97

1 sss 1 BCA Introduction to Database 55

1 sss 1 BCA Introduction to PC Software 74

now when i am entering roll no in form then student name ,program, sem is fetched but in label 1 to label 6 same subject name that is 1st subject name is copied and in text box also first marks are fetched in all textboxes

my c# code on student enroll textbox is this

protected void txtEnroll_TextChanged1(object sender, EventArgs e)
    {
        conn.Open();
        qry = "SELECT * FROM Marks_Entry WHERE Student_Enroll_No = '" + txtEnroll.Text + "'";

        SqlCommand cmd = new SqlCommand(qry, conn);
        SqlDataReader dr = cmd.ExecuteReader();
        //DataSet ds = new DataSet();

        if (dr.Read() == true)
        {
            txtname.Text = dr.GetValue(4).ToString();
            txtprog.Text = dr.GetValue(5).ToString();
            txtSem.Text = dr.GetValue(1).ToString();


            
            lbl1.Text = dr.GetValue(2).ToString();
            lbl2.Text = dr.GetValue(2).ToString();
            lbl3.Text = dr.GetValue(2).ToString();
            lbl4.Text = dr.GetValue(2).ToString();
            lbl5.Text = dr.GetValue(2).ToString();
            lbl6.Text = dr.GetValue(2).ToString();
            
            txt1.Text = dr[6].ToString();
            txt2.Text = dr[6].ToString();
            txt3.Text = dr[6].ToString();
            txt4.Text = dr[6].ToString();
            txt5.Text = dr[6].ToString();
            txt6.Text = dr[6].ToString();

        }

        dr.Close();
        conn.Close();

}

plz help me in this how can i get different values? from database

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 2

Reply
ANSWER
User: kalpesh
Replied: on Oct 08, 2013 07:14 AM
Report

Kindly check an below Example for your referance

I have Same Table name as Marks_Entry In which Student marks details Stored .

Below is design of Web Page .

<form id="form1" runat="server">
    <div>
        <table>
        <tr>
        <td colspan="3">
        Enroll No
        </td>
        <td>
        <asp:TextBox ID="txtEnroll" runat="server"  AutoPostBack="true" 
                ontextchanged="txtEnroll_TextChanged" ></asp:TextBox>
        </td>
        </tr>
            <tr><td>Student Enroll</td>
                <td>Name</td>
                <td>Sem</td>
                <td>Program</td>
                <td>Subject</td>
                <td>Marks</td>
            </tr>
            <tr>
                <td>
                    <asp:TextBox ID="txtStudentEnroll" runat="server"></asp:TextBox>
                </td>
                <td>
                    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                </td>
                <td>
                    <asp:TextBox ID="txtSem" runat="server"></asp:TextBox>
                </td>
                <td>
                    <asp:TextBox ID="txtProgram" runat="server"></asp:TextBox>
                </td>
                <td>
                    <asp:Label ID="lbl1" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt1" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                    <asp:Label ID="lbl2" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt2" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                    <asp:Label ID="lbl3" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt3" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                    <asp:Label ID="lbl4" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt4" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                    <asp:Label ID="lbl5" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt5" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
                <td>
                    <asp:Label ID="lbl6" runat="server" Text=""></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt6" runat="server" Text=""></asp:TextBox>
                </td>
            </tr>
        </table>
    </div>
    </form>

When user Enter EnollmentNo and change the focus from textbox.

It will Display The detils of Student Marks Details Depending on Enrollment No .

  protected void txtEnroll_TextChanged(object sender, EventArgs e)
    {       
        txtName.Text = string.Empty;
        txtStudentEnroll.Text=string.Empty;
        txtSem.Text =string.Empty;
        txtProgram.Text = string.Empty;

        string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        SqlConnection con = new SqlConnection(strConnString);

        SqlCommand cmd = new SqlCommand("Select * From Marks_Entry Where EnrollNo =@Enroll ");
        cmd.Parameters.AddWithValue("@Enroll", txtEnroll.Text.Trim());

        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        con.Open();
        
        SqlDataAdapter da = new SqlDataAdapter();
        DataSet ds = new DataSet();

        da.SelectCommand = cmd;
        da.Fill(ds);

        Label lbl = new Label();
        TextBox txt = new TextBox();

        txtName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
        txtStudentEnroll.Text = ds.Tables[0].Rows[0]["EnrollNo"].ToString();
        txtSem.Text = ds.Tables[0].Rows[0]["Sem"].ToString();
        txtProgram.Text = ds.Tables[0].Rows[0]["Program"].ToString();

        for (int i = 1; i <= ds.Tables[0].Rows.Count; i++)
        {
            lbl = (Label)FindControl("lbl" + i.ToString());
            txt = (TextBox)FindControl("txt" + i.ToString()); 

            lbl.Text = ds.Tables[0].Rows[i-1]["Subject"].ToString();
            txt.Text = ds.Tables[0].Rows[i-1]["Marks"].ToString();
        }
        con.Close();
    }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Fetching values of same field from database in different textbox

Company

Explore

Follow us

Contact Us