Click here to Skip to main content
15,915,032 members
Home / Discussions / C#
   

C#

 
GeneralRe: I want to enter (+,-,.) values in Texbox in windows based C# applications only numeric Pin
Christian Graus14-Nov-07 19:56
protectorChristian Graus14-Nov-07 19:56 
GeneralRe: I want to enter (+,-,.) values in Texbox in windows based C# applications only numeric Pin
Adeel Chaudhry14-Nov-07 20:05
Adeel Chaudhry14-Nov-07 20:05 
Questionneed your help Pin
arslanjatt14-Nov-07 18:56
arslanjatt14-Nov-07 18:56 
AnswerRe: need your help Pin
Vasudevan Deepak Kumar14-Nov-07 18:59
Vasudevan Deepak Kumar14-Nov-07 18:59 
GeneralRe: need your help Pin
arslanjatt14-Nov-07 19:10
arslanjatt14-Nov-07 19:10 
AnswerRe: need your help Pin
Adeel Chaudhry14-Nov-07 19:20
Adeel Chaudhry14-Nov-07 19:20 
AnswerRe: need your help Pin
Reddy Prakash14-Nov-07 22:33
Reddy Prakash14-Nov-07 22:33 
QuestionMark Record as Exported in DB Pin
MumbleB14-Nov-07 18:39
MumbleB14-Nov-07 18:39 
Hi Guys. I am running an export from my db to csv. I would like to populate the Exported Column in the DB with a 'Y' to show that the record has been exported. Can somebody please tell me how I can do this? Below a snip of the export code. Also, if I do this, how do I only export records that are marked as N in the ["Exported"] Column in the table?

private void toolStripButton2_Click(object sender, EventArgs e)
{
    //Write Header Record
    StreamWriter sw = new StreamWriter(@"C:\nefz.csv", false);
    DataTable dt = m_dtCallCentre;
    int iColCount = dt.Columns.Count;
    for (int i = 0; i < iColCount; i++)
    {
        sw.Write(dt.Columns[i]);
        if (i < iColCount - 1)
        {
            sw.Write(";");
        }
    }
    sw.Write(sw.NewLine);
    //Write all records in the DB
    foreach (DataRow dr in dt.Rows)
    {
        for (int i = 0; i < iColCount; i++)
        {
            if (!Convert.IsDBNull(dr[i]))
            {
                sw.Write(dr[i].ToString());
            }
            if (i < iColCount - 1)
            {
                sw.Write(";");
            }
        }
        sw.Write(sw.NewLine);
    }

    sw.Close();

}


I would like to enhance this to search for value 'N' in ["Exported"] column, export the record and change the value to 'Y'.

Any help with this would be greatly appreciated.
AnswerRe: Mark Record as Exported in DB Pin
Adeel Chaudhry14-Nov-07 19:32
Adeel Chaudhry14-Nov-07 19:32 
GeneralRe: Mark Record as Exported in DB Pin
MumbleB14-Nov-07 20:18
MumbleB14-Nov-07 20:18 
QuestionSize of a Web Service Request Pin
Ferudun Atakan14-Nov-07 18:38
Ferudun Atakan14-Nov-07 18:38 
QuestionSetting readonly values in structs within my struct Pin
JoeRip14-Nov-07 18:13
JoeRip14-Nov-07 18:13 
AnswerRe: Setting readonly values in structs within my struct Pin
Wil Peck14-Nov-07 18:41
Wil Peck14-Nov-07 18:41 
AnswerRe: Setting readonly values in structs within my struct Pin
Wil Peck14-Nov-07 18:55
Wil Peck14-Nov-07 18:55 
GeneralRe: Setting readonly values in structs within my struct Pin
JoeRip14-Nov-07 20:42
JoeRip14-Nov-07 20:42 
QuestionMDI Child maximizing problem Pin
shahid hameed14-Nov-07 18:08
shahid hameed14-Nov-07 18:08 
Questionproviding scrollbar in listbox+c#? Pin
Venkatesh.P14-Nov-07 18:08
Venkatesh.P14-Nov-07 18:08 
AnswerRe: providing scrollbar in listbox+c#? Pin
Venkatesh.P14-Nov-07 18:28
Venkatesh.P14-Nov-07 18:28 
QuestionShowing Gridlines in a GridView while using Windows Presentation Foundation Pin
Darmi14-Nov-07 17:52
Darmi14-Nov-07 17:52 
Questionre:remoting security Pin
RameshwerE14-Nov-07 17:36
RameshwerE14-Nov-07 17:36 
QuestionInitializing reference variables in a struct Pin
JoeRip14-Nov-07 17:29
JoeRip14-Nov-07 17:29 
AnswerRe: Initializing reference variables in a struct Pin
Not Active14-Nov-07 17:31
mentorNot Active14-Nov-07 17:31 
GeneralRe: Initializing reference variables in a struct Pin
JoeRip14-Nov-07 17:35
JoeRip14-Nov-07 17:35 
GeneralRe: Initializing reference variables in a struct Pin
Not Active14-Nov-07 17:57
mentorNot Active14-Nov-07 17:57 
GeneralRe: Initializing reference variables in a struct Pin
JoeRip14-Nov-07 17:59
JoeRip14-Nov-07 17:59 

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.