1
Answer

How to search for a particular phrase in Excel and copy it ?

Irenus Kassii

Irenus Kassii

9y
389
1
I need an algorythm that will search for a particular phrase in Excel file (f.e. a cell containing "Anna") and copy the value of the opposite cell  to GridView that it to say synchronize two databases. Synchronising and copying the whole file will not suit me because every time the position of "Anna" cell (both row and column) will be unpredictable.
in Excel
Name - Phone number
Anna - 007655456586
Mary - 007945685675
in GridView () 
Name - Phone Number 
Anna - .... 
Mary - .... 
 
Answers (1)
1
Santhosh Kumar Jayaraman

Santhosh Kumar Jayaraman

NA 9.9k 2.3m 12y
In the dropdownlist selection changed event

if (DropDownList1.SelectedIndex != 0)

{
string strValue = string.Empty;
SqlConnection con = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;");
SqlCommand cmd = new SqlCommand(" select Empname from Employee where empid='"+ DropDownList1.SelectedValue.ToString()+"'", con);
con.Open();
strValue = (string)cmd.ExecuteScalar();
con.Close();
TextBox1.Text = strValue;
}
Accepted
0
prakash kumawat

prakash kumawat

NA 3 700 10y
what to do if the selection mode is multiple in listbox and I want to display those records which are selected in the list box
0
Satyapriya Nayak

Satyapriya Nayak

NA 53k 8m 12y
Hi Richa,


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Dropdownlist_click_data_in_textbox._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server"
            onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        </asp:DropDownList><br />
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    </div>
   
    </form>
</body>
</html>





using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Dropdownlist_click_data_in_textbox
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str;
        SqlCommand com;
        protected void Page_Load(object sender, EventArgs e)
        {
            DropDownList1.AutoPostBack = true;
            SqlConnection con = new SqlConnection(strConnString);

            if (!IsPostBack)
            {
                DropDownList1.Items.Add("Choose id");
                con.Open();
                str = "select * from  test";
                com = new SqlCommand(str, con);
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    DropDownList1.Items.Add(reader["id"].ToString());
                }
                reader.Close();
                con.Close();
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from test where id='" + DropDownList1.SelectedItem.Text + "'";
            com = new SqlCommand(str, con);
            SqlDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                TextBox1.Text = reader["name"].ToString();
               
            }
            reader.Close();
            con.Close();
        }
    }
}



Thanks
If this post helps you mark it as answer