namespace WindowsLogin
{
public partial class Formcreate : Form
{
private SqlDbconnect con;
public Formcreate()
{
InitializeComponent();
}
private void btninsert_Click(object sender, EventArgs e)
{
btninsert_Click(sender, e, con);
}
private void btninsert_Click(object sender, EventArgs e, SqlDbconnect con)
{
con = new SqlDbconnect();
con.SqlQuery("INSERT INTO USERS_TABLE ('Username') VALUES (@UsernameP) ");
System.Data.SqlClient.SqlCommand cmd = con.cmd;
cmd.Parameters.Add("@UsernameP", textBox1.Text.Trim());
con.NonQueryEx();
con.SqlQuery("SELECT * FROM TEST");
foreach (DataRow dr in con.QueryEx().Rows)
{
cbtype.Items.Add(dr[1].ToString());
}
}
}
}
