|
I have a dataset in which is data is comming from two table coresponding id
ad = new SqlDataAdapter("select cityid,cityname,stdcode,statename from cities,States where cities.stateid=states.stateid", con.cn);
ad.fill(ds,"Temp");
GridView1.DataSource =ds.Tables["Temp");
GridView1.DataBind();
but Right now I Want to filter dataset according to textbox value Colmun Wise who will enter by user.
we can filter data directly from table but I want to filter data from dataset. give me help or sugesstion. Thnks.....
|
|
|
|
|
|
It is not working. there are more than one textboxes and user can enter value more than one textboxes according to colmuns
|
|
|
|
|
You can change filter expression for Select of dataset as per our values.
|
|
|
|
|
But it is giving error object refrence is no set an instance in secondline while colmun is ok and also creare memory for dataset
DataRow[] R;
R =ds.Tables["tmp"].Select("cityname ='" + TextBox6.Text + "'");//Error
GridView1.DataSource = R;
GridView1.DataBind();
|
|
|
|
|
I think something you did wrong in code.Plz check stack trace and find out whats causing the pblm.
|
|
|
|
|
hai i have one doubt i m using substring in for to display only 10 characters
i m fetching data from database.. column name called description
and now i want to substring of that desciption colunm , write code in c#.
and i wrote code for that like this
lbl_sub.Text = lbl_sub.Text.Substring(0,5-0).ToString() + "..";
this coding working but my problem is when i m fetching .. if there is no data in database ..the n i m getting error. if data lessthan 5 characters then also i m getting error..
plz could u tell me how can i do this ..
try and try untill reach success..
|
|
|
|
|
try this,
if(!string.IsNullOrEmpty(lbl_sub.Text))
{
lbl_sub.Text = (lbl_sub.Text.Length > 5) ? lbl_sub.Text.Substring(0, 5) : lbl_sub.Text;
}
|
|
|
|
|
Thanks dude its working ..thanks a lot ..
do u know how can i change color of that description column data nad disply into different color.
try and try untill reach success..
|
|
|
|
|
|
Rajeshwar Code- Developer wrote: do u know how can i change color of that description column data nad disply into different color.
You are displaying it in a label.right?
Then just give color for label.
|
|
|
|
|
no no i m not displaying in label ..just that is for ex..
actaully how can i substring for dataset.
i m displaying in treeview.
try and try untill reach success..
|
|
|
|
|
If you are using treeview you can do it while adding the nodes to treeview.
|
|
|
|
|
i enable to unserstand how can i so it..
only just tell me ..
ds.tables[0].rows[0]["desc"].tostring;
i fetch data from database now my desc column data it is in ds ..right
plzz could u tell me how can i do substring and change the color..
try and try untill reach success..
|
|
|
|
|
Where you want to display that description.As treeview node?
You have multiple rows.Where you want to change the color?because every node having description.
|
|
|
|
|
yes i want to change every row of the description...
try and try untill reach success..
|
|
|
|
|
Rajeshwar Code- Developer wrote: yes i want to change every row of the description...
style treeview.
|
|
|
|
|
Hello
I download A client server Application from code project.
I want to access server application through internet
Thankyou
|
|
|
|
|
Better you learn from a book or online resources.Plz just try yourself some basics.Everybody started as beginners.
manish.m.meshram wrote: I want to access server application through internet
You need to host the application.
|
|
|
|
|
How to host my application
But it receives message when send it from any browser
|
|
|
|
|
manish.m.meshram wrote: I download A client server Application from code project.
So, you are expecting we have to guess that, which article you are talking about . 
When you have some query releated with any article, it is always better to ask the Article Discussion Forum. When you ask any query over ther, a Notify mail sents to the Author of that article. So you can expect a quick and better reply form author.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
This has NOTHING to do with ASP.NET. Ask in the article, buy a book, do some work yourself instead of asking us to do it for you.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hello sir,
I created a small server application which running ony computer
i.e Local machine connect to internet,
In browser I give
http://IpAddress:8001/abc
It receives on my server,
How could i send message throuh my website.
Thank You
|
|
|
|
|
manish.m.meshram wrote: i.e Local machine connect to internet,
manish.m.meshram wrote: It receives on my server,
manish.m.meshram wrote: How could i send message throuh my website.
Your question is not clear it seems.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
