ado.net实现一个通知公告功能

时间:2023-03-08 22:23:24
ado.net实现一个通知公告功能

一、建立相应的数据库,此处就不多说了,相信大家都非常了解

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAASQAAACkCAIAAACxXMTXAAAUZ0lEQVR4nO2da3BU1R3At58dp52OVcextbbWGUdn2o5gy2ppLbZDfbVTbcehrcykdvEBVQIyQ6PSGsEKCAshlKcJIRCTICCPDWAMRAJihPA24EIwBAIJScgYYPMipx92773neV9799x7Nv/f3A9md8/rcn57zr17/39DyFfuXwqHvAPwl5C/zfs+/4bVAfgLyDaMDsBfQLZhdAD+4qVs7667NKeifU5F+zvvt/+npG3aiosvLrowfm7rUzPPj33t3C+ntYx+tYUqwp8W1Qh1oXFL0f1LUXEXqq32Y2pWomaEiiv9N4R7WkwOkzMG+IvHspXsRit3Di35aHBhbGDOxv78yr68tb1Ti69OXHZ1wv+ujn7lKFUkc7IVdyFE2WJvsrqWbUYTNjD7DYFswwahbDs+ql7AY8dH1aIi7667NLei/Z3y9tdL2l5ZejFnfuvTM8//9l8tD05p+dnksz/PbXng+QNUkYzKVttEzk4bkzWdhXRGE2puwMRrkicb3m2QLbAIZVuwYEH/wAB7LFiwQFSkLLZ/cGiQOhL9A5evDrRe7j91sW/UExOoIpmVrRoVdxkCyJRtXAPIBtB4L9uu+njyGBwa3F53YuuuLzZUH2293L+5ut5ctlr8DVI2/S18GuGfnyGaf5WoWS9FTla2eC3eeiVqxqrV39J1Yl/BZaNmPL+rlaiZGZcxXq2r3NPCP29daJzpGQP8JbMrG76sVVR9ZiJbLTYtZjQRsiF9glYb/12LyCWL8U2f7uMatHeriRnMLW5IgslGfFh7Rb+c04uIrtmEbTVpnyE7gEjJuafFfGXjnjGQzXfMZOvs7Hjs72X40dnZYWdl+3jfl9vrTiT6BzZUH63YdnjN5oOHmxMlm/YJZasWXlxRS0TqT2ZDxe6d6PnXhJUSF+fIxm7emIvWpEv4ymbMctOuJr8IktC2m54Wc9k4ZwxkCwAWsrGHzZUNX9MONyf2xa+tWJ9Z2ag7h0TB5GayyUy2ZHG7svEmPSGbvvqJ2qpEzfqKh62iIFsWYyZbCw8T2VZt3Etdp63ZfLBow/7llfX74teWVHxqcxtZ3EVuI7U7DcaGkN2bJT+P3a+n5lxqDRFtI1m3yW2k0bcG+pUZTamP8Vc2UVtYo/i42Is97mkxl417xkA23/FStqXvfzw4NHiu9cKpsxeOnWr9/IvztQfPbatv+XBPy7pPzprLhu/NihvI2Y9dC+EXZpy7DmLZ2MnKvWlhOInfIMHuZLCvENdUvDpFbSUvrhBCzU2ClU18WqgD/yoxOWOAv3j5O1tBSdVPfzN+xNgc0WH31j8cmTkAf4FnI9U7aslzaP+HQcBfQLZhdAD+ArINowPwF5BtGB2Av4Bsw+gA/MVn2QBg+ACyAYAkQDYAkATIBgCS8F+2daXz8cNR2Xg0HKIJR+P6m5FYBjoMAO7wWbZ1pfM7zm3q7Yr1dsWudZT3NC906htCjFaxSDgaB9mAoOG9bI4eqqSWtfLiuWUrZ5etnL162azVy2YVF+brh0mL8WhYX84QAtmAgOK9bI5CvNeVzu/rrtGP3q+3DHRWDnSsGTxfOHhm9uCpvP7juVfqJ1zZM276yzmCBom9ZCQGsgEBxWfZylbO7uuuSW4jE92aZmfnDJ7K6z/6z8T+nJ7dT3dXP35w6a1C2WKRkOZUyjKQDQgkPsu2etksXTbCtOO5if05V/aM665+/EL5iE/n3/Bizp95rcWj4XA0Fo8jpEsGsgHBJCOy2U9eUlSY39ddk1zTBi4uZ03r3PyLltJ7d86+4S9/HMtpLBYJRaL6NjJ15QayAYEkU7LZTF5SVJjf2xUb6KxMmjbQ9KZ+kZY0ra1y5Nn3frjlzW8++uswWzwWMXaQxj1/kA0IJBmRzX4+hSXzXuvtig1cXD54vpAyrWPLw22VI1tK7z21+PbyvJvC998nbDIeDYeI+5HaqyAbECB8lq1w9vRrHeW6aYlDL1zZM6675ve6aWeW3dEY/U7RtNvuu/sObnPxaDjEMQ2BbEDQ8Pl3toVvT+s+U9J+4OWz28bG1z9wsvy+I6t+9OmS71fPu2N9/ncr37i1PO+momm3LZ78vTtvv5nTWDwaDjFG6b8FcB0EAJ/w+QmS+W9NnTn9pWkTx//jr3946rGHfzXqJz++5wd33n7zLd++kT387SoApIn/z0YCwDABZAMASYBsACAJkA0AJAGyAYAkQDYAkESWyPbV0Q/rqxZtWzt363tTjn48z+/uAACHbJDt+J5ilDiCEkeGWkq6q8bsWvlozZrJfncKAGiUl63p0AdJzRpL75oVGXlh/S2NpXftKHhw7/rpmW2Y/0CmK/CnqDOEh72VgR6kiEUrqo/ystVXLUKJI0ONk2ZFRvZcPr+lKO9c2bcOFYZWvf0n03LJZ7rI+edo0jucvvozZJy5I25XexyNiUbXyhm1JT8impmKyybh60gCystWs64QddUONU5qLL1rS1FeX92o1tLQgYLQf6dwg0114tFwKBIh/w2t/0m5z2LaRVi96A0juQqWZgXThghSF4tmg7TGlYHa2JWNTjSjIsrLtm/L3OsdO/vqRl3aendf3ShnssXIL/yAyYa5REw1/ePaB2KRdB+6Dr5s2bCjVF62U/tWNnwwfuBYbseGGy9tvTtpWu6zo63ukRAbtNQ/IjHpYxF644a9Eo7GiRllvKVVwL5COYXXz3UFF8xENnsbRKO3sUgoHI1GsGbJcfHLs6XsnSXLSvDTSHSSkU39tU152RBCB2Jv1ZU8PXAst+39byRN27Dob1aFjH9YQzfDBnKtMPZo2NQgZobJxR81zeNUjdzy2sv6R4TbSLuRRGRvsdEkC1uuRdxSNs6SZSX2ZVN/acsG2RBCJ2oX7iqd0Fn1eO6zo/du/LeNEvQ/cigSI5YMYgbrH+bJxm4CyUVL14Fw2fJakfgix2+QENM72Wtr37jKG23YkY0pZecsWVbiQDbll7YskQ0hVFc+pX3TmNxnR9v7ODkhkrpFTGRjJqW5bIJrMAey2Zhn2ifwrbDlcDMqm3ltacoGK1tgqF07uX3TmDMrQvOm/s7Gx+kJkVo7RNtI9gqD3JjpV/FR7SoImyPsJSH+AVFiB64V9Cfwu5FmUzETstk5S5aVYLti7DtDcM0GsgWE6lUT2zeNqcp3KRsz6dlLf/1DzA0SY5fHvoJfGWKfwG+gRJ3djeR9QKuRvnPDDpfvMH9cRFNc863Oko1KjCwWkYjZyqb8wpZ1ss16+Qm/O+Id7i5S0pyUAZ3Tyl+woWySbXvRC+2bxpxcHMom31xsndJMKhbMnGTwBEmw+GL38oNF98x/5X6/OwIAfLJHNoRQwfTH8l96xO9eAACfrJINAIIMyAYAkgDZAEASIBsASAJkAwBJqC3bnIr2ORXts9ZefKO49dVlLRMLvsqZe/qZt758Mq/xkSnHHpp06IHnD/rdRwBIobxsJZ+gkk/QiprrBdsG39nQ/3pZ75Tiay8uu/JcYc9zhT0jn2/IVNueJBrgVxLAhzjU/VU5QOlMlJcttbKtSq5szTlzTz+T/+WTeY2PTD360KTDI4Urm+wcJEzYTSgUiXkim5QHdNOSDQ+QoOOOEP4yPygiPQKUzkRt2cpi+0VvDQ2h/gE0YmyO4H0fcpBobXArwGt2IpukZwbTmKJYD3m1UMGwnmccCVA6E7VlW71pH0KoJ4F6EmhK3kz9SL5ypqXNQja5OUi0NryUTdbeyL1sVEQaXQtxRrE/PBtYgAII1JbtvfW7k//RkzBevH49pd/JM5aySc1Bor2O/TunKqHydlDzk1uPXp5McUJk+CC+SsgcCJyIoEhMC9LhtEtUTtphXhWdPYX+OBMmZATemNnNDlaBdCZqy7asvAYJVraOr9GRkzZkk5iDRHuLlQ0JVjaTetjaeBk+OAGd8WgED0bDo+2IqpgR8TKX2KqKs4hwU5CQAzZffXj9CXzQt9qyLV6zI/kfPQk0NIT6r6Nrfaj7KupJoHOdqP6YLdmk5SDR3rMtm1k9WnH+JhgPpuZMam5oq/E2Z7cnDBu3qEq4hmgVilY2i9UnzQwL/ixtastWUFKFxNdsuw/alE1SDhLtPSeyWUwJ0QWRMZmSr1Jx0cy+y5VsdqoSriGYbKS59q6r0pQNVjbnJGW7PoR6EuhKL7p8BV3sRs2XUE8CHTuLqj+3LZuUHCRaXY62kaJ66J4JF594NByORHg3BLHLVdYQdkRM5XarwnqIjZBzSi13zfyBx1VJZ6K8bPrtEGplO9CEtu51IBv5RY14N0j0D7nJQYKMarmy4bZT04JbD1udaKeH3wIiasRyfjBngx4Rt3JbVREDpn9RE5w9vBhfDP5g9ZqCmc5EedkS/eh0c9uJ022HT7Z9frxtz+G2nQ1t2z9r27K3bWOdiWzZgm8/GtnGTQ/J3+Y8FgN+Z3NFQUnViLE55offfcw4Pu2JHOC0h9Sy5e3g0vh5Pl3Ulg0AFAJkAwBJgGwAIAmQDQAkAbIBgCRANgCQBMgGAJJQWzbIQQIohPKyqZ2DZLjg4y/JmYD7cLM1ysumSg4SrA3Thx2lI+UBlLRkw+MreOFG3Acu6Rc91Z2WzWblasumWA4SLOIx+afzf353HRCXkvScYBpTPe4uhUkQ85qoLZtSOUiIeBm3eCybrMff3csmithLQYxM+4P7IvJwtC4jCdSWTaUcJBYRpezmMsak2SA7IGzXshR+EshwuOxIYSKK/rZYftgz4CQg1cbaprZsKuUgEcomagvbdJIzXRDAhl3XmJWimia/L6iCnKhZBVKYiMNXLaO/M5vXRG3ZVMpBIpJN2JYwXtNYh9lWLEtR54C/h9bf0F4kK2AWJPJtzkhFga1WVQmXC61CRyubxeojiv62KZv10qa2bErlIBHYJmzLhmwWrVjJJrwgMuaNvlbgsdDMFsuVbHaqEi4XmGykucwmgtoLmK9s6ciW7SubWjlI8NmVfEO/puK1ZakNtxWnspHXbOziE1cxhYngK8ni7pJINvx7xvSaLetlUywHCb9W8Q0SZvYTXwqcVmyUIrtjXpC8g0Q0GegUJtwXYxFRf61PnRd5TZSXbbjnIEkTG/fQfMazHmIV2RDDfeVilJcNcpCkiY3tj8940kNq2fJ2xGY/62CoLRsAKATIBgCSANkAQBIgGwBIAmQDAEmAbAAgCZANACShtmyQgwRQCOVly+YcJBKa8BKbP+0GEO6Dxd6jvGyq5CAhnhpmSvMr8042KY+JpCUbGZAXYp6BpB+L9NRsWrYMfW2oLZtKOUiYuA/+s/6et4ukPQCZxhQln1tkasG+dYgwU69Gxa5sGTllasumUg4SoqlYJBSJOAipT0u2zO6NiHZcTlBRXF0KYvRk+Iw3A3P5FL9T1JZNpRwkzCzhBUzGiQwcqdfJds0q1wrSIyWD1rIj0Qiy/I5iB+skGDQDa5vasqmUg4S8LEl5rsdk4/GlnNlAxYyylZMFCahlI0sSjZgUNOuPp5HXTlFbNpVykCDdLjx6MhwlspOQ84orG79y8T6TXjbY+EjtRbZxYoUh3+bs9kThp1ZVCdcQrULRymax+ogir23K5v3SprZsSuUgQcb2kfhmpsOirWXjVG5yUSe6IDLajamYaMSsoHl/YGVzhVo5SJB2Y4Somfjbhmz8ys1lI6/Z2MUnrmKiEcvbRiLZ8K8U02s2kA1H0Rwk1JTl6kX9RXwXCG858IdK3mLj7vTw20REA4FONILfqOeMnj9Yvab0c4o4RXnZIAeJNRm4seYxbnpIb8d975AlyssGOUjskIE9kcc47SG1bHk7uDR+njdDbdkAQCFANgCQBMgGAJIA2QBAEiAbAEgCZAMASYBsACAJtWWDHCSAQigvW/bkIPG8Qi4e/l4rp8NCuE8PBxrlZVMlBwkOEyUTCkVins9d6wcGPWggQLJl6LEPD1FbNpVykHDKZvIrWfRwn8UYLQcYnAe/2JUt6M+Aqi2bSjlI5MomrDqbZQv6jlJt2dTJQUKWNUphU4MIkAtHY6lQkNQOiQ46YVukRkct2RhkYA02QraTpqPwssN4V4OVOMRD1JZNqRwkVisbWaERMx5iG7eMoKQijsk/9CksyA4iCH5jRuFlh/GeBytxiIeoLZtSOUgcycaNrcbSBHDqJwfHrYD5kwlDJWOizUfhYYeJcxKsxCEeorZsSuUg8VQ2ixklCM7G/8QD07n5FyxH4WWH2f6hgCQO8ZBskE2RHCTeycavn6oZL0Wu4cwXiiA7iNUovOwwt+eBSBziIcrLplAOEtJnlIZs4hwnGkTV+L2JKPHFkXrVyMZhmeyEewZcdViRxCEeorxskIOET6AvXhBCmRAj6GNWXjbIQSIi2FsqZRKHeIjasgGAQoBsACAJkA0AJAGyAYAkQDYAkATIBgCSANkAQBJqywY5SACFUF42H3KQ+PjrqbxMBNzHfIG0UF42tzlIEELEA3sWMY04zmRLO9mJXkvE+zwlYmjZgv98RvBRW7Y0cpAwMZ94yLY5zmVznuyEqcPW5z18Qotd2YL+5GHwUVu2NHKQEEEfJq/xizqVzXGyE7pBewplVDbYUaaL2rK5z0HCn+5EZGUkhkX7U8HGvEgcPJgEK+si2QlFnPifX+NRLUSuDqweoclsqezJ8BF81JbNfQ4SizDk5IWWZRoPYZYOKv7LiLukg7uZKFV+iBdXBiZXh/XKls0ZPoKP2rK5z0EilI03a0WZBWzlGnGX7ITXKcSsbHSQpR3ZsjbDR/BRW7Y0cpCYX7PZls0614i7ZCdUt7gyyJcNVra0yAbZXOUgobMgkHcjqVkrSONhK9eIu2QnOFRygUzIlg0ZPoKP8rK5zUGCEDL5nY2ZVvw0HtwsHRay2Ux2gmPMdwvZBClSiJqyNsNH8FFetmGRg8TFtdLwy/ARfJSXbZjkIHG6gxuGGT6Cj9qyAYBCgGwAIAmQDQAkAbIBgCRANgCQBMgGAJIA2QBAEiAbAEji/2/27laQ6MBqAAAAAElFTkSuQmCC" alt="" />

