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

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.

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.

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???

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)
    {

Yes that was confusing till now...Thank you... So then I will let the user know that MySql is must for using the application. Or point them to XAMPP so that they only need to download the package without having the trouble of configuring it, it's just download and run, so it will be much less hassle for them. Thanks a lot for your guidance. Regards Ahmed

But I thought MySql is free or opensource? doesn't that make it freely distributable? Secondly, how about I distribute XAMPP with my application? As it is lot easier to use then to configure/install actual MySql server?

Ahh...I think I've not make myself clear regarding my issue. This application is not for my organization, it is commercial software, general purpose accounting application. So any organization that needs it will download from website and do the install (server or client). I need to provide them some quick and easy way to do both installations as an when required. For server PC, the installation will be Application + MySql Server and for client PC only Application required.

V. Thanks for your reply again, despite of fact that there are no quickfix or shortcut, and if choose between WMI Scripts or batch, end-use still have to download the complete bundle alongwith MySql server, if the server installation is required. Only then will batch or script will work.

V. Thanks for your reply, I guess 2nd option will be more feasible for me. Can u guide me to some good tutorials/samples related with my issue? Like MySql and C# winform application. Regards Ahmed

Hi to All, I am working on C# Winform application (Visual Studio 2010) with MySql as back-end. Meanwhile I am looking for a suitable solution to a problem about How will I deploy this application along with MySql server. As this will be multiuser application, embedded database is not an option. It need to be a server based. There should be one server, for which this combine deployment is required, for client, ofcourse only application installation is required. So what are the options do I have for deployment? If I am offering this application available for download from a website, should I break it into 2 separate downloads? One is MySql itself (I am using XAMPP bundle for MySql because it is easy and portable), Second is the application alongwith it's all dependencies. If this approach is followed, then I've to setup whole database required by application from within the application (which I think is not so difficult). But then end user have to download the whole package of MySql, is there anyway I can reduce the size of whole XAMPP package as I am only using MySql database, As I don't use anything else in XAMPP (PHP/Apache/Mercury Mail etc) can I remove them so that size of bundle will be small enough for end user to download? I've searching long for the solution, and many forums has many questions about it, but there are no helpful solutions. I am looking for better solution from experts of this forum. Thanks and best regards Ahmed

Thanks Alan, I am at present using button column. Actually this textbox with button idea is the inspiration from some popular Accounting softwares. They use in variety of there data entry forms, like for e.g Invoice, when user enter line item, there is column ProductID, when user enters ProductID column he/she can directly enter Product ID or use the ellipse button to show a lookup form. This looks cool, so I thought may be there are some ways we can do it in C# winforms, and by the look of all posts here I am now sure there are more then one ways. Thanks to all for helping me..I am trying to learn to create custom control, and if there is no success I will stick to button column approach.

Ravi thanks again for all links....and thanks BillWoodRuff I will appreciate if u can post the sample....

Ravi thanks for link with sample....I will try it...and let u guys posted....

Ravi thanks for your post, as mentioned in my post, I am not familier with custom controls programming. Need some guidance/tutorial/sample, anything get me started... Thanks

Wayne is right... I am talking about ellipse button like ...

Dear All, I am using Visual Studio 2010, C# and MySql. In one of my Winforms, there is a bound DataGridView which contains few textbox columns. I am looking for a solution to add an ellipse button in one of the Textbox column, upon clicking the ellipse button it will show a second form. I've no experience of creating any user controls, so upon searching on net, I found plenty of examples but due to the lack of knowledge I am unable to follow them. I am not looking for someone to spoon feed me, but some simple to advance tutorials/guidelines/sample will be highly appreciated. Thanks in advance Ahmed

Thanks....I will try this...

Thanks for your reply, Are there any option available via Sql, when user find the record, the find function should call a function which fetch data from MySql Db in read-only mode.

Keith Barrow wrote:

ahmed_one wrote:

What I need is a way, that after POSTED is marked, no one can edit the record, even when it is search by any user.

Can this be clarified a little please? There are a few different potential problems here. First off, what do you mean by "no one can edit the record"? The database admin is going to be able to edit the record, one way or another. If you mean users should not be able to edit the record, then you are in control of what they do in the application, so you must have enabled the ability to updated? I don't know why searching alters the record (as your comment seems to suggest) - this sounds like something is very wonky to me, or you don't mean database record. It might be better to expand on your question.

By "No one can edit the record" I mean users. Database admin surely can alter the data. That's not a problem. At present, searching is not altering the record, my requirement is: when POSTED is marked users are restricted to Add/Edit/Delete/Update that POSTED record. This means when user use find function to display record (which is POSTED now) in Winforms, it should be locked for ADD/EDIT/DELETE/UPDATE.