How to fix an error in sql query

Question

0.00/5 (No votes)

See more:

i am creating a database application in c# using sql. i am trying to search records in the database but i having an errors. the sql query i am using is:
Select * from Member where MemberId like @MemberId. this query works well in sql but when i used in my code in c#. this is my code:

C#

Members f = new Members();
            f.Show();
            string str = (@"Data Source=BROTHER-PC;Initial Catalog=iEMYS;Integrated Security=True");
            SqlConnection con = new SqlConnection(str);
            if (comboBox1.SelectedIndex == 0)
            {
                try
                {
                    string searchtext = textBox1.Text;
                    int value = int.Parse(textBox1.Text);
                   if (f.iEMYSDataSet2.Member.Count != 0)
                {
                f.memberTableAdapter.FillByMemberId(f.iEMYSDataSet2.Member, "%" + int.Parse(searchtext) + "%");
                }
            if (this.iEMYSDataSet.Administrator.Count == 0)
                {
                MessageBox.Show("No Administrator found in iEMYS System", "Admin Info");

                }
                }

                catch (Exception)
                {

                }
            }

I get this error:
the best overloaded method match for 'iEMYS.iEMYSDataset2TableAdapters.memberTableAdapter.FillByMemberId(iEMYS.iEMYSDataset2.memberDataTable,int)' has some invalid arguments

please I need help

Posted 19-Aug-14 3:11am

MaximusDebois

Updated 19-Aug-14 3:50am

DaveAuld

v2

Add a Solution

Comments

[no name] 19-Aug-14 9:33am

It's because you are taking a string, attempting to parse that string to an integer and then turning it back to a string by concatenating your integer to 2 other string and then trying to call a method that expects an integer.

MaximusDebois 19-Aug-14 9:42am

so how do i solve the error

[no name] 19-Aug-14 9:46am

Either pass the correct type of parameter to your method or change the method.

Then do yourself a favor and get yourself a decent book on basic programming and work through it. Reposting the same questions over and over is not going to help you. And, we can't teach you programming in a forum posting.

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)

OriginalGriff · Answer 1 · 2014-08-19T03:49:00

Taking a string, converting it to an integer to call a method expecting an integer is one thing: but you can't then add strigns to it and expect it to remain an integer: what should I do with this?

%17% / 42

Mathematically, it's garbage - and that's what you are trying to pass to your method.

Either pass the integer value without adding strings to it, or write an overload fro your method which takes a string instead.