二、开始建立连接,建立连接首先需要有一个连接字符串,用来存储连接相关的信息,比如你连的是哪里的数据库呀,什么数据库呀,数据库名字,以及数据库用户名,密码之类的呀等等!这个链接字符串呢,一般都是直接放在配置文件(Web.config)中的,如下

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAABHUAAACHCAIAAAAX5fJ7AAAgAElEQVR4nO2dz5IcxbWHy2bhCC/QgGN2RAi8YEGEA2Sz8ArxZ2/LBrZGMnts8wDIxg8AfgFLE4S219YDXOQHuMEo9AAML3Bn9tem8i56VKrJPOfkyaysruru74uOierszHNO/q38ddVUdyFH12WzFPDV8fHmFSW29FFItfe2LQMAAAAAALtO92DEkydP4o9bi6voYJvM4RSJBQAAAAAAA1f0QaSvmouHHb1OZYPEAgAAAACADaq+EmXDcHffWKtEKcNxmpgtqzkS7Wu+tJAqvNte7LYCAAAAAIBDQ9ZXmrhKj7VEO4NhOWs8PTb+m2uK9+Co0QASCwAAAAAAug+fEnLXr0Rd4RddmoU0vVRfaTbTq1VF3j2RbEBcAQAAAABAKPr/q63pqzD5qlSTq2dOO4grAAAAAADYYOmrcFU8FN0faJeKMBRO1o6ozVp5z9YIcQUAAAAAAAMZfRUSiSVeWRIfJjF+O04XnzChPY5CdGTb1MyOg/Fky9YIcQUAAAAAAGMyv3+1CJ6LTgAAAAAAAGtjpZdgxKtSAAAAAAAAa6Z78ODB0jEAAAAAAADsA+grAAAAAACANqCvAAAAAAAA2oC+AgAAAAAAaAP6CgAAAAAAoA0tnx+4/t+DmvJAQu23trbjPWX9rQ0AAAAAcGg0+/2rVW33mz/YXftJrmWfIL+qNgcAAAAAgCs79Gp9tbaN/qz6alZHpayt5QEAAAAADpkG+krc4ot300Upw3E2USwuOhq/NVwXhTR8pPlNHYmVymbzNF1aBSQWrJ10jGqjduJonm8ybNmy4a40PwAAAGyXqfpKE1fpsZaYZtASnTZDooW0dH9I6UeGI+1/tAxrzvpqHtlcwRoZxqVxoBXZHIsvp1Pt08iU075zjommbPvoKwAAgP2i+/Apod31q6y6qFBN4vWi0tv2nPqqoiLNvWel3QA7K1gvg4YJiXYy8ht5okRNg2mSJj1ODYpOnUpP9GVXCn0FAACwX8zy/1cz6SvbZkX6CvVVMKUUNwfCTiKKCqf+sU151JGWwamv/BedRPtaor/IxPwAAACwXdroq3D1/N5QSi1yf+BER628Zz2yp4L1Ylzz0RRC9s69VOo01Fe23IriNOxPuT8wDWa6HgMAAIDt0kxfhURiGU9usN+miX6bUXqaTUs33kbF/Y4M70WOxEQ2VLADiPcHGtdziq5lBd/9gUZ+p5dx2SIM/WMrTy3FyA+wTuou/zZx1CpzRX4AOGya/f4VNMFzFQ5gNxAv/oTW+iqbx87vLOW8flURnhiSLczSY+P6GMAiaNM/uOdC9usS20KrnFOKAMChwnqxOrQLZQC7hK2UtJ1WdL0ru8fyb92MSLLXu8Sy9pWxoktqkQW7Onb1AdZDNJ2jdC2/kadu0ol2stnqpjNssBcuT3q1o4aUGmcwwIjuwYMHS8cAAPuLsU/S9jRpQfvc7Mmp2dT0jCGEomj9sTlDEg+c+QHWRla6iDmd+sp25IxHC7La2sFirGBOUV2hYLNr/hR5XNS/DAYYgb4CgBmwz2SiLirdbI3tOM+d6aeavrIrYp+Y04rYmdPjKDxPfoD1YEwZY8BH2bKTrkJfidMKcdUQcV0NuTXcyJN2ludlFDfeZr3bOUvFG+w16CsAmA3/eU7LX7TB0sza9oOy67Ita/Eb2whnle140FewK2S/wjDmlHNrXrTPrpg7HpkHKeLKnNU/Tn1lO5pe3DmiPHbggEFfAcA81J3YouNSIzPpq6wj565LlIhDonMPaucHWAPp4Exn2XR9lc1jh1cxcZhrGoYg0ZRtmi0rabajr5zWxomlgcG+g76aRNd1w19YJ/TRYoxPjeK5xxYt2ZOWfUp2flfqlChOISf6tRNFm0Y1s/kBFqdu0kVfdvinc91EQFzNQdSJ48T02PjIENX+Bd+TX6uCUbvIePop4wTCQs8PdI49z+9NLYixca+eXHVTvpopNu0FaorZptYQV0sjDpGsvrJ3YOJHRqJhStwNeGxmE7N7C79my+ZnhMM6MYa0OJ49O3LDjnMi1J23mGVZtAW8rb7K5tHyZ99mzdoe7fMIHBgL/P5V0dgTpdQe66smxbdscM2LCfpqYYZ9TPYkqn3fqX3dWKSFDF/aF5Bail+JFe0Uxxmc37AaL4BlsYeluCYYMzGrr/wTwTlx7GxMNxG7+7SlO12NPYPHMGhElX2bNehZwAFCCNH1qy3oq9Kxt2Z9pWFvwPwWGrJ+g7BvpDsPbWLY50vP6dCTQbNjC6qKs2+6J2A3BodJ6UQWN+XG9LEnb5Q+FHcuERUZYIPRuWKXeVZ+w84c+qpCTrO8w1W2qq/EsSf+nO6QOE4XEwUf43U5/ciz6bmaWPp1VfplTemOyw48TY+WGo+jrM3x26A0p1h30VF6YB+XVtPICQAA26ZqX9s/enQlQ6kRz9KPvpoJW42IukjMkx5HXjRf2Q2EJ7/hWvuo1D4cBtvTV+Iwi+RTaaLqaawPUvdRYjTtPTPcRFxGNOeiH8+UL7LpPKFoNkX70Ue2d4+jopCciQAAsAD2mSNNDCF0XX/zZv/yy/39+3l9ld1nGxtuLeBsjSDLlJ2N1qe2Ebtf/DsMp8FxtiG86kEF+0v34VPCQtevQnIJq4G+0lxG01XTV9O+e0iLzq2vigJw2vTrlmzL2eth3eqnOWI1AwBYC4bCUdL7R49C111RWVHB9NhOdOZBX01nopjJimrRyFL6ylOEMXPAbO/61aW/ZLClCmoufZUqBk1fJfb8mssvUWbSV35dZNus01ceL+PE7FJZsfqxoAEALI/47b5xmhm97e/d669fV8++U7azqc3sqV07XUGE0Uf6Kb+/c8fKIwqw7Essnn1rJNqgryBh2/oqXB1vc90fmB5n1/QiXdLOueinVF9lbTbXV9O9V+ir6vYEAIDtkcqV7IqvLOX99ev90VH/5z/3Z2f5ld2pryrKclLxI4pVQ1/dvt3fuZMRZuJHRqL2UXazVdfR6CtIWEBfhURipQ+u8CcKpqNvUKLj9EuO8TciopGSeo2tpsfRQmEnaoFrdfVkdmbTWsKukRiSljNIC11FNT2OAABgRxmuZfW3b/dnZ0uHAybRzmpITI9H2frbt62tWmok8mgEo6Xoek+1ZiBuL9mOHDYL/P7VASJOMeYdAABAlv78vL97t7927VJlnZ4uHREkiN+DBofICSF0Xf/GG5c3CopGbL9F6UaG6m1ZdQywv9D3s+O8/AIAAAAaV1TW228/e5g77D79+fkziQWw+3QPHjxYOgYAAACAPLHKun9/6YigDf35ef/yy0gs2A/QVwAAALBL9Ofn/R//uLkP5PJh7rD79Ken/bVrSKwdw3+n5cS7toqKL32HGPoKAAAAdo/+7Kz/6KNnKuvLL/vz86WDgklcSqxbt+jKtSP9H118oBUJ+kNBnE6LIvTnb/d4EvQVAADAPrD0N7bLcEVlbR7mbm7ND7OVdoj+9DR0XX/jBhJr7YwfYaI9MTLNb+SxnyttSzJn5iHarJRCX8EidF03/AUAgMU55PU4Vln6w9wPuZV2hf7+fSTWwNq3W+L9gaJ0qdBXtiP/pxU20Vc7w5Sumn69sunMtGc7j0bcYHyDIy474pVzrWD0LUxUxPPljmEzG2e2i9tdY18ST/DbrGZzF54u9gwPT2Bzt48Yhj9y+9tMbSaujYqpWmrfsLmGBukfPepv3hyiFFVW0Z5tWdJ1vqHNKMWwLy4IMzHY/12HxAphteIqXTHHQ2ScTcxvW0iLi2/tj7Qw7IJiqSrQVzMwxyYoe7xdshPesyvde7JbkHTKZ7u3rridYWKigbOXtzYYKhzZRRafjlOcNul3fwDZ81qpQWfZibOj1N2yaL0zx2zdQvWrXcQq69at8cPc16avnItMW51can/La93GRf/llxUSa9kOnWEDuEp9tWEsqEpPGJ4hpWkwTY9F1lK9p+UsisoH+moGZtVXszpqB/pqg2dPWbQlmmMHWeHIyUHpq0WYT41oiXV7U/E0t2V9FaomQqm7ZXFuZjxlPdnmboGJ9mOV9fQns5xSf2usRF81LzKFwUV/+3apxFpzb+4V6dBMF/rp+iqbJ83v95LqNPRVBlHapo049ISdKBYXHWmqWtPZnpCGjzS/qSOxUtlsUo0iP54ztLPh7ebMUtTD2rFW3B+8p0Gyidpbu6zYdJpZMX6PzWzw/sz22KybcJrZtPh0RxpaxbM2i8anMTK1bOlYNbrerpFRpMiC3R1NBkOQRkJ67J8IxjAQq+kZnFpOT92N3kxDMtqhuuXt9kzLptX3zw5/SJGjcZ5fdf88664PSf3rr/+uux9CbDOlOs62/W4PWiPsKY2ctkl2LNldbLSJVouBv3e3Q9f1N24cdeetho2nj/xTxvaujc/oU9HRejEGxDhFHEZie2ltpx0YIYldGwUWkm4YJ9pzw8c+6iu7b0LSjs5Ep82gd79nuRK9px8ZjrTRYFgrGsE6ExvJ04Sljgzvzt5whuSMVgxAi8QoqJ0SsjnTFcawKZrVEkU8gy7Npn1aNzOmOBKLpGhnhKxN//jUgpkyjwxfaY2MEeJBG3haTi2lbkUvKu6vZvWKboQUNVRFb3pCsjPUFdcsbCEkj6P+3r3++vWhg9OfzKqOc2K/p66LHIkUjaWKxbztspZ1F0L47+6d8PQqVsP2nLJcOCNPfbVytBaMxdFeETy1Te14OsC5iGvBZAv62Hd9JSZOPPFm+8OZXje9ijJUe68aT/Z5t9P3oHZOI1vWe936mwZTdGLwWB5/pFXE7l6xhbN+/WPfb8rA00eCqY8/PuoujAnnqWnwjbrszK7YEPhXC//4NOLXshWN2KLBli0oZisdoraFmZZ5zbgn1NKxJOaM+q50CXLOuNR7msGOM+vOSHHOjqzBbPDpRIhV1uhh7vYpIErJhqQlir3prKZ/XdLGkm3fxijumQh+R2Lmo+68f+ON0HX9jRvXuzPDu+HIM5LtYeCZhs5lrWiErJEoVrGz04FSOgoHO9pLs29nTiM0mru2J9BX5Ym2I3963QpalKHUe4iXK3t8OkOrqNz0Fd+ZwRnPOKV0BcxO2/ECogXvjLOuhVudMLJ5vN1xcvI/3S/C48eiwdK+m9jv/qV1Ssc5nRbFb5xoSsObeOopqqYzkq0t8/5Q67o4OsguAnZvls64ihXDKOIZn1POWoZ3z0QY+Ki711+7NrTgRmUddfG/99i9YB8XDTCnff+6lB1LFUucfyH1V9PpbvO2P7+UWOfdUX96amc2DFb0UdE09Ftwel81/uXg4kLOX7SiiSnO8OwME09yYrk911cTz7EViUHvDM+pb7qjVt7LmRh76cnD42ii96KQnNPTdjTxtF00OhoOeQ3PoBNN/a47CS++GP72N8274aXI0fR+dxafYwkpymnnqdhzTHSklZ3SRw0nVzaqNLFJnOO/RszOOItGWmnLe0bjxBk3ZWob6d1ms3737lhlha77e3d7eJj7HFN7jnVJPPUUjSXPuCoNaYojMfPmbX9+vumy/uioPz2dqT2dic7Ip4e0XowVMHr78KGlr/w2xZS6kKKUIZguEXu1PbGP+iqEK02jJWpv00S/zSg9zaalG2+j4n5HhvcKRz6MVtTiyha3vYjpts264p6KG5+WBq9Nc7sztR52utA+zQYf1TE1rnk3GvBX3cP/7V78r+43l+tyYUgVo85TPK31xLHkHJ9GPJ7u8AdvjASjeBqSWGtPd4iJ9hC13zobs6iaWcvGWy28oYm0nB7srrQrFRwtnx3wWh3FzNlEOyRnTVOGRFFl9bdvby6PiL3j8e7pd381Pd5FU8ZYsm1qTedv+aI+0rykQYYQ+tPTi+5SYr3enVa3Z2kfOYMXvdfNmh0gijv6aPh7chIePhSyjfNEiVGG7Essnn0bfOOytjP2VF9BHcYwhWnUrcs7xCxhP34cXnwxvPLK5l5BhqeTxRtn8QAOFlp+jNYaUbqssp4+zL3ay66z2nr1p6fjq1hLh3PwGOq868LJSfjggzhdPEjfikPQHpcV+iprFn0FbdilL0/gAHj8OPz0p6HrhnsFGZ4GtM+BQ9dvsCeCmN6fn/cffRR9L96//Xb/j39UO4KZ6B89uuwgJNayjC8yjhM3PH4cuu7KnYGivtIu5Gkes/F4rnRlrYmX10pAXwHAurm4CL/4Rei68Jtn9woCADSnPzsTVFbyMHdYnP7+fSTWkqRyJRIkjx+Hn/wkPHyYuWaVvcSU+q2mtOy0L07QVwCwegaJ9cIL4V//WjoaANhnDJW1eZg7rAEk1nrZiKvf/nbpOJYEfQUAu8DFRbhz53Kv85e/LB0NAOw5/dlZf/NmrLJGP5kFi9P/6U9IrNWxEVdHRwd+vwn6CgB2h48/vtzovPPOga/dALAF+kePZJX1hz8MD3OHBelv337WL9zGuTgXF+HNN0PXPXtm4KGCvjoIuq4b/sKuU9Gbe9Xzn38efvAD7hUEgK0hqqyweZg7KmtpkFhrYRBXh31n4Ab0VQnG80wq/m1u/NyVOZ9ApG3HjUeqbJ8tB+N0ZzxyJn3UjWatbY0miqs19HUDTk4uJVbXhU8/XToaADgILJXle5g7zET/xhtIrIUZxNXB3xm4AX3ViIp9q+dJlC0Qd+TT99zNQy5qjFaPkKnwNeXJN6VI0m7qxas9lFg//3n47rulAwKAg6C/d6+/fl1QWe6fzILm9OfnSKwlGcQVdwY+BX3ViBXrK8354hYMg1njrfRVaf7s9a62zNRNeyKxNr8+vJlHL7zAmg4AW0NVWa+/zuZ+EZBYSzL8azR3Bj5l7/RVtNhF6SHI6eJtXp5b+AxfWe9DSki28GJIaQBXE5N1Pt9UmjEjhJKI6uNp0R5eX2nx1KxdUPs0O2rGb0MyOvxN5w8pm75jjCVWx72CALBVVJXFT2YtQf/tt/21a0isbTOIK+4MHLF3+irk9unZnMZuekpxzXukrwybnpyFpDJQc+7x6Y9dC6a5d9ud03i1vvJbi5SV012Wimh3j+++u/xprO7pvYKPH19+dHLCAzAAYG76L74Yb+uvqCwe5r5d+tNTUWL15+f9rVv9t98uG94+cHER3n//mY4axFXHnYFXODB95ck5XV+J1x0076LySC9wpDlbXeCQ6iGGY5QyIpqoryLLhnctp01ptzfRV1orlbrLYhTfE3G1Yfj14c3rhRfCyUk4OQk//GF4772lgwOA/ac/P+/v3pVVFj+ZtV1SidX/85/90VHgilYTHj26PM8+fHhFXHFn4FXQV/pxVlJk5ZlRNipim9L0VWKvTnN5qp4mehRXUGJ3hhEdZ4VHthOcRebWV3aeVvrqUMTVhouL8O67whzoOi5hAcB2yKgsHua+Lfr798XTQY8GmM5f/yq0LXcGJqCv9OPp+srpPXshI6uvyvfLTjlh5HQ2pxa73R4NvRfFKRr3y61SfVUxavxoZfdQXA2Mv0sbXlzCAoAtslFZ8tc9yU9m9ffvc1FlDkSJ1R8dLR3X7iOeZ7kzMGFP9dXwshPH6akRzaZmNtrU297Tt5rNIdvw13DkRmsPu+qiETFzlCGK3SioedEa1c6ZNWinZ7vdDtJZXGs0rZoetCJVg2WnEJd+LmEBwHbpz876jz6ST+hPH+a+0QD90VF/erp0vHuILLG++WbpuHac4Tns49fvf790WKtjT/UV1ELjhb1ohD2oQiUPH4Yf/jBe+rmEBQBLYKusZ5v+Gzf4B622bB5oITT1558vHdqO86MfycMYiXWVvdNX2kUQyEHLbaAddpiLi3B8LC/9XMICgIXwqKz+zp2lw9wfhgdaCO387rtLR7fLnJ4K32B2XXj7bU6yEXunrwDgYPngA3X7wiUsAFiU/vS0v3nTklj8I1Yj+tPT/pNPxJ8mC13HpcJ6Tk5QVk66ByOePHkyk5t///KXvHjx4jXv6803//Paa9+/9FJ/fBx+/OPoNPCf115bPkJevHgd+Ou1175//nl53//cc//3s58tH+E+vV599fvj4/6558bt/O9XX10+sN18ff/SS8+G6/PP7/RZdSa9M7Cl61dbqAkAQMzjx+H+/XD3bnjnnfD++0tHAwAQ+m++4R+xtkl/ft7fu9f/+teXjfzpp0tHtLO8996uXLPqzH/zQF8BAAAA7A/9p5/yj1iL0J+d9V980d+6tXQgO8v7769fWW1AX+02m/6ze3EN7EqcBwLdAQBwsPSvvNJfv96/9Vb/1lv9J5/0n33Wf/ZZ//XX/ddf86B2OFgqtkZG3gPVV87W++r4+KvjY0/iImxzlzz+equ87O7v5qcEP6XtpnsXjMXdMT3AwgC26q45adhidYrqKGZLLUy06S/ur5HH5jjP9ru+qMWMzGlHrB9xrkWXK6LEkLRD1kiUaMdQNBjEUO36OqmeBdnMrQbGShbJqLPmdrSef2Ix1oHFO6WanQ4+pfV8nySupKXv8PRV0fASpdSh6SttDLlPPLujr5oHObHtZkDsjvFeymFhivc2dpZCFBjpcVE1tV1pW5v+4v4aFdn0j7FZZ+H2cy5LtrMiHRX0znIm+h0FXzO2WnDms1A6N9t6n5uizproaD36yo5zd2ke/OJPiWg1VKZfvEreHpi+Kh1ba9ZXW8P4Imff2NrObmVtN9/+oGHZldBcX9k2bUd1NtFX28y5LEW9aesr0aaYMtjRQtonfVXqAn1lOEJfzQ36qhWO0/Qh6Suxspv7/SLJNCSO08XEGPEcNf4oOpt10k0AVxOjjJ7lPs0pOg/Jqc6IXXORehEteJkpeiNxXCrruiik4SPNb7btipr4qtmiYRN5sGvpGLNeX7Yj41jrJU/XiX6r49eazk702NSGknNmlcZpGxGLGzaNyEsH2LjTgzQePNNIzGzUN0rMzTbLuzPOcR471OlTuzR426z21ohfy5P1VdrC/mXBSLcxMniGd6l3/2jUCnqGjWiztGxwdFNktm7TXNeeadWyZcVJ6m/5zXG1KsgO77EXrVJNRsg4w+KqqVpfZYexjb2+hRAOSF+JNY3kU2miTDSoo4M0cfxXy+nG8JMmimGKpaKPjOg8i6/KHNH7bQa9wY2ab6HtDGt2fd1MbKTSMRtVtNS7szeKQvKjeddOyXU2tYr455enlfwW7EbORlW01GnN6C9u9JGNvaXQ3laMz6KcUyhaU0PSyFqoUaJYEXs1tfOk+f1+7ZRsQc9SXeqiev0sWusaLnTTF9W6hbpi02y3g2ddEnO2nZvjIq2uuvhn8awLy+KqaXpLTqm+8ekB6augt0h0VaqBvhKPQ7I/0qbC+FWIWKL0FFtqKhuAlzmiF9vTedbV0rfcdvOfY/1j1g6zaMzWDUXnFmraNLIQAxA3ixVNkb6tPkdO3B84i2t1F605lzqti52bBru4jZHH3yBacc888ofqpHT5NALwB2zXIuvI9msvVnZZO11cLrIRZkf+lPVz/rVfDcZw5PGlrZOdfiruqvTVlO21fyyVrp+ar4o62gaj46KlciIbU4urprXpq1GzW229b/oqSI2SKqi59JW2HBpT4WmCthGxnTujyCZmTWUD8DJH9EVROtO33Hb+nd3obfWwmVg5/wCoG4rOLZQzjKJWylquPo01GV8VNp1lPcWdA0zbWnm8OzcNxsYui7Nzi7yHkk6M6qhFMnFqG4lGAP6A7VqIg8HAP5Kdi4OdM2vT6UKzWbR+Vq39ajBzDBuPBaNIZHOH9FXpuWMotVp9VVejxVXT9vWVew9gteAe6qtwtf5z3R+YHjefCo2cVydq0ZWHrBSeNfqiKqXpW267Uu/lFMVrnzhbnbYnep82jSy03vB07xzja6LNum2QEZsdTKfoK+fkmDg+/XGmmT3taXvP5nQGWYS/tf2nI/9gyOb0VNbZ8ulbMWW6TdtaqxXMH2fbAeN0VDSV/DZ3SF9VsCk4q74ajkuXnTrm7rLd0lfJmLHaej/1VbjaCuOnVozVlDMxplP+33D8UXf1+4Hhb5qzCrG0GJcWWhR7+lFkNvVSP4ebR++06amSmG68DZPbThwtpY5yZGPU4vLkdPqyE7O1LOrhKWQHghZ5kBqtNHhPR0wv7hzympfhIy2bx4IYfFTWDilq9vH40YgqnlrQEg3vmgVjsjQcsdkg08EZNVRFNbUYtLdRZi3+KJ40bGdU2eHtsZni7HcxpCLv/u6YSNGgNcqK6VrmubfXxvj0t3x1U3fT9JXRbqkX51CcyNxd1vZlrzb+KjvTD1RfAewb0XkAYFEYg3UceLsdePXrOPC1f6K+2hqD64b6alnq5OKCLzH+ulr7cqKvAPaDOb7DBICtwPSFapYaPNFVkUVGb/X2emtEjTNRFYg2t8zY++KqabUDAH0FAAAAALvHarfXGitXBaUsrppW25LoKwAAAADYPVa7vT4QFldNOzoA0FcAAAAAAABtQF8BAAAAAAC0YR/01fAfeLN6AQAAAAAAsNkxfSX+ssGGxe/75MWLFy9evHjx4sWLF69W2kfVRK30lfigjlU961b9SeIWBrXj7bOqNgcAAAAAOCja6Kv1i6sws76a1VEpa2t5AAAAAIADoYG+0nbzafpXx8fDK00cvx0faIlicdHR+K3huiik4SPNb+pIrFQ2m6fp0iogsQAAAAAAts9UfVUkrtJjLTHNoCU6bYZEC2np/pDSjwxHogqyrTnrq3lEYgEAAAAAbJm5rl/Z+kpMrFBN4vWi0tv2nPqqoiLNvWel3QDiCgAAAABg+8zy/1fi5n4mfeV05E9fob4KppTi5kAAAAAAgJUwy/MDs/pqopRa5P7AiY5aec96RFwBAAAAACxF+9+/Mvb34sMY0rv7xLdpot9mlJ5m09KNt1FxvyPDe5EjMRFxBQAAAACwIC311aVFtvit8VyFAwAAAACAxWmvr2AOtAtlAAAAAACwHtBXAAAAAAAAbegejHjy5MnS8QAAAAAAAOwqXL8CAAAAAABoA/oKAIhFgoMAAAF2SURBVAAAAACgDegrAAAAAACANqCvAAAAAAAA2oC+AgAAAAAAaAP6CgAAAAAAoA3oKwAAAAAAgDagrwAAAAAAANqAvgIAAAAAAGgD+goAAAAAAKAN6CsAAAAAAIA2oK8AAAAAAADagL4CAAAAAABoA/oKAAAAAACgDegrAAAAAACANqCvAAAAAAAA2oC+AgAAAAAAaAP6CgAAAAAAoA3oKwAAAAAAgDZ0LW21NLYMXx0ff3V8nKbvQdUAAAAAAGBuugcjnjx5Um+oqQIRRc520FwjsQAAAAAAwOaKaKjWV821xwr1VUBiAQAAAACASQN9JaqOzY12w+122rGRM71Vzyho67Gx8XD1JsC0uG0TiQUAAAAAABpT9ZUmrtJjf2KQLiIZxcd/NcScRSENILEAAAAAAECk+/ApYYbrV2liSESLkTPNll7C0swaru0rYLa+QlwBAAAAAIDGvP9/lUqpNNHIaaeEptevREdRBsQVAAAAAAAY/D92VKB6f7pl6QAAAABJRU5ErkJggg==" alt="" />

