Dear Programmerhere the form code ltdiv class34textmid234gtAdviser Photo ltdivgtltdiv class34textright34gtAdviser Sign ltdivgtltdivgt ltdiv class34Row34gtltdiv class34viewimg134gt ltaspImageMap ID34imgADphoto34 runat34server34 Width34140px34 Height34150px34gt ltaspImageMapgt ltdivgt ltdiv class34viewsign134gt lta

AnkitPal saysSqlDataReader rdr cmdExecuteReader using rdr if rdrHasRows rdrRead txtCIDText rdrCIDToString imgADphotoImageUrl rdrCustPhotoToString else cnnClose Change the above line of code like belowSqlDataReader rdr cmdExecuteReaderwhile rdrRead imgADphotoImageUrl rdr34CustPhoto34ToString imgADsignImageUrl rdr34CustSign34ToStringcnnCloseAlso i have created sample please refer the below codeHTMLltdivgt ltaspTextBox runat34server34 ID34txtCID34 OnTextChanged34txtCIDOnTextChanged34 AutoPostBack34true34 gt ltbr gt ltdiv class34textmid234 style34float left34gt Advi

Display user image and signature on TextBox TextChange using C# in ASP.Net

AnkitPal

SOLVED CLOSED ACTIVE ANSWERED
User: AnkitPal
Posted: on Feb 22, 2016 02:39 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3803
Sample Code: Download

Dear Programmer,

here the form code -

<div class="textmid2">Adviser Photo :</div><div class="textright">Adviser Sign :</div></div>

        <div class="Row"><div class="view_img1">
            <asp:ImageMap ID="imgADphoto" runat="server" Width="140px" Height="150px">
            </asp:ImageMap>
        </div>

            <div class="view_sign1">
                <asp:ImageMap ID="imgADsign" runat="server" Width="200px" Height="70px">
                </asp:ImageMap>
            </div>

Code Behind for form code -

//code behind//
protected void txtCID_OnTextChanged(object sender, EventArgs e)
        {
            SqlConnection cnn = new SqlConnection();
            cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            cnn.Open();

            SqlCommand command = new SqlCommand("SELECT * FROM CIDNO_DETAILS where CID = '" + txtCID.Text + "'", cnn);
            SqlDataReader reader = command.ExecuteReader();
            using (reader)
            {
                if (reader.HasRows)
                {
                    reader.Read();

                    //to fill textboxes from database//
                    txtCID.Text = reader["CID"].ToString();
                    txtADname.Text = reader["CUST_NAME_CATE"].ToString() + " " + reader["CUST_FNAME"].ToString() + " " + reader["CUST_MNAME"].ToString() + " " + reader["CUST_LNAME"].ToString();
                    txtADfhname.Text = reader["FH_CAT"].ToString() + " " + reader["FH_NAME"].ToString();
                    txtADadd.Text = reader["PADD1"].ToString() + " " + reader["PADD2"].ToString() + " " + reader["PLAND"].ToString() + " " + reader["PCITY"].ToString() + " " + reader["PDISTRICT"].ToString() + " " + reader["PSTATE"].ToString() + " " + reader["PPIN"].ToString();
                    txtADmbl.Text = reader["PRMOB_NO"].ToString();
                    txtADidbr.Text = reader["BRCODE"].ToString() +" - "+ reader["BRNAME"].ToString();
                    txtADidadd.Text = reader["BRADD"].ToString();
                }
                else 
                {
                    Console.WriteLine("You Entred Invlid GPNL CID, Please Input Correct CID.");
                }
                cnn.Close();
                cnn.Open();
                SqlCommand cmd = new SqlCommand("select * from CID_Photos where CID = '" + txtCID.Text + "'", cnn);
                SqlDataReader rdr = cmd.ExecuteReader();
                using (rdr)
                {
                    if (rdr.HasRows)
                    {
                        rdr.Read();
                        txtCID.Text = rdr["CID"].ToString();
                        imgADphoto.ImageUrl = rdr["CustPhoto"].ToString();
                    }
                    else
                    {
                    }
                }
                cnn.Close();
            }
        }

Problem Faced -

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

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Feb 22, 2016 03:39 AM
Modified: on Sep 14, 2017 04:19 AM
Report

AnkitPal says:
SqlDataReader rdr = cmd.ExecuteReader();

                using (rdr)

                {

                    if (rdr.HasRows)

                    {

                        rdr.Read();

                        txtCID.Text = rdr["CID"].ToString();

                        imgADphoto.ImageUrl = rdr["CustPhoto"].ToString();

                    }

                    else

                    {

                    }

                }

                cnn.Close();

Change the above line of code like below.

SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
    imgADphoto.ImageUrl = rdr["CustPhoto"].ToString();
    imgADsign.ImageUrl = rdr["CustSign"].ToString();
}
cnn.Close();

Also i have created sample please refer the below code.

HTML

<div>
    <asp:TextBox runat="server" ID="txtCID" OnTextChanged="txtCID_OnTextChanged" AutoPostBack="true" />
    <br />
    <div class="textmid2" style="float: left;">
        Adviser Photo :<br />
        <div class="view_img1">
            <asp:ImageMap ID="imgADphoto" runat="server" Width="140px" Height="150px">
            </asp:ImageMap>
        </div>
    </div>
    <div class="textright" style="float: inherit;">
        Adviser Sign :<br />
        <div class="view_sign1">
            <asp:ImageMap ID="imgADsign" runat="server" Width="140px" Height="150px">
            </asp:ImageMap>
        </div>
    </div>
</div>

Code

protected void txtCID_OnTextChanged(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[] { new DataColumn("CID"), new DataColumn("CustPhoto"), new DataColumn("CustSign") });
    dt.Rows.Add("16020001", "~/Images/Chrysanthemum.jpg", "~/Images/Desert.jpg");
    dt.Rows.Add("16020002", "~/Images/Hydrangeas.jpg", "~/Images/Jellyfish.jpg");
    dt.Rows.Add("16020003", "~/Images/Koala.jpg", "~/Images/Lighthouse.jpg");
    dt.Rows.Add("16020004", "~/Images/Penguins.jpg", "~/Images/Tulips.jpg");

    string cId = txtCID.Text.Trim();
    DataRow rdr = (from row in dt.AsEnumerable()
                    where row.Field<string>("CID") == cId
                    select row).FirstOrDefault();

    imgADphoto.ImageUrl = rdr["CustPhoto"].ToString();
    imgADsign.ImageUrl = rdr["CustSign"].ToString();
}

Screenshot

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

Display user image and signature on TextBox TextChange using C# in ASP.Net

Company

Explore

Follow us

Contact Us