|
i am using active report.so i want to know how could i send email from active report just like crystal report.pls answer me urgent.
tbhattacharjee
|
|
|
|
|
I am trying to construct "advanced serach" page where user can select choices from multiple dropdown lists and then when Search button is pressed the results are being displayed in a gridView. When I run the sproc below manually results are perfect, I can pass no parameter, 1 parameter or 2 . The output is correct in a standard SQL Query. For some reason in aspx the serach works only if 2 dropdownchoices are selected, I tried to select only 1 choice and search resulted in 0 rows. I believe problem lays somewhere in Default Value or pasing null. Can someone shed light on this problem. I need to be able to run this search for any dropdown list selected.
here is my G Wells sproc with coalesce:
ALTER proc sp_gwells
@DCSTANDALONE varchar(8000) = null,
@STAGE varchar(8000) = null
as
begin
select SERVER_NAME,[Team Member],DC/STANDALONE],SRM,STAGE,DECOMMSTATUS
from DecommMaster
where [DC/STANDALONE] = coalesce(@DCSTANDALONE,[DC/STANDALONE])
and STAGE = coalesce(@STAGE,STAGE)
end
*******************************************ASPX below*************
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="SearchC.aspx.cs" Inherits="DeleteConfirm" Title="Untitled Page" %>
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource3.Select(DataSourceSelectArguments.Empty);
GridView1.AllowPaging = false;
GridView1.DataBind();
int rowcount = GridView1.Rows.Count;
GridView1.AllowPaging = true;
lblRowCount1.Text = rowcount.ToString() + " Rows Found!";
}
<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">
<asp:label id="Label1" runat="server" text="DCO/NON-DCO:" width="119px"> | <asp:dropdownlist id="DropDownList1" runat="server" datasourceid="SqlDataSource1"
="" datatextfield="column1" datavaluefield="column1" appenddatabounditems="true">
<asp:listitem text="Select" value="">
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:DECOM_DataConnectionString1 %>"
="" selectcommand="SELECT DISTINCT [DC/STANDALONE] AS column1 FROM [DecommMaster]">
| <asp:label id="Label2" runat="server" text="STAGE:"> | <asp:dropdownlist id="DropDownList2" runat="server" datasourceid="SqlDataSource2"
="" datatextfield="STAGE" datavaluefield="STAGE" appenddatabounditems="true">
<asp:listitem text="Select" value="">
<asp:sqldatasource id="SqlDataSource2" runat="server" connectionstring="<%$ ConnectionStrings:DECOM_DataConnectionString1 %>"
="" selectcommand="SELECT DISTINCT [STAGE] FROM [DecommMaster]">
| | | <asp:button id="Button1" runat="server" onclick="Button1_Click" text="Search"> | |
<asp:label id="lblRowCount1" runat="server" width="129px">
<asp:button id="Button2" runat="server" onclick="Button2_Click" text="Export To Excel">
<asp:gridview id="GridView1" runat="server" cellpadding="3" datasourceid="SqlDataSource3"
="" forecolor="#333333" gridlines="None" allowpaging="True">
<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<editrowstyle backcolor="#999999">
<selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White" forecolor="#284775">
<asp:sqldatasource id="SqlDataSource3" runat="server" connectionstring="<%$ ConnectionStrings:DECOM_DataConnectionString1 %>"
="" selectcommand="sp_gwells" selectcommandtype="StoredProcedure">
<selectparameters>
<asp:controlparameter controlid="DropDownList1" name="DCSTANDALONE" propertyname="SelectedValue"
="" type="String" defaultvalue="">
<asp:controlparameter controlid="DropDownList2" name="STAGE" propertyname="SelectedValue"
="" type="String" defaultvalue="">
|
|
|
|
|
Hi
I have written javascript for adding two nos.
But it not added but concate two nos.
var Store='';
function myfun(id,value)
{
var Tchk;
var str=value;
Tchk=document.getElementById(id).checked
if(Tchk==true)
{
Rate= str + Store;
}
Store=Rate
}
I have str and stor2 value but not adding two values but concate.
str=123
store=456
Give result like Rate=123456
what i do?
Thanks
monika
|
|
|
|
|
If you write out the words, it's much easier to understand your question. It was not until I had read the entire post that I understood that by "nos" you actually meant "numbers".
If you add two strings, they are concatenated. If you want to add numbers, you have to add numbers instead of adding strings. Use the intParse function to parse the strings into numbers.
---
b { font-weight: normal; }
|
|
|
|
|
use parseInt(str) + parseInt(Store);
|
|
|
|
|
Hi,
I know I am not the only one struggling with the following, but so far
I have not seen a solution.
Problem:
I have an asp.net 2.0 web page with a gridview which is bound to an
accessdatasource. In my code-behind I want to be able to set the
selectcommand of the datasource to a specific SQL string based on a
user's input to retrieve only certain records.
This works fine when I hit the search button. BUT, as soon as I start
paging or sorting (gridview's default), the accessdatasource seems to
revert back to the initial select command "SELECT * FROM tblProduct"
and all records are shown again.
I know that I could maintain state for the selectcommand using session
variables, but I would like to see a cleaner solution.
My code in aspx:
<asp:accessdatasource id="AccessDataSource1"
datafile="~/App_Data/product.mdb" selectcommand="SELECT * FROM
tblProduct" runat="server" datasourcemode="DataSet">
My code in code-behind:
AccessDataSource1.SelectCommand = "SELECT * FROM tblProduct WHERE
[brand]='" & txtBrandCustom.Text & "'"
Hopefully, anyone out there will have a solution for me!
Regards,
Mark
|
|
|
|
|
hi,
i have used asp+c# n am unable to access the data through wizard..
It is very much possible in c#..
could u plzz help me to solv the problemm..
i just need the instructions
Sincerly,
Shriya
|
|
|
|
|
|
Dear all
I am able to open a window using buttin click and few lines of java script code. But I am unable to pass the values of this second or child window browser to the first browser or the parent browser. Can any one of u advice me or give me little much of code to achieve this task.
U can mail me to : aleem076@gmail.com
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Stop spamming the forum.
You have asked this question several times before, and got several replies to them. Why not follow up on the replies that you got? If you just ignore the people who try to help you, who do you think would want to help you in the future?
As I already explained before, replies goes in the forum, not in your mailbox.
---
b { font-weight: normal; }
|
|
|
|
|
Ok. I am sorry. But they dont wotk in perfect way. And instead of waiting for the same thing I went with another thing. Thats what happened. Please help me int this matter. I would be thank ful.
And remember I want to access not only the html controls, mainly I want to access server side controls from the child Window. So I need to write server side scritping. Please help me in this regard. I would be thank full to them and the forum too.
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
aleem076 wrote: Ok. I am sorry. But they dont wotk in perfect way. And instead of waiting for the same thing I went with another thing.
And that other thing is to start three new threads still about the same thing within an hour?
aleem076 wrote: And remember I want to access not only the html controls, mainly I want to access server side controls from the child Window.
That is not even possible.
---
b { font-weight: normal; }
|
|
|
|
|
Dear all
I am able to open a window using buttin click and few lines of java script code. But I am unable to pass the values of this second or child window browser to the first browser or the parent browser. Can any one of u advice me or give me little much of code to achieve this task.
U can mail me to : aleem076 know how to do it.
-- modified at 5:07 Saturday 2nd December, 2006
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi,
i have a problem ,i have a data grid and in this datagrid footer i add the WebUsercontrol this control can contain one textbox and one imgaebutton ,the textbox value is coming from javascritp Window.opener method.now tell me how can i read the value from this webusercontrol .tell me the way or send me some codesnippet that is helpfull form me.
best regards
|
|
|
|
|
Hey guys
I am opening a web form (form2) and when a button is clicked in form1. Both are in two sepatrate browsers. Now I would like have communication from form2 to form1. Means from child borwser to parent browser. And I want to acces the parent forms controls and update them from the child form.
Could any one help me please. I would be thankful to them.
Aleem
VB.Net,ASP.Net, VB, ASP, Database
|
|
|
|
|
Can any one help me out to read the emails from PST file of Outlook into asp.net and i have to fetch all the from address in the PST File. Please Help.
Thanks in Advance,
Regards,
Prya
|
|
|
|
|
|
Hello,
I have used the datalist in Usercontrol which is loaded dynamically in placeholder in aspx page.
There is another usercontrol having dropdownlist on the same aspx page. When call this page for the first time. It works fine. But if I change item in dropdownlist, the post back is done and The datalist's OnItemCreated event is fired directly before calling any other events as in asp.net page life cyle.
So it's creating problem since it uses the dataset which is set to reference in page load of usercontrol where datalist is placed.
I need help since I am at the door of project delivary.
Thanks
Sachin A. Pawar
|
|
|
|
|
in my code user have to fill few forms. i want to show a progress bar (on users main page)indicateing how many (in percent) forms has been filled.
Neha Mishra
|
|
|
|
|
Easiest way is to have a div element on the page somewhere, color it in and set it's width. Keep increasing it's width as the user moves through the form. So if the user is 40% way through the forms set the width to 40pixels, when they're finished set to 100 pixels and so on.
|
|
|
|
|
Hi
I have runtime checkbox in datagrid.When i click on checkbox,how to get coresponding value of checked checkbox?
I write a javascript function on checkbox.
Thanks
monika
|
|
|
|
|
|
i have a javascript menu, when the menu items listed it shows below the dropdown box in the aspx page.
how can i show the menu list over the dropdown control.
thank you
|
|
|
|
|
Can someone please explain to me how does asp.net controls render Html. I'm actually a little confused about the meaning of rendering in this context because when I first drag a control to asp.net designer, it actually generate html...is that what rendering of html is. Please explain I'm just starting out with it. Thank You
TINA
|
|
|
|
|
Tina P wrote: when I first drag a control to asp.net designer, it actually generate html
Not really. It generates markup code, but that is not the final html code.
Tina P wrote: Can someone please explain to me how does asp.net controls render Html.
When the page is created, everything in the markup code is created as objects.
For example, this part of the markup:
<div><asp:Label id="myLabel" runat="server"></div>
will be created as these three objects:
LiteralControl("<div>")
Label id="myLabel"
LiteralControl("</div>")
As you see, everything that is not server controls are treated as literal text.
The last part of creating the page is the rendering, where the objects in the page will each create a bit of the html code. Let's say that you have set the Text property of the label to "Hello world.". Then the three objects will create these three strings:
"<div>"
"<span id="myLabel">Hello world.</span>"
"</div>"
Those strings will be written to the response stream among with the strings from all the other objects in the page to form the complete html document.
---
b { font-weight: normal; }
|
|
|
|