然后就需要在程序中读取那个链接字符串并创建链接了:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAApAAAAAwCAIAAAApVN3AAAAFxklEQVR4nO2d6ZHkNgxGlcRE4WgdgwNwiPKPqZVZxMlDB6X3amqLgkACVKP5DbXqnm0HAACAx7PdnQAAAADEINgAAAALgGADAAAsAIINAACwAAg2AADAAiDYAAAAC4BgAwAALACCDQAAsAAINgA8mu0Ph+Wfn5/j3ycj85RzAchzet0sUZlbwfXR//r73+NncITKOCO7TvqilxMZvCYXcG/ZWIwkMz6jMy5FNeaVav3Pz8/x09F3N/JMXiUKbG70F9Az+ZddsbICrPZ5lILULXIj3QeZHrQS7LmDT+T6UnESmD7g7bMruUuwyxBWO+zeLdi3vwTfKbCFQLDNcrmgjKYI0oo7aX/A5wv2E5aYU9fTUwO1clcCljCP/64Qzuj2a35GDo8tsIUI6+b/n+qwvMiVQ9XXd1MDuSkpN1Uqy9EOjccpK4SMoo7gdHc8HUGqbgirMlbeS6926qraVc7q+FYsK6WO6JkoyejSzUogmWry14XMq18e7i2l6BjLXuG7oCkldV5Nb4SkmzojxyizslBvX1eWox0aj1NWCBlFHUElnJHjkHk1M1deNW6vLjCZwHJ42Vdaq7ZLo2W33JyGnZJyI8UySgfVKE+pDpbbCJYkqPfJK7lqGqQaxw+0GyoYtjPR92hGh16GOTvdLWPf3CVWDQyWYr68kzk0pSRPOYGsN4IzWnK+/hQs1FvWllE6qEZ5SnWw3BzCGVFg0wvsHYR1o4hoRpgtuyr8fYKtGvtK0x8qTKCbVsH2HfzBW0XLGlNuSZuih5mogq1Gd9KwPNXtdXJGJa3rad5Yko/l2C9+IzRFD5dyP1aJJaKynTeGQ4UJWEwX7LzxywX2AlLzcUTXN/p9q3bm2i4h2JvA8rxSsPfhffOU/X04jiXYHdvl/D2DjL3kvPW0L5Zjf+B6utvarI6MYKt2CswZx19418WbkiOuvrNjV8fJX9iJ9RrWVrdgN9GqZH7bGtlyy4950i1xy5i8Jd5h7JiR+ua/rBSb6lPaL34jtEbPRGwV7A5tblLx6YJNgYVRuqO/jECwN+NBsE17mswx/torH2nPXOftD47ROpTG6qwaS0aZWxDyrqw0qoelPbzZq3qqznnPKpmMmz+jModq5GpY64L0zUhN/jBar/j0UkyOaSWmDp5MaR9+I8joTYH86HsC9QPT6kNn8tB5Bk39z2nr0bakbKuvr+oWFoN1qF755JhWYurgyZT2uwvs8NlX5hHZVzIPZ5DZFr+VL8/9gVSrcMZfXXxX5E1zeSxOga1+5Z+SfX6HDd2ou8yP8OW5PxB0C07lrQX2tvkAAAC8EgQbAABgARBsAACABUCwAQAAFgDBBo8nP7Xx5NwAAKbDkrfv9ud0Lbe+7hcznswFiuh8YjLZfXpKAADPhPWu+UO6me/wupLzgp4th9bHJfNxEWwA+A6sd82Cd7tCV5yUwzXb6/HQaDYAfIRgsfO/Iq48LBuWMQzhO2+JP6ctPVX/Cuu7pq3vs/Q7Vt3Lw137Es3KqHZXU0p+CWhTSgfqt/pNLwZ56ETJjOAYAQCWJpBS2baM0kE1jqbr/jltaSz/9ZGap7b9U75PJZa+Ue3enUNTSr84uji3GPIajDYDwJfJCrZqDBduf6gOLG3exJ8PaRXsX0J19E/5Pk1GuXVOCnNT2s5cWjeyg8XQ5JCxAwC8jPsFexO4KSlttcfqgu2P2WFHsAEAlmbaLfGkcZBQsGU7jNyqZN1CeIZR5jOe54H1Cs4qhnB8KxnfCADwSoL1Tt31VkbrUBpHczWeLJOnDuOeE+zME16VJXzIy+rrDOX4O8aqYz5PJ/ov/uuuGpuKwbmtUhktT7bdAPAdWNdirC3sF3iy8jm5PTltAIA+WNcCrE0tAADAlSDYAAAAC4BgAwAALACCDQAAsAAINgAAwAIg2AAAAAuAYAMAACwAgg0AALAACDYAAMACINgAAAALgGADAAAsAIINAACwAP8BjmPltuEGTrcAAAAASUVORK5CYII=" alt="" />

