Ajaxauto complete with oracle database (c#) Error

Question

1.00/5 (2 votes)

See more:

This code is Getting Executed but when i type a letter in textbox it pops System.Data.DataRow

[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> GetName(string prefixText)
{
OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
//con.ConnectionString = ConfigurationManager.ConnectionStrings["dbconnection"].ToString();

con.Open();

string query = "select name from vpro where name like :Name||'%'";
//Console.Write("select name from vpro where name like :Name||'%'");
OracleCommand cmd = new OracleCommand(query, con)
{ CommandType = CommandType.Text };

cmd.Parameters.AddWithValue(":Name", prefixText);

OracleDataAdapter sda = new OracleDataAdapter(cmd);
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
sda.Fill(ds);
dt = ds.Tables[0];
List<string> name = new List<string>();

for (int i = 0; i < dt.Rows.Count; i++)
{
name.Add(dt.Rows[0].ToString());
}

return name;

}

Posted 21-Mar-13 10:23am

akash02asp

Updated 22-Mar-13 2:42am

v2

Add a Solution

Comments

[no name] 21-Mar-13 16:38pm

This is just an unformatted code dump. No question asked and no explanation.

[no name] 22-Mar-13 8:58am

Yes of course it will. That is exactly what dt.Rows[0].ToString() will do. Did you try dt.Rows[0][i].ToString()?

akash02asp 22-Mar-13 9:20am

Greattttttt !!!!! Got it.

yes can u explain me plzzz.

[no name] 22-Mar-13 9:21am

Explain what?

akash02asp 22-Mar-13 9:22am

Wat is happening really there
dt.Rows[0].ToString() ---> dt.Rows[0][i].ToString()

[no name] 22-Mar-13 9:32am

dt.Rows[0].ToString() calls the object ToString method. In this case you are calling ToString on Row 0 of the table which is "System.Data.DataRow"
dt.Rows[0][i].ToString() calls the object ToString method on the item that is in position i (cell or item) of the row 0.

akash02asp 22-Mar-13 9:34am

Thank you very much.

[no name] 22-Mar-13 9:37am

You're welcome

3 solutions

Solution 1

What is the error you getting ? seems to be code correct but I have one suggestion use foreach instead of for loop.

Posted 21-Mar-13 12:36pm

Sivakrishna Donepudi

Comments

akash02asp 22-Mar-13 8:27am

It is getting excuted but
When i type a letter in textbox eg:- d .
It is getting System.Data.DataRow

akash02asp 22-Mar-13 11:11am

Thank you SivaKrishna :)

Solution 2

dt.Rows[0].ToString() ---> dt.Rows[0][i].ToString()

Solved.
Thank you ThePhantomUpvoter.

Posted 22-Mar-13 3:29am

akash02asp

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)

akash02asp · Accepted Answer · 2013-03-22T05:09:00

Solved Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.OracleClient;
using System.Data;

public partial class ajaxautocomplete : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetCountries(string prefixText)
{

OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
con.Open();

string query = "select name from vpro where name like :Name||'%'";
//Console.Write("select name from vpro where name like :Name||'%'");
OracleCommand cmd = new OracleCommand(query, con) { CommandType = CommandType.Text };
cmd.Parameters.AddWithValue(":Name", prefixText);
OracleDataAdapter sda = new OracleDataAdapter(cmd);
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
sda.Fill(ds);
dt = ds.Tables[0];
string[] name = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
name.SetValue(dr["name"].ToString(), i);
i++;
}
return name;
}

}