如何快速开发 一个执行一个update语句的简单windows程序用c#
数据库连接设置可以调用ini文件,
只用一个按钮执行完语句后显示语句成功执行的信息,或者报错信息再添加一个删除的语句按钮
我现在用的是按钮 能执行一个语句 可是不能显示是否成功,后台看更新成功了,
本人菜菜 请指教。using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;namespace WindowsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
string connectionString = "UID=sa;Password=;Initial Catalog=database;Data Source=localhost ";
SqlConnection myConn = new SqlConnection(connectionString);
//打开数据库
myConn.Open(); SqlCommand myComm = new SqlCommand();
SqlTransaction myTran;
myTran = myConn.BeginTransaction();
try
{
myComm.Connection = myConn;
myComm.Transaction = myTran; myComm.CommandText = "UPDATE roysched SET royalty ='1' "; myComm.ExecuteNonQuery();
myComm.CommandText = "UPDATE roysched1 SET royalty ='1' "; myComm.ExecuteNonQuery();
myTran.Commit();
}
catch (SqlException ex)
{
Console.WriteLine( "Commit Exception Type: {0} ", ex.GetType());
Console.WriteLine( " Message: {0} ", ex.Message); myTran.Rollback();
}
finally
{ myConn.Close();
}
}
}
}
数据库连接设置可以调用ini文件,
只用一个按钮执行完语句后显示语句成功执行的信息,或者报错信息再添加一个删除的语句按钮
我现在用的是按钮 能执行一个语句 可是不能显示是否成功,后台看更新成功了,
本人菜菜 请指教。using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;namespace WindowsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
string connectionString = "UID=sa;Password=;Initial Catalog=database;Data Source=localhost ";
SqlConnection myConn = new SqlConnection(connectionString);
//打开数据库
myConn.Open(); SqlCommand myComm = new SqlCommand();
SqlTransaction myTran;
myTran = myConn.BeginTransaction();
try
{
myComm.Connection = myConn;
myComm.Transaction = myTran; myComm.CommandText = "UPDATE roysched SET royalty ='1' "; myComm.ExecuteNonQuery();
myComm.CommandText = "UPDATE roysched1 SET royalty ='1' "; myComm.ExecuteNonQuery();
myTran.Commit();
}
catch (SqlException ex)
{
Console.WriteLine( "Commit Exception Type: {0} ", ex.GetType());
Console.WriteLine( " Message: {0} ", ex.Message); myTran.Rollback();
}
finally
{ myConn.Close();
}
}
}
}
解决方案 »
- 求C#,Java,或者C++读取 DWG文件的代码,可以付钱!
- WPF GridViewColumn的问题
- C#中winform 最小宽高限制问题
- C#中domainupdown控件怎么显示时间?以及domainupdown1里面放时间格式怎么实现让他加减?
- 一条语句看不懂,高手请指教!
- 如何实现在多选项卡间搜索
- 我在一个table中放置了一个dropdownlist和一个textbox,获取dropdownlist的selectvalue值和textbox的值,然后把获取的值插入到数据库里面,如何做?
- 如何处理新闻内容中的图片--思路
- vs2005中的问题
- 如何让WINFORM程序在网上邻居上共享运行,在使用Dns类不会出DnsPermission错误。
- 有关存储的问题?
- 为什么连接数据库的时候只执行到 Open() ?????????
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms; namespace WindowsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
string connectionString = "UID=sa;Password=;Initial Catalog=database;Data Source=localhost ";
SqlConnection myConn = new SqlConnection(connectionString);
//打开数据库
myConn.Open(); SqlCommand myComm = new SqlCommand();
SqlTransaction myTran;
myTran = myConn.BeginTransaction();
try
{
myComm.Connection = myConn;
myComm.Transaction = myTran; myComm.CommandText = "UPDATE roysched SET royalty ='1' "; myComm.ExecuteNonQuery();
myComm.CommandText = "UPDATE roysched1 SET royalty ='1' "; myComm.ExecuteNonQuery();
myTran.Commit();
MessageBox.Show("更新成功。");
}
catch (SqlException ex)
{
MessageBox.Show( "Commit Exception Type: {0} ", ex.GetType());
MessageBox.Show( " Message: {0} ", ex.Message); myTran.Rollback();
}
finally
{
myConn.Close();
}
}
}
}