C#

string baglan = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=veritabani.mdb";<br />
conn = new OleDbConnection(baglan);<br />
conn.Open();<br />
string query = "Insert Into Users(username,password) values('" + txtusername.Text +"','"+ txtpassword.Text+"')";<br />
OleDbDataAdapter da = new OleDbDataAdapter(query ,conn );<br />
DataSet ds = new DataSet();<br />
da.Fill(ds);<br />
conn.Close();<br />

eggsovereasy wrote:

Once you get it working you really should make a method to go through the textboxes and strip out some characters.

object GetDefaultValue(object SysTypeValue)
{
return Activator.CreateInstance(SysTypeValue.GetType());
}

try{<br />
int stocktype = Convert.ToInt16(tbStockTypeId.Text);<br />
  if(stocktype <= 0) { <br />
    //do stuff<br />
  }<br />
}<br />
catch(FormatException fexc){<br />
  Messagebox(tbStockTypeId.Text + "Is not a number");<br />
}

J4amieC wrote:

the user making an invalid entry is not exceptional, it is expected

<br />
short outint;<br />
if (!Int16.TryParse(tbStockTypeId.Text, out outint)) {<br />
	throw new ArgumentException("Argument is not integer", "tbStockTypeId");<br />
}<br />
//use outint<br />