怎样用C#语句向数据库中插入一条记录 在C#中,如何使用sql语句向数据库中添加信息
\u5982\u4f55\u5f80\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u4e00\u6761\u6570\u636e\u4f60\u8fd9\u662f\u7528jsp\u505a\u7684\u8fd8\u662f\u7528\u5176\u4ed6\u7684\uff1f
jsp\u7684\u8bddform\u91cc\u8bbe\u7f6e\u597d\u5bf9\u5e94\u7684\u53d8\u91cf\uff0c\u5728jsp\u4e2d\u8bbe\u7f6e\u5176\u5bf9\u5e94\u7684\u5c5e\u6027\uff0c\u53d6\u5230\u503c\u76f4\u63a5\u62fcinsert\u6216\u8005update\u8bed\u53e5\u5c31\u53ef\u4ee5\u4e86\u5427\u3002
\u8fde\u63a5\u5b57\u7b26\u4e32 = @"Data Source=LocalHost\\u670d\u52a1\u5668\u540d;Initial Catalog=\u6570\u636e\u5e93\u540d ;Integrated Security=True";
SqlConnection con = new SqlConnection(\u8fde\u63a5\u5b57\u7b26\u4e32);
string ss = \u201csql\u8bed\u53e5\u201d;
SqlCommand com = new SqlCommand(ss, con);
con.Open();
com.ExecuteNonQuery();
con.Close();
\u7136\u540e\u518d\u52a0\u5165SQL\u8bed\u53e5\u201cinsert into \u8868(\u5b57\u6bb5\u540d\uff0c\u5b57\u6bb5\u540d\uff0c\u5b57\u6bb5\u540d......) values\uff08\u2018\u76f8\u5e94\u6570\u636e\u2019\uff0c\u2018\u76f8\u5e94\u6570\u636e\u2019.....\uff09\u201d\u5c31\u884c\u4e86\uff0c\u8bb0\u4f4f\uff1a\u6807\u70b9\u7b26\u53f7\u4e00\u5b9a\u8981\u662f\u82f1\u6587\u72b6\u6001\u4e0b\u7684\u624d\u884c
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strSql = "insert into moneyinf values('" + namecombox.Text.Trim() + "','" + moneytext.Text.Trim() + "')";
OleDbCommand com = new OleDbCommand(strSql,conn);
com.ExecuteNonQuery();
conn.Close();
往一个叫moneyinf的表里插入数据~~很简单的，就按照表里的对应的字段的顺序~~ 当然还可以加上try catch 那就更好些~~
SqlConnection con=new SqlConnection("XXXXX");
con.Open();
SqlCommand cmd=new SqlCommand("insert into XXXX",con);
cmd.ExecuteNonQuery();
SqlConnection con=new SqlConnection("连接字符串");
con.Open();
SqlCommand cmd=new SqlCommand("insert into 表名",con);
cmd.ExecuteNonQuery();
你还没搞清楚C#与数据库是什么吧。。
不是C#是T-SQL命令
绛旓細鐐瑰嚮close銆傛敞鎰忓埌宸︿笂瑙掞紝鍗曞嚮鈥渇ile鈥濓紝鍗曞嚮鈥渘ew鈥濄傞夋嫨鈥淔ILE鈥濋偅涓夐」鍗★紝閫夋嫨c++soursefile(C璇█绋嬪簭鐨勬簮鏂囦欢)锛屽崟鍑籓K绯荤粺鑷姩鐢熸垚涓涓猚pp1鏂囦欢锛屾帴涓嬫潵灏卞彲浠ュ湪閲岄潰鏁蹭唬鐮佸暒~~鍏蜂綋浠ｇ爜鎬庝箞鏁诧紝灏遍渶瑕佷綘绯荤粺鍦板涔燙璇█鎴栬匔++浜嗐傚鍥炬墍绀猴紝绾㈠湀閲岀殑鎸夐挳鐨勪綔鐢ㄦ槸淇濆瓨cpp鏂囦欢鍜屾煡閿欙紝钃濆湀閲岀殑...
绛旓細鏂规硶/姝ラ 1銆侀鍏堬紝鎵撳紑缂栬瘧鍣紝鏂板缓鏂囦欢銆傚嚭鐜扮殑绌虹櫧澶勬槸鍐欎唬鐮佺殑銆2銆佽緭鍏モ#include<stdio.h>鈥滆繖涓负澶存枃浠躲3銆佺浜岃锛岃緭鍏モ漨ain鈥滐紝鍔犱笂涓瀵光濆皬鎷彿鈥溿4銆佸湪main锛屼笅鏂癸紝杈撳叆涓瀵瑰ぇ鎷彿 {}銆5銆佸湪澶ф嫭鍙烽噷杈撳叆锛屸漰rintf("Hello,Word\n")锛涒濄6銆佽繍琛岀▼搴忓嵆鍙湅鍒拌緭鍏ョ殑璇濅簡銆
绛旓細int main(void){ char name[20];printf("璇疯緭鍏ヤ綘鐨勫鍚嶏細");scanf("%s",name);printf("浣犵殑濮撳悕鏄細%s\n",name);return 0;}
绛旓細鍏充簬c璇█濡備綍姹備竴涓暟鐨勪綅鏁板涓嬶細鍦–璇█涓紝璁＄畻涓涓暟鐨勪綅鏁版槸涓椤瑰父瑙佺殑鎿嶄綔銆備綅鏁版槸鎸囦竴涓暟鐨勫崄杩涘埗琛ㄧず涓殑鏁板瓧涓暟銆備笅闈㈡垜浠皢浠嬬粛涓绉嶇畝鍗曠殑鏂规硶鏉ヨ绠椾竴涓暟鐨勪綅鏁般傝繖绉嶆柟娉鍒╃敤浜嗘暣鏁伴櫎娉曡繍绠楃殑鐗规с傛垜浠彲浠ラ氳繃涓嶆柇鍦板皢寰呰.绠楃殑鏁伴櫎浠10锛岀洿鍒板晢涓0涓烘锛屾瘡杩涜涓娆￠櫎娉曡繍绠楀氨灏嗕綅...
绛旓細鍒╃敤srand((unsigned int)(time(NULL))鏄竴绉嶆柟娉曪紝鍥犱负姣忎竴娆¤繍琛岀▼搴忕殑鏃堕棿鏄笉鍚岀殑銆傚湪C璇█閲屾墍鎻愪緵鐨勯殢鏈烘暟鍙戠敓鍣ㄧ殑鐢ㄦ硶锛氱幇鍦ㄧ殑C缂栬瘧鍣ㄩ兘鎻愪緵浜嗕竴涓熀浜嶢NSI鏍囧噯鐨勪吉闅忔満鏁板彂鐢熷櫒鍑芥暟锛岀敤鏉ョ敓鎴愰殢鏈烘暟銆傚畠浠氨鏄痳and()鍜宻rand()鍑芥暟銆傝繖浜屼釜鍑芥暟鐨勫伐浣滆繃绋嬪涓嬶細1) 棣栧厛缁檚rand()鎻愪緵涓涓瀛...
绛旓細瀹屽叏鏁版槸鎸囨墍鏈夌湡鍥犲瓙涔嬪拰绛変簬璇ユ暟鏈韩鐨勬鏁存暟銆傚彲浠浣跨敤浠ヤ笅C璇█浠ｇ爜鏉ユ壘鍑哄皬浜庣瓑浜巒锛坣涓烘鏁存暟锛夌殑瀹屽叏鏁帮細```c include <stdio.h> int main() { int n, i, j, sum;printf("璇疯緭鍏ヤ竴涓鏁存暟n锛");scanf("%d", &n);for (i = 1; i <= n; ++i) { sum = 0;for (j =...
绛旓細1銆佹柊寤轰竴涓枃浠跺す锛屽苟鍦ㄦ枃浠跺す涓缓绔嬩竴涓枃妗ｃ2銆佹墦寮鑷繁鐨C璇█缂栬緫鍣ㄣ3銆佹柊寤轰竴涓簮鏂囦欢銆4銆佸啓濂紺璇█鍩烘湰鐨勬鏋躲5銆佸皢鏂囦欢淇濆瓨鍒版柊寤虹殑鏂囦欢澶逛腑銆6銆佷繚瀛樼殑鏂囦欢鍚嶄竴瀹氳鍔.c锛屽湪鐐瑰嚮淇濆瓨銆7銆佽緭鍏ヤ笅闈㈢殑浠ｇ爜銆8銆佺偣鍑绘枃妗ｏ紝杈撳叆鐨勫唴瀹瑰氨鍑虹幇鍦ㄤ簡鏂囨。涓
绛旓細鏈甯哥敤鐨勬柟娉曞氨鏄氳繃寰幆瀵规暟缁勪腑鐨勫厓绱犻愪釜鍙栧硷紝骞朵笌鍙傝冨(瑕佹煡璇㈢殑鍊)鍋氭瘮瀵癸紝骞跺鐞嗙粨鏋溿備笅闈㈡槸涓涓畝鍗曠殑瀵逛竴缁存暟缁勮繘琛屾煡璇㈢殑鏍蜂緥銆傚嚱鏁板姛鑳斤細瀵硅緭鍏ョ殑鏁扮粍鍏冪礌杩涜鏌ヨ锛屾墦鍗扮鍚堟煡璇㈠肩殑鍏冪礌浣嶇疆锛屽苟杩斿洖鏌ヨ鍒扮殑鍏冪礌鎬绘暟銆傚嚱鏁板悕锛歛rray_query 鍑芥暟澹版槑: int array_query(int *a, int n, ...
绛旓細Linux涓C璇█缂栫▼鍩虹鐭ヨ瘑:1.婧愮▼搴忕殑缂栬瘧 鍦↙inux涓嬮潰,濡傛灉瑕佺紪璇戜竴涓狢璇█婧愮▼搴,鎴戜滑瑕佷娇鐢℅NU鐨刧cc缂栬瘧鍣. 涓嬮潰鎴戜滑浠ヤ竴涓疄渚嬫潵璇存槑濡備綍浣跨敤gcc缂栬瘧鍣. 鍋囪鎴戜滑鏈変笅闈竴涓潪甯哥畝鍗曠殑婧愮▼搴(hello.c): int main(int argc,char **argv) { printf("Hello Linuxn"); } 瑕佺紪璇戣繖涓▼搴,鎴戜滑鍙鍦ㄥ懡浠よ...
绛旓細鏂规硶锛歩nclude <stdio.h> define PI 3.14 int main(){ float r,c,area;printf("璇疯緭鍏ュ渾鐨勫崐寰勶細");scanf("%f",&r);c=2 * PI * r;area=PI * r * r;printf("璇ュ渾鐨勫懆闀挎槸%.2f锛岄潰绉槸%.2f\a",c,area);}
