#c data base

Taigi turiu problemele:

http://www.part.lt/img/a5a58c37c4b2fec553e3f4bb524b31fc361.png

kodas:

{

public static SqlConnection Getconnection()

{

string connStr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pauli\OneDrive\Documents\Visual Studio 2015\Projects\WindowsFormsApplication1\WindowsFormsApplication1\WPC.mdf, Integrated Security=True";

SqlConnection conn = new SqlConnection(connStr);

return conn;

 

}

public static void AddUser(string vardas, string pavarde, string pareigos, string phone, string email)

{

SqlConnection conn = Getconnection();

conn.Open();

try

{

 

string insStmt = "INSERT INTO USER VALUE @vardas, @pavarde, @pareigos, @phone, @email";

 

SqlCommand insCmd = new SqlCommand(insStmt, conn);

insCmd.Parameters.AddWithValue("@vardas", vardas);

insCmd.Parameters.AddWithValue("@pavarde", pavarde);

insCmd.Parameters.AddWithValue("@pareigos", pareigos);

insCmd.Parameters.AddWithValue("@phone", phone);

insCmd.Parameters.AddWithValue("@email", email);

 

insCmd.ExecuteNonQuery();

}

catch (SqlException ex)

{

 

throw ex;

}

finally { conn.Close(); }

}

public static List<user>GetUser()

{

List<user> UserList = new List<user>();

SqlConnection conn = Getconnection();

string selStmt = "SELECT * FROM USER ORDER BY Vardas,Pavarde";

SqlCommand selCmd =new SqlCommand(selStmt, conn);

try

{

conn.Open();

SqlDataReader reader = selCmd.ExecuteReader();

while (reader.Read())

{

user hh = new user();

hh.DBNumber = (int)reader["ID"];

hh.Vardas = (string)reader["Vardas"];

hh.Pavarde = (string)reader["Pavarde"];

hh.Pareigos = (string)reader["Pareigos"];

hh.Phone = (string)reader["Phone"];

hh.Email = (string)reader["Email"];

 

 

}

reader.Close();

}

catch (SqlException ex)

{

 

throw ex;

}

finally { conn.Close(); }

return UserList;

}

}

}

Pabandyk į

string connStr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\pauli\OneDrive\Do...";

įdėti

User Instance=true