学步园

话接上回。

介绍之前先介绍一个结构体。因为以下函数都要用到这个结构体。

//普通的节点<br /> public struct Node<br /> {<br /> private string nodeType;<br /> public string NodeType//表的字段名<br /> {<br /> set { nodeType = value; }<br /> get { return nodeType; }<br /> }</p> <p> private string nodeValue;<br /> public string NodeValue//具体的值<br /> {<br /> set { nodeValue = value; }<br /> get { return nodeValue; }<br /> }<br /> }</p> <p> //照片节点<br /> public struct PictureNode<br /> {<br /> private string nodeType;<br /> public string NodeType//照片的列名<br /> {<br /> set { nodeType = value; }<br /> get { return nodeType; }<br /> }</p> <p> private byte[] nodeValue;<br /> public byte[] NodeValue//照片的值，注意类型<br /> {<br /> set { nodeValue = value; }<br /> get { return nodeValue; }<br /> }<br /> }

具体就用不着多加描述了吧！继续看问题点。

1.向table中插入数据（按行插入，如果需要插入多条请自己组织这个函数就ok了），其中的 insertArray存储的是一系列Node，pictureNode是PictureNode。
//插入数据<br /> public static bool InsertRow( string mdbPath, string tableName, ArrayList insertArray,<br /> PictureNode pictureNode, ref string errinfo)<br /> {<br /> try<br /> {<br /> //1、建立连接<br /> string strConn<br /> = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";Jet OLEDB:Database Password=haoren";<br /> OleDbConnection odcConnection = new OleDbConnection(strConn);<br /> //2、打开连接<br /> odcConnection.Open();</p> <p> string str_col = "";<br /> int size_col = insertArray.Count;<br /> for (int i = 0; i < size_col; i++)<br /> {<br /> Node vipNode = new Node();<br /> vipNode = (Node)insertArray[i];<br /> str_col += vipNode.NodeType + ",";<br /> }<br /> str_col = str_col.TrimEnd(',');</p> <p> int size_row = insertArray.Count;<br /> string str_row = "";<br /> for (int i = 0; i < size_row; i++)<br /> {<br /> Node vipNode = new Node();<br /> vipNode = (Node)insertArray[i];<br /> string v = vipNode.NodeValue.ToString();<br /> v = DealString(v);<br /> if (v == "")<br /> {<br /> str_row += "null" + ',';<br /> }<br /> else<br /> {<br /> str_row += "'" + v + "'" + ',';<br /> }<br /> }<br /> str_row = str_row.TrimEnd(',');<br /> if (pictureNode　!= null && pictureNode.NodeValue != null)<br /> {<br /> str_col += ',' + pictureNode.NodeType;<br /> str_row += ",@Image";<br /> }<br /> string sql = "insert into " + tableName + @" (" + str_col + ") values" + @"(" + str_row + ")";<br /> OleDbCommand odCommand = new OleDbCommand(sql, odcConnection);<br /> if (pictureNode != null　&& pictureNode.NodeValue != null)<br /> {<br /> odCommand.Parameters.Add("@Image", OleDbType.VarBinary, pictureNode.NodeValue.Length).Value = pictureNode.NodeValue;<br /> }<br /> odCommand.ExecuteNonQuery();<br /> odcConnection.Close();<br /> return true;<br /> }<br /> catch (Exception err)<br /> {<br /> errinfo = err.Message;<br /> return false;<br /> }<br /> }

2.更新一行的数据（与插入类似）

