Beispiel #1
0
        private bool saveDATA()
        {
            Boolean tempvalue = false; //定义返回值,并设置初值

            //下面把note中的数据添加到数据库中!
            try
            {
                System.Data.DataSet mydataset;                    //定义DataSet
                OleDbConnection     conn    = SaveDate.getConn(); //getConn():得到连接对象
                OleDbDataAdapter    adapter = new OleDbDataAdapter();
                string sqlstr = "select * from mdb where Photo='" + class1.photo + "' and TextName='" + class1.TextName + "'";
                mydataset             = new System.Data.DataSet();
                adapter.SelectCommand = new OleDbCommand(sqlstr, conn);
                adapter.Fill(mydataset, "notes");
                conn.Close();

                if (mydataset.Tables[0].Rows.Count > 0)
                {
                    return(tempvalue);
                }
                else
                {
                    #region MyRegion
                    OleDbConnection conn_ = SaveDate.getConn();
                    conn_.Open();
                    string qk = class1.ID == "1" ? "58同城" : "赶集网";
                    //设置SQL语句
                    string insertstr = "INSERT INTO mdb(Counts, Photo, Personname, Times, Href,del, TextName ,http,Addess,PM,Moneys,datetimes) VALUES ('";
                    insertstr += 0 + "', '";
                    insertstr += class1.photo + "','";
                    insertstr += class1.PersonName + "','";
                    insertstr += DateTime.Now.ToString("yyyy-MM-dd") + "','";
                    insertstr += class1.href + "','";
                    insertstr += 0 + "','";
                    insertstr += class1.TextName + "','";
                    insertstr += qk + "','";
                    insertstr += class1.Address + "','";
                    insertstr += class1.Allpm + "','";
                    insertstr += class1.SumMoney + "','";
                    insertstr += class1.datetime + "')";

                    OleDbCommand insertcmd = new OleDbCommand(insertstr, conn_);
                    insertcmd.ExecuteNonQuery();

                    conn_.Close();
                    tempvalue = true;
                    #endregion
                }
            }
            catch (Exception e)
            {
                throw (new Exception("数据库出错:" + e.Message));
            }
            return(tempvalue);
        }
Beispiel #2
0
        private void buttons_Click(object sender, RoutedEventArgs e)
        {
            #region 更新表单
            Boolean tempvalue = false;
            string sqlstr = ""; //当时在这里定义,是为了在出现异常的时候看看我的SQL语句是否正确
            try
            {
                //用到了我前面写的那个得到数据库连接的函数
                OleDbConnection conn = SaveDate.getConn(); //getConn():得到连接对象,
                conn.Open();

                //确定我们需要执行的SQL语句,本处是UPDATE语句!
                sqlstr = "UPDATE Author SET ";
                sqlstr += "Author='" + zztext.Text.Trim() + "',";
                sqlstr += "Photo='" + phototext.Text.Trim() + "',";
                sqlstr += "QQ='" + qqtext.Text.Trim() + "'";
                sqlstr += " where id=4";

                //定义command对象,并执行相应的SQL语句
                OleDbCommand myCommand = new OleDbCommand(sqlstr, conn);
                myCommand.ExecuteNonQuery(); //执行SELECT的时候我们是用的ExecuteReader()
                conn.Close();


                //假如执行成功,则,返回TRUE,否则,返回FALSE
                tempvalue = true;
            }
            catch (Exception es)
            {
                MessageBox.Show("数据库更新出错:" + sqlstr + "\r" + es.Message);
            }
            #endregion
            if (tempvalue)
            {
                zztext.IsReadOnly = true;
                phototext.IsReadOnly = true;
                qqtext.IsReadOnly = true;
                zztext.BorderThickness = new Thickness(0);
                phototext.BorderThickness = new Thickness(0);
                qqtext.BorderThickness = new Thickness(0);
                buttons.Visibility = Visibility.Collapsed;
            }

        }
Beispiel #3
0
 private void Window_Loaded(object sender, RoutedEventArgs e)
 {
     DataView dataview;
     System.Data.DataSet mydataset; //定义DataSet
     try
     {
         OleDbConnection conn = SaveDate.getConn(); //getConn():得到连接对象
         OleDbDataAdapter adapter = new OleDbDataAdapter();
         string sqlstr =  "select * from Author where ID=4";
         mydataset = new System.Data.DataSet();
         adapter.SelectCommand = new OleDbCommand(sqlstr, conn);
         adapter.Fill(mydataset, "notes");
         conn.Close();
     }
     catch (Exception es)
     {
         throw (new Exception("数据库出错:" + es.Message));
     }
     dataview = new DataView(mydataset.Tables["notes"]);
     zztext.Text = dataview.Table.Rows[0]["Author"].ToString();
     phototext.Text = dataview.Table.Rows[0]["Photo"].ToString();
     qqtext.Text = dataview.Table.Rows[0]["QQ"].ToString();
 }
Beispiel #4
0
        private void Button_Click_5(object sender, RoutedEventArgs e)
        {
            SaveDate sd = new SaveDate();

            sd.Show();
        }