如果这是一个愚蠢的问题,我很抱歉,但是您能帮我在我的应用程序中添加一些代码吗?每当有人成功地添加到表中时,这些代码就会生成一个MessageBox,而每当生成阻止将所需信息添加到表中的异常时,就会生成另一个MessageBox。我的代码如下:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
public partial class AddJob : Form
{
public AddJob()
{
InitializeComponent();
}
private void AddJob_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommand cmd;
SqlConnection con;
SqlDataAdapter da;
con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\richard.schade\Desktop\IKJobs\WindowsFormsApp1\ikData.mdf;Integrated Security=True");
con.Open();
cmd = new SqlCommand("INSERT INTO openJobs (jobTitle, jobDescription, dateOpened, jobsiteLink, jobLocation) VALUES (@jobTitle, @jobDescription, @dateOpened, @jobsiteLink, @jobLocation)", con);
cmd.Parameters.AddWithValue("@jobTitle", textBox1.Text);
cmd.Parameters.AddWithValue("@jobDescription", textBox5.Text);
cmd.Parameters.AddWithValue("@dateOpened", textBox4.Text);
cmd.Parameters.AddWithValue("@jobsiteLink", textBox3.Text);
cmd.Parameters.AddWithValue("@jobLocation", textBox2.Text);
cmd.ExecuteNonQuery();
}
}
}
谢谢你的帮助,我已经从这个论坛学到了很多。
发布于 2018-06-09 07:46:30
将方法的内容包装在try
/catch
中
在捕获中执行MessageBox.Show(exception msg)
并执行MessageBox.Show(successfully done)
作为最后一行尝试。
例如
Try{
SqlCommand cmd;
SqlConnection con;
SqlDataAdapter da;
con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\richard.schade\Desktop\IKJobs\WindowsFormsApp1\ikData.mdf;Integrated Security=True");
con.Open();
cmd = new SqlCommand("INSERT INTO openJobs (jobTitle, jobDescription, dateOpened, jobsiteLink, jobLocation) VALUES (@jobTitle, @jobDescription, @dateOpened, @jobsiteLink, @jobLocation)", con);
cmd.Parameters.AddWithValue("@jobTitle", textBox1.Text);
cmd.Parameters.AddWithValue("@jobDescription", textBox5.Text);
cmd.Parameters.AddWithValue("@dateOpened", textBox4.Text);
cmd.Parameters.AddWithValue("@jobsiteLink", textBox3.Text);
cmd.Parameters.AddWithValue("@jobLocation", textBox2.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("done") ;
}
Catch(Exception ezx) {
MessageBox.Show("bad");
}
https://stackoverflow.com/questions/50769633
复制相似问题