Reply to thread

Message

<blockquote data-quote="Core" data-source="post: 10769205" data-attributes="member: 263471">[CODE].CS Fileusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.IO;using System.Data.SqlClient;namespace DataBase_UserDetails{&nbsp; &nbsp; public partial class Form1 : Form&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; string connectionString;&nbsp; &nbsp; &nbsp; &nbsp; public Form1()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; InitializeComponent();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connectionString = @&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=Database1 - Copy.mdf;Integrated Security=True;User Instance=True&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //Create a New Table&nbsp; &nbsp; &nbsp; &nbsp; private void btnCreate_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection SqlCon = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCon.Open(); //open the connection&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandStr = &quot;CREATE TABLE users(&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_id INT NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_name VARCHAR(40) NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_email VARCHAR(40) NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_pass VARCHAR(40) NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_registration_date DATETIME NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;user_state VARCHAR(10) NOT NULL,&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;PRIMARY KEY(user_id))&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandStr, SqlCon);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCon.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message, &quot;Error&quot;,MessageBoxButtons.OK,MessageBoxIcon.Error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //Create a DataBase&nbsp; &nbsp; &nbsp; &nbsp; private void btn_newDB_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandStr = &quot;CREATE DATABASE Core&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandStr);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message, &quot;Error&quot;, MessageBoxButtons.OK, MessageBoxIcon.Error);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //create new field&nbsp; &nbsp; &nbsp; &nbsp; private void btnInsert_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open(); //open the connection&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandStr = &quot;INSERT INTO users(user_id, user_name, user_email, user_pass, user_registration_date, user_state)&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; VALUES(@userID,@userName,@email,@userPass,@date,@userState)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandStr, con);//create an object from the sqlcommand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userID&quot;, txtID.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userName&quot;, txtName.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@email&quot;, txtEmail.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userPass&quot;, txtPass.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@date&quot;, DateTime.Now);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userState&quot;, txtState.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //UPDATE&nbsp; &nbsp; &nbsp; &nbsp; private void btnUpdate_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();//open the connection between the database and the application&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandString = &quot;UPDATE users SET &quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;user_name=@userName,user_email=@email,user_pass=@userPass,&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;user_registration_date=@date,user_state=@userState WHERE user_id=@selectedID&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string selectedID = treeView1.SelectedNode.Text;//get the selected index value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandString, con);//make the SQL command object&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@selectedID&quot;, selectedID);//replace the @selectedId with selected value on treenode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //get the selected index value from the treeview &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //and then replace that with SQL string command&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //therefore the condition is id everything related that ID will be updated.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //following fields will replace the txt boxes with SQL command parameters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userName&quot;,txtName.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@email&quot;,txtEmail.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userPass&quot;,txtPass.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@date&quot;,DateTime.Now);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userState&quot;,txtState.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();//execute the command&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //SELECT ALL&nbsp; &nbsp; &nbsp; &nbsp; private void btnSelectAll_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; treeView1.Nodes.Clear();//clear all nodes if there are any remaining&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandString = &quot;SELECT * FROM users&quot;;//get everything from the users table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandString, con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader reader;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; reader = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (reader.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TreeNode mainNode =&nbsp; treeView1.Nodes.Add(reader[&quot;user_id&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_name&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_email&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_pass&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_registration_date&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_state&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //Delete data Field&nbsp; &nbsp; &nbsp; &nbsp; private void btnDelete_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandStr = &quot;DELETE FROM users WHERE user_id=@userID&quot;;//just select the primary key so it will delete the entire row&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandStr, con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;userID&quot;, treeView1.SelectedNode.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //Select the TreeNode&nbsp; &nbsp; &nbsp; &nbsp; private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TreeNode indexNode = treeView1.SelectedNode;//get the selected node&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtID.Text = indexNode.Text;//get the index id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtName.Text = indexNode.Nodes[0].Text;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtEmail.Text = indexNode.Nodes[1].Text;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtPass.Text = indexNode.Nodes[2].Text;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtDate.Text = indexNode.Nodes[3].Text;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtState.Text = indexNode.Nodes[4].Text;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //search Keyword&nbsp; &nbsp; &nbsp; &nbsp; //IN SQL SERVER EXPREE DON&quot;T USE '' SINGLE QUOTATION MARKS OR % WHEN COMPARE LIKE OR NOT LIKE&nbsp; &nbsp; &nbsp; &nbsp; //NEARLY EQUALITY&nbsp; &nbsp; &nbsp; &nbsp; private void btnSearch_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /*&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * user_name=@userName,user_email=@email,user_pass=@userPass,&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;user_registration_date=@date,user_state=@userState&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionString);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string commandStr = &quot;SELECT * FROM users WHERE (user_name LIKE @userName) OR&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;(user_email LIKE @userEmail) OR (user_pass LIKE @userPass) OR &quot; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;(user_registration_date LIKE @userReg) OR (user_state LIKE @userState)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(commandStr, con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //replace the parameters with the C# components&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userName&quot;, txtSearchKey.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userEmail&quot;, txtSearchKey.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userPass&quot;, txtSearchKey.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userReg&quot;, txtSearchKey.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@userState&quot;, txtSearchKey.Text);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader reader = cmd.ExecuteReader(); ;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (reader.Read())//read the next record if non of record found return 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TreeNode mainNode = treeView1.Nodes.Add(reader[&quot;user_id&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_name&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_email&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_pass&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_registration_date&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainNode.Nodes.Add(reader[&quot;user_state&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(error.Message);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private void btnClear_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; treeView1.Nodes.Clear();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]Instructions First add a Server SQL Database into the solution explorer and just proceed with above codes.!Copyright NoticeAll Source Codes belong to Core and don't mess with my codes without my permission.I made this on another forum which I can't mention in here. <img src="http://www.elakiri.com/forum/images/icons/sq/7.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />but thought make the same thing in here is useful.</blockquote>

[QUOTE="Core, post: 10769205, member: 263471"] [CODE] .CS File using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using System.Data.SqlClient; namespace DataBase_UserDetails { public partial class Form1 : Form { string connectionString; public Form1() { InitializeComponent(); connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=Database1 - Copy.mdf;Integrated Security=True;User Instance=True"; } //Create a New Table private void btnCreate_Click(object sender, EventArgs e) { SqlConnection SqlCon = new SqlConnection(connectionString); SqlCon.Open(); //open the connection string commandStr = "CREATE TABLE users("+ "user_id INT NOT NULL," + "user_name VARCHAR(40) NOT NULL," + "user_email VARCHAR(40) NOT NULL," + "user_pass VARCHAR(40) NOT NULL," + "user_registration_date DATETIME NOT NULL," + "user_state VARCHAR(10) NOT NULL," + "PRIMARY KEY(user_id))"; SqlCommand cmd = new SqlCommand(commandStr, SqlCon); try { cmd.ExecuteNonQuery(); SqlCon.Close(); } catch (Exception error) { MessageBox.Show(error.Message, "Error",MessageBoxButtons.OK,MessageBoxIcon.Error); } } //Create a DataBase private void btn_newDB_Click(object sender, EventArgs e) { string commandStr = "CREATE DATABASE Core"; SqlCommand cmd = new SqlCommand(commandStr); try { cmd.ExecuteNonQuery(); } catch (Exception error) { MessageBox.Show(error.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } //create new field private void btnInsert_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); con.Open(); //open the connection string commandStr = "INSERT INTO users(user_id, user_name, user_email, user_pass, user_registration_date, user_state)" + " VALUES(@userID,@userName,@email,@userPass,@date,@userState)"; SqlCommand cmd = new SqlCommand(commandStr, con);//create an object from the sqlcommand cmd.Parameters.AddWithValue("@userID", txtID.Text); cmd.Parameters.AddWithValue("@userName", txtName.Text); cmd.Parameters.AddWithValue("@email", txtEmail.Text); cmd.Parameters.AddWithValue("@userPass", txtPass.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now); cmd.Parameters.AddWithValue("@userState", txtState.Text); try { cmd.ExecuteNonQuery(); con.Close(); } catch (Exception error) { MessageBox.Show(error.Message); } } //UPDATE private void btnUpdate_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); con.Open();//open the connection between the database and the application string commandString = "UPDATE users SET "+ "user_name=@userName,user_email=@email,user_pass=@userPass,"+ "user_registration_date=@date,user_state=@userState WHERE user_id=@selectedID"; string selectedID = treeView1.SelectedNode.Text;//get the selected index value SqlCommand cmd = new SqlCommand(commandString, con);//make the SQL command object cmd.Parameters.AddWithValue("@selectedID", selectedID);//replace the @selectedId with selected value on treenode //get the selected index value from the treeview //and then replace that with SQL string command //therefore the condition is id everything related that ID will be updated. //following fields will replace the txt boxes with SQL command parameters cmd.Parameters.AddWithValue("@userName",txtName.Text); cmd.Parameters.AddWithValue("@email",txtEmail.Text); cmd.Parameters.AddWithValue("@userPass",txtPass.Text); cmd.Parameters.AddWithValue("@date",DateTime.Now); cmd.Parameters.AddWithValue("@userState",txtState.Text); try { cmd.ExecuteNonQuery();//execute the command con.Close(); } catch (Exception error) { MessageBox.Show(error.Message); } } //SELECT ALL private void btnSelectAll_Click(object sender, EventArgs e) { treeView1.Nodes.Clear();//clear all nodes if there are any remaining SqlConnection con = new SqlConnection(connectionString); con.Open(); string commandString = "SELECT * FROM users";//get everything from the users table SqlCommand cmd = new SqlCommand(commandString, con); SqlDataReader reader; try { reader = cmd.ExecuteReader(); while (reader.Read()) { TreeNode mainNode = treeView1.Nodes.Add(reader["user_id"].ToString()); mainNode.Nodes.Add(reader["user_name"].ToString()); mainNode.Nodes.Add(reader["user_email"].ToString()); mainNode.Nodes.Add(reader["user_pass"].ToString()); mainNode.Nodes.Add(reader["user_registration_date"].ToString()); mainNode.Nodes.Add(reader["user_state"].ToString()); } } catch (Exception error) { MessageBox.Show(error.Message); } } //Delete data Field private void btnDelete_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); con.Open(); string commandStr = "DELETE FROM users WHERE user_id=@userID";//just select the primary key so it will delete the entire row SqlCommand cmd = new SqlCommand(commandStr, con); cmd.Parameters.AddWithValue("userID", treeView1.SelectedNode.Text); try { cmd.ExecuteNonQuery(); con.Close(); } catch (Exception error) { MessageBox.Show(error.Message); } } //Select the TreeNode private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { TreeNode indexNode = treeView1.SelectedNode;//get the selected node txtID.Text = indexNode.Text;//get the index id txtName.Text = indexNode.Nodes[0].Text; txtEmail.Text = indexNode.Nodes[1].Text; txtPass.Text = indexNode.Nodes[2].Text; txtDate.Text = indexNode.Nodes[3].Text; txtState.Text = indexNode.Nodes[4].Text; } //search Keyword //IN SQL SERVER EXPREE DON"T USE '' SINGLE QUOTATION MARKS OR % WHEN COMPARE LIKE OR NOT LIKE //NEARLY EQUALITY private void btnSearch_Click(object sender, EventArgs e) { /* * user_name=@userName,user_email=@email,user_pass=@userPass,"+ "user_registration_date=@date,user_state=@userState */ SqlConnection con = new SqlConnection(connectionString); con.Open(); string commandStr = "SELECT * FROM users WHERE (user_name LIKE @userName) OR" + "(user_email LIKE @userEmail) OR (user_pass LIKE @userPass) OR " + "(user_registration_date LIKE @userReg) OR (user_state LIKE @userState)"; SqlCommand cmd = new SqlCommand(commandStr, con); //replace the parameters with the C# components cmd.Parameters.AddWithValue("@userName", txtSearchKey.Text); cmd.Parameters.AddWithValue("@userEmail", txtSearchKey.Text); cmd.Parameters.AddWithValue("@userPass", txtSearchKey.Text); cmd.Parameters.AddWithValue("@userReg", txtSearchKey.Text); cmd.Parameters.AddWithValue("@userState", txtSearchKey.Text); try { SqlDataReader reader = cmd.ExecuteReader(); ; while (reader.Read())//read the next record if non of record found return 0 { TreeNode mainNode = treeView1.Nodes.Add(reader["user_id"].ToString()); mainNode.Nodes.Add(reader["user_name"].ToString()); mainNode.Nodes.Add(reader["user_email"].ToString()); mainNode.Nodes.Add(reader["user_pass"].ToString()); mainNode.Nodes.Add(reader["user_registration_date"].ToString()); mainNode.Nodes.Add(reader["user_state"].ToString()); } } catch (Exception error) { MessageBox.Show(error.Message); } } private void btnClear_Click(object sender, EventArgs e) { treeView1.Nodes.Clear(); } } }[/CODE][B]Instructions First add a Server SQL Database into the solution explorer and just proceed with above codes.![/B] [B][COLOR=Red]Copyright Notice All Source Codes belong to Core and don't mess with my codes without my permission.[/COLOR][/B] I made this on another forum which I can't mention in here. [IMG]http://www.elakiri.com/forum/images/icons/sq/7.gif[/IMG] but thought make the same thing in here is useful. [/QUOTE]

Verification

Dawasata paya keeyak thibeda?

Latest ads

Reply to thread