PDA

View Full Version : مبتدی: وارد كردن عدد به صورت خاص در ديتا گريد ويو



fatemeali
دوشنبه 03 مرداد 1390, 17:54 عصر
سلام
من يك برنامه نوشتم و اين جوري كار مي كنه كه يك فرم دارم كه چند تا تكس باكس داره ‌كاربر اونا رو از عدد پر ميكنه بعد اون عددا بايد توي ديتا گريد ويو به صورت زير نشون داده بشن . با دستور insert كار ميكنم. مشكلي كه وجود داره اينه كه اگر از "n\" براي جدا كردن استفاده مي كنم خطا ميگيره. يعني اينكه توي هر سطر چند خط عدد داشته باشم مثلا سطر اول اون 4 تا عدد رو داشته باشم
ممنون.


10
12
1 15
18

15
2 20
52
14

alicam
سه شنبه 04 مرداد 1390, 02:20 صبح
کدت رو بده ببینم چیه

fatemeali
سه شنبه 04 مرداد 1390, 10:58 صبح
SqlConnection conn = new SqlConnection();

conn.ConnectionString =
@"Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\mydata.mdf;
Integrated Security=True; User Instance=True";
conn.Open();


SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;


string sql = "insert into mydata (sabt,bed,tozih) ";
sql += " values (N'{0}',{1},N'{2}')";
sql = string.Format(sql,


comkh.Text ,Int32.Parse(txtkhnag.Text) + "\n" +
Int32.Parse(txtkhnes.Text) +
"\n" + Int32.Parse(txtsabt.Text),"");


cmd.CommandText = sql;
cmd.ExecuteNonQuery();
this.Close();

