|
Hi.. Good Day..
I have a question about how to get different field values from database and combine both of these values and display it in the textbox.
I use the SqlDataReader to read data from database. The way i use to assign data from database into textbos is like below :
txtBookTitle= myReader.GetValue(2).ToString
Can anyone give me a solution how to combine 2 values get from database and dispaly out in a textbox. Thanks.... 
Best Regards,
Pei Sun
|
|
|
|
|
txtBookTitle.text = myReader.GetValue(2).ToString() & myReader.GetValue(2).ToString()
That should concatenate two strings. For numbers, you should cast to the number and use a + sign instead.
|
|
|
|
|
Thanks for your help. it's work ! Thanks so much.. 
Best Regards,
Pei Sun
|
|
|
|
|
I hav a DataView object named dv. It gets its data from a DataTable named tbl.
It has three columns: col1,col2,col3. I populate a ListBox object named lstItems from it in the following way:
...
Dim dv As New DataView
dv.Table=tbl
lstItems.DataSource=dv
lstItems.DataValueField="col1"
lstItems.DataTextField=DataBinder.Eval(dv,"col2,col3")
lstItems.DataBind()
It want col2,col3 values to be displayed in as a single item listbox.
it gives error on reaching to DataBinder.Evel() method.
Can someone help me how to solve this problem.
Thanks
|
|
|
|
|
You can use the DataBinder in this way as the DataTextField is where you specify a single data field. IMO, your chances are:
+ Manage to add the ListItem in the Items collection and you can combine the two columns.
+ Rearrange the datasource to have a column that is the combination of the two columns.
|
|
|
|
|
|
|
you can write a function to combine the two fields with comman and then use that function in DataTextField.
like,
string Combine(object o1, object o2)
{
return o1.ToString() + "," + o2.ToString();
}
you can use
lstItems.DataTextField = Combine(DataBinder.Eval(dv, "col2"), DataBinder.Eval(dv, "col3"));
Thanks,
Pradipta.
Pradipta Basu
|
|
|
|
|
Hi all,
I want to store contents to database from Textarea, Sometimes the user put's the HTML tags in the textarea, this makes a little confusion in the design while retriving the data. Is there any options to remove all the HTML tags before storing the data's in the database?, I am doing this work in ASP.NET with VB.NET.
Please guide me.......
Regards
Exelio
|
|
|
|
|
Hi there,
The common way is to keep saving data as it is in DB, but when you display on the web page you can use the HttpUtility.HtmlEncode encode the html markup in data.
|
|
|
|
|
Before doing it you have to write ValidateRequest="false" in the page directive.
The problem is that it provides an option for HTML injection.
Pradipta Basu
|
|
|
|
|
Hi everybody!!
I want to play some audio files in my project. Audio-Files should be stored in database , first it will read from databse then play this file.
Can anyone tell me how to do this.
Thanx n regards
|
|
|
|
|
Hi there,
Basically, to play the media file on the web page you can host the player on the page with the object tag, and assign the url of the media file to the player. You can use the search functionality of the site to look for the sample code as this question was answered many times at this site.
|
|
|
|
|
Pls help me understand why is that when using server.transfer the previous page is displayed in the url address of the browser.
For example, login.aspx is displayed in the browser. When login button is clicked, server.transfer(mainmenu.aspx) is called.
When the mainmenu.aspx is displayed on the browser, the url address displayed
is still the url of login.aspx. Becaus of this my sitemap is having problems in getting the correct current node. Pls help. Thanks.
|
|
|
|
|
The Server.Transfer method redirects the web page at the server side, so it does not update the new url in the address bar. In this case, you might consider using the Redirect method instead.
|
|
|
|
|
ok thanks. for the explanation.
|
|
|
|
|
Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the client's browser. This provides a faster response with a little less overhead on the server. Server.Transfer does not update the clients url history list or current url. If u want to update ur url address it is better to use Response.Redirect();
eg.Response.Redirect("mainmenu.aspx");
|
|
|
|
|
Hi Thanks for the reply.
But is there a way for my sitemap to get the correct node even if I use Server.Transfer? Below is the code I used to resolve SiteMap in Global.asax.
Function AppendQueryString(ByVal o As [Object], ByVal e As SiteMapResolveEventArgs) As SiteMapNode
If (Not (SiteMap.CurrentNode) Is Nothing) Then
Dim temp As SiteMapNode
temp = SiteMap.CurrentNode.Clone(True)
Dim u As Uri = New Uri(e.Context.Request.Url.ToString)
temp.Url = (temp.Url + u.Query)
If (Not (temp.ParentNode) Is Nothing) Then
temp.ParentNode.Url = (temp.ParentNode.Url + u.Query)
End If
Return temp
Else
Return Nothing
End If
End Function
Thanks in Advance
|
|
|
|
|
because Server.Transfer is transfer the server from one page to another and actuaaly it is to handle the server side control not the client side controls.
and change of url is just cilent area of web-application
better to use
Response.Redirect(http://localhost/WebApplication1/WebForm1.aspx");
Mairy
|
|
|
|
|
Thanks everyone!
|
|
|
|
|
I have a follow-up qs though!
is there a method or function in asp.net for setting the browser features
same as window.open?
Thanks in advance.
|
|
|
|
|
I've come across this odd behavior, that I'm not quite sure what to make of it, or even how to determine the source of the problem.
Ok, I have one page.
3 different buttons on that page.
asp:Panel ID="PanelNew" runat="server" Width="97%" >
asp:button runat="server" text="MostRecent" OnCommand="SelectActiveView" CommandArgument="MostRecent" CommandName="Hide" />
asp:button runat="server" text="Most Recent 2" id="testbutton" />
/asp:Panel>
Then I had code in the page load that is:
<br />
<br />
testbutton.Command += new CommandEventHandler(this.SelectActiveView);<br />
testbutton.CommandArgument = "MostRecent";<br />
testbutton.CommandName = "Hide";<br />
<br />
Button TempButton = new Button(); <br />
TempButton.Text = "Cancel";<br />
TempButton.Command += new CommandEventHandler(this.SelectActiveView);<br />
TempButton.CommandArgument = "MostRecent";<br />
TempButton.CommandName = "Hide";<br />
PanelNew.Controls.Add(TempButton);<br />
So, I have on that's declared in html, one that's declared in html then modified from code, then the last is complete code made, all three buttons end up having the same command arguements, but the one made from code behaves differently from the rest. The function they call, modifies some hiden value fields then calls a page load.
Ok, now this part, is hard to explain, so please stay with me.
If I go straight to that page from a link, all three buttons work, first try.
If I click on a button that does a post back on to the page, then I click on the tempbutton, the hidden field values are not updated, Then I click the same button a second time and it does update the hidden values like it was supposed to on the first click.
Well, I hope that made sense. If it didn't then post that and I'll see if i can post some source code to duplicate this behavior.
Drathmar
|
|
|
|
|
A couple of things come to mind:
+ Try to give the control an id when you statically declare on the web page or dynamically load the control in code.
+ Try to add the dynamic control in the Init phase in the control life cycle.
+ Just curious that why you try with 3 buttons that have the same command name and argument.
|
|
|
|
|
My problem in a nutshell is the programmatically created controls aren't working 100% of the time.
NOTE: Giving the Programmically made controls an id fixed the problem, and thank you minhpc_bk for the help.
However I made some sample code to demonstrate the problem, what's cause the problem, is still abit puzzling,
To replicate the problem:
When the page first loaded the hidden value is blank, then I click on ButtonR1 or R2 to make it red. So on and so on.
Now, if you start clicking on the buttons in the "Panel Created" panel, they don't work 100% of the time. You have to click the same button twice in a row for it to work.
Drathmar
Here is a simplified example of my problem.
*****************HTML**************
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel ID="Panel1" runat="server" Height="50px" Width="125px">
<asp:Button ID="Button1" runat="server" Text="Button" OnCommand="SetPanelColor" CommandArgument="Reset" />
</asp:Panel>
<asp:Panel ID="PanelRed" runat="server" Height="50px" Width="125px" GroupingText="Make Panel Red">
<asp:Button ID="ButtonR1" runat="server" Text="ButtonR1" OnCommand="SetPanelColor" CommandArgument="Red" />
<asp:Button ID="ButtonR2" runat="server" Text="ButtonR2" />
</asp:Panel>
<asp:Panel ID="PanelBlue" runat="server" Height="50px" Width="125px" GroupingText="Make Panel Blue">
<asp:Button ID="ButtonB1" runat="server" Text="ButtonB1" OnCommand="SetPanelColor" CommandArgument="Blue" />
<asp:Button ID="ButtonB2" runat="server" Text="ButtonB2" />
</asp:Panel>
<asp:Panel ID="PanelCreate" runat="server" Height="50px" Width="125px" GroupingText="Panel Created">
</asp:Panel>
</div>
<asp:HiddenField ID="HiddenField1" runat="server" />
</form>
</body>
</html>
***************** Code **************
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("HiddenField1.Value = " + HiddenField1.Value + "<br>");
if (HiddenField1.Value == "Red")
Panel1.BackColor = System.Drawing.Color.Red;
else if (HiddenField1.Value == "Blue")
Panel1.BackColor = System.Drawing.Color.Blue;
else
Panel1.BackColor = System.Drawing.Color.White;
ButtonB2.CommandArgument = "Blue";
ButtonB2.Command += new CommandEventHandler(SetPanelColor);
ButtonR2.CommandArgument = "Red";
ButtonR2.Command += new CommandEventHandler(SetPanelColor);
PanelCreate.Controls.Clear();
Button TempButton;
TempButton = new Button();
TempButton.CommandArgument = "Red";
TempButton.Text = "ButtonR3";
TempButton.Command += new CommandEventHandler(SetPanelColor);
PanelCreate.Controls.Add(TempButton);
TempButton = new Button();
TempButton.CommandArgument = "Blue";
TempButton.Text = "ButtonB3";
TempButton.Command += new CommandEventHandler(SetPanelColor);
PanelCreate.Controls.Add(TempButton);
}
protected void SetPanelColor(Object sender, CommandEventArgs e)
{
HiddenField1.Value = e.CommandArgument.ToString();
Page_Load(sender, e);
}
}
|
|
|
|
|
Hi there,
Basically, the ASP.NET processes the postback event like Command based on the id of the control. When you dynamically create and add the control, the ASP.NET will generate the automatic id if you don't explicitly specify a value. And if the id of the control before and after it is clicked, the postback cannot be routed to the right control, and as a result of this the event handler does not execute. You can check this thing by doing a view source the web page. Here it's really odd that you call the Page_Load event handler again in the SetPanelColor as it leads to the fact that you recreate the dynamic control. Instead, you can seperate the code to set the backcolor of the panel in a method ,say SetPanelBackColor, then you can call it in both the Page_Load and SetPanelColor methods.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
