using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace banks管理
{
public
partial class Form1 : Form
{
int mark =0;
SqlConnection con1 = null;
DataSet set1 = null;
DataTable table = null;
public Form1()
{
InitializeComponent();
con1 = new SqlConnection("Data Source=.;Initial
Catalog=Banks1;Integrated Security=True");
set1 = new DataSet();
table = new DataTable();
}
private void button1_Click(object sender, EventArgs e)
{
if (con1.State == ConnectionState.Closed)
{
con1.Open();
label11.Text = "您的余额:";
SqlCommand com = new SqlCommand();
com.Connection = con1;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "show_money";
com.Parameters.Add("@myid", SqlDbType.NChar);
com.Parameters["@myid"].Value =
Convert.ToChar(textBox2.Text);
com.Parameters.Add("@mymoney", SqlDbType.Decimal );
com.Parameters["@mymoney"].Direction =
ParameterDirection.Output;
com.ExecuteNonQuery();
string mymoney = com.Parameters["@mymoney"].Value.ToString();
textBox1.Text = mymoney;
com.Dispose();