110,535
社区成员
发帖
与我相关
我的任务
分享
public int sqlMethod( string sql)
{
using (OleDbConnection conn = new OleDbConnection(strcon))
{
OleDbCommand comm = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(comm);
DataSet ds = new DataSet();
int result = da.Fill(ds, "dt");
if (result != 0)
{
gridSql.DataSource = ds.Tables["dt"];
return result;
}
else
return 0;
}
}
sql:sql = "select JCRname as 姓名,JCRbm as 别名,JCRsex as 性别, JCRidenty as 身份证号,JCRJG as 籍贯,JCRsf as 身份 from JCRJBXX where 1=1 ";
sql += " and JCRname like '%" + sqlName.Text.Trim() + "%'";
第二个模块
using (OleDbConnection conn = new OleDbConnection(strcon))
{//查询JCRJBXX表中是否有该监测人
// string sqlJCRexist = "select JCRname from JCRJBXX where JCRname='" + jcrname.Text.Trim() + "'";
string sql = string.Empty;
OleDbCommand comm = new OleDbCommand(sql, conn);
try
{
conn.Open();
}
catch (Exception ex)
{
string temp = ex.Message;
MessageBox.Show("无法连接数据库\r\n" + temp);
}
string inJCRJBXX = "insert into" +
" JCRJBXX(JCRcym,JCRnl,JCRbrith,JCRid,JCRname,JCRsex,JCRnation,JCRpolity,JCRLiPla,JCRidenty,JCRphone,JCRbm,JCRfl,JCRjg,JCRsf,JCRfy,JCRzjxy,JCRsxdj,JCRlkdw,JCRjjzk,JCRxz,JCRlkjb,JCRbyyx,JCRhjszd,JCRgzdw,JCRzy,JCRgxry,JCRgddh,JCRbgsdh,JCRyddh,JCRqq,JCRwx,JCRdzyj,JCRgrjl,JCRzpbh)"
+ " values('"+JCRCYM .Text.Trim()+"','"+stuAge.ToString()+"','"+birth+"','"+JCRguid+"','" + jcrname.Text.Trim() + "','" + jcrsex.SelectedItem.ToString() + "','" + JCRMZ.SelectedItem.ToString() + "','" + JCRZZMM.SelectedItem.ToString() + "','" + JCRXJZD.Text + "','" + JCRSFZ.Text + "','"
+ JCRLXDH.Text + "','" + JCRBM.Text.Trim() + "','" + JCRFL.Text.Trim() + "','" + JCRJG.Text.Trim() + "','" + JCRSF.Text.Trim() + "','" + JCRFY.Text.Trim() + "','" + JCRZJXY.Text.Trim() + "','" + JCRSXDJ.Text.Trim() + "','" + JCRLKDW.Text.Trim() + "','" +
JCRJJZK.Text.Trim() + "','" + JCRXZ.Text.Trim() + "','" + JCRLKJB.Text.Trim() + "','" + JCRBYYX.Text.Trim() + "','" + JCRHJSZD.Text.Trim() + "','" + JCRGZDW.Text.Trim() + "','" + JCRZY.Text.Trim() + "','" + JCRGXRY.Text.Trim() + "','" + JCRGDDH.Text.Trim()
+ "','" + JCRBGSDH.Text.Trim() + "','" + JCRYDDH.Text.Trim() + "','" + JCRQQ.Text.Trim() + "','" + JCRWX.Text.Trim() + "','" + JCRDZYJ.Text.Trim() + "','" + JCRGRJL.Text.Trim() + "','0')";
try
{
comm.CommandText = inJCRJBXX;
int inResult = comm.ExecuteNonQuery();
if (inResult > 0)
{
//没有照片
if (jcrphoto.Image == null)
{
MessageBox.Show("添加成功", "提示");
}
//有照片
else
{
photoGuid = Guid.NewGuid().ToString();
sql = "update JCRJBXX set JCRzpbh='" + photoGuid + ".jpg" + "' where JCRid='"+JCRguid+"' ";
comm.CommandText = sql;
int result = comm.ExecuteNonQuery();
if (result < 0)
return;
//将图片移动到JCRphoto文件夹
else
{
movePhoto(pathTemp);
MessageBox.Show("添加成功", "提示");
}
}
}
大概主要的操作数据库的代码就这样,有点乱,还请大家见谅。本人只是一个大二的学生,在自学C#。还请大家帮帮忙。