sad sam doso da one korisnike napravim da izbaci kad kliknem na show ali nesto neradi, nepokazuje mi nikakve greske nego nece da ji prikaze gdje sam sad pogresio
/code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace wpfloginscreen
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into ADMIN_1 (Username,Password,IsAdmin) values(@username,@password,@admin)";
cmd.Parameters.AddWithValue("@username", this.txtUsername.Text);
cmd.Parameters.AddWithValue("@password", this.txtPassword.Text);
cmd.Parameters.AddWithValue("@admin", this.txtIsAdmin.Text);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Saved");
}
private void Button_Click2(object sender, RoutedEventArgs e)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "Select * From ADMIN_1 (Username,Password,IsAdmin) values(@username,@password,@admin)";
command.CommandType = CommandType.Text;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string value = (string)reader["Username"];
string value2 = (string)reader["Password"];
string value3 = (string)reader["IsAdmin"];
string item = string.Format(value, value2 , value3);
this.listBox1.Items.Add(item);
}
reader.Close();
}
catch
{
}
finally
{
if (connection.State == ConnectionState.Open)
connection.Close();
}
}
}
}
/code
ovo je od xaml
<Window x:Class="wpfloginscreen.MainWindow"
xmlns="
http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="
http://schemas.microsoft.com/winfx/2006/xaml"
Title="MainWindow" Height="350" Width="525">
<Grid>
<TextBox x:Name="txtUsername" HorizontalAlignment="Left" Height="23" Margin="65,34,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/>
<TextBox x:Name="txtPassword" HorizontalAlignment="Left" Height="23" Margin="65,75,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/>
<TextBox x:Name="txtIsAdmin" HorizontalAlignment="Left" Height="23" Margin="65,116,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/>
<Button Content="Save" HorizontalAlignment="Left" Margin="91,163,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click"/>
<Label Content="Username" HorizontalAlignment="Left" Margin="-3,31,0,0" VerticalAlignment="Top"/>
<Label Content="Password" HorizontalAlignment="Left" Margin="0,72,0,0" VerticalAlignment="Top"/>
<Label Content="IsAdmin" HorizontalAlignment="Left" Margin="7,113,0,0" VerticalAlignment="Top"/>
<ListBox x:Name="listBox1" Height="100" Margin="271,31,10,0" VerticalAlignment="Top"/>
<Button Content="Show" HorizontalAlignment="Left" Margin="354,148,0,0" VerticalAlignment="Top" Width="74" Click="Button_Click2"/>
</Grid>
</Window>