三、链接建立后就是打开那个链接,然后执行数据库的一些操作,然后在关闭链接,具体业务操作也不同,这里把实现一个通知公告功能的数据库操作代码粘贴一下,仅供参考:

 /*
* 创建人:
* 创建时间:2015-07-01
* 说明:数据库的助手类
* */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration; namespace DAL
{ public class SQLHelp
{
private SqlConnection conn = null;
private SqlCommand cmd = null;
private SqlDataReader sdr = null;
public SQLHelp()
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
conn = new SqlConnection(connStr); }
//SqlConnection conn = new SqlConnection(connStr); /// <summary>
/// 该方法实现对数据库的增删改。
/// </summary>
/// <param name="sql">对数据库的增删改sql语句</param>
/// <returns></returns>
public int ExecuteNonQuery(string sql)
{
conn.Open();
cmd = new SqlCommand(sql,conn);
int res = cmd.ExecuteNonQuery();
conn.Close();
return res;
}
/// <summary>
/// 执行查询的方法
/// </summary>
/// <param name="sql">执行查询的sql语句</param>
/// <returns></returns>
public DataTable ExecuteQuery(string sql)
{
DataTable dt = new DataTable();
conn.Open();
cmd = new SqlCommand(sql, conn);
sdr = cmd.ExecuteReader();
dt.Load(sdr);
//sdr.Close;
conn.Close();
return dt;
}
} }
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
/// <summary>
/// 公告管理数据库操作类
/// </summary>
public class NoticeDAO
{
/// <summary>
/// 根据公告id删除公告信息
/// </summary>
/// <param name="NoticeId">公告id</param>
public static void deleteNotice(string NoticeId)
{
SQLHelp SQLHelp = new SQLHelp();
string sql = "delete from T_notice where NoticeId='" + NoticeId + "'";
int i = SQLHelp.ExecuteNonQuery(sql);
//return i;
}
/// <summary>
/// 查询所有公告内容
/// </summary>
/// <returns>返回一个datatable类型的值</returns>
public static DataTable selectAll()
{
SQLHelp SQLHelp = new SQLHelp();
string sql = "select * from T_notice";
DataTable dt = SQLHelp.ExecuteQuery(sql);
return dt;
}
/// <summary>
/// 更新公告内容
/// </summary>
/// <param name="title">公告标题</param>
/// <param name="content">公告内容</param>
/// <param name="time">发布时间,默认为当前时间</param>
/// <param name="keyword">公告id</param>
public static void UpdateNotice(string title, string content, string time,string keyword)
{
string retitle = title.Replace("'", "''");//为了避免用户输入单引号的时候报错
title = retitle;
string recontent = content.Replace("'", "''");
content = recontent;
SQLHelp SQLHelp = new SQLHelp();
string sql = "update T_notice set NoticeTitle='"
+ title + "',NoticeContent='"
+ content + "',NoticeTime='"
+ time + "' where NoticeId='"
+ keyword + "'";
int i = SQLHelp.ExecuteNonQuery(sql); } /// <summary>
/// 插入公告内容
/// </summary>
/// <param name="title">公告标题</param>
/// <param name="content">公告内容</param>
/// <returns></returns>
public static int InsertNotice(string title, string content)
{
string retitle=title.Replace("'", "''");//为了避免用户输入单引号的时候报错
title = retitle;
string recontent = content.Replace("'", "''");
content = recontent;
string sqlstr = @"insert into T_notice(NoticeTitle,NoticeContent,UserId)values('"+title+"','"+content+"','1')";
SQLHelp SQLHelp = new SQLHelp();
int i = SQLHelp.ExecuteNonQuery(sqlstr);
return i;
}
}
}