n
در واقع مي خوام عددها مثل تصوير پايين توي يك سطر چند خط قرار بگيره. و اگر هم كاربر 3 تا عدد وارد كرد،‌ 3 تا رو قرار بده و خطا نگيره كه عدد وجود نداره.
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAApsAAACjCAIAAAB KRkLaAAAMeUlEQVR4nO3dX04bWRbH8bsaLwHV5N37ABtlEV7Bp HCkSGyg37sV23mI1KsYxfx5iTTd6U6nZ+YlgWBsbCPmoWxX1bU xBOrW8Tn3+9FVizYVOPdU+fzAgO0cAABQ7tcP/3POuZ8AAIBaeaJfAAAAnUqJfnl5eQcAd3d3d3f2BoLeHemtvH4 GenVxcTGeTJ+wSHQAm9kbCHp3pLfy+hnoVTWJfnFxIb0RALvC3 kDQuyO9ldfPQK9IdAAVszcQ9O5Ib+X1M9ArEh1AxewNBL070lt 5/Qz0qppE//btm/RGAOyKWgbCxzcvnHv5PvwnurvTvCOG8+MZ6FU1if7161fpjWDH vX/54s1H6SJQjyAD4eObF4tL6P1L55zbdD3lx1RMZEfZrc/MeIHh/PHNiwdrDnamtnr/cmthtfbqRzvwmK5Wleh//+e/8/nt0z4QizWenB8lh/3BYdI9l66E9dw1m82DDISz10ny+nTyru0O+2vvPe3+oz1YHWNh R/kaHLr2u92qPKsqs97ws9fJgwWHOFODw/bgXfveD/vAkAnYqwo68K6dvD59aELOZvNqEv2vL3/P57fX4xtWTOs8TZZPHtgePPWfJ+mp+EZYVa7pbB5kIJx2k6R7M r657h+67I0tx4zP03b3pH+YHJ1r3VE/i8wkPb05OUpKG+kfPvIeF6ry8XmauEVJ600+7SbF8jZWm5+pR6 xFK1wlZ7PmXvXbbvPlWuzAaTcbpa3+c7dQTaJ//uvL7S2JHuVaXosP5/rybpkdthhShcu6337uBc3ahTWdzSsdCIOWO+yP1ydg6WvBxcXz QzkxLiXllstPYkfnaZKkp6tjlv/rfYQ6K/eSe3HHz8so7as0CjZV+4gz5X8dM745OUqcc612qZL1w7asGs9y/hnLs3HD2V9WVWrUlrZs2UI1if7n5y/z29vR9YQV0zpLE+eS7vB6MrqeDNN2erJ41zBNkvSseHCvlR/Za7lWf/Hf0fVZmiTZP1zewtK9ptNZtQNhcTmddJPlJTS6noyuBy2XrC65 xcVTOGbtIjxLk3av/K7iMVsuP4kdDVouq3bQSrrD68kwTYrlFf+3nsrX79TZja5wFvJ 9tQbeYX61/t4fODurVZwkWwob9durG6XOcvFT91rOryfvQGkGlveyugxKbdm yBRKd9cTl3ZGGaeKWd+Neyy3ePukmSbdXeNdodafqt7N7Zq+VX c35Zc1SvQLm33K6ZaswnZcXT+GY/CLM1kk3cYvjV+8qHLPt8hPe0eJu4rxEd2t5ELby5R22fPug5fL CtiS6X6239wfOzvJ2tymPT7qJ8ztQ+IxiZ3l0z1cn/tk/6SYuC/KzNHGudEnk7S20ZdsWqkn0T398ns9vr0ZjVjxrmCZ76Wnxlret 1ePvyd7isfik1coflc+0evlHKL+jL74p1vPXzXRW7UBYXWmFCy y7uJK9tYtn00W4+N9XvaPF8a2jV0n5ja2Xn8yOPMnRsHh8cvRq 9XZdlft3WOeca79d39fwaK/Vv3qo2vLeHzo7hbmxYQ2P1vpWPPuFt2s8y1ej8dXodLmFvFHrZ 7/VWx7W6l+N+oXGbGjLlj7cVJXov3/6cz6//X51zYpoDdM913r7/A+yl34Q3wurujW5mVY6EPoHLnk1ZEe7UPmu7EtzrwJ2aXIzrSb Rf/v9j/l8fvl9xIprFb/M3kv/9X10+X30y0Hyz7fp3kFv67/tHSy/PP1FfBesStdkMq1oICwukoO34cv+sO2K3ekd1VR5RfvaWm2o9b hPGr5Xwa/nyaSiRP/3b59m8/nF5RWLxYp8jSc3xgaC3h3prZxePW0L1ST6GQAAEFVNok+n0xkA zGaz2czeQNC7I72V1885J13Cc1WT6D8BAKBZ5FmWJ/rPAGAag868yE8xiQ4gFgw68yI/xSQ6gFioG3TqChYXecdIdAA+qwNB3b7UFSwu8o6R6AB8VgeCun 2pK1hc5B0j0QH4rA4EdftSV7C4yDtGogPwWR0I6valrmBxkXeM RAfgCz4QjvcbrrF/7N3aaW64sUrqBp26gsVF3jESHYAv8EA43m84txbeneaGG6ulbt CpK1hc5B0j0QH4gg6E4/2GazTK36N3movX8SPRS9QVLC7yjpHoAHwBB8LxfsM1O96j7p2m a3bueSi+SuoGnbqCxUXeMRIdgC/YQMjy/J6fo5Poa9QVLC7yjpHoAHyBBsIyz0n0x1JXsLjIO0aiA/AFGQh5npPoj6WuYHGRd4xEB+ALMRCyX3D3LBN+dQSJXqKuYHGR d4xEB+CT+Xt0En2NuoLFRd4xEh2Aj0TfEeoKFhd5x0h0AD4SfU eoK1hc5B0j0QH4rA4EdftSV7C4yDtGogPwWR0I6valrmBxkXeM RAfgszoQ1O1LXcHiIu8YiQ7AZ3UgqNuXuoLFRd4xEh2Az+pAUL cvdQWLi7xjJDoAn9WBoG5f6goWF3nHSHQAvlADwXveuLB/qraBukGnrmBxkXeMRAfgCzUQOs36U7xI3aBTV7C46jomfbE+CY kOwBf8tdeEqBt06goWV1XHOk2JB5GejUQH4As0EMS/61E36NQVLK6KjnWaUj8WejYSHYAvzEDoNJ1rNFY/SRf4bl3doFNXsLgKOtZpumanhuckDoFEB+ALMhCO9xvF73okHo JXN+jUFSyuso6R6ABsqGUgdJq1f5+ubtCpK1gciU6iAygh0XeE uoLFkegkOoCSIAPBT3CB35NTN+jUFSyORCfRAZSEGQjln5xL/OK7ukGnrmBxJDqJDqAk2EBY/V2QzF8GqRt06goWR6KT6ABKrA4EdftSV7A4Ep1EB1BidSCo25e 6gsVF3jESHYDP6kBQty91BYuLvGMkOgCf1YGgbl/qChYXecdIdAA+qwNB3b7UFSwu8o6R6AB8VgeCun2pK1hc5B0j0 QH4Ag+E+/8UPfAvGKsbdOoKFhd5x0h0AL6gA+H+V54+3m+E/UN1dYNOXcHiIu8YiQ7AF/4ZZjbE9vF+wzUafI9epK5gcZF3jEQH4As1ELa88nT2FLE86l6m rmBxkXeMRAfgCzsQNsT28infSfQydQWLi7xjJDoAX82Jnr+EC4 lepq5gcZF3jEQH4Ks10YsvyUail6krWFzkHSPRAfjqTPTsF9w9 xddRr5C6QaeuYHGRd4xEB+Cr/efoj3hXFdQNOnUFi4u8YyQ6AB+JviPUFSwu8o6R6AB8JPqOUFe wuMg7RqID8FkdCOr2pa5gcZF3jEQH4LM6ENTtS13B4iLvGIkOw Gd1IKjbl7qCxUXeMRIdgM/qQFC3L3UFi4u8YyQ6AJ/VgaBuX+oKFhd5x0h0AD6rA0HdvtQVLC7yjpHoAHyBB0KnyV+vP Y66gsVF3jESHYAv6EDoNN3G10dfPiEsiZ5TV7C4yDtGogPwBRs Inebiids3xPbxfsM1GnyPXqSuYHGRd4xEB+ALNRA6TdfsbH5oP XsFNh51L1NXsLjIO0aiA/DV/iywy1dUJdHL1BUsLvKOkegAfDUnev4K6SR6mbqCxUXeMRIdgK/WRM/znET3qStYXOQdI9EB+OpM9OwX3D3LhK+YukGnrmBxkXeMRAfg4 9VUd4S6gsVF3jESHYCPRN8R6goWF3nHSHQAPhJ9R6grWFzkHSP RAfisDgR1+1JXsLjIO0aiA/BZHQjq9qWuYHGRd4xEB+CzOhDU7UtdweIi7xiJDsBndSCo25e6 gsVF3jESHYDP6kBQty91BYuLvGMkOgCf1YGgbl/qChYXecfyRAcAAEr9zPfoANZZHQjq9qWuYHGRd4xEB+CzOhDU7 UtdweIi7xiJDgA7ismMH0KiA8COYjLjh5DoAABYQKIDAGABiQ4 AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDA GABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAAB YQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAF pDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAU kOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABi Q4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKI DAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoA ABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgA AFpDoAABYkCX6/wFdLiRknGjjlgAAAABJRU5ErkJggg==

