|
Christian Graus wrote: Why ask this twice ?
May be he expecting two different approaches. 
Cross Post, Message Delete is now very much common with this ASP.NET Forum. 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
I want to fetch data from three tables according to itemcode .and item code is entering only two tables.
plz help me
|
|
|
|
|
What is with the run of stupid questions ?
First of all, this has nothing to do with ASP.NET, you should be asking in the SQL forum
Second, you can't possibly expect or want help. If you did, you'd ask a question that could be answered. We can't work out what you need to do, without knowing the schema of the tables.
Third, if there's no other ID you can use to link these tables, then it's probably not possible, and you need to talk to whoever designed the database and get them to fix it. You should not attempt it yourself, because it seems you don't really know anything about databases.
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.
|
|
|
|
|
rummer wrote: I want to fetch data from three tables according to itemcode .and item code is entering only two tables.
How this is related with ASP.NET ? You need to write simple SQL query with join operation.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
How is this possible? 
Can you show ur table structure.
You should have posted this in Database forum.
|
|
|
|
|
Then the third table must contain any key column from other two tables or somehow it should be connected to other two tables.
Provide the table schemas to get more help.
|
|
|
|
|
You can use a Join
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Oh, seriously. One stupid question, and it needs 6 answers, all increasingly clueless ? What does this add to the discussion ? He plainly has no idea what a join is, and the issue is, there's no indication that he has anything to join to, in the third table. I expect that's why he's asking the question, even if he does ask it so inadequately.
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.
|
|
|
|
|
It is very much frustrating when people don't reply when some one wants to help him . It may happen after some time he will delete his post .
These are useless !!
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
Well, I'm not sure what you want here.
1 - this is not an ASP.NET question
2 - how can we tell what your problem is, based on this vague question ?
The SQL is the same, no matter where the text comes from. Use your debugger to work out what's going wrong, and ask a more specific question if you need to
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.
|
|
|
|
|
sorry for not begin clear enough.Well i am working on a asp.net platform using visual studio 2008 and i need to store a value which is selected in the dropdownlist web control into a database (MYSQLEXPRESS).i am able to do with text box web control
|
|
|
|
|
You just restated the question. You've added NOTHING to the situation. Here are some things to consider
1 - your database has no idea where your data comes from. Therefore, I have to assume your problem is with interacting with controls, because the SQL code will be the same
2 - I've already told you to use the debugger - have you ? You don't give us any clue what your code looks like, or what it is doing, so we can't really help you, but the first step, is to walk through the code and work out at what point you're failing to get your value.
Having experience with this sort of idiotic question, I am willing to make a guess. Your problem, although you've not said so, is that the wrong value is stored. This is because you bind to the datasource in page load ( the wrong place ), on postback ( the wrong time ). If I am utterly wrong, it is because the only way this question makes sense, is if you were trying to test our ability to work out solutions based on zero information. If you want actual help, you need to know enough to be able to explain what is exactly going wrong, and what exactly you've tried to fix it. Until you do that, I have to consider that you don't even have the skills to ask for help, let alone write any code.
Seriously.
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.
|
|
|
|
|
sumanmks wrote: sorry for not begin clear enough.Well i am working on a asp.net platform using visual studio 2008 and i need to store a value which is selected in the dropdownlist web control into a database (MYSQLEXPRESS).i am able to do with text box web control
ARGH !!! We are trying to HELP YOU. How does deleting your posts and not answering our questions, solve your problems. I may not be polite, but that's because you're plainly doing work you're incapable of, and you're not answering me. Answer our questions if you want help.
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.
|
|
|
|
|
sumanmks wrote: I am finding it difficult to insert a value into MySqlExpress database
for dropdown list control. i am able to insert the values of textbox control
What code you have written for that ? What problem are you getting?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
there r no errors and i am able to insert the values for the textbox web control. But not able to do the same for dropdownlist.
|
|
|
|
|
AAAARRRRGHHHHH !!!!!
If this is paid work, you need to tell the client you are cheating them. If it's a project you're doing to learn, buy a book and work through it, you really need the basics laid out 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.
|
|
|
|
|
sumanmks wrote: am able to insert the values for the textbox web control. But not able to do the same for dropdownlist.
As CG Suggested, I will suggest you to buy some beginners .NET Books and start reading. Its quite surprise that you are able to insert records from Text Box , but not from Dropdown list. 
Can you show us the code that you have written ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Good Day sumanmks
This is a Very Basic Question and it is covered in most Books. i will advice you buy a Book and Read it.
you said you were able to get the values in the Textbox, obviously you used something like this
String Value_To_the_DB = Text1.Text;
but now in a DropDown you have to go in your selectedindexchanged and get the Value there by adding a code like this
String Value_To_the_DB = DropdownList1.SelectedValue;
Hope this Help. Remember to buy a Book
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
This is very Rude to delete messages ! 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi,
I'm working on a legacy .net web-app where one of the pages displays a tree(which can expand/collapse the branches).
The html code for this tree is generated using an XSLT file.
Right now, we are experiencing a problem where the tree does not display at all when the generated tree has some 20,000+ leaves. In the normal case, or even when the tree has some 10,000 leaves, the tree is generated and displayed properly.
My question is if there is a known limit to how large this tree can be. Or if this is just a bug in the XSLT file that we have fix.
Thanks in advance for your help.
Rafferty
|
|
|
|
|
Actually if you write XSLT, it will render HTML in the browser. So if there is a limit, it would be the browser.
But I do think there is no limit in html AFAIK.
Lets see what others reply. 
|
|
|
|
|
Updates: I have found that the tree will display after 3 (or more times) of refreshing the page and trying again. Does anyone know why?
@Abhishek Sur: Thanks for your answer.
Rafferty
|
|
|
|
|
I want to display record from a table in the datagrid control. For example The table stucture is
Address Table
Person Name
Address
City
Now I want the display in the data grid as follows
Person Name:name1
Address:add1
City:city1
Person Name:name2
Address:add2
City:city2
Person Name:name3
Address:add3
City:city3
Not Like This
Person Name Address City
name1 add1 city1
name2 add2 city2
name3 add3 city3
Can anyone help me offer a lead to work on this Thanx in advance
|
|
|
|
|
Then Why Grid ? Use Repeater Control 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
