SkyCross

Hello Experts, I just wanna know how to display prime numbers in TListBox, If I put 10 in EditBox then it would display all the possible numbers fom 1 to 10,and will display to its according listbox.The even numbers in even_listbox, if prime it will display in prime_listbox and if …

Hello everyone, I got an error Syntax error From Clause, anyone can help me? I want to delete rows from 2 tables in my database that has the same LotNo. I am using c# with MSaccess I have tables -Personaldata -Spouse Primary keys for each tables is LotNo. Pls, help …

Pls do help me, I got an error **Input String was not in a correct format**. Here is the code where error appears, This is in my Record form. After I click edit, it will be redirected to my Update2 form Update2 f2 = new Update2(); f2.BlockNo1 = Convert.ToInt32(BlockNo1);//error here …

Hello... I just wanna ask why is that my edit is not working? I have 2 tables in my database, Personal data and Spouse. And I have each datagrids for both tables. My problem was that, when I inserted this in my code ***string queryString = "SELECT BlockNo, LotNo, Numberofoccupants, …

Why I can't update data in my database MSAccess? though, it's already working, but no changes. Pls help me... Here's my code for Update I have 10 Fields in my table Personaldata try { Records f1 = new Records(); BlockNo = textBox1.ToString(); LotNo = textBox2.ToString(); Numberofoccupants = textBox3.ToString(); Firstname = …

I got an error, "Syntax error (missing operator) in query expression ''Blanco, Familyname='Grace'." in my code, near ExcecuteQuery(); I am performing Update from MSAccess, I can retreive data but when I used to click my update button, I got error. anyone can help me? Heres my code `private void button1_Click(object …

I have here my code; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from Personaldata", connParam); OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter); DataTable dataTable = new DataTable(); DataSet ds = new DataSet(); dAdapter.Fill(dataTable); dataGridView1.DataSource = dataTable; for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][3], dataTable.Rows[i][4], …

hello everyone. I am doing a program with c# DatabaseMicrosoftAcces And I got error Overflow. It points out in ExecuteQuery(); pls help me. Here's my code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace sad { public partial class …

Hi everyone, pls help me with my problem. I got error (OleDbException was unhandled) (sysntax error in INSERT INTO statement) specifically, the error points out in "int temp = oleDbCmd.ExecuteNonQuery();" And, here's my code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; …