Search results for query: *

I am also not want to include MySql with my application, how about make 2 downloads for end-users? One is just the application along with it's all prerequisites, and other is just the MySql. So those users who already have MySql need only to download just the application, and within the...

Hi Thanks for your reply, MySql (with XAMPP or alone installer) is greater then 200mb in size, packaging with application will make it more or less about ~250mb approx. This application is planned to available for download for end-users, is 250mb application will be good for this? Or are there...

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

Dear All Experts I am new to Sql, and need some guidance to create a Trial Balance via Sql query in MySql. Consider the following scenario: Two Tables: 1.Accounts 2.Transactions Accounts Table fields details: AccNo (PK)(varchar) (5) AccName (varchar)(50) AccOpBal (double) Transactions...

Dear All, I am using Microsoft Visual Studio 2010 Ultimate, C# Winforms & MySql Database. I am trying to use BCrypt class by Derek Slager for creating and authenticating username and password. A form is use to create new user to save Username and Password to database, but this Password is not...

Hi, Atlast...I've make it working... :) Following is the code if anyone is looking for it: public int CheckUser() { oCn = da.GetConnection(); if (oCn == null) { oCn.Open(); }...

Yes I've also tried the following: sInsProcName = "Select fLogin_Check(mUserName, mUserPass, mUserKey)"; insertcommand = new MySqlCommand(sInsProcName, oCn); insertcommand.CommandType = CommandType.Text; insertcommand.Parameters.Add(new MySqlParameter("mRes"...

Development Environment: Microsoft Visual Studio 2010 Ultimate, C#, MySql Hi, I've create a function in mysql which accept 3 parameter to validate username and password. DELIMITER $$ USE `generalledger`$$ DROP FUNCTION IF EXISTS `fLogin_Check`$$ CREATE DEFINER=`root`@`localhost`...

ools: Visual Studio 2010 Ultimate, Language C#, Database MySql Hi, I am searching this a while, but to date didn't find any suitable solution. I've a form with bound DataGridView with 5 columns, ProductID, ProductName, Qty, Price and Amount. After normal data entry user can click button...

So that User can select Financial Year from combobox and Admin can Active or In-Active mark to restrict access to data entry user for mistakenly enter in wrong Financial year. This is why I've created a table, and need a global/application level variable to store year id when user select it...

Hi, In continuation with this thread, I've now add a Table FYear with ID, YearDesc fields. Is it possible to use something like a application level/Global variable in which I can save ID of a particular Year and insert it with every transactions created? My idea is: Enter multiple Financial...

Awesome.... Once again thanks for great guidelines. Best regards Ahmed

Thanks again for your reply. I will definitely follow your guidelines. But what about data volume? if we use one table for multiple years transactions, assuming 50-80k transactions per year, would it cause any slow processing for database operations?

Thanks a lot for prompt response jmcilhinney, but I am wondering about the data volume say 50-80k per financial year. If we use same tables, doesn't it make processing slow at some stage lets say after 4-5 financial year data? How about I add a column for Financial Year instead of date field...

Dear All, I am on the beginning stage on C# development. Currently I am developing an Voucher based Accounting Software with following: 1- Visual Studio 2010 2- Programming Language: C# 3- Database: MySql 5 At present, Database structure is as follows: 1.accAccounts (For holding...

Thanks for your prompt reply, Actually this is the part of code what you've mentioned, It is Master/Detail type of project, I can enter Order, and everything with OrderDetails and then saved it with the code mentioned earlier, OrdDetID is a reference for each and every product entered by user...

I am using Visual Studio 2010, language C# and SQL Server Express Edition as backend. There is one form with DataGridView control, I've setup columns manually using designer, then on runtime set the data source. connectionString = ConfigurationManager.AppSettings["connectionString"]...

I need some help to make a Order Form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate Sql Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables=Orders and OrderDetails) I've create a Form for order dataentry, which contain Textbox...

Sorry that was typo error...I was calling FillSchema method.

Re:Save data from Unbound DataGridView to Sql Server 2005 and then Bind to records C# Thank you very much for your help and support, is FillSchema method support Update/Delete method? if I convert: sqlDataAdapter.Fill(ds, "Products");to sqlDataAdapter.Fill(ds, SchemaType.Source...