四、页面的话,使用的是一个gridview来实现的,这里说一下从后台绑定数据:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAoEAAACHCAIAAADm9xTbAAALaklEQVR4nO3c27HbvBUGUDbhKlKP+3ELqSHj55TIPDjWT+GyAfAiiNJac8ZDQbiR9vATcCgvv3//XgGAl1tkMABMIYMBYI4vyuDl11I87mwCAOf6nAwu5mUtdx/Hy6/lz89QtwBw3Idk8GgAP3J3+2fybu3nwtMA4Jt8VwZvl7/F8lpXne8CQL9PyOBmAK9/V7f5u5a2AMzyLRm8Vn4HnGewvWgAXuP2GTwawMnLfC+6p38AOO6LMni7im1mcF4TAM517wzuDOC8QvBcdNKJjWgALvJdGVxcB8edyF0ALnLjDB4K4OJGdNxJ81fFAHDEt2RwrUL89JbnogG4zo0zGABuTQYDwBwyGADmkMEAMIcMBoA5ZDBly7IkBwCc6ytur8uyFnPkT3ntrdeoDVSb2N93lyAah1Kz2FVSIoYBrrD83pg9mQuFefbCeYyIJ3ZiLspggCn+ubfK4HczK4OLPYthgNPdOIMfO8nbbdv4uLjBm5QE1YK967xtcWLbtkcGWv/uISc7ybWS7UHcwyqDAV7lxhm8rmmkjRYWXzbrtKLx0OgjAy3F4+LL/AGr/uZBIQBHLD9//vz58+cqg+s91+ocnFLz5YkZnB/LYIDprINPzuBH5dqIMhiAP2TwyXvR6/0zuNkhAKe4fQYXH19asse1ijXzarXCbXnnxGpTjUcPyrMOo2eykkexttGbHPc8liWDAa5w7+8Hi4brFFfMAJzoxrfXoYUpALwb/180AMwhgwFgDhkMAHPIYACY40MyOP92DQC8uc/J4NlTAIAxMhgA5pDBADCHDAaAOT4hgwUwAHf0CRm8imEAbkgGA8AcMhgA5pDBADDH52SwGAbgXj4kgwHgdmQwAMwhgwFgDhkMAHPIYACYQwYD/3h8v8AXDeAFZPCTf/37v4+fi7oNeq69e9aUdnyDa9kovpvXbPa5PZ0jp7a7VTBoXnj6P4b+C7Wj5+ZA8eh55dMnCWzJ4NTjhttz5+28Oz/yptkkTuiesWJJag41yevvvmVvg615XudG4Br+FSclQ/8YhhyJt84EHS3My2UwXE0Gp7Z323Pj4WCoT8/g4vGODte3yeDicW1ip6+Gz22b/3U0K+8uBM4ig1PBDTpJjtquZm2rs7bPWRxlX/OaZEt5eZbXScq3/STHuzN4zTIvP6PaRQ4uUU/lizK4uG9f2/stlgRbx8Ff3LbD12SwYIazyOBU8Qbdcwdvvhu8bA7U2bwoDtGml2Vw/0UulvdfzysyuHgdgosTvOz89FOcgHUw3IsMTsUpGKyo4pq1yvnKLxi92LC5FL4ug/M1X0+H6/UZvC3Mr1L/Vkez/614FdvM4HgHImib9NBZ+UghcBYZnGomQTMe+m/iec196+BYZwYvmaBJszCW7DYnhcFxsZOgWrMwGH3fBe/8UBJHctw8DtrdPctgeD0ZnBqKhK/ai272UyvMB7o6gzv3ovs/b23fbS43X78XfUoGd7YFTiSDnwS7u7W93+Kec3H/s6dmMERQ3jyv2qZoMU5qDfPCvOfiMjoZIt4ZDi7+vgtS+4uoNSzWz69Jz4VKrlVes3ZV48JkDsW/jtpAtdEf7wYvm+XAKBkM/GMprcJrdYCDZDAAzCGDAWAOGQwAc8hgAJhDBgPAHDIYAOaQwQW1b0/WKgedrPWvb8bN+6farDB0OkNDX9TzFe4yT+CryOBUz/cjj3R1YhJ05srQGe345HGXbLvjnIHPJoOfnHtrvjqDO3sbGv3g6v+dyWDg3cjgJ50by9vC4n/4V9tzTkri5vnQa7b2PZLBxYGKs6oVFscqTr52nJ9O8dIVL1Rx3KD5dsSePuMzBThOBj8J7ra1W3aQTPlx3kNP8+U5gzsn3NNnfNx8N0+7oYH6z702t6b+0wR4PRn8JFmo9dy1T8/gfJV2RQYnwzU7DBaOcV7uC/t83P5la61PGQy8Gxn8JI6rZpOghx3r4GLbEzO4f61ZrNnZz/EMzguL1YKPLz2jA7yeDE7V8uZgBtd6uGIZXavTE0jxEDvi9oqB+slg4J3J4II8yYrbobVt0qC81mexeVI56GF05j0TiGvWuo0LDzZfd+k/zaCHfUMDxGQwNMhg4CIyGADmkMEAMIcMBoA5ZDAAzCGDAd7U8qvxPGBeodmEtyKD4esk39Ta8e2vnvr/+fHj8eftdE5+37fmijFZy844U5dfy7bCn5dJIe9MBhcM3ZJq1fLvwhZ7Pvi9l2bz2jdxDw6anNHB5r78M+rgBSte8NEMjivkGfafHz/+/CTHo3aH+mPQ4tDbwqFPD8P//kcCuLOrbej+OZDBdyGDU9vFwRVdnZ6F+6bRrHxin8XmJ17nz/DKyzAlg9dSzjV7OF3Q7ftk8HY5m/wE3fZX5n3I4Cfn5sHVGdzZ29DoQxm8+1xkcO7DMrjoLhk8ZOy6jS+Ce3J3W806+F5k8JPOjeVtYd6kuP2bh1azeT50MoFgwrWTCiawPAumlE+j2Wd+3HNNhqa0Vq58bYYdNf+fi4+D5K1H4bZmsX6x56T/pM/aBDqrFQfaXoTSrF6RwWtrm3qtbxrH28j9lXua96tdivJFPjWDH+8mm9IWwTcig580793NJkHgFfvvaV5LrHjCPX3Gx3HzYgR2DlQ8o1Nq1s5inyT8koO8cPtn0GfzuDiBWifNeeY9HMzg3Ze3mMFJcBaP807iJkE/Pc1HdV6Qfb8J7szgZB3MXcjgJ0HGdH7aPZ7B+RLtigxOhmt2GEwpnnyxcnxGzXMPBjorff92WDheSsvW/gx+9BCMFRfm5cHHgmInBzN4tPLD1Rm8Laytbk/P4IHPLt0Z3Pn74GQv2i+D70gGP4njqtkk6KE/g2tDnJ7BSc41JxAfBJOpZfCapWat/zyDiwN1vluL8FLlwnEQlp0ZXOzn9Axeo2X0zAxe678YPjGDm3PoHzHWeSl2Pw7duVNtHXxTMjhVu9EfzOBaD6dHeFCnGcbNIfozOD73YgYHAwUZPPRpYFQzg/PjnkVw8zguzMv7Pyv8feszM3jKXvQ7ZPDoQ9S8DxlckCdZcdlUW04F5bU+i82TykEPozPvmUBQc9ukZ/LJzJM6waXbjpKMFVy3fPR9lsqDV/lbj8LHnz3d5jWX0sNWQeFjxOI8w4EmZHD+4FXtraQ8r9bz+FVQrbO8U+1SPP3j3BvAzWq156K5CxnM5c4KRYYEi+z8Y9DoZ5cTP+vcWnAddmdw8Mvg4q+Et39aB9+ODOZC5y5MGVVbBwNvQgYDwBwyGADmkMF8AtvdwB3JYD6BDAbuSAbzjorfXOqpD3AjMrhg6Gne4JsJ22+15sdx8/6pNiuc/nDy8mx0SnlXcQ89Hcpg4I5kcGp0BTba1elZuG8azcr91U7/GCGDgS8hg5+ceyu/OoM7exsafXoGF3s7a9oAb0UGP+ncWN4WFpdxtT3npCRung+dTCCYcO2kggkEO8zF0wkKk5J82rUeamfULJTBwB3J4CfBrbyYl3mTIPCK/fc0TzK4c8I9fcbHO5oXX+at+psHhUMVAN6QDH6SLwrzt2pN8pf7MjhfIF6RwclwzQ6LU6r12RxdBgOsMjgxmg1xtYPr4GLbEzO4JxFrNWUwwHEyOFXMifxlrfxgupyyjK7V6dl/vmIveqh5s8MiGQzckQwuyJMs3x9OCjvLa30WmyeVgx5GZ94zgaBm/4kndfLj4GRrL4vltToA70wG846W0oq5VieuBvC2ZDCfQAYDdySD+QQyGLgjGQwAc8hgAJhDBgPAHPfO4OJXbgDgFu6dwauHcQC4LRkMAHPIYACYQwYDwBy3z+BVDANwT7fPYAEMwE3JYACYQwYDwBwyGADmuHcG+3+yALive2cwANyXDAaAOZbfG7MnAwBfxDoYAOaQwQAwhwwGgDlkMADMIYMBYI7/AXMGv12dnpYiAAAAAElFTkSuQmCC" alt="" />

五、分页功能的话本文暂时不做分享,谢谢