Click here to Skip to main content
15,887,596 members
Home / Discussions / C#
   

C#

 
Generalfloating values issue Pin
Ryno Burger7-Feb-08 8:41
Ryno Burger7-Feb-08 8:41 
GeneralRe: floating values issue Pin
J$7-Feb-08 8:47
J$7-Feb-08 8:47 
GeneralRe: floating values issue Pin
led mike7-Feb-08 8:49
led mike7-Feb-08 8:49 
GeneralRe: floating values issue Pin
Ryno Burger7-Feb-08 8:51
Ryno Burger7-Feb-08 8:51 
GeneralRe: floating values issue Pin
Luc Pattyn7-Feb-08 12:21
sitebuilderLuc Pattyn7-Feb-08 12:21 
GeneralRe: floating values issue Pin
benjymous7-Feb-08 22:03
benjymous7-Feb-08 22:03 
GeneralWith apologies Pin
Ennis Ray Lynch, Jr.8-Feb-08 3:48
Ennis Ray Lynch, Jr.8-Feb-08 3:48 
GeneralProblem with Insert statement Pin
MumbleB7-Feb-08 7:54
MumbleB7-Feb-08 7:54 
Hi Guys. I am having problems with writing data to an Access DB. I keep getting error message "Syntax error in INSERT INTO statement". This is when I try and add a new row to the data table. See below code. The section where it stops is highlighted below.

I'm stumped. Have tried a number of things and nothing works.
D'Oh! | :doh: Cry | :(( WTF | :WTF:

public partial class logon : Form
{
    OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database.mdb");
    OleDbDataAdapter m_daDataAdapter;
    DataTable m_dtPassword = new DataTable();
    public logon()
    {
        InitializeComponent();
    }
    private void btnCreateUser_Click(object sender, EventArgs e)
    {
        conn.Open();
        m_daDataAdapter =
            new OleDbDataAdapter("Select * From [Callcentre]", conn);
        OleDbCommandBuilder m_cbCommandbuilder =
            new OleDbCommandBuilder(m_daDataAdapter);
        m_daDataAdapter.Fill(m_dtPassword);

        DataRow drNewRow = m_dtPassword.NewRow();
        drNewRow["UserName"] = txtboxUserName.Text;
        drNewRow["Password"] = cipherText;
        m_dtPassword.Rows.Add(drNewRow);
        <code>m_daDataAdapter.Update(m_dtPassword);</code>
        m_rowPosition = m_dtPassword.Rows.Count - 1;

    }
}

GeneralRe: Problem with Insert statement Pin
led mike7-Feb-08 8:46
led mike7-Feb-08 8:46 
GeneralRe: Problem with Insert statement Pin
MumbleB7-Feb-08 9:27
MumbleB7-Feb-08 9:27 
GeneralRe: Problem with Insert statement Pin
led mike7-Feb-08 9:57
led mike7-Feb-08 9:57 
AnswerRe: Problem with Insert statement Pin
Guffa7-Feb-08 12:22
Guffa7-Feb-08 12:22 
GeneralRe: Problem with Insert statement Pin
Ravenet7-Feb-08 16:21
Ravenet7-Feb-08 16:21 
AnswerRe: Problem with Insert statement Pin
MumbleB7-Feb-08 19:44
MumbleB7-Feb-08 19:44 
GeneralStop keyboard and mouse input with a screen Pin
lifeh2o7-Feb-08 3:15
lifeh2o7-Feb-08 3:15 
GeneralRe: Stop keyboard and mouse input with a screen Pin
Justin Perez7-Feb-08 4:19
Justin Perez7-Feb-08 4:19 
GeneralRe: Stop keyboard and mouse input with a screen Pin
lifeh2o8-Feb-08 0:45
lifeh2o8-Feb-08 0:45 
QuestionHow to convert String to Decimal Pin
Exelioindia7-Feb-08 3:10
Exelioindia7-Feb-08 3:10 
AnswerRe: How to convert String to Decimal Pin
Jimmanuel7-Feb-08 3:15
Jimmanuel7-Feb-08 3:15 
AnswerRe: How to convert String to Decimal Pin
Guffa7-Feb-08 3:24
Guffa7-Feb-08 3:24 
AnswerRe: How to convert String to Decimal Pin
Thomas Stockwell8-Feb-08 7:22
professionalThomas Stockwell8-Feb-08 7:22 
GeneralLinking listbox scrolling in multiple listboxes. Pin
GuyThiebaut7-Feb-08 2:58
professionalGuyThiebaut7-Feb-08 2:58 
GeneralRe: Linking listbox scrolling in multiple listboxes. Pin
led mike7-Feb-08 4:34
led mike7-Feb-08 4:34 
GeneralRe: Linking listbox scrolling in multiple listboxes. Pin
GuyThiebaut8-Feb-08 1:09
professionalGuyThiebaut8-Feb-08 1:09 
GeneralExcel process Pin
arkiboys7-Feb-08 2:45
arkiboys7-Feb-08 2:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.