private vpid btnSubmit_Click(object sender, EventArgs e)
{
if (txtUsername.Text == "" || txtPassword.Text == "")
{
MessageBox.Show("Tolong isi bagian wajib");
}
else if (txtPassword.Text != textConfirmPassword.Text)
{
MessageBow.Show("Password salah");
}
else
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
sqlCommand sqlCmd = new sqlCommand("UserAdd", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@First Name", txtFirstName.Text.Trim());
sqlCmd.Parameters.AddWithValue("@LastName", txtLastName.Text.Trim());
sqlCmd.Parameters.AddWithValue("@Username", txtUsername.Text.Trim());
sqlCmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
sqlCmd.ExecuteNonQuery();
MessageBox.Show("Registration is successfull");
Clear();
}
}
}
public static bool QryUpdDelCre(string cmdExec, ref DataSet dsResponse)
{
iDB2DataReader DB2UdbDataReader;
string mstrQueryObject = string.Empty;
string mstrError;
mstrQueryObject = cmdExec;
sqlCommand DB2Cmd = new sqlCommand(mstrQueryObject);
if (mstrQueryObject.Contains("SELECT "))
{
try
{
DB2UdbDataReader = DB2Cmd.DB2UdbCommand.ExecuteReader();
}
catch (iDB2Exception e)
{
mstrError = "Source: " + e.Source + Environment.NewLine +
"Message: " + e.Message + Environment.NewLine +
"MessageDetails: " + e.MessageDetails + Environment.NewLine +
"MessageCode: " + e.MessageCode + Environment.NewLine +
"SqlState: " + e.SqlState + Environment.NewLine +
"iDB2Exception type: " + e.GetType().ToString() +
Environment.NewLine + Environment.NewLine +
"There are " + e.Errors.Count.ToString() +
" errors in the error collection.";
Console.WriteLine(mstrError);
return(false);
}
DataTable table = new DataTable();
for (int i = 0; i <= DB2UdbDataReader.FieldCount - 1; i++)
{
table.Columns.Add();
}
while (DB2UdbDataReader.Read())
{
DataRow dr = table.NewRow();
for (int i = 0; i <= DB2UdbDataReader.FieldCount - 1; i++)
{
if (DB2UdbDataReader[i] != DBNull.Value)
{
dr[i] = DB2UdbDataReader.GetString(i);
}
}
table.Rows.Add(dr);
}
DB2UdbDataReader.Close();
DB2UdbDataReader = null;
dsResponse.Tables.Add(table);
}
return(true);
}
private void Connect()
{
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
if (sqlConnection.state == ConnectionState.Closed)
{
sqlConnection.Open();
}
using (SqlCommand sqlCommand = new sqlCommand(String.Format("SELECT * FROM", sqlConnection)))
{
IDataReader dataReader = sqlCommand.ExecuteReader();
while (dataReader.Read())
{
}
}
}
