목차
[ProjectTest]
[bin]
[obj]
[Properties]
BookRoom01.cs
BookRoom01.Designer.cs
BookRoom01.resx
DBCONNECT.cs
Program.cs
ProjectTest.csproj
ProjectTest.sln
ProjectTest.suo
USERTABLE.bak
1.75MB
파일 28
폴더 8
[bin]
[obj]
[Properties]
BookRoom01.cs
BookRoom01.Designer.cs
BookRoom01.resx
DBCONNECT.cs
Program.cs
ProjectTest.csproj
ProjectTest.sln
ProjectTest.suo
USERTABLE.bak
1.75MB
파일 28
폴더 8
본문내용
BookRoom01.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
namespace ProjectTest
{
public partial class BookRoom01 : Form
{
public SqlConnection sct;
private int no = 0;
private SqlCommand scm = null;
private string inup;
public void cmb(ComboBox cb, ArrayList list, string val)
{
cb.SelectedValue = val;
cb.DataSource = list;
cb.ValueMember = \"val\";
cb.DisplayMember = \"dis\";
}
public static SqlConnection ConnectionProvider()
{
return new SqlConnection(DBCONNECT.connect);
}
public DataSet getDataSet(string query)
{
SqlDataAdapter qeqp = null;
DataSet ds = null;
sct = ConnectionProvider();
qeqp = new SqlDataAdapter(query, sct);
ds = new DataSet();
qeqp.Fill(ds, \"tb\");
return ds;
}
public int nonquery(string query)
{
sct = ConnectionProvider();
no = 0;
scm = new SqlCommand(query, sct);
sct.Open();
no = scm.ExecuteNonQuery();
return no;
}
public BookRoom01()
{
InitializeComponent();
}
private void BookRoom01_Load(object sender, EventArgs e)
{
yn();
tableSrh();
}
private void tableSrh()
{
string test = \"select userid,usernm,userno,major,joindt,quitdt,yn from usertable \"
+ \"where 1=1 and usernm like \'%\" + srhusernm.Text + \"%\' and userno like \'%\" + srhuserno.Text + \"%\'\";
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
namespace ProjectTest
{
public partial class BookRoom01 : Form
{
public SqlConnection sct;
private int no = 0;
private SqlCommand scm = null;
private string inup;
public void cmb(ComboBox cb, ArrayList list, string val)
{
cb.SelectedValue = val;
cb.DataSource = list;
cb.ValueMember = \"val\";
cb.DisplayMember = \"dis\";
}
public static SqlConnection ConnectionProvider()
{
return new SqlConnection(DBCONNECT.connect);
}
public DataSet getDataSet(string query)
{
SqlDataAdapter qeqp = null;
DataSet ds = null;
sct = ConnectionProvider();
qeqp = new SqlDataAdapter(query, sct);
ds = new DataSet();
qeqp.Fill(ds, \"tb\");
return ds;
}
public int nonquery(string query)
{
sct = ConnectionProvider();
no = 0;
scm = new SqlCommand(query, sct);
sct.Open();
no = scm.ExecuteNonQuery();
return no;
}
public BookRoom01()
{
InitializeComponent();
}
private void BookRoom01_Load(object sender, EventArgs e)
{
yn();
tableSrh();
}
private void tableSrh()
{
string test = \"select userid,usernm,userno,major,joindt,quitdt,yn from usertable \"
+ \"where 1=1 and usernm like \'%\" + srhusernm.Text + \"%\' and userno like \'%\" + srhuserno.Text + \"%\'\";
소개글