empty rows in the table

Question

0.00/5 (No votes)

See more:

am using this code to insert multiple rows into a table from a form and it works alright. but when part of the form is empty, it inserts empty space in the hole row. how can i prevent this

code behind form

C#

try
{
    if (string.IsNullOrEmpty(txtActivity1.Text))
    {
        MessageBox.Show("Type Your First Activity");
        return;
    }
    clsCategory person = new clsCategory();
    
    var  _with1 = person;
    _with1.oneCategory = this.txtCategory1.Text;
    _with1.twoCategory = this.txtCategory2.Text;
    _with1.threeCategory = this.txtCategory3.Text;
    _with1.fourCategory = this.txtCategory4.Text;
    _with1.fiveCategory = this.txtCategory5.Text;
    _with1.oneActivity = this.txtActivity1.Text;
    _with1.twoActivity = this.txtActivity2.Text;
    _with1.threeActivity = this.txtActivity3.Text;
    _with1.fourActivity = this.txtActivity4.Text;
    _with1.fiveActivity = this.txtActivity5.Text;
    _with1.saveRegister();
    clearScreen();
    MessageBox.Show("Record is successfully Added");
    
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

Posted 27-Jun-12 3:19am

mikeoabban

Updated 27-Jun-12 3:28am

Tejas Vaishnav

v2

Add a Solution

Comments

Tejas Vaishnav 27-Jun-12 9:30am

you can use .Trim() function like this Textbox.Text.Trim() to prevent blank space to insert.

Kschuler 27-Jun-12 9:34am

You should post this as a solution.

Sandeep Mewara 27-Jun-12 9:35am

Elaborate a little more: but when part of the form is empty, it inserts empty space in the hole row

1 solution

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)

Tim Corey · Answer 1 · 2012-06-27T03:35:00

There are a couple things I notice that are issues here. First, to solve your issue, you should first check to be sure the text fields have values before you decide to populate the row. Don't fire the _with1.saveRegister(); line unless all five fields have values in them.

Next, you should be doing validation on your fields before you save them directly into your database. Before the "Save" method is run, check to be sure the text in the fields is valid (no special characters, etc.) If you don't, you could be subject to a SQL injection attack.