c#和SQL

来源:互联网 发布:数据库开发工程师前景 编辑:程序博客网 时间:2024/06/06 18:55
 

c#

简单的加减乘除

    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        double num1, num2, result;

        private void button2_Click(object sender, EventArgs e)
        {
            num1 = double.Parse(textBox1.Text);
            num2 = double.Parse(textBox2.Text);
            result = num1 + num2;
            textBox3.Text = result.ToString();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            num1 = double.Parse(textBox1.Text);
            num2 = double.Parse(textBox2.Text);
            result = num1 - num2;
            textBox3.Text = result.ToString();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            num1 = double.Parse(textBox1.Text);
            num2 = double.Parse(textBox2.Text);
            result = num1 * num2;
            textBox3.Text = result.ToString();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            num1 = double.Parse(textBox1.Text);
            num2 = double.Parse(textBox2.Text);
            result = num1 / num2;
            textBox3.Text = result.ToString();
        }

 

 

 

sql:

 创建一个数据库 TEST2,数据文件初始大小均为 20MB,最大大小为
60MB,按 5MB 增长。日志文件初始大小为 2MB,最大大小不限定,
按15%方式增长。两种文件路径均放在 D盘根目录。

 

 

create database TEST3    
on                         
(name=TEST3_data,                
  filename='D:\TEST3_data.mdf',
  size=30MB,                
  filegrowth=2MB,        
  maxsize=50MB          
  )
log on              
(name=stu_log,           
  filename=D:\TEST3_log.ldf',    
  size=1MB,            
  filegrowth=10%,      
  maxsize=unlimited        

)