http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAApwAAADACAYAAAC pmLMAAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJc EhZcwAADsIAAA7CARUoSoAAABhHSURBVHhe7d1rjFxneQDg15S EJCX/iOSSIAsbG8tpLFmVUBSkklDZAbm5OLC/u3KoUbPrilbUIuvfXkxCiWDWlbok0fZP1WpcGxJZztolpn+ilS K0IrWD5di0qIJsUfnBzbm1uOfMXry73svs5cx8880z0SiBPfOd 933e73znnXN2djZExLXi6UGAAAECBAgQIEBgXQVGf/jz2LPzjthQNpwjIyPrOrjBCBAgQIAAAQIEulugt7c35jScv/zlL7tbRPYECBAgQIAAAQLrJnDy5Mm4oeH81a9+Fbfffvu67cRA BAgQIHCjwK9//Wtr7QITo1tdujXvVNcG9Ygo+8GbP3DrupTon//pH+c0nO9bl1ENQoAAAQIECBAgQGARgUbDee2azw2ZIQQIEKhaw Fq7sHC3unRr3lUfZ6sdXz1WK9fc61zhbM7JVgQIECBAgAABAqs U0HCuEs7LCBAgQIAAAQIEmhNwS705J1sRIEBgzQJp3LK7HN/85IbY8MXTa85nvQboVpc08l6vKnb+OOpRbQ01nNX6Gr2tAqfji 5/8Zlxuawx2TuC6QMtPaJe/GZ+cOQaK42FD0Whu+LOIf7gW1/7+szeWZs72ratcyi6nv1iaVdOgtzzvZktazoOVvCFp07xpLp1i 3jeZS3L1WKvrSuvYHOiqt2r84fc3J/477vjQh+K9//2/VQ/khQQ6V+ByDN3/jdj6ZMTRN/46zvV/rHNTEXmyAu//vffF//ziF61da6/U4oHHI579/tZ45pYX4qG3/y4eXEDoytCn4pmt/xZDH5ve/mBsaZFkyi5zCEafiFtfeDjeOvaZdZFpS95l5GUejzw7mcO9fxv nv79Arct5842tca7ZXGfmWYvmTZFDfzwc8dU34q8Win+mQs2v7 W2rx1KzaU2uL0X//YXPkz+KLzR5XisNrl79bbV/Ful3v/tdI+Wyu/dkkNYcuBy1+2+OW2+ZevadXoc5Oj3mH0ftclnvLdF37ljs2XMs Xu7bsg7jm0NpzaFE6lGsse1Ya8tvL7527cGofSfi0fu/FZcXWOc3930/ansmnSa3L5/FcdJXbP/SE/FA7XJ1x0XCLteK3CfXnmKt2HIs/n374I0W5TarWZfakndR068+G/c+/XpcfeuduPqVohlZpLbX58HUfFgmzxu2b7afmDG+ufl5VqzVtT3 FnD7XH5uX3M8K1vY21GO0r5hbixyT02voHNfL34oHps6FfS8tt 65N+azkvLYub6UWH2Tmlnpxx8CDQIICW6L/XLEwnv963FtG99wjcdutH4jb+l9qLtbRvsntZ73mytD+OPG5Ys E9//k48YVaXJka6Uz/B6J/tLlhbUVgNQLlSaT6tba4snFrX5yZH+CDx+JqcWHrz2/9VAxNT/ol535x7A0VV6yK173c39z1zvJK6adnDd7sMZWmy5UYOno+njpf rj+Ta0X0Px+P/cv+uX4PPhT7n3txjncyeRfr3+x6RHHduv/Zr0f8zY5iTSzmyJzaLjJvpufRGvKcPxXnzJNyXpbNb/H8duxvrNX9/fPjjpg/t1Zy/CVTj4WCHvty3DPnfLZ4Hc488+XY8Z3S6rvFu8cFjvElUEq/dp/fphrOsod2hdNVmeXeMbXj58UtkQeKhvELEcNX347fFs/Xnno8nvrSgzNXXC7XipPcAu/SR/uK1x3dHq9Nve7ktUeKA+5aXP7RWOzYujmubf5sPBbH43TjKmf5 bFznr+5KTrPv+G2XZQ3KCVbOserX2gfjS0+dj6ONY2LyDDSztm 3uj+9dfTIu/mHRdM7M+9lzf+72Cx9b5TH5RIxOzdO52zR2Nqt+yx9T6bq8ERf H7o6tm4t8Nm+NHY3UNsdnHou4OMdu0vuFYm25fg5JI+/Ll87Pq0eZSzkHynX0fDxavvmYyWXevCnn6pxaLpXnvHk2dYW8+ XkyaVdeaT+5P+L5C9tjuK9Yo+fPpcXWxuIW++xzwI3zNo16zM6 njPHoxy80zmnluel6/Isdv5fj0oV7Y/uWyTsWD+1/duoYnz3vymZ1iWNzmfPbzIKxkm5+Bdv6s0grwLJp6wWuDD0eJx 4rDsqX+2f9TtmFOPTM9UuRVy6OxdjFqY8GXRmKP/n0UJwZuj/2xXfnvW4y/j0PPx7PHx0qrmxuia3lWaTxuBJvvF4ezK3P0R4JVCow9qOZq/iT+ylPVmNxceYq57y5P2v7OcfWzKFyOk6MPRcvTl1Cnb3N3O0T P6aWdflYbL/3QrxROl15I16fXimK9Wahx+SaktZasmXb3TF24vS8+k9Gv6X/yeJ64ux50NwsXDTP+Z5Xmp0nk/s9039L/P5tt8SLDxcXFuas91PxfvbzEYcej2Pzrs43xC9dmJNnR83Dshb bG/fvFn5MuzY8x+LE6caELM5XEWOHvnHjnYxY7NiMtp/fGg1n4/eKbng340qPK57tnwON+TnvXdnmvnNxIh5pLE7lc9/z98YnXp/63/ccjx07jse+Q8VJ4fnr2zQWsofeim/tLnLaPRSvPXY8djZeOxaH7inHuTsO7fhKPFFezXCFkUEVc6CFa +3McbO5Lw7tfy72TR0rM8dM8ebq/KOTx8+cuT9v+znH1vQYxTG27+TTM6/fF0/H16aOv9n/3fQxlbJLcYJvrA/3fDnGilufjTXj9afjS8U6MjrVIJWGO098Lr62Y/LnSeU9a62brv31f78Qf/rbqTVxar7PXm+n192m8lxonjU9T6YazWJ9/s28eOasxcU+/vW1z8Xxxno997nzUMQnYtp/3jmh2bW9hfNw8mrus7HvxN2NXHYeKs4/s67oLnj8FnNwx8nzU68pz1ffKbweihfnWHw1Pr7IsfniQ+eWP7 81955j1Vs1PqX+nz/5r7jrzg/HW2+/s+qBvJBAJQI/Lq5Y7rwYX/nNUOxe7x2UYxe36r9dvJvevN5jG4/APIGbbnp/TBR/EaT6tfZM/OUHj8b2114uTjDpl6FbXVqXd7NzoLPmTbNZNbtdOvVoXx1Kg3f efqvaT6nP/WSiKzyucCU0Bz5avKs9EfHYB2+L26efxS3z6U/ajh78dBw7UzSOB0ebvCo3WpyMp8YqGtlD3+uLj1ZxNcuYTdYjo blWcc2m7yJV93vC03P70YgT34u/+Gibbctfb2niuMzOJZm8m63/KudNk3m25Xy6itiqn4fL1WOVdVjHdavxC+YVPhpXOH/8Hz+Jj3zkzuLvL71d4a4MTYAAge4VuPnmm+LNNyestfOmQLe6d Gveqa4A6hFRGrz7ztuVXeFsNJwXLlxIdQ6IiwABAgQIECBAoAU Cd911V7UN57vvvtv46i4PAgQIEKhOYPLvTVpr5wt3q0u35l3dE ba2kW+66aZ477331jZIh7/66tWr1TacIyMjHU4kfAIECBAgQIDA6gV6e3tDP7R6v4VeWZqO/vDnsWfnHdG4pV6v19d3D0YjQIAAAQIrEOjp6QnnohWA2XTdBcz BdSeN0nS64fSH39ff14gECBAgQIAAAQKzBDScpgMBAgQIEGihQ HnVx4NAtwloOLut4vIlQKAtApqMtrDbKQECiQhoOBMphDAIECB AgAABArkKaDhzray8CBAgQIAAAQKJCGg4EymEMAgQIECAAAECu QpoOHOtrLwIECAwW2DiVBzuORynJhZiGY/hRX+GkQABAmsX0HCu3dAIBAgQSFxgIk7VRuLSIlGODw/G2cQzEB4BAp0toOHs7PqJngABAssKTJyqxUhsK/6Z/yivbPbEoG5zWUMbECCwNgEN59r8vJoAAQJpCxS30msjm2Lg4H0 3xjn+apzdPRD1Wu8CzWjaaYmOAIHOEtBwdla9REuAAIEVCEzeS t80cCB2LfSqXQeifmDBn6xgHzYlQIDA8gIazuWNbEGAAIGOFGj cSt80EHrKjiyfoAlkJaDhzKqckiFAgMCUwPStdN2mKUGAQAICG s4EiiAEAgQIrLfAxA9eKT6VfjYGiw8FlV+r2XOw/JT6pRg52BPD4+u9N+MRIEBgaQENpxlCgACBDAU27j0S9Xr9+rP xwaBt0Vuru8WeYb2lRCB1AQ1n6hUSHwECBAgQIECgwwU0nB1eQ OETIECAAAECBFIX0HCmXiHxESBAYD0ENu6NI/UjsXfjAoMt9bP12LcxCBDoegENZ9dPAQAECBAgQIAAgWoFNJzV +hqdAAECBAgQIND1AhrOrp8CAAgQIECAAAEC1QpoOKv1NToBAg QIECBAoOsFNJxdPwUAECBAgAABAgSqFdBwVutrdAIECLRPoPh6 y8PT3zQ0/e/Dp2KifRHZMwECXSqg4ezSwkubAIEuEHjzp3FpW2/UZn/j0JG9sdBfRuoCDSkSaLPAeAz3HI5TXfqOT8PZ5uln9wQIEKhKY OJnP4nY9GENZlXAxiWwAoHx4cE4u4Ltc9tUw5lbReVDgACBKYE 3f3optt35BzwIEGirQHllsycGu7nbLPw1nG2dhHZOgACBqgTG4 9XyBPdKLXpmfo9zOMar2p1xCRBYWGD81Ti7eyDqtd7Y1sVGGs4 uLr7UCRDIWGDiZ1HcUI+472DUp3+Hs3ZnHO/RdGZcdamlKLDrQNQP7EoxspbGpOFsKbedESBAoEUCje9Hr8eR2 V+evvHDsan4LbJXXeZsURHshgCBaQENp7lAgAABAgQIECBQqYC Gs1JegxMgQKBNAuPDxe9uLnT7fFv4HFGbamK3BLpYQMPZxcWXO gECGQvsejh6t827fV5+eGHbffFH/hBnxoWXGoE0BTScadZFVAQIEFijwMbYe2QgYrDn+qfUj98ZNX/4fY2uXk6AwGoENJyrUfMaAgQIdITArjjgW4Y6olKCJJC7gIYz9 wrLjwABAgQIEGi/QOMvRxyJ2X84ov1BtS4CDWfrrO2JAAECBAgQINCVAhrOriy7pA kQIECAAAECrRPQcLbO2p4IECBAgAABAl0poOHsyrJLmgABAgQI ECDQOgENZ+us7YkAAQJtEhiP4Z7DcWpiid1PnIrDy23Tpujtlg CBzhfQcHZ+DWVAgACBJQXGhweLb1Bf6jERp2ojcYkjAQIEKhLQ cFYEa1gCBAi0X6C8stkTg0t3mzFxqhYjsa34x4MAAQLVCGg4q3 E1KgECBNovUH6V5e6BqNd6F28mi1vptZFNMXDwvvbHKwICBLIV 0HBmW1qJESDQ9QK7DkT9wK4lGCZvpW8aOBBLbdX1jgAIEFizgI ZzzYQGIECAQGcKNG6lbxqIJXvSzkxN1AQIJCag4UysIMIhQIBA SwSmb6XrNlvCbScEul1Aw9ntM0D+BAh0pcDED14pPpV+NgaLDx X1lM+D5afUL8XIwZ4YHu9KEkkTIFChgIazQlxDEyBAIFWBjXuP RL1ev/5sfLBoW/TW6m6xp1o0cRHoYAENZwcXT+gECBAgQIAAgU4Q0HB2QpXESIAA AQIECBDoYAENZwcXT+gECBBoSmDj3jhSPxJ7Ny6xdTPbNLUzGx EgQOBGAQ2nWUGAAAECBAgQIFCpgIazUl6DEyBAgAABAgQIaDjN AQIECBAgQIAAgUoFNJyV8hqcAAECBAgQIEBAw2kOECBAgAABAg QIVCqg4ayU1+AECBBIQWA8hnsOx6mJJWIpvury8HLbpJCKGAgQ 6EgBDWdHlk3QBAgQaF5gfHiw+BLLpR4TcapWfrWlBwECBKoR0H BW42pUAgQIJCBQXtnsicGlu82YOFWLkcYXW3oQIECgGgENZzWu RiVAgED7BcZfjbO7B6Le+J70RR7FrfTayKYYOHhf++MVAQEC2Q poOLMtrcQIEOh6gV0Hon5g1xIMk7fSNw0ciKW26npHAAQIrFlA w7lmQgMQIECgMwUat9I3DcSSPWlnpiZqAgQSE9BwJlYQ4RAgQK AlAtO30nWbLeG2EwLdLqDh7PYZIH8CBLpSYOIHrxSfSj8bg8WH inrK58HyU+qXYuRgTwyPdyWJpAkQqFBAw1khrqEJECCQqsDGvU eiXq9ffzY+WLQtemt1t9hTLZq4CHSwgIazg4sndAIECBAgQIBA JwhoODuhSmIkQIAAAQIECHSwgIazg4sndAIECDQlsHFvHKkfib 0bl9i6mW2a2pmNCBAgcKOAhtOsIECAAAECBAgQqFRAw1kpr8EJ ECBAgAABAgQ0nOYAAQIECBAgQIBApQIazkp5DU6AAAECBAgQIK DhNAcIECBAgAABAgQqFdhQjH6t0j0YnAABAgQIECBAoKsEyi+W KL/FbPSHP489O++IRsNZ/p8eBAgQIFCdQLnwWmsX9+0mn27Ktbojav1HVpdqTKcbTrfU19/XiAQIECBAgAABArMENJymAwECBFog4Orm0sh8WjAJ7WJJAXOw2 gmi4azW1+gECBAgQIAAga4X0HB2/RQAQIAAAQKtFHAlrZXa9pWKgIYzlUqIgwABAgQIECCQqYCGM9P CSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwABA gQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkqLAAECBAgQIJC KgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQIECBAgkIqAhjOVS oiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQioCGM5VKiIMAAQI ECBAgkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIgwABAgQIECCQq YCGM9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08J KiwABAgQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkqLAAECB AgQIJCKgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQIECBAgkIq AhjOVSoiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQioCGM5VKi IMAAQIECBAgkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIgwABAgQ IECCQqYCGM9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpg IYz08JKiwABAgQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkq LAAECBAgQIJCKgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQIEC BAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQioC GM5VKiIMAAQIECBAgkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIg wABAgQIECCQqYCGM9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAg QIJCpgIYz08JKiwABAgQIECCQioCGM5VKiIMAAQIECBAgkKmAh jPTwkqLAAECBAgQIJCKgIYzlUqIgwABAgQIECCQqYCGM9PCSos AAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwABAgQIE CCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkqLAAECBAgQIJCKgIY zlUqIgwABAgQIECCQqYCGM9PCSosAAQIECBAgkIqAhjOVSoiDA AECBAgQIJCpgIYz08JKiwABAgQIECCQioCGM5VKiIMAAQIECBA gkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIgwABAgQIECCQqYCGM 9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwA BAgQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkqLAAECBAgQI JCKgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQIECBAgkIqAhjO VSoiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQioCGM5VKiIMAA QIECBAgkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIgwABAgQIECC QqYCGM9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz0 8JKiwABAgQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTwkqLAAE CBAgQIJCKgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQIECBAgk IqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQioCGM5V KiIMAAQIECBAgkKmAhjPTwkqLAAECBAgQIJCKgIYzlUqIgwABA gQIECCQqYCGM9PCSosAAQIECBAgkIqAhjOVSoiDAAECBAgQIJC pgIYz08JKiwABAgQIECCQioCGM5VKiIMAAQIECBAgkKmAhjPTw kqLAAECBAgQIJCKgIYzlUqIgwABAgQIECCQqYCGM9PCSosAAQI ECBAgkIqAhjOVSoiDAAECBAgQIJCpgIYz08JKiwABAgQIECCQi oCGM5VKiIMAAQIECBAgkKnA/wOXVQ27+RGZQgAAAABJRU5ErkJggg==

