즐겁게 살자

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml.Linq;
using System.Xml;
using System.IO;
using System.ComponentModel;
using System.Collections;

namespace WebService
{   

            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select * from Student";

            SqlDataAdapter ad = new SqlDataAdapter();
            ad.SelectCommand = cmd;
            DataSet ds = new DataSet();
            ad.Fill(ds);

            List<Student> studentlist;
            studentlist = new List<Student>();

            foreach (DataRowView rw in ds.Tables[0].Rows)
            {
                Student std = new Student();
                std.name = rw["Name"].ToString();
                std.age=rw["Age"].ToString();

                studentlist.Add(std);
            }
            return studentlist;
        }
    }

        public class Student
        {
            public string name {get; set;}
            public string age {get; set;}
        }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.ServiceModel.Channels;
using System.ServiceModel;
using System.Collections.ObjectModel;

namespace Demo
{
    public MainPage()
        {
            InitializeComponent();
            studentList = new List<Student>();

            this.Loaded += new RoutedEventHandler(MainPage_Loaded);
        }

        void MainPage_Loaded(object sender, RoutedEventArgs e)
        {

            StudentListService.CompanyListSoapClient com = new StudentListService.StudentListSoapClient();

            com.GetStudentCompleted += new EventHandler<StudentListService.GetStudentCompletedEventArgs>(com_GeStudentCompleted);
            com.GetStudentAsync();
        }

        void com_GetStudentCompleted(object sender, StudentListService.GetStudentCompletedEventArgs e)
        {
               // 바인딩
        }
}

// Set parent window’s hidden field value from child window
window.opener.document.getElementById(Client ID of Hidden Field).value = Selected IDs;

// raise button click event of parent window
window.opener.document.getElementById(Client ID Of Button).click();

// Close the child window
close();

Fig – (1) Javascript on child window to raise button click event on parent window

I had written this script on child page. Tis will raise button click event and in post back I wrote the logic of retrieving data from database for IDs set in hidden field and displayed them in grid.

Now the second way, call javascript function of parent window from child window.

<script language="Javascript" type="text/javascript">
    function CallAlert()
    {
        alert("This is parent window's alert function.");
    }
</script>

Fig – (2) Javascript on parent window.

<script language="Javascript" type="text/javascript">

    function SetParentWindowsHiddenFieldValue()
    {
        window.opener.document.getElementById("HiddenField1").value =
                            document.getElementById("TextBox1").value;
        return false;
    } 

    function CallParentWindowFunction()
    {
        window.opener.CallAlert();
        return false;
    }
</script>

Fig – (3) Javascript on child window

<connectionStrings>
　<add name="MyDB" connectionString="Data Source=[서버];Initial Catalog=[DB명];
UserID=[아이디];Password=[비밀번호]" providerName="System.Data.SqlClient"/>
</connectionStrings>

SqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString);