C# Discussion Boards - CodeProject

Connection test for SAP Netweaver and Microsoft SharePointList in C#

Member 1138787727-Apr-15 19:13

27-Apr-15 19:13

Hi i need to test a connection for SAP Netweaver and Microsoft SharePointList data bases with connection strings like in Microsoft SSRS data source creation. Please share your suggestions !

Re: Connection test for SAP Netweaver and Microsoft SharePointList in C#

Pete O'Hanlon27-Apr-15 23:12

Pete O'Hanlon

27-Apr-15 23:12

If you're looking for connection string reference details, I highly recommend this site[^].

Get string website c# [HELP ME PLS]

Member 1106300127-Apr-15 12:00

Member 11063001

27-Apr-15 12:00

Hello , it's possible to give me the code for get a string in a textbox of a website
Exemple : i want to get this in my software ( c#) [^]

Re: Get string website c# [HELP ME PLS]

Sascha Lefèvre27-Apr-15 14:54

Sascha Lefèvre

27-Apr-15 14:54

There are two issues with your question.

The first one is that this forum is intended to provide answers to specific programming questions. Requesting code isn't one.

The second one is that you either didn't provide enough information about what you're trying to accomplish or don't have a clear idea yourself of what you're trying to do. Where do you want to process that "string in a textbox of a website"? In the browser? Then you would have to look into Silverlight. Or in your server application? Then you can't do it with C# alone. You would either have to have a HTML-form that gets posted to your server application or a JavaScript-Ajax function that performs an Ajax-request. Would your server application be ASP.NET or something else? As you didn't specify all this, we couldn't "give you the code" even if we wanted.

So, please, first think about what you're really trying to accomplish, then make yourself familiar with the required technologies for which you will most certainly find tons of tutorials and examples on this website, then try to do it yourself. If you get stuck, try to find an answer with Google because in most cases there will already be an answer in some forum and thus it will be the quickest way for you and not wasted time for you and us. If you can't find an answer, come back here and ask - while providing enough information to allow someone who is not you to understand what you're trying to do and where exactly the problem is.

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

c# covert a for loop to for each (arraylist)

Aindriu Mac Giolla Eoin27-Apr-15 9:29

Aindriu Mac Giolla Eoin

27-Apr-15 9:29

hi,

I have a for loop that works but I need to implement a foreach loop. How do I change to a foreach loop ?

here is the existing working for loop in a method

public void liststudents()
           {

               for (int i = 0; i < studentarraylist.Count; i++)
               {
                   // Cast the object from the ArrayList to Student
                   Student currentStudent = (Student)studentarraylist[i];
                   Console.WriteLine("Student {0} {1}", currentStudent.FirstName, currentStudent.LastName);



               }
           }

Also, does the above code indeed cast the returned object from the ArrayList to a Student object ?

Re: c# covert a for loop to for each (arraylist)

PIEBALDconsult27-Apr-15 9:39

PIEBALDconsult

27-Apr-15 9:39

Aindriu Mac Giolla Eoin wrote:
change to a foreach loop

Why? For loops perform better.

Aindriu Mac Giolla Eoin wrote:
does the above code indeed cast the returned object

Looks like it; why do you ask?

Re: c# covert a for loop to for each (arraylist)

Aindriu Mac Giolla Eoin27-Apr-15 9:42

Aindriu Mac Giolla Eoin

27-Apr-15 9:42

I need a foreach loop to satisfy a requirement even though a for loop might perform better.

I was looking at [microsoft link] but could get the cast work as well

I wanted to double check that the returned object was casted to its orignal type thanks !

Re: c# covert a for loop to for each (arraylist)

Richard Deeming27-Apr-15 10:17

Richard Deeming

27-Apr-15 10:17

Try this:

foreach (Student currentStudent in studentarraylist)
{
    Console.WriteLine("Student {0} {1}", currentStudent.FirstName, currentStudent.LastName);
}

You should try to avoid the ArrayList class[^], as it's not strongly typed. Use the List<T> class[^] (or one of the other generic collection types) instead.

Generics (C# Programming Guide)[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: c# covert a for loop to for each (arraylist)

Aindriu Mac Giolla Eoin27-Apr-15 10:28

Aindriu Mac Giolla Eoin

27-Apr-15 10:28

thanks for that, i know its not strongly typed and could use something else but I need to use it for a question.

Re: c# covert a for loop to for each (arraylist)

Marjan Venema30-Apr-15 8:02

Marjan Venema

30-Apr-15 8:02

While a for loop may perform better, a foreach loop reads better and is less prone to off-by-one errors. That is why I have come to prefer them everywhere except _proven_ performance bottlenecks.

foreach (Student currentStudent in studentarraylist)
{
    Console.WriteLine("Student {0} {1}", currentStudent.FirstName, currentStudent.LastName);
}

---
http://softwareonastring.com

C# Datepicker value not saved in MySql database

ahmed_one27-Apr-15 0:20

ahmed_one

27-Apr-15 0:20

Hi to All,

I am using C# Winforms to create a Voucher system which is Master/Detail, using MySql as backend. Create Voucher class to setup followings:

1.Create New Voucher 2. Save Voucher 3. Query Voucher

Currently having problem with Save Voucher, I've setup Insert/Update/Delete commands, to make this post short I am posting Insert commands so that general idea of application will be clear:

Class Variables

ClsMgt da = new ClsMgt();
MySqlDataAdapter sqlDataMaster = new MySqlDataAdapter();
private DataSet oDs = null;
MySqlCommand selectcommand = null;
MySqlCommand insertcommand = null;
MySqlCommand updatecommand = null;
MySqlCommand deletecommand = null;
private DataTable dt = null;
private DataTable dtDet = null;
private String sSelProcName = null;
private String sInsProcName = null;
private String sDelProcName = null;
private String sUpdProcName = null;
private int voucType;

public MySqlConnection oCn = new MySqlConnection();
    MySqlTransaction oTrn = null;

Following is the NewVoucher procedure which will setup VoucherForm to open with blank record:

public DataSet NewVoucher()
    {
     DataSet vDs = new DataSet();
     oCn = da.GetConnection();

     if (oCn == null)
       {
           oCn.Open();
       }
       try
       {
        DataTable dt = new DataTable();
            //===============================================================================
        //--- Set up the Select Command
            //===============================================================================
String sqlSelect = "Select vID, vTypeID, vNo, accCodeDR, accCodeCR, vDate, vChqNo, vChqDt, vPayName, vRemarks, vAmount from vMaster";
sqlDataMaster = new MySqlDataAdapter(sqlSelect, oCn);
sqlDataMaster.FillSchema(dt, SchemaType.Source);
  vDs.Tables.Add(dt);
  VoucherDetails vdet = new VoucherDetails();
  DataTable dtDet = new DataTable();
  dtDet = vdet.NewVoucherDet();

  vDs.Tables.Add(dtDet);

  vDs.Tables[0].Columns["vID"].AutoIncrement = true;
  vDs.Tables[0].Columns["vID"].AutoIncrementSeed = -1;
  vDs.Tables[0].Columns["vID"].AutoIncrementStep = -1;
  vDs.Tables[1].Columns["vID"].AutoIncrement = true;
  vDs.Tables[1].Columns["vID"].AutoIncrementSeed = -1;
  vDs.Tables[1].Columns["vID"].AutoIncrementStep = -1;
  vDs.EnforceConstraints = false;
 vDs.Relations.Add("VouchersToVoucherDetails", vDs.Tables[0].Columns["vID"], vDs.Tables[1].Columns["vID"]);

        }
        catch (MySqlException e)
        {
            MessageBox.Show(e.ToString());
        }

        return (vDs);
    }

Following is the SaveVoucher procedure:

public void SaveVoucher(DataSet oDs)
    {
        oCn = da.GetConnection();
        oTrn = oCn.BeginTransaction();
        sqlDataMaster = new MySqlDataAdapter();
        try
        {

        if (oCn == null)
         {
            oCn.Open();
         }

            //===============================================================================
//--- Set up the INSERT Command
           //===============================================================================
     sInsProcName = "prInsert_Voucher";
     insertcommand = new MySqlCommand(sInsProcName, oCn, oTrn);
     insertcommand.CommandType = CommandType.StoredProcedure;
    insertcommand.Parameters.Add(new MySqlParameter("nNewID", MySqlDbType.Int32, 0, "vID"));
  insertcommand.Parameters["nNewID"].Direction = ParameterDirection.Output;
  insertcommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
  insertcommand.Parameters.Add("svTypeID", MySqlDbType.Int32,0, "vTypeID");
  insertcommand.Parameters.Add("svNo", MySqlDbType.Int32, 0, "vNo");
  insertcommand.Parameters.Add("svaccCodeDR", MySqlDbType.VarChar, 12, "accCodeDR");
  insertcommand.Parameters.Add("svaccCodeCR", MySqlDbType.VarChar, 12, "accCodeCR");
  insertcommand.Parameters.Add("svDate", MySqlDbType.DateTime);
 insertcommand.Parameters["svDate"].SourceColumn = "vDate";
 insertcommand.Parameters.Add("svChqNo", MySqlDbType.Int32, 0, "vChqNo");
 insertcommand.Parameters.Add("svChqDt", MySqlDbType.DateTime);
 insertcommand.Parameters["svChqDt"].SourceColumn = "vChqDt";
insertcommand.Parameters.Add("svPayName", MySqlDbType.VarChar, 100, "vPayName");
insertcommand.Parameters.Add("svRemarks", MySqlDbType.VarChar, 70, "vRemarks");
insertcommand.Parameters.Add("svAmount", MySqlDbType.Double, 0, "vAmount");

 sqlDataMaster.InsertCommand = insertcommand;
            //===============================================================================
 //--- Set up the UPDATE Command
            //===============================================================================
  sUpdProcName = "prUpdate_Voucher";
  updatecommand = new MySqlCommand(sUpdProcName, oCn, oTrn);
  updatecommand.CommandType = CommandType.StoredProcedure;
  updatecommand.Parameters.Add("nNewID", MySqlDbType.Int32, 4, "vID");
  updatecommand.Parameters.Add("svTypeID", MySqlDbType.Int32, 0, "CustomerID");
 updatecommand.Parameters.Add("svNo", MySqlDbType.Int32, 0, "vNo");
 updatecommand.Parameters.Add("svaccCodeDR", MySqlDbType.VarChar, 12, "accCodeDR");
 updatecommand.Parameters.Add("svaccCodeCR", MySqlDbType.VarChar, 12, "accCodeCR");
updatecommand.Parameters.Add("svDate", MySqlDbType.DateTime);
 updatecommand.Parameters["svDate"].SourceColumn = "vDate";
 updatecommand.Parameters.Add("svChqNo", MySqlDbType.Int32, 0, "vChqNo");
updatecommand.Parameters.Add("svChqDt", MySqlDbType.Date);
 updatecommand.Parameters["svChqDt"].SourceColumn = "vChqDt";
 updatecommand.Parameters.Add("svPayName", MySqlDbType.VarChar, 100, "vPayName");
 updatecommand.Parameters.Add("svRemarks", MySqlDbType.VarChar, 70, "vRemarks");
            updatecommand.Parameters.Add("svAmount", MySqlDbType.Double, 0, "vAmount");
sqlDataMaster.UpdateCommand = updatecommand;

           //===============================================================================
            //--- Set up the DELETE Command
            //===============================================================================
 sDelProcName = "prDelete_Voucher";
 deletecommand = new MySqlCommand(sDelProcName, oCn, oTrn);
 deletecommand.CommandType = CommandType.StoredProcedure;
 deletecommand.Parameters.Add("nNewID", MySqlDbType.Int32, 4, "vID");
 sqlDataMaster.DeleteCommand = deletecommand;

 sqlDataMaster.Update(oDs.Tables[0]);
 VoucherDetails vDet = new VoucherDetails();
 vDet.SaveVoucher(oTrn, oDs.Tables[1]);

 oTrn.Commit();
 MessageBox.Show("Records saved.", "Saving Records");
 }
 catch (MySqlException e)
        {
            //===============================================================================
 //--- Rollback the transaction
            //===============================================================================
 oTrn.Rollback();
//MessageBox.Show(e.ToString());
 MessageBox.Show(e.Message +" Error code: "+ e.Number);
oDs.Tables[0].Rows[0]["vNo"] = DBNull.Value;

 }

 }

Using paramterized StoredProc to save data in MySql db, for Insert records following StoredProc is used:

DELIMITER $$
USE `generalledger`$$

DROP PROCEDURE IF EXISTS `prInsert_Voucher`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `prInsert_Voucher`(
IN svTypeID INT, 
IN svNo INT, 
IN svaccCodeDR VARCHAR(12),
IN svaccCodeCR VARCHAR(12), 
IN svDate DATETIME,
IN svChqNo INT, 
IN svChqDt DATETIME, 
IN svPayName VARCHAR(100), 
IN svRemarks VARCHAR(70), 
IN svAmount DOUBLE,  
OUT nNewID INT)
BEGIN

INSERT INTO vMaster (vTypeID, vNo, accCodeDR,accCodeCR,vDate, vChqNo, vChqDt, vPayName, vRemarks, vAmount)
VALUES (svTypeID, svNo, svaccCodeDR, svaccCodeCR, svDate, svChqNo, svChqDt, svPayName, svRemarks, svAmount);
SET nNewID = LAST_INSERT_ID();
END$$

DELIMITER ;

Code behind Voucher form:

public frmVoucher()
    {
    InitializeComponent();
    DoNewVoucher();
   }

    private void Form1_Load(object sender, EventArgs e)
    {
     txtVDt.Text = DateTime.Today.ToString();
    }

   public void DoNewVoucher()
    {
      vr.VoucherType = 1;
      ds = vr.NewVoucher();

     //Create New binding source for Order
     bs = new BindingSource();
     //Create New binding source for Order Details
     bsDet = new BindingSource();
     //Set Order binding source to Dataset ds
     bs.DataSource = ds;
     //Set Order Data Member to Dataset ds table "Orders"
     bs.DataMember = "vMaster";
     //Set Order Details binding source to Order's Binding source
   bsDet.DataSource = bs;
 //Set Order Data Member to Dataset's Relationship for data integrity
  bsDet.DataMember = "VouchersToVoucherDetails";
  BindControls();

  bs.AddNew();
  txtVDt.Text = DateTime.Today.ToString();
 // txtChqDt.Text = DateTime.Today.ToString();
    }

public void BindControls()
    {
   txtvTypeID.Text = null;
   txtVType.Text = null;
   txtVNum.Text = null;
   txtVDesc.Text = null;
   txtVDt.Text = null;
   if (vr.VoucherType == 1)
     {
       txtChqNo.Text = null;
       txtChqDt.Text = null;
       txtDrAcc.Text = null;
       txtDrAccDesc.Text = null;
       txtCrAcc.Text = null;
       txtCrAccDesc.Text = null;
       txtPayName.Text = null;
       txtAmount.Text = null;
     }

     txtRemarks.Text = null;
     txtTransID.DataBindings.Clear();
     txtvTypeID.DataBindings.Clear();
     txtVType.DataBindings.Clear();
     txtVNum.DataBindings.Clear();
        txtVDt.DataBindings.Clear();
        if (vr.VoucherType == 1)
        {
            txtChqNo.DataBindings.Clear();
            txtChqDt.DataBindings.Clear();
            txtDrAcc.DataBindings.Clear();
            txtCrAcc.DataBindings.Clear();
            txtPayName.DataBindings.Clear();
            txtAmount.DataBindings.Clear();
        }
        txtRemarks.DataBindings.Clear();


 txtTransID.DataBindings.Add(new Binding("Text", bs, "vID"));
txtvTypeID.DataBindings.Add(new Binding("Text", bs, "vTypeID"));
txtVNum.DataBindings.Add(new Binding("Text", bs, "vNo"));
txtVDt.DataBindings.Add(new Binding("Text", bs, "vDate"));
  if (vr.VoucherType == 1)
     {
 txtChqNo.DataBindings.Add(new Binding("Text", bs, "vChqNo"));
 //string s = txtChqDt.Value.ToString("yyyy-MM-dd HH:mm");
 //DateTime dt = DateTime.ParseExact(txtChqDt.Text, "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture);
 txtChqDt.DataBindings.Add(new Binding("Text", bs, "vChqDt"));
 txtDrAcc.DataBindings.Add(new Binding("Text", bs, "accCodeDR"));
txtCrAcc.DataBindings.Add(new Binding("Text", bs, "accCodeCR"));
txtPayName.DataBindings.Add(new Binding("Text", bs, "vPayName"));
 txtAmount.DataBindings.Add(new Binding("Text", bs, "vAmount"));
        }
 txtRemarks.DataBindings.Add(new Binding("Text", bs, "vRemarks"));

  txtVDt.Text = DateTime.Today.ToString();
   if (vr.VoucherType == 1)
    {
      txtChqDt.Text = DateTime.Today.ToString();
     }

if (txtvTypeID.Text == null || txtvTypeID.Text == string.Empty)
    {
  //txtVType.Text = dm.GetData("Select vType from vType Where vTypeID = '" + txtvTypeID.Text + "'").Rows[0]["vType"].ToString();
    txtVType.Text = null;
    }
      else
   {

 txtVType.Text = dm.GetData("Select vType from vType Where vTypeID = '" + txtvTypeID.Text + "'").Rows[0]["vType"].ToString();

   }
   dgVDet.AutoGenerateColumns = false;
   dgVDet.DataSource = bsDet;

   dgVDet.Columns["vDetID"].DataPropertyName = "vDetID";
   dgVDet.Columns["vID"].DataPropertyName = "vID";
   dgVDet.Columns["accCode"].DataPropertyName = "accCode";
   dgVDet.Columns["accName"].DataPropertyName = "accName";
  dgVDet.Columns["accDebit"].DataPropertyName = "accDebit";
   dgVDet.Columns["accCredit"].DataPropertyName = "accCredit";
  dgVDet.Columns["accRemarks"].DataPropertyName = "accRemarks";

    //CalculateTotals();
    }

private void btnSave_Click(object sender, EventArgs e)
    {
   int rowCount = 0;
   rowCount = dgVDet.Rows.Count - 1;

     this.Validate();
     bs.EndEdit();
     double dCr = 0;
     double dDr = 0;
    Double.TryParse(txtTotDR.Text.ToString(), out dDr);
    Double.TryParse(txtTotCR.Text.ToString(), out dCr);

   if (!ds.HasChanges())
     {
   MessageBox.Show("No changes to save.", "Saving Records");
       return;
    }

    if (dCr != dDr)
      {
  MessageBox.Show("Total of Debit and Credit are not equal.", "Saving Records");
         return;
    }

  try
   {

  if (txtvTypeID.Text == null || txtvTypeID.Text == string.Empty)
            {
        return;
      }
     else
      {
   if (txtVNum.Text == null || txtVNum.Text == string.Empty)
     {
  int temp = int.Parse(this.txtvTypeID.Text.ToString());
  ds.Tables[0].Rows[0]["vNo"] = vr.GetVoucherNum(temp);
      }

     }


   vr.SaveVoucher(ds);
        }
       catch (MySqlException err)
        {

 // MessageBox.Show(err.Message.ToString() +" "+ err.ErrorCode );
     MessageBox.Show(err.ErrorCode.ToString());

        }

  CellSum(5);
  CellSum(6);
    }

The problem: The vChqDt is the MySql DateTime field, and I am using DateTimePicker in C# Winform for user to select date. svChqDt is the parameter I used in SaveVoucher procedure, all fields are saved properly EXCEPT vChqDt....which is only getting NULL. I've search this forum for solution, and find that using ToString to change format of date to yyyy-mm-dd will do the trick. But the problem is where should I put it??

NOTE: Although txtChqDt is prefix with "txt" but it is actually DateTimePicker.

Re: C# Datepicker value not saved in MySql database

Gerry Schmitz27-Apr-15 19:47

Gerry Schmitz

27-Apr-15 19:47

Try this:

txtChqDt.DataBindings.Add(new Binding("Value", bs, "vChqDt"));

(Bind to the "Value" property instead of the "Text" property of txtChqDt).

Re: C# Datepicker value not saved in MySql database

ahmed_one27-Apr-15 20:26

ahmed_one

27-Apr-15 20:26

Thanks for your reply, I will definitely try this.. Meanwhile I've noticed that when form load, and if user manually select date in datetimepicker, ONLY then date is saved!!!! Otherwise not....

Any thoughts???

Re: C# Datepicker value not saved in MySql database

Gerry Schmitz27-Apr-15 20:56

Gerry Schmitz

27-Apr-15 20:56

I'm not clear on what / when "Otherwise not" refers to.

All controls go through a series of events before they are fully initialized.

If in some cases you see properties that are not available (and then are), you may be accessing them too soon; or not the right property in the current context (e.g. "Text" versus "Value").

The easiest thing to do is simply display the properties of interest at key points in the program which will give one a better understanding of the "life" of a control.

Re: C# Datepicker value not saved in MySql database

ahmed_one27-Apr-15 21:02

ahmed_one

27-Apr-15 21:02

Actually I am referring otherwise to when Form is load but user did not select any date in DateTimePicker and trying to saved the record with default Today's date.

Re: C# Datepicker value not saved in MySql database

Gerry Schmitz27-Apr-15 21:33

Gerry Schmitz

27-Apr-15 21:33

Have you tried binding to "Value" yet?

Re: C# Datepicker value not saved in MySql database

ahmed_one28-Apr-15 3:40

ahmed_one

28-Apr-15 3:40

Sorry for late reply, Yes I've tried the "Value"...

As you've noticed from my code that it's Master/Detail application, and I've create a relation VouchersToVoucherDetails in form code. Before modification of "Value" to DataBindings of vChqDt, vID was showing -1 on form load. But now it is showing null and when try to save the records it say vID cannot be null, and when press ok then no record is save to database.

Re: C# Datepicker value not saved in MySql database

ahmed_one28-Apr-15 4:18

ahmed_one

28-Apr-15 4:18

Hi,

problem is solved, I've modified the "Text" and change to "Value", and also add fourth parameter "true" which enable formatting. After which all is going well.

Thanks for your guidance and support. Really appreciate.

Ahmed

Re: C# Datepicker value not saved in MySql database

Gerry Schmitz28-Apr-15 9:14

Gerry Schmitz

28-Apr-15 9:14

Glad it's working for you now.

What is Constructor Overloading in C# .net ?

dhivya.sakthi26-Apr-15 20:35

dhivya.sakthi

26-Apr-15 20:35

What is Constructor Overloading in C# .net ?

Re: What is Constructor Overloading in C# .net ?

OriginalGriff26-Apr-15 21:28

OriginalGriff

26-Apr-15 21:28

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search using your subject as the search term gave 198,000 hits: Google: "What is Constructor Overloading in C#"[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: What is Constructor Overloading in C# .net ?

Dr Gadgit27-Apr-15 3:43

Dr Gadgit

27-Apr-15 3:43

public class MyExceptionClass : Exception
{
    public MyExceptionClass(string message, string extrainfo) : base(message)
    {
        //other stuff here
    }
}

Inherit from a class and call the base i think is the answer you are looking for

I want OO to have children that can speak to parent objects without having to wire them up but i guess i will have to wait for that bit of code canndy to come out one day.

Re: What is Constructor Overloading in C# .net ?

David A. Gray3-May-15 10:19

David A. Gray

3-May-15 10:19

Constructor overloading refers to designing a class that contains several constructors, each having a unique set of arguments for initializing class properties.

Video cutter / merger in C# winfrom

Member 1162007426-Apr-15 7:35

Member 11620074

26-Apr-15 7:35

How to make Video cutter / merge that cut the videos and show start and end point in track bar like vcd Cutter player....

Re: Video cutter / merger in C# winfrom

Sascha Lefèvre26-Apr-15 7:46

Sascha Lefèvre

26-Apr-15 7:46

Please read: How to get an answer to your question[^]

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

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