how can I Substring dropdownlist

Question

0.00/5 (No votes)

See more:

C#

public static Boolean Insert_Imp_Case(int Imp_Case_Id, string Imp_Case_Number, string Imp_Case_Date,
           string Case_Ref_No, string Bl_Number, string Bl_Type, string POL, string POD, string PLD, string Client_Coa,
            string Case_type)
        {
           
            StringBuilder var1 = new StringBuilder();
            var1.Append("INSERT INTO Imp_Case_Header \n");
            var1.Append("            (Imp_Case_Id, \n");
            var1.Append("             Imp_Case_Number, \n");
            var1.Append("             Imp_Case_Date, \n");
            var1.Append("             Case_Ref_No, \n");
            var1.Append("             Bl_Number, \n");
            var1.Append("             Bl_Type, \n");
            var1.Append("             POL, \n");
            var1.Append("             PLD , \n");
            var1.Append("             POD , \n");
            var1.Append("             Client_Coa, \n");
            var1.Append("             Sustring(Case_type,1,1))");

----------------------------------------------------------------------



            var1.Append("VALUES      ( '" + Imp_Case_Id + "', \n");
            var1.Append("              '" + Imp_Case_Number.Replace("'", "''") + "', \n");
            var1.Append("              '" + Imp_Case_Date + "', \n");
            var1.Append("              '" + Case_Ref_No + "', \n");
            var1.Append("              '" + Bl_Number + "', \n");
            var1.Append("              '" + Bl_Type + "', \n");
            var1.Append("              '" + POL + "', \n");
            var1.Append("              '" + PLD + "', \n");
            var1.Append("              '" + POD + "', \n");
            var1.Append("              '" + Client_Coa + "', \n");
            var1.Append("              '" + Case_type + "') ");

Case_Type is drop down list I want to pick the first letter and then insert into table but i am not getting the result.

Posted 24-Jan-14 18:10pm

glmjoy

Updated 24-Jan-14 18:12pm

Ron Beyer

v2

Add a Solution

2 solutions

Solution 1

C#

string ctypeChar = string.Empty;

if (Case_type.SelectedItem != null && !string.IsNullOrEmpty(Case_type.SelectedItem.ToString())
    cTypeChar = Case_type.SelectedItem.ToString()[0];

Then replace Case_type in your append with cTypeChar.

But...

You are really making your query wrong, you should be using parameters[^]. Read up on how to use parameterized queries so you don't subject yourself to SQL injection attacks.

[Edit]
Just read a little closer, you are passing Case_type as a string into the function. You can use this code to calculate the Case_type value to pass to the function. I wrote the code as if Case_type was the actual combobox.

Posted 24-Jan-14 18:16pm

Ron Beyer

Updated 24-Jan-14 18:20pm

v2

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)

Karthik_Mahalingam · Accepted Answer · 2014-01-25T08:22:00

Solution 2

Do these changes
change from

C#

var1.Append(" Sustring(Case_type,1,1))");

To

C#

var1.Append("Case_type))");

and add this line

C#

 Case_type = Case_type.Substring(0, 1);
  var1.Append(" '" + Case_type + "') ");

Posted 25-Jan-14 8:22am

Karthik_Mahalingam