private void button1_Click(object sender, EventArgs e)
{
int flag = 0;
if (IsFormValid())
{
sqlconnection con = new sqlconnection();
SqlDataAdapter sda = new SqlDataAdapter(" Select Username,Password,Role from LoginTable where Username='******' and Password='******' ", con.openconn());
DataTable dt = new DataTable();
sda.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Username"].ToString() == usernametext.Text && dt.Rows[i]["Password"].ToString() == passwordtext.Text)
{
flag = 1;
if (dt.Rows[i]["Role"].ToString() == "Admin")
{
this.Hide();
MainForm obj = new MainForm();
obj.Show();
}
else if (dt.Rows[i]["Role"].ToString() == "User")
{
this.Hide();
Student_registration obj1 = new Student_registration();
obj1.Show();
}
}
}
if (flag == 0)
{
MessageBox.Show("Invalid Username/Pasword");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
Sqlconnection con = new sqlconnection(@"Data Source=DESKTOP-MRN8371\SQLEXPRESS;Initial Catalog=Food;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
con.open();
Sqlcommand cmd = new Sqlcommand("Select * from User tab" con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DataGridview1.Datasource = dt;
}
private void button3_Click(object sender, EventArgs e)
{
Sqlconnection con = new sqlconnection(@"Data Source=DESKTOP-MRN8371\SQLEXPRESS;Initial Catalog=Food;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
con.open();
Sqlcommand cmd = new Sqlcommand("Delete into User tab where ID=@ID", con);
cmd.Parameters.AddWithValue("@ID", int.Parse(textBox1.Text));
cmd ExcutionNonquery();
con Close();
MessageBox.Show("successfully Delete");
}
private void button1_Click(object sender, EventArgs e)
{
Sqlconnection con = new sqlconnection(@"Data Source=DESKTOP-MRN8371\SQLEXPRESS;Initial Catalog=Food;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
con.open();
Sqlcommand cmd = new Sqlcommand("insert into User tab values (@ID,@Food Name,@Price)"; con);
cmd.Parameters.AddWithValue("@ID", int.Parse(textBox1.Text));
cmd.Parameters.AddWithValue("@Food Name", (textBox2.Text);
cmd.Parameters.AddWithValue("@Price", double.Parse(textBox3.Text));
ProcessCmdKey ExcutionNonquery();
con Close();
MessageBox.Show("successfully insert");
}
// GET: sqlconectionobject
public ActionResult Index()
{
connString = @"data Source=(localdb)\MSSQLlocalDB;Initial Catalog=" dbAlgebra ";Integrated Security=True";
//Nakon toga instanca SQLconnection
sqlconnection con = new sqlconnection(connString);
try
{
conn.Open();
if (conn.ModelState == System.Data.ConnectionState)
{
Response.Write("Konekcija je uspjela");
}
}
{
static void Main(string[] args)
{
//LER ARQUIVO - criar arquivo primeiro
String nomeArq = Path.Combine(Directory.GetCurrentDirectory(), "dados.csv");
StreamReader arqEntrada = new StreamReader(nomeArq);
while (!arqEntrada.EndOfStream) //EndsOfStream vai ate o final do arquivo
{
String linha = arqEntrada.ReadLine();
String[] campos = linha.Split(';'); //quebra string por ';'
Console.Write("Name: {0} - CPF: {1} - Date: {2}\n", campos[0], campos[1], campos[2]);
}
arqEntrada.Close();
Console.ReadKey();
//TRATAMENTO DE EXCEÇÃO - em tempo de desenvolvimento
sqlconnection con = null;
try
{
con = new sqlconnection(); //tentar acessar o banco
con.open();
}
catch (SqlException erro) //erro de banco de dados SQL
{
}
catch (Exception erro) //outro tipo de exceção
{
}
finally //executado sempre, danco ou não erro (opcional)/recursos, cancelar execução
{
}
}
private static void updatedbwithexception(exception ex)
{
string connectionstring = @"data source = (localdb)\projectsv13; initial catalog = twentyonegame;
integrated security = true; connect timeout = 30; encrypt = false; trustservercertificate = false;
applicationintent = readwrite; multisubnetfailover = false";
string querystring = @"insert into exceptions (exceptiontype, exceptionmessage, timestamp) values
(@exceptiontype, @exceptionmessage, @timestamp)";
using (sqlconnection connection = new sqlconnection(connectionstring))
{
sqlcommand command = new sqlcommand(querystring, connection);
command.parameters.add("@exceptiontype", sqldbtype.varchar);
command.parameters.add("@exceptionmessage", sqldbtype.varchar);
command.parameters.add("@timestamp", sqldbtype.datetime);
command.parameters["@exceptiontype"].value = ex.gettype().tostring();
command.parameters["@exceptionmessage"].value = ex.message;
command.parameters["@timestamp"].value = datetime.now;
connection.open();
command.executenonquery();
connection.close();
}
}
Public void Insert()
{
sqlconnection con = new sqlconnection(connection);
