求大神們解答
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;
namespace _15_1
{
/// <summary>
/// MainWindow.xaml 的互動邏輯
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void btnInsert_Click(object sender, RoutedEventArgs e)
{
insert ins = new insert();
ins.Show();
this.Hide();
}
private void btnSelect_Click(object sender, RoutedEventArgs e)
{
select s = new select();
s.Show();
this.Hide();
}
}
}
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.Shapes;
using System.Data.SqlClient;
namespace _15_1
{
/// <summary>
/// insert.xaml 的互動邏輯
/// </summary>
public partial class insert : Window
{
public insert()
{
InitializeComponent();
}
//宣告SqlConnection類和SqlCommand類的全域變數。
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
//資訊插入界面加載時，顯示性別選項。
cbSex.Items.Add("請選擇");
cbSex.Items.Add("男");
cbSex.Items.Add("女");
cbSex.SelectedIndex = 0;
}
private void btnInsert_Click(object sender, RoutedEventArgs e)
{
/*插入按鈕點擊事件*/
//判斷姓名、年齡是否為空，性別是否沒有選擇男或女，彈出提示框。
if (txtName.Text.Equals(""))
{
MessageBox.Show("姓名為空，請重新輸入！");
return;
}
if (cbSex.SelectedIndex == 0)
{
MessageBox.Show("您沒有選擇性別！");
return;
}
if (txtAge.Text.Equals(""))
{
MessageBox.Show("年齡為空，請重新輸入！");
return;
}
SqlConnection conn;
SqlCommand cmd;
//功能2：將姓名、性別和年齡插入到資料庫中。
//1、連接資料庫
conn = new SqlConnection("server=;database=student;uid=sa;pwd=123456");
conn.Open();------------------------------------------------------------------運行時這里會出錯
//2、獲取姓名、性別和年齡。
string sname, ssex;
int sage;
sname = txtName.Text;
ssex = cbSex.SelectedValue.ToString();
sage = int.Parse(txtAge.Text);
//3、生成SqlCommand類的物件。
cmd = new SqlCommand("insert into info(name,sex,age) values('"+sname+",'"+ssex+","+sage+")",conn);
//4、執行SQL陳述句，插入成功彈出提示對話框。
int i = cmd.ExecuteNonQuery();
MessageBox.Show("你已成功插入1條記錄");
//5、釋放資源（SqlConnection類和SqlCommand類的物件）
cmd.Dispose();
conn.Dispose();
}
private void Window_Closing_1_Click(object sender, RoutedEventArgs e)
{
MainWindow mw = new MainWindow();
mw.Show();
this.Hide();
}
}
}
uj5u.com熱心網友回復：
你沒有定義server，本機的話是localhost轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/26208.html
標籤：基礎類