//更新一行数据<br /> public static bool UpdateRow(string mdbPath, string tableName,<br /> Node keyNode,ArrayList insertArray,PictureNode pictureNode, ref string errinfo)<br /> {<br /> try<br /> {<br /> //1、建立连接<br /> string strConn<br /> = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";Jet OLEDB:Database Password=haoren";<br /> OleDbConnection odcConnection = new OleDbConnection(strConn);<br /> //2、打开连接<br /> odcConnection.Open();</p> <p> int size = insertArray.Count;<br /> string str = "";<br /> for (int i = 0; i < size; i++)<br /> {<br /> Node node = new Node();<br /> node = (Node)insertArray[i];<br /> string v = node.NodeValue.ToString();<br /> v = DealString(v);<br /> str += node.NodeType + " = ";<br /> if (v == "")<br /> {<br /> str += "null" + ',';<br /> }<br /> else<br /> {<br /> str += "'" + v + "'" + ',';<br /> }</p> <p> }<br /> str = str.TrimEnd(',');<br /> if (pictureNode.NodeValue != null)<br /> {<br /> str += ',' + pictureNode.NodeType;<br /> str += " = @Image";<br /> }<br /> string sql = "update " + tableName + " set " + str +<br /> " where " + keyNode.NodeType + " = " + "'" + keyNode.NodeValue + "'";<br /> OleDbCommand odCommand = new OleDbCommand(sql, odcConnection);<br /> if (pictureNode.NodeValue != null)<br /> {<br /> odCommand.Parameters.Add("@Image", OleDbType.VarBinary, pictureNode.NodeValue.Length).Value = pictureNode.NodeValue;<br /> }<br /> odCommand.ExecuteNonQuery();<br /> odcConnection.Close();<br /> return true;<br /> }<br /> catch (Exception err)<br /> {<br /> errinfo = err.Message;<br /> return false;<br /> }<br /> }

3.  插入图片数据.

//插入图片数据<br /> public static bool InsertPictureToMDB(string mdbPath, string tableName,Node keyNode,<br /> PictureNode pictureNode,ref string errinfo)<br /> {<br /> try<br /> {<br /> //1、建立连接<br /> string strConn<br /> = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";Jet OLEDB:Database Password=haoren";<br /> OleDbConnection odcConnection = new OleDbConnection(strConn);<br /> //2、打开连接<br /> odcConnection.Open();<br /> string sql = @"update " + tableName + " set " + pictureNode.NodeType + "="<br /> + "@Image where " + keyNode.NodeType + "=" + "'"+keyNode.NodeValue+"'";<br /> OleDbCommand comm = new OleDbCommand(sql, odcConnection);<br /> byte[] pic = pictureNode.NodeValue;<br /> comm.Parameters.Add("@Image", OleDbType.VarBinary, pic.Length).Value = pic;<br /> comm.ExecuteNonQuery();<br /> odcConnection.Close();<br /> return true;<br /> }<br /> catch (Exception err)<br /> {<br /> errinfo = err.Message;<br /> return false;<br /> }<br /> }

4.修改mdb的一条数据.

//修改mdb的一条数据<br /> public static bool UpdateMDBNode( string tableName, Node keyNode,<br /> Node saveNode, ref string errinfo)<br /> {<br /> try<br /> {<br /> //1、建立连接<br /> string strConn<br /> = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";Jet OLEDB:Database Password=haoren";<br /> OleDbConnection odcConnection = new OleDbConnection(strConn);<br /> //2、打开连接<br /> odcConnection.Open();</p> <p> string sql = @"update "+ tableName+" set " + saveNode.NodeType + " = '" + saveNode.NodeValue+<br /> "' where " + keyNode.NodeType + " = " + "'" + keyNode.NodeValue + "'";<br /> OleDbCommand comm = new OleDbCommand(sql, odcConnection);<br /> comm.ExecuteNonQuery();<br /> odcConnection.Close();<br /> return true;<br /> }<br /> catch (Exception err)<br /> {<br /> errinfo = err.Message;<br /> return false;<br /> }<br /> }

5.从mdb中获得照片

//从mdb中获得照片<br /> public static byte[] GetImageFromMDB( string tableName, Node keyNode)<br /> {<br /> try<br /> {<br /> string sql = "Select 照片 From " + tableName +<br /> " member Where " + keyNode.NodeType + " = "<br /> + "'" + keyNode.NodeValue + "'";<br /> string strConn<br /> = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";Jet OLEDB:Database Password=haoren";<br /> OleDbConnection odcConnection = new OleDbConnection(strConn);<br /> //2、打开连接<br /> odcConnection.Open();<br /> OleDbCommand comm = new OleDbCommand(sql, odcConnection);<br /> OleDbDataReader sdr = comm.ExecuteReader();<br /> sdr.Read();</p> <p> byte[] pic = (byte[])sdr[0];<br /> sdr.Close();<br /> odcConnection.Close();<br /> return pic;<br /> }<br /> catch<br /> {<br /> return null;<br /> }<br /> }

到此以上描述问题，全部解决。这些程序代码都在net2005下测试通过。希望能给大家带来一些帮助。

补充一句：转载的朋友请一定注明出处谢谢！半支烟阿杰 http://blog.csdn.net/gisfarmer/