我用了继承窗口。用TEXTbox 和button 。
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 gousxt
{
public partial class sptj : gousxt.Form2
{
public sptj()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{ } private void button1_Click_1(object sender, EventArgs e)
{
string pm = pm.text;
string xh = xh.Text;
string price= jg.Text;
string hzs = sl.Text;
string cname = cm.Text;
if (pm.Text == "" || xh.Text == "" || jg.Text == "" || sl.Text == "" ||cm.Text == "")
{
if (pm.Text == "")
{ MessageBox.Show("品名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
pm.Focus();
return;
} if (xh.Text == "")
{ MessageBox.Show("型号不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
xh.Focus();
return;
}
if (jg.Text == "")
{ MessageBox.Show("价格不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
jg.Focus();
return;
} if ( sl.Text == "")
{ MessageBox.Show("数量不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sl.Focus();
return;
}
if (cm.Text == "")
{ MessageBox.Show("厂名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
cm.Focus();
return;
}
}
else
{
SqlConnection myConn = new SqlConnection("user id=sa; password=123; initial catalog='g&s'");
myConn.Open();
try
{ SqlCommand myComm = new SqlCommand("insert into cpzl values ('" + pm + "','" + xh + "','" + price+ "','" +hzs + "','" + cname+ "')", myConn);
myComm.ExecuteNonQuery(); pm.Text = "";
xh.Text = "";
price.Text = "";
hzs.Text = "";
cname.Text = "";
MessageBox.Show("数据已经添加成功", "温馨提示");
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show("数据添加失败", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
} } 提示错误说:string 不包含text定义,并且找不到可以接受的类型string第一参数的扩张方法text缺少using指令
string 不包含Focus定义,并且找不到可以接受的类型string第一参数的扩张方法Focus缺少using指令
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 gousxt
{
public partial class sptj : gousxt.Form2
{
public sptj()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{ } private void button1_Click_1(object sender, EventArgs e)
{
string pm = pm.text;
string xh = xh.Text;
string price= jg.Text;
string hzs = sl.Text;
string cname = cm.Text;
if (pm.Text == "" || xh.Text == "" || jg.Text == "" || sl.Text == "" ||cm.Text == "")
{
if (pm.Text == "")
{ MessageBox.Show("品名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
pm.Focus();
return;
} if (xh.Text == "")
{ MessageBox.Show("型号不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
xh.Focus();
return;
}
if (jg.Text == "")
{ MessageBox.Show("价格不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
jg.Focus();
return;
} if ( sl.Text == "")
{ MessageBox.Show("数量不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sl.Focus();
return;
}
if (cm.Text == "")
{ MessageBox.Show("厂名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
cm.Focus();
return;
}
}
else
{
SqlConnection myConn = new SqlConnection("user id=sa; password=123; initial catalog='g&s'");
myConn.Open();
try
{ SqlCommand myComm = new SqlCommand("insert into cpzl values ('" + pm + "','" + xh + "','" + price+ "','" +hzs + "','" + cname+ "')", myConn);
myComm.ExecuteNonQuery(); pm.Text = "";
xh.Text = "";
price.Text = "";
hzs.Text = "";
cname.Text = "";
MessageBox.Show("数据已经添加成功", "温馨提示");
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show("数据添加失败", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
} } 提示错误说:string 不包含text定义,并且找不到可以接受的类型string第一参数的扩张方法text缺少using指令
string 不包含Focus定义,并且找不到可以接受的类型string第一参数的扩张方法Focus缺少using指令
这是什么意思?
string xh = xh.Text;
string price= jg.Text;
string hzs = sl.Text;
string cname = cm.Text;pm ,xh这些是什么?你在哪定义的?确认pm里有Text,Focus()这些公共接口?
控件名pm和变量名pm不能重名,将变量名改pm1;
C#是区分大小写的,大小写不要弄混了
我把变量和textbox,设计名改成一样的名字。
郁闷死了