Click here to Skip to main content
15,903,856 members
Home / Discussions / C#
   

C#

 
AnswerRe: C# area map Pin
fly90422-Feb-09 12:13
fly90422-Feb-09 12:13 
GeneralRe: C# area map Pin
Zap-Man22-Feb-09 14:40
Zap-Man22-Feb-09 14:40 
GeneralRe: C# area map Pin
fly90422-Feb-09 15:06
fly90422-Feb-09 15:06 
GeneralRe: C# area map Pin
Zap-Man22-Feb-09 15:18
Zap-Man22-Feb-09 15:18 
GeneralRe: C# area map [modified] Pin
fly90423-Feb-09 0:04
fly90423-Feb-09 0:04 
GeneralRe: C# area map Pin
Zap-Man23-Feb-09 13:41
Zap-Man23-Feb-09 13:41 
QuestionPassable function Pin
Chris Copeland22-Feb-09 10:04
mveChris Copeland22-Feb-09 10:04 
AnswerRe: Passable function Pin
Jon Rista22-Feb-09 10:54
Jon Rista22-Feb-09 10:54 
GeneralRe: Passable function Pin
Chris Copeland22-Feb-09 11:02
mveChris Copeland22-Feb-09 11:02 
GeneralRe: Passable function Pin
Jon Rista22-Feb-09 11:16
Jon Rista22-Feb-09 11:16 
QuestionHow to enable auto scroll in a listbox? Pin
bar300022-Feb-09 9:20
bar300022-Feb-09 9:20 
AnswerRe: How to enable auto scroll in a listbox? Pin
Luis Alonso Ramos22-Feb-09 9:34
Luis Alonso Ramos22-Feb-09 9:34 
GeneralRe: How to enable auto scroll in a listbox? Pin
bar300022-Feb-09 9:48
bar300022-Feb-09 9:48 
GeneralRe: How to enable auto scroll in a listbox? Pin
Luis Alonso Ramos22-Feb-09 10:11
Luis Alonso Ramos22-Feb-09 10:11 
GeneralRe: How to enable auto scroll in a listbox? Pin
Luis Alonso Ramos22-Feb-09 10:30
Luis Alonso Ramos22-Feb-09 10:30 
AnswerRe: How to enable auto scroll in a listbox? Pin
Luc Pattyn22-Feb-09 10:11
sitebuilderLuc Pattyn22-Feb-09 10:11 
GeneralRe: How to enable auto scroll in a listbox? Pin
bar300023-Feb-09 7:08
bar300023-Feb-09 7:08 
GeneralRe: How to enable auto scroll in a listbox? Pin
Luc Pattyn23-Feb-09 7:27
sitebuilderLuc Pattyn23-Feb-09 7:27 
QuestionIHTMLElement to Bitmap Pin
Sunset Towers22-Feb-09 9:14
Sunset Towers22-Feb-09 9:14 
QuestionHow to query and execute code according to result.. Pin
High0ctane22-Feb-09 8:59
High0ctane22-Feb-09 8:59 
AnswerRe: How to query and execute code according to result.. Pin
Luis Alonso Ramos22-Feb-09 9:12
Luis Alonso Ramos22-Feb-09 9:12 
GeneralRe: How to query and execute code according to result.. Pin
High0ctane22-Feb-09 12:17
High0ctane22-Feb-09 12:17 
I finally tried it out like this and it works:

private void txtClientCode_Validated(object sender, EventArgs e)
{
    try
    {
        OleDbDataAdapter l_daCCSearch = new OleDbDataAdapter(
            "SELECT * from ClientFile WHERE ClientCode = '" + txtClientCode.Text + "'", m_connection);
        DataTable l_dtCCSearch = new DataTable();
        l_daCCSearch.Fill(l_dtCCSearch);
        txtClientCode.Text = l_dtCCSearch.Rows[0]["ClientCode"].ToString();
        txtAdress.Text = l_dtCCSearch.Rows[0]["Adress"].ToString();
        txtCity.Text = l_dtCCSearch.Rows[0]["City"].ToString();
        txtCompanyName.Text = l_dtCCSearch.Rows[0]["CompanyName"].ToString();
        txtContactName.Text = l_dtCCSearch.Rows[0]["ContactName"].ToString();
        txtCountry.Text = l_dtCCSearch.Rows[0]["Country"].ToString();
        txtEmail.Text = l_dtCCSearch.Rows[0]["Email"].ToString();
        txtFax.Text = l_dtCCSearch.Rows[0]["FaxNumber"].ToString();
        txtPhone.Text = l_dtCCSearch.Rows[0]["PhoneNumber"].ToString();
        txtPostalCode.Text = l_dtCCSearch.Rows[0]["PostalCode"].ToString();
        txtProvince.Text = l_dtCCSearch.Rows[0]["Province"].ToString();
        txtTaxCode.Text = l_dtCCSearch.Rows[0]["TaxCode"].ToString();
        rtxtNotes.Text = l_dtCCSearch.Rows[0]["Notes"].ToString();

    }
    catch (IndexOutOfRangeException)
    {
        DialogResult result;
        result = MessageBox.Show("Aucune entrée correspondante à votre requête n'a été trouvée.", "Erreur");
        if (result == DialogResult.OK)
        {
            this.ShowCurrentRecord();
        }
    }

}


Thanks a lot you pointed me in the right direction Smile | :)

Yup, I'm a NEWB

QuestionHow to make pdf file ? Pin
E_Gold22-Feb-09 8:42
E_Gold22-Feb-09 8:42 
AnswerRe: How to make pdf file ? Pin
Luis Alonso Ramos22-Feb-09 9:16
Luis Alonso Ramos22-Feb-09 9:16 
QuestionHow to define pointer to office in c# to control excel document ? Pin
Yanshof22-Feb-09 8:35
Yanshof22-Feb-09 8:35 

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.