Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
AWS Certified Solutions Architect-Associate + AWS Certified Cloud Practitioner
Sanjeewani95
Updated:
Aug 19, 2026
🚀 එක පැකේජ් එකයි - මාසෙටම Unlimited Internet! 🌐
sayuru bandara
Updated:
Aug 18, 2026
🎬 CapCut Pro 1 Month Access! LKR 600
sayuru bandara
Updated:
Aug 18, 2026
🚀 Google One AI PRO Plan (Gemini Pro Activation) – 18 Months Access! LKR 2200
sayuru bandara
Updated:
Aug 18, 2026
Canva Pro Lifetime Own Mail Activation LKR 500
sayuru bandara
Updated:
Aug 18, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
C# එහෙම කාපු අය පොඩ්ඩක් එන්ඩෝ..
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="මම බෙනා" data-source="post: 17451896" data-attributes="member: 418963"><p><strong>C# එහෙම කාපු අය පොඩ්ඩක් එන්ඩෝ..</strong></p><p></p><p><span style="color: White">C# එහෙම කාපු අය පොඩ්ඩක් එන්ඩෝ..</span></p><p></p><p><span style="color: Purple"><span style="font-size: 15px">මචන්ලා මේකයි අවුල,මම ඩේටාබේස් එකක් හැදුවා MS Accsess හොඳද ඉතින් මේක C# වලට කනෙක්ට් කලා පහල කෝඩ් එකේ විදිහට, <img src="/styles/default/xenforo/smilies/default/oo.gif" class="smilie" loading="lazy" alt=":oo:" title="Oo :oo:" data-shortname=":oo:" /></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px">[CODE]</span></span></span></p><p> <span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px">private void Form1_Load(object sender, EventArgs e)</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> {</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> myconnect();</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> }</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> private void myconnect()</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> {</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> try</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> {</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> rs = new DataSet();</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\mydata2.accdb;");</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> cn.Open();</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> ad = new OleDbDataAdapter("SELECT * FROM Tblterms ORDER BY school", cn);</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> ad.Fill(rs, "Tblterms");</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> com = new OleDbCommand("SELECT school FROM Tblterms ORDER BY school", cn);</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> reader = com.ExecuteReader();</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> //clear list</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> //listBox1.Items.Clear();</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> </span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> while (reader.Read())</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> {</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> listBox1.Items.Add(reader[0].ToString());</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> }</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> }</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> catch (Exception ex) { }</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> </span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"> }</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px">[/CODE]</span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"><span style="font-size: 12px"></span></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px">ඩේටාබේස් එකේ තියෙන්නේ සිංහල, <img src="/styles/default/xenforo/smilies/default/yes.gif" class="smilie" loading="lazy" alt=":yes:" title="Yes :yes:" data-shortname=":yes:" /></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px">මම ඩේටාබේස් එකේ ඩේටා කනෙක්ට් කලේ Listbox එකකට,ඒත් Listbox එකට ඩේටා එන්නේ ඩේටාබේස් එකේ තියෙන පිලිවෙලට නෙමේ,</span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px">මේ මගුල හින්දා ඒ row ඒකේ තියෙන ඩේටා හරි පිලිවෙලට textbox වලට ඇඩ් වෙන්නෙත් නෑ....</span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px">ඇයි මේ ඩේටාබේස් එකේ තියෙන පිලිවෙලට Listbox එකට ඩේටා ඇඩ් නොවෙන්නේ... <img src="/styles/default/xenforo/smilies/default/sorry.gif" class="smilie" loading="lazy" alt=":sorry:" title="Sorry :sorry:" data-shortname=":sorry:" /><img src="/styles/default/xenforo/smilies/default/sorry.gif" class="smilie" loading="lazy" alt=":sorry:" title="Sorry :sorry:" data-shortname=":sorry:" /></span></span></p><p><span style="color: Purple"><span style="font-size: 15px"></span></span></p><p><span style="color: Purple"><span style="font-size: 15px">ඩේටාබේස් එකේ English words හරියට ඩේටාබේස් එකේ තියෙන පිලිවෙලට එනවා,ඒත් ඇයි සිංහල ඒ විදිහට Listbox එකට ඇඩ් නොවෙන්නේ</span></span> <img src="/styles/default/xenforo/smilies/default/eek.gif" class="smilie" loading="lazy" alt=":eek:" title="eek :eek:" data-shortname=":eek:" /></p></blockquote><p></p>
[QUOTE="මම බෙනා, post: 17451896, member: 418963"] [b]C# එහෙම කාපු අය පොඩ්ඩක් එන්ඩෝ..[/b] [COLOR="White"]C# එහෙම කාපු අය පොඩ්ඩක් එන්ඩෝ..[/COLOR] [COLOR="Purple"][SIZE="4"]මචන්ලා මේකයි අවුල,මම ඩේටාබේස් එකක් හැදුවා MS Accsess හොඳද ඉතින් මේක C# වලට කනෙක්ට් කලා පහල කෝඩ් එකේ විදිහට, :oo: [SIZE="3"][CODE] private void Form1_Load(object sender, EventArgs e) { myconnect(); } private void myconnect() { try { rs = new DataSet(); cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\mydata2.accdb;"); cn.Open(); ad = new OleDbDataAdapter("SELECT * FROM Tblterms ORDER BY school", cn); ad.Fill(rs, "Tblterms"); com = new OleDbCommand("SELECT school FROM Tblterms ORDER BY school", cn); reader = com.ExecuteReader(); //clear list //listBox1.Items.Clear(); while (reader.Read()) { listBox1.Items.Add(reader[0].ToString()); } } catch (Exception ex) { } } [/CODE] [/SIZE] ඩේටාබේස් එකේ තියෙන්නේ සිංහල, :yes: මම ඩේටාබේස් එකේ ඩේටා කනෙක්ට් කලේ Listbox එකකට,ඒත් Listbox එකට ඩේටා එන්නේ ඩේටාබේස් එකේ තියෙන පිලිවෙලට නෙමේ, මේ මගුල හින්දා ඒ row ඒකේ තියෙන ඩේටා හරි පිලිවෙලට textbox වලට ඇඩ් වෙන්නෙත් නෑ.... ඇයි මේ ඩේටාබේස් එකේ තියෙන පිලිවෙලට Listbox එකට ඩේටා ඇඩ් නොවෙන්නේ... :sorry::sorry: ඩේටාබේස් එකේ English words හරියට ඩේටාබේස් එකේ තියෙන පිලිවෙලට එනවා,ඒත් ඇයි සිංහල ඒ විදිහට Listbox එකට ඇඩ් නොවෙන්නේ[/SIZE][/COLOR] :eek: [/QUOTE]
Insert quotes…
Verification
Awruddata maasa keeyada?
Post reply
Top
Bottom