C#.net Windows Application Input data check before insert to Database

Question

1.00/5 (2 votes)

See more:

C#

C#4.0

C#.net Windows Application Input data check before insert to Database

Posted 23-Nov-13 0:27am

krishna97

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2013-11-23T00:37:00

Solution 1

You have to write validations for data yourself.

Posted 23-Nov-13 0:37am

Abhinav S

Comments

krishna97 23-Nov-13 6:39am

private bool RecordExists(string ItemName, string weightgm, string Weightmg, string Purity, string groupName)
{
string connect1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BSTJewellers.accdb";
olcon = new OleDbConnection(connect1);
OleDbCommand cmd = new OleDbCommand();

//query for duplicate
cmd.CommandText = "select count(*) from StoreManagement where ItemName = @ItemName and groupName=@groupName and weightgm = @weightgm and Weightmg = @Weightmg and Purity=@Purity";
cmd.Parameters.AddWithValue("@ItemName", txtItemname.Text);
cmd.Parameters.AddWithValue("@groupName", cmbgrpname.Text);
cmd.Parameters.AddWithValue("@weightgm", txtweightgm.Text);
cmd.Parameters.AddWithValue("@Weightmg", txtweghtmg.Text);
cmd.Parameters.AddWithValue("@Purity", txtpurity.Text);

//cmd.CommandText = "select count(*) from StoreManagement where ItemName = '"+txtItemname.Text+"' and groupName='"+cmbgrpname.Text+"' and weightgm ='"+ txtweightgm.Text+"' and Weightmg ='"+ txtweghtmg.Text+"' and Purity='"+ txtpurity.Text+"'";

olcon.Open();

int recordCount = Convert.ToInt32(cmd.ExecuteScalar());
//cmd.ExecuteScalar();
olcon.Close();

return recordCount > 0;
//if (recordCount > 0)
//{
// MessageBox.Show("duplicate value insert");
//}
}

but error given it..??

S. M. Ahasan Habib · Answer 2 · 2013-11-23T00:52:00

User input data should be validated. Question is where you write that validation logic. Your applilcation is windows application. So some validation you should write in your presentation layer. For example

Example-1. The date of submit order should not be greater then current data or User name should not be empty.
That type of validation you should write in your windows windows form and call it when user press submit/save/edit etc button. You can also write that logic to your business model/entity and entity should contain a IsValid type method. This method will return validationResult type object which may contain any invalid data if entity contain.

Example-2> User wants to withdraw money from her account. In that type of validation you need to query your database for verify your input. In that type of validation logic you should write your business logic/domain service layer.

One important point you should remember that if you write data validation logic in your application but you first should add data constraint to your database first. It will ensure your data/referential integrity. For example Primary key/Unique index, Not Null etc.