Comments by RoopikaS - CodeProject

RoopikaS 30-Mar-11 0:29am View

The issue is it, we are not sure as in what the user will copy, so it happens that there might be the loss of data, when we try to recover that data.How do we go for that?

RoopikaS 15-Nov-10 22:03pm View

Hey Rahul, Thanks for your reply, But my concern was, I am trying to search a string from table, I do know the Column name of the same,and am searching the user entered Search String in that particular Column Code OracleConnection Oracon = new OracleConnection(sql); OracleDataAdapter dataAdapter = new OracleDataAdapter("SELECT * FROM MY_TABLE", Oracon); dt = new DataTable(); dataAdapter.Fill(dt); DataView dv1 = new DataView(dt); foreach (DataRow row in dt.Select()) { dBStrings.Add(row["VALUE_NAME"].ToString()); // Do something with columnValue } This is the way Im getting the values from Table and then I am carrying out Search on it..The issue is since the entries in Column are too many, it is taking a lot of time to load things up.. Please guide me for the same.

RoopikaS 26-Oct-10 2:07am View

using (SPSite site = new SPSite(strListURL.Trim()))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists[strListName.Trim()];

SPView wpView = list.Views["All Items"];

RoopikaS 25-Oct-10 5:35am View

List<string> ab = new List<string>();
foreach (SPField obj in web.Fields)
{

ab.Add(obj.Title);
ab.Sort();

}
foreach (string str in ab)
{
DropDownList1.Items.Add(str);
}

RoopikaS 7-Oct-10 1:47am View

Thanks Abhinav...

RoopikaS 3-Sep-10 2:46am View

Danke :)

RoopikaS 3-Sep-10 2:38am View

hey thanks Sandeep :)

RoopikaS 3-Sep-10 2:37am View

Hey Dalek,,
Thanks for your answer, But my concern was,
I am trying to search a string from table, I do know the Column name of the same,and am searching the user entered Search String in that particular Column

Code

OracleConnection Oracon = new OracleConnection(sql);
OracleDataAdapter dataAdapter = new OracleDataAdapter("SELECT * FROM MY_TABLE", Oracon);
dt = new DataTable();
dataAdapter.Fill(dt);
DataView dv1 = new DataView(dt);
foreach (DataRow row in dt.Select())
{
dBStrings.Add(row["VALUE_NAME"].ToString());
// Do something with columnValue
}

This is the way Im getting the values from Table and then I am carrying out
Search on it..

RoopikaS 1-Sep-10 4:25am View

Hey thanks a lot buddy :)

Comments by RoopikaS (Top 9 by date)