fatemeali
سه شنبه 04 مرداد 1390, 11:15 صبح
[QUOTE=fatemeali;1304007]SqlConnection conn = new SqlConnection();

conn.ConnectionString =
@"Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\mydata.mdf;
Integrated Security=True; User Instance=True";
conn.Open();


SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;


string sql = "insert into mydata (sabt,bed,tozih) ";
sql += " values (N'{0}',{1},N'{2}')";
sql = string.Format(sql,


comkh.Text ,Int32.Parse(txtkhnag.Text) + "\n" +
Int32.Parse(txtkhnes.Text) +
"\n" + Int32.Parse(txtsabt.Text),"");


cmd.CommandText = sql;
cmd.ExecuteNonQuery();
this.Close();

n
در واقع مي خوام عددها مثل تصوير پايين توي يك سطر چند خط قرار بگيره. و اگر هم كاربر 3 تا عدد وارد كرد،‌ 3 تا رو قرار بده و خطا نگيره كه عدد وجود نداره.
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAApsAAACjCAIAAAB KRkLaAAAMeUlEQVR4nO3dX04bWRbH8bsaLwHV5N37ABtlEV7Bp HCkSGyg37sV23mI1KsYxfx5iTTd6U6nZ+YlgWBsbCPmoWxX1bU xBOrW8Tn3+9FVizYVOPdU+fzAgO0cAABQ7tcP/3POuZ8AAIBaeaJfAAAAnUqJfnl5eQcAd3d3d3f2BoLeHemtvH4 GenVxcTGeTJ+wSHQAm9kbCHp3pLfy+hnoVTWJfnFxIb0RALvC3 kDQuyO9ldfPQK9IdAAVszcQ9O5Ib+X1M9ArEh1AxewNBL070lt 5/Qz0qppE//btm/RGAOyKWgbCxzcvnHv5PvwnurvTvCOG8+MZ6FU1if7161fpjWDH vX/54s1H6SJQjyAD4eObF4tL6P1L55zbdD3lx1RMZEfZrc/MeIHh/PHNiwdrDnamtnr/cmthtfbqRzvwmK5Wleh//+e/8/nt0z4QizWenB8lh/3BYdI9l66E9dw1m82DDISz10ny+nTyru0O+2vvPe3+oz1YHWNh R/kaHLr2u92qPKsqs97ws9fJgwWHOFODw/bgXfveD/vAkAnYqwo68K6dvD59aELOZvNqEv2vL3/P57fX4xtWTOs8TZZPHtgePPWfJ+mp+EZYVa7pbB5kIJx2k6R7M r657h+67I0tx4zP03b3pH+YHJ1r3VE/i8wkPb05OUpKG+kfPvIeF6ry8XmauEVJ600+7SbF8jZWm5+pR6 xFK1wlZ7PmXvXbbvPlWuzAaTcbpa3+c7dQTaJ//uvL7S2JHuVaXosP5/rybpkdthhShcu6337uBc3ahTWdzSsdCIOWO+yP1ydg6WvBxcXz QzkxLiXllstPYkfnaZKkp6tjlv/rfYQ6K/eSe3HHz8so7as0CjZV+4gz5X8dM745OUqcc612qZL1w7asGs9y/hnLs3HD2V9WVWrUlrZs2UI1if7n5y/z29vR9YQV0zpLE+eS7vB6MrqeDNN2erJ41zBNkvSseHCvlR/Za7lWf/Hf0fVZmiTZP1zewtK9ptNZtQNhcTmddJPlJTS6noyuBy2XrC65 xcVTOGbtIjxLk3av/K7iMVsuP4kdDVouq3bQSrrD68kwTYrlFf+3nsrX79TZja5wFvJ 9tQbeYX61/t4fODurVZwkWwob9durG6XOcvFT91rOryfvQGkGlveyugxKbdm yBRKd9cTl3ZGGaeKWd+Neyy3ePukmSbdXeNdodafqt7N7Zq+VX c35Zc1SvQLm33K6ZaswnZcXT+GY/CLM1kk3cYvjV+8qHLPt8hPe0eJu4rxEd2t5ELby5R22fPug5fL CtiS6X6239wfOzvJ2tymPT7qJ8ztQ+IxiZ3l0z1cn/tk/6SYuC/KzNHGudEnk7S20ZdsWqkn0T398ns9vr0ZjVjxrmCZ76Wnxlret 1ePvyd7isfik1coflc+0evlHKL+jL74p1vPXzXRW7UBYXWmFCy y7uJK9tYtn00W4+N9XvaPF8a2jV0n5ja2Xn8yOPMnRsHh8cvRq 9XZdlft3WOeca79d39fwaK/Vv3qo2vLeHzo7hbmxYQ2P1vpWPPuFt2s8y1ej8dXodLmFvFHrZ 7/VWx7W6l+N+oXGbGjLlj7cVJXov3/6cz6//X51zYpoDdM913r7/A+yl34Q3wurujW5mVY6EPoHLnk1ZEe7UPmu7EtzrwJ2aXIzrSb Rf/v9j/l8fvl9xIprFb/M3kv/9X10+X30y0Hyz7fp3kFv67/tHSy/PP1FfBesStdkMq1oICwukoO34cv+sO2K3ekd1VR5RfvaWm2o9b hPGr5Xwa/nyaSiRP/3b59m8/nF5RWLxYp8jSc3xgaC3h3prZxePW0L1ST6GQAAEFVNok+n0xkA zGaz2czeQNC7I72V1885J13Cc1WT6D8BAKBZ5FmWJ/rPAGAag868yE8xiQ4gFgw68yI/xSQ6gFioG3TqChYXecdIdAA+qwNB3b7UFSwu8o6R6AB8VgeCun 2pK1hc5B0j0QH4rA4EdftSV7C4yDtGogPwWR0I6valrmBxkXeM RAfgCz4QjvcbrrF/7N3aaW64sUrqBp26gsVF3jESHYAv8EA43m84txbeneaGG6ulbt CpK1hc5B0j0QH4gg6E4/2GazTK36N3movX8SPRS9QVLC7yjpHoAHwBB8LxfsM1O96j7p2m a3bueSi+SuoGnbqCxUXeMRIdgC/YQMjy/J6fo5Poa9QVLC7yjpHoAHyBBsIyz0n0x1JXsLjIO0aiA/AFGQh5npPoj6WuYHGRd4xEB+ALMRCyX3D3LBN+dQSJXqKuYHGR d4xEB+CT+Xt0En2NuoLFRd4xEh2Aj0TfEeoKFhd5x0h0AD4SfU eoK1hc5B0j0QH4rA4EdftSV7C4yDtGogPwWR0I6valrmBxkXeM RAfgszoQ1O1LXcHiIu8YiQ7AZ3UgqNuXuoLFRd4xEh2Az+pAUL cvdQWLi7xjJDoAn9WBoG5f6goWF3nHSHQAvlADwXveuLB/qraBukGnrmBxkXeMRAfgCzUQOs36U7xI3aBTV7C46jomfbE+CY kOwBf8tdeEqBt06goWV1XHOk2JB5GejUQH4As0EMS/61E36NQVLK6KjnWaUj8WejYSHYAvzEDoNJ1rNFY/SRf4bl3doFNXsLgKOtZpumanhuckDoFEB+ALMhCO9xvF73okHo JXN+jUFSyuso6R6ABsqGUgdJq1f5+ubtCpK1gciU6iAygh0XeE uoLFkegkOoCSIAPBT3CB35NTN+jUFSyORCfRAZSEGQjln5xL/OK7ukGnrmBxJDqJDqAk2EBY/V2QzF8GqRt06goWR6KT6ABKrA4EdftSV7A4Ep1EB1BidSCo25e 6gsVF3jESHYDP6kBQty91BYuLvGMkOgCf1YGgbl/qChYXecdIdAA+qwNB3b7UFSwu8o6R6AB8VgeCun2pK1hc5B0j0 QH4Ag+E+/8UPfAvGKsbdOoKFhd5x0h0AL6gA+H+V54+3m+E/UN1dYNOXcHiIu8YiQ7AF/4ZZjbE9vF+wzUafI9epK5gcZF3jEQH4As1ELa88nT2FLE86l6m rmBxkXeMRAfgCzsQNsT28infSfQydQWLi7xjJDoAX82Jnr+EC4 lepq5gcZF3jEQH4Ks10YsvyUail6krWFzkHSPRAfjqTPTsF9w9 xddRr5C6QaeuYHGRd4xEB+Cr/efoj3hXFdQNOnUFi4u8YyQ6AB+JviPUFSwu8o6R6AB8JPqOUFe wuMg7RqID8FkdCOr2pa5gcZF3jEQH4LM6ENTtS13B4iLvGIkOw Gd1IKjbl7qCxUXeMRIdgM/qQFC3L3UFi4u8YyQ6AJ/VgaBuX+oKFhd5x0h0AD6rA0HdvtQVLC7yjpHoAHyBB0KnyV+vP Y66gsVF3jESHYAv6EDoNN3G10dfPiEsiZ5TV7C4yDtGogPwBRs Inebiids3xPbxfsM1GnyPXqSuYHGRd4xEB+ALNRA6TdfsbH5oP XsFNh51L1NXsLjIO0aiA/DV/iywy1dUJdHL1BUsLvKOkegAfDUnev4K6SR6mbqCxUXeMRIdgK/WRM/znET3qStYXOQdI9EB+OpM9OwX3D3LhK+YukGnrmBxkXeMRAfg4 9VUd4S6gsVF3jESHYCPRN8R6goWF3nHSHQAPhJ9R6grWFzkHSP RAfisDgR1+1JXsLjIO0aiA/BZHQjq9qWuYHGRd4xEB+CzOhDU7UtdweIi7xiJDsBndSCo25e6 gsVF3jESHYDP6kBQty91BYuLvGMkOgCf1YGgbl/qChYXecfyRAcAAEr9zPfoANZZHQjq9qWuYHGRd4xEB+CzOhDU7 UtdweIi7xiJDgA7ismMH0KiA8COYjLjh5DoAABYQKIDAGABiQ4 AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDA GABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAAB YQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAF pDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAU kOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABi Q4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKI DAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgAAFpDoA ABYQKIDAGABiQ4AgAUkOgAAFpDoAABYQKIDAGABiQ4AgAUkOgA AFpDoAABYkCX6/wFdLiRknGjjlgAAAABJRU5ErkJggg==



72933

z.gh_user
چهارشنبه 05 مرداد 1390, 11:22 صبح
سلام
منم تقریبا همچین مشکلی دارم , اما برای من مهم نیست که اعداد حتما خط به خط نشون داده بشن ,فقط میخوام همه در یک سلول قرار بگیرند(با فاصله) اگه در این مورد مشکلی ندارین میشه راه حلتونو بهم بگین؟

fatemeali
پنج شنبه 06 مرداد 1390, 09:52 صبح
سلام دوست عزيز
من هنوز جوابي براي اين مشكل پيدا نكردم اگه به نتيجه اي رسيدم حتما شما رو خبر مي كنم
ميشه لطفا يكي ما رو راهنمايي كنه
خيلي ممنون :گریه::گریه::گریه: