|
Hi Richard,
Sounds like you're already know if what the problem is 
Ok it's goes like this...
-------------------------------------------------------
First I have a table named tblTitle_Category and has only two fields - "PlayID" and "CatID".
And then I have also another table named tblCategories which contains only two fields - "CatID" and "Description".
tblTitle_Category:
PlayID CatID
1 1
1 2
2 3
2 4
3 5
3 6
tblCategories:
CatID Description
1 Liquid
2 Solid
3 Stone
4 Wood
5 Steel
6 Place
So, we have now a tblTitle_Category table and tblCategories table. And inorder to link them both, of course we need to join them using the Left Outer Join SQL Statement.
ASP.Net 2.0 Web Controls used:
1 - GridView, used for non editable records, only viewing purposes.
2 - DetailsView, used for inserting, editing and deleting of records.
GridView's SQLDatasource Statement:
Select tc.PlayID, tc.CatID, c.Description * From tblTitle_Category tc
Left Outer Join tblCategories c on tc.CatID = c.CatID
DetailsView's SQLDatasource Statement:
Select:
Select tc.PlayID, c.Description * From tblTitle_Category tc
Left Outer Join tblCategories c on tc.CatID = c.CatID
Insert:
Insert Into dbo.tblTitle_Category
(PlayID, CatID)
Values
(@PlayID, @CatID)
Edit:
Update dbo.tblTitle_Category
Set CatID = @CatID
Where PlayID = @PlayID and CatID = @CatID2
In my DetailsView I have a template for DropDownList for tblCategory.Description.
I have 3 parameters for editing existing record by just changing the tblCategory.Description thru the DropDownList.
Parameters:
@PlayID = From Other GridView source (I checked the value thru msgbox and the value is correct)
@CatID = TextBox1.Text (The value of TextBox1.Text is the CatID based on the DropdownList
selection that I passed).
Code below:
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As
System.EventArgs)
TextBox1.Text = CType(sender, DropDownList).SelectedValue
End Sub
@CatID2 = TextBox2.Text (The value of TextBox2.Text is CatID based from the GridView's CatID)
And, that's all. It's very simple, isn't it?
But I really don't know if why the category can't be saved when I select another category from the DropDownList.
I am hoping that you can simulate this one, and I think you will get the same problem
By the way I am using MSSQL2005. Anyway, Access DB will do.
Thanks in advance.
-- modified at 12:59 Monday 23rd April, 2007
hifiger2004
|
|
|
|
|
What are the data types(and lengths) of the fileds in those tables?
|
|
|
|
|
All ID fields are integer "int". PlayID and CatID fields were declared as int.
hifiger2004
|
|
|
|
|
Just to be sure, why don't you parse the ID's to the update as int's first before doing the update?
I'm not sure if this is your problem, but it wouldn't hurt to do it
|
|
|
|
|
I parse all ID's, and I even tried converting the parameter value passed into integer just to be sure, but still the problem is there
hifiger2004
|
|
|
|
|
Im starting a new site using FrontPage and Im still clueless when coming to a few things like, getting expandable menus on buttons, and marqueing text(moving text).
Please help, where you can
kagiso
|
|
|
|
|
My best answer, but it won't help you much, is to stay away from Frontpage, as it is limited and will make you frustrated.
The moving text, is called a marquee, and holds the <marquee> tags. Maybe worst case scenario, you can have the part that you want to be moving, and put it in marquee tags.
Expandable menu's on buttons.. can be done with CSS. Do you want something like a folded out menu?
www.code.ae
|
|
|
|
|
matjame wrote: Im starting a new site using FrontPage
As Michael Hendrickx said FrontPage is not a good editor. It will put things in the code to ensure that the page will not render on anything but IE. GoLive is not much better as you will also have cross browser compatibility problems, just not the same problems as FrontPage.
Getting HTML to render properly on a wide variety of browsers is like trying to herd cats. They all have their own agenda and it is not the same as any other.
I would recommend using an HTML editor, like HTML-Kit and learning how to hand code HTML. It really isn't that difficult once you get past the basics and HTML-Kit has templates to get you started with the basic framework. HTML-Kit is a free download.
Separate the layout from the presentation using CSS and you will be able to make site wide changes in one place as opposed to going through every page looking for formatting parameters.
Go to W3C HTML Tutorial[^] if you would like to get started learning HTML.
HTML looks daunting at first but it is easy once you get used to it. Then you can move on to javascript and a server side scripting language to make dynamic pages. There are a lot of examples on the web so it is easy to get examples of working code.
|
|
|
|
|
please ,anyone who can help me as soon as possible,i need the code,asp code,to take input from user and display this specific user information from my database, 
|
|
|
|
|
I require a software component to be added to an existing .net application(web based). The coponent or the software should posses the following features:
1. It should provide PC to Phone integration either on VOIP technology or TAPI or both.
2. It should provide automated phone dialing from phone number lists.
3. Transfer calls to other users internally.
4. Record conversations and provide automated call reports and statistics.
5. Every phone number in the system should be automatically clickable and the call details must be logged to that user.
6. The phone call must be recorded and stored as a sound file.
Can anyone help me to find any freewares or commercial products available in the market which can provide me the above features.
Thanks in Advance
----------------------------------
where there is a will there is a way
|
|
|
|
|
how can i make an input mask on textbox for a date mm/dd/yyyy. example input 16/07/1975. initially it should be displayed like __/__/____ and if i enter a digit then underscore should be replaced by that digit rest should remain same.
any help would appreciate..
thanks..
Dinesh Sharma
|
|
|
|
|
I dont know much about javascript, but you can use the MaskedEdit extender from AJAX toolkit. Its much easier. I know you will have to use the OnKeyPress type of event to do this. Also the OnBlur event. But I am not sure how to do this in javascript. If possible try using the AJAX control I suggested. Hope I helped you in some manner ?
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Is there a way to change change the button that is checked in a radio button group programmatically?
I have a group of buttons that control the presentation of a web page. That is if a button is clicked a form expands to offer more options. Originally that part of the form is hidden and it is only visible if the yes button in a yes/no group is clicked. Originally the no button is checked by default.
I set a state variable for future reference and hide the buttons from view. Everything works fine transitioning from view to view unless the refersh browser control is pressed for a reset of the form.
On Opera original state of the form is visible, as it should be, and the no button is checked, as it should be. This is consistant with the original form the first time it is loaded.
On FF the yes radio button is clicked but the form is not expanded which is inconsistant. To make matters worse I need to first click the no button to get the yes button to respond again. Even though it is checked it is not active until the other button is clicked.
On IE both buttons are unchecked and the form is in original state. Not quite consistant with the original state of the page but at least a click on the yes button expands the form.
If I can re-check the no button before I hide the buttons things would work consistantly on FF and Opera.
If I could uncheck both buttons I could use that on the original page and at least things would be consistant on all three browsers.
My question is how do I click a radio button programatically in javascript? Or failing that how do I uncheck a checked button (the yes button) programmatically in javascript?
|
|
|
|
|
For example:
<input type="radio" name="group1" id="radButton1">
<br />
<input type="radio" name="group1" id="radButton2">
<br />
<script language="javascript">
<!--
document.getElementById("radButton2").checked = true;
//-->
</script>
cheers
F
|
|
|
|
|
Thanks - That is what I need to do. 
|
|
|
|
|
hi
I am not getting email in russian language.The email content is partly comming from database and partly entered by the user. It is a html mail. I am getting correct email in english. But when I am changing email language to russian the output of mail content look like-------------
hi ÐÐºÐ°Ð´ÐµÐ¼Ð¸Ñ Ð¤ÐµÐ´ÐµÑ€Ð°Ð»ÑŒÐ½Ð¾Ð³Ð¾ агентÑтва ПравительÑтвенной ÑвÑзи и информации при президенте РоÑÑийÑкой Федерации
--------- This is not in russian language
Plz. help me!!!
Bharat Bhusanam
|
|
|
|
|
When you say you change the language to Russian is that on the client, the server, or both?
Do you set the mime character set in the header of the HTML document before it is sent out? You may be sending Russian with an English character set header setting.
Another possibility is that when viewing the email you are on the client and there may not be the same fonts available as there were on the server?
I think it is more likely the character set setting in the HTML header.
|
|
|
|
|
As said by Mr Ropes, the problem is based in encoding. Please post a copy of the RAW email (text) and what it should be.
Brad
Australian
- unknown PHP Developer on "Job Prospect"
Requirement: * Experience working with XML, XSL, XPath
Comment: and other things starting with X.
|
|
|
|
|
my mail code is as follows-------------
$message = "
| $mail1_invitationsent $mail2_invitationsent |
| | $mail3_invitationsent ($college_name) |
| | | $mail_contents | | | | | | $mail4_invitationsent | | | $mail5_invitationsent | | | |
|
|
|
";
// To send HTML mail, the Content-type header must be set
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$headers .= 'From: xxxxx<community@xxxx.com>' . "\r\n";
mail($to, $subject, $message, $headers);
----------------------------- end of code-----------------------
some variables are used to change language
and
$mail_contents is the vatiable of mail contents which is partly from database and partyt from use input.
Plz. solve my prob
Bharat Bhusanam
|
|
|
|
|
Hi all,
I think this is a newbee question ! Sorry
I have a php web page that is working perfect !!!
However, I need it to be displayed inside a white square (22cm by 15cm) on a black background. This square needs to be centre aligned.
I think this is a CSS thing but I am new to all this so if any kind person could help me with this then I would be VERY grateful !!!
Thanks Lots
John
|
|
|
|
|
Try check my website www.boutiqueboneka.com. I think it has what you want.
|
|
|
|
|
|
I have a web page,in that on click of a button a modal pop up window appears,im handling that button event in javascript "onclick" property.
My popup window contains a panel,inside that panel there are ajax controls like drop down list and text boxes.
My problem is i want to set focus to that drop down list in the panel on click of the button.
Can anybody help me..
Dream it to achieve it
|
|
|
|
|
You can use document.getElementById(<id> ).focus() to set the focus to any (enabled) control you like.
Wout Louwers
|
|
|
|
|
the code you had sent will not work for ajax controls,i tried it before raising the issue
Dream it to achieve it
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
