Comments by manasBonton

manasBonton 25-Nov-11 4:24am View

i have some group list those have parentGRID =0,these are root nodes. after that some child nodes are there of corresponding groups. i want to get the root node (B) and their child node(B1,B2,B3....)as well as subchild nodes(B11,B12......)

manasBonton 15-Apr-11 2:16am View

sir i have aleardy connect MS agent with Database.But it speaking only first value. But i want it should speak all value.

manasBonton 15-Apr-11 2:16am View

sir i have aleardy connect MS agent with Database.But it speaking only first value. But i want it should speak all value.

manasBonton 15-Apr-11 2:16am View

sir i have aleardy connect MS agent with Database.But it speaking only first value. But i want it should speak all value.

manasBonton 4-Apr-11 6:29am View

kindly write briefly,i am new in coding

manasBonton 4-Apr-11 6:08am View

how will use the same concept in Window Base application

manasBonton 30-Mar-11 6:09am View

you try to give the correct answer and try to understand my question

manasBonton 30-Mar-11 4:23am View

//i want to take a sentence in textbox and spliting and searching and displaying if related word is there.now it is displaying if accurate word will give like TV but if Tvor Tvv means not displaying.
kindly answer me sir
/////////////////
string commaDelimited = textBox1.Text;
string[] year = commaDelimited.Split(new char[] { });

/////////////////////////////////////////
//string[] r = { "TV", "Radio", "Coal" };
string filter = string.Empty;
foreach (string name in year)
{
if (filter.Length > 0)
{
filter += ",";
}
filter += string.Format("'{0}'", name);
}
SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ERPDB;Integrated Security=True");
SqlDataAdapter adp;
DataSet ds = new DataSet();
adp = new SqlDataAdapter("Select * from Prod_Tbl where ProductName IN (" + filter + ")", con);
adp.Fill(ds, "Prod_Tbl");
dataGridView1.DataSource = ds.Tables[0].DefaultView;

manasBonton 30-Mar-11 4:22am View

//i want to take a sentence in textbox and spliting and searching and displaying if related word is there.now it is displaying if accurate word will give like TV but if Tvor Tvv means not displaying.
kindly answer me sir
/////////////////
string commaDelimited = textBox1.Text;
string[] year = commaDelimited.Split(new char[] { });

/////////////////////////////////////////
//string[] r = { "TV", "Radio", "Coal" };
string filter = string.Empty;
foreach (string name in year)
{
if (filter.Length > 0)
{
filter += ",";
}
filter += string.Format("'{0}'", name);
}
SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ERPDB;Integrated Security=True");
SqlDataAdapter adp;
DataSet ds = new DataSet();
adp = new SqlDataAdapter("Select * from Prod_Tbl where ProductName IN (" + filter + ")", con);
adp.Fill(ds, "Prod_Tbl");
dataGridView1.DataSource = ds.Tables[0].DefaultView;

manasBonton 30-Mar-11 2:38am View

Sir ,but i want to take collection of item in the variable filter dynamically.if i wl take this ,can not change the value bcz it is constant

manasBonton 29-Mar-11 3:54am View

I got the result thanking you i have taken double

manasBonton 29-Mar-11 3:52am View

i have taken the Rate in Money data type.so it is displaying error"Input string was not in a correct format.
"

manasBonton 29-Mar-11 2:44am View

Thank you so much...........
it is working now.

manasBonton 29-Mar-11 2:34am View

Incorrect syntax near '='. displaying

manasBonton 29-Mar-11 1:46am View

I have tried aleardy "Select * from Prod_Tbl where ProductName='" + name + "'"

Comments by manasBonton (Top 15 by date)