praveenanand wrote:
if we are trying to add the several columns in select statement without using Aggregate functions and only one condition in group by.
You can't. Each column not specified in the GROUP BY clause must be part of an aggregate on the SELECT. If you think about what it is doing you will see why.
Upcoming FREE developer events: * Developer Day Scotland My website | blog
hi thanks for u reply.. can u help me in writing the query for that requirement.If u have any thing about the dynamic sql and like generic procedures ..please help me by giving some sample query.
Hope the article by rudy.net here[^] in CP will help you.
Regards, Satips.:rose: Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Walk beside me, and just be my friend. - Albert Camus
hi, you can use Excel API for that purpose. Just include Microsoft Excel component in your project's reference and you will be able to use Application.Excel component.
Manoj Never Gives up
I've forgotten to remind you that ddl is the DropDownList's id in the GridView.:-O
:^):^):^):^):^):^):^):^):^):^):^):^) :^):rose::rose::rose::rose::rose:▒▒〓▒〓▒▒ :^):rose::^):^):^):^)▒〓〓〓〓〓▒ :^):rose::^):^):^):^)▒▒〓▒〓▒▒ :^):rose::^):^):^):^)▒〓〓〓〓〓▒ :^):rose::rose::rose::rose::rose:▒▒〓▒〓▒▒ :^):^):^):^):^):^):^):^):^):^):^):^)
in first step you must create your report by WebSite >> Add New Item and select CrystalReport Object then Set Name Of Your report and press add. then create your report. if you passed this step in the second step must be load it by your codes. html codes:
c# codes: public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportDocument rptFile = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptFile.Load(Server.MapPath("YourReportFile.rpt")); DataTable dt = new DataTable(); // this DataTable is Source Of your report that made by sqlquery or any data in table syntax rptFile.SetDataSource(dt); CrystalReportViewer1.ReportSource = rptFile; CrystalReportViewer1.DataBind(); } } We Can Do Anything, If We Want It
ca8msm wrote:
Don't do it.
We need a smiley for that! Seriously though - COMPLETELY AGREE!
"Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
First I must ask do you really want to Post your page to a different page. There are good reason to do this, but in most cases it probably makes more sense to just have the button postback to your code behind for the page you are on. If you do have a good reason to post to a different page, all you have to do is set the postbackurl on the control that you are using. In the page load of the other page you can check for PreviousPage. If that is not Null (Nothing in VB) then you have postbackurl from one page to a different page. Hope that helps. Ben
try this http://www.peachpit.com/content/images/0321146425/companionsite/asp.ch4.pdf[^] search here as Response.Form
Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com
HEre's an idea, why not see if shift has been preesed, that way if it hasn't and the input is Caps then they would have caps lock on (most likely). Things to consider: > If Caps lock is on then pressing shift would make a lower case letter (so check it is pressed no matter what the input is) > If the user pastes something then it might be in caps but cs lock might not be on. In this case make sure to only validate when keys are pressed.
Brad Australian - Christian Graus on "Best books for VBscript" A big thick one, so you can whack yourself on the head with it.
wrote:
i already binded the data at the required places
And where is that? It sounds like the problem is that you are binding the 3rd ddl and wiping out the existing items and selections.
only two letters away from being an asset
