Passing parameter to SQL Report

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Asp
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Regarding ASp.Net2.0 Login Control. Hello I am using ASP.Net2.0 login control in my web-site. For this i had handled Login1_Authenticate event. As i m entering wrong password Error-message promt me correctly, But as i entered spaces then Correct password,it accepts the password & redirect to the specified page,which is not correct,so plz reply me whether it is triming the spaces or what???? Thanks. Tag: Passing parameter to SQL Report Tag: 522223
  - 2
    - Small window popup I'd like a little window to pop up when a user clicks the hyperlink text "Grade Key": Grade Key Score Range A+ 95% - 100% A 90% - 94% A- 85% - 89% B+ 80% - 84% B 75% - 79% B- 70% - 74% C+ 65% - 69% C 60% - 64% (it's a small table). In ASP 3.5, how can I specify that the window is small, has no browser menus etc? Tag: Passing parameter to SQL Report Tag: 522219
  - 3
    - Nested GridViews In UserControls. Hi all, I have two user controls that contain there respective own gridview and objectdatasource. Now when i add both controls to a page, i want gridview A's selected value to be a parameter for gridview B's select method. This is where my problem lies....because both gridview's are contained in there respective user controls, when i make a selection in gridview A, the objectdatasource of gridview B doesn't seem to pick up that event/value being passed from gridview A. Anyone shead some light on this? Cheers... Tag: Passing parameter to SQL Report Tag: 522218
  - 4
    - DNN + GridView I have tried DotNetNuke forms but no one is responding to my question so I am trying this news group maybe someone here has worked with DotNetNuke. I am using DNN 4.8.4 I've created a module and this module has a GridView with Autoformat, but the problem is when I click to see another page in the GridView I loose all of mine CSS formatting and default DNN formattring takes over. Does anyone knows what could be causing this or how I can fix this? Thank You Peter Tag: Passing parameter to SQL Report Tag: 522206
  - 5
    - ASP.NET 1.1 and Web Parts... Has anyone tried to create something similar to Web Parts or draggable layers for VS.2003 / ASP.NET 1.1? ...preferably free. TIA. :) Tag: Passing parameter to SQL Report Tag: 522196
  - 6
    - Understanding Web Services I'm looking into implementing Web services to provide product activation codes to resellers. This seems to be going fine. One large reseller tells me they support CGI for this purpose, as thought it's the same as Web services. Clearly, CGI is not the same as a Web service, but reading about it, it seems similar in that it somehow calls code running on my server. Can anyone clarify for me the primary differences between CGI and Web services? Specifically, can a CGI interface be implemented using ASP.NET, or could a Web service be made to work by code that calls CGI? Thanks! Jonathan Tag: Passing parameter to SQL Report Tag: 522195
  - 7
    - MessageBox.ShowDialog () - As Windows Form Hello everyone! How can I implement a control type MessageBox.ShowDialog () (As Windows Form) with ajax? Best regards, Gustavo Arriola Tag: Passing parameter to SQL Report Tag: 522190
  - 8
    - Web Service Authentication Hi guys, I'm writing a web service and I don't know how I can secure it by forcing our clients to use a username/password. I've used SalesForce a lot and they ask for a username/password once and any subsequent calls you don't need to authenticate anymore. How can this be done in asp.net (C#)? Ex.I make a call result = Object.Connect (username, password) all my other calls I would send result in the method??? Thank you M. Tag: Passing parameter to SQL Report Tag: 522189
  - 9
    - Export to Excel Hi I am trying to export a GridView to Excel. It exports the data but transforms it in the process. for instance, this RBHK-17+RCHJ-24A2 becomes RBHK-17=E4=90=A124A2 so basically anywhere i have a '+' sign the rest of the data chnages to special characters ...like FC/MC62D=E3=85=9D=E7=98=8F=EE=93=97 i have tried setting various Response.Charset and encoding but to no avail... Please help! TIA Tag: Passing parameter to SQL Report Tag: 522184
  - 10
    - Generating Letters Hi, I am looking for tutorials related to generating letters. If possible I would like these letters to be generated in Microsoft Word format, as that way they can be directly imported into my companies records management system. I have looked at various methods, Crystal Reports seems a little over kill for what I need, as I am only importing very basic data to the letter (name, address, title date ect), I had a breif look at word interop, and that worked well, but I read somewhere that it shouldnt be used with asp.net - why is this? So I am just wondering if anyone knows of any good tutorials to help me generate letters. Ideally, I would like to run it via a webservice, so that it can be consumed in more than one application, simply passing a ClientID of the recipient is all I envisage to call the service. Any suggestions of tutorials / further reading would be great. Kind Regards Tag: Passing parameter to SQL Report Tag: 522180
  - 11
    - Cookies will not expire (noob question) This seems like an easy one, but i'm stuck on getting rid of a cookie and cannot seem to make it happen. I'm creating a cookie like so: private void createCookie() { HttpCookie cookie = Request.Cookies["myCookie"]; if (cookie == null) { cookie = new HttpCookie("myCookie"); } cookie["Name"] = "myName"; cookie["PW"] = "myPw"; cookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookie); lbl_welcome.Text = "<b>Cookie Created.</b>"; lbl_welcome.Text = "Logged in As: " + cookie["Name"] + " Pw: " + cookie["PW"]; } Then upon clicking a button i'm trying to get rid of the cookie (but it does not go away): private void doLogout() { HttpCookie cookie = Request.Cookies["myCookie"]; if (cookie != null) { cookie.Expires = DateTime.Now.AddMinutes(-1); } } What am i missing here, seems fairly simple? Thanks for any help! Tag: Passing parameter to SQL Report Tag: 522179
  - 12
    - Import Namespace using conditional compilation symbols Anyway to do the following in aspx HTML? Currently in my codebehind: #if SOMECONDITION using MYBL=MyNamespace.Biz #else using MYBL=MyNamespace.WebServiceBiz #endif Right now in the aspx I have <%@ Import Namespace="MYBL=MyNamespace.Biz" %> How can I conditionaly set the other alias in the HTML side? Thanks, Suresh. Tag: Passing parameter to SQL Report Tag: 522178
  - 13
    - ed-hardy ca t -shirt cheap sell polo t-shirt www.yahoo808.cn YAHOO808 Export Trade Co., Ltd., located in PUTIAN City, is a leading import and export company. We have a professional manufacturer, designer and exporter of shoes jeans clothing handbags, wallets and so on . Based on quality and fashion, we have established a strict quality control system and manufac-ture products according to the latest fashion trends. We export our products to customers all over the world, We enjoy a good reputation among our customers Tag: Passing parameter to SQL Report Tag: 522176
  - 14
    - Using an ActiveX in a Web service Hi there, I need to use an ActiveX inside a Web service. My problem is that I need an handle on this Com component, so I add a reference to my .Net project, and I create an instance of class of this Com exe. But I then realize that each time I call for a method of my web service, I create a new Com exe process, which is not what I want. Any idea to avoid this pitfall ? Philippe Tag: Passing parameter to SQL Report Tag: 522171
  - 15
    - RangeValidator validate failed when input with currency symbol Hi, I have a composited control with a Textbox and a Rangevalidator. If I am not mistaken, Rangevalidator should take currency ($) symbol, but I got the validation error when user enter -$100 in the text box. It will succeed if -100. So I tried add a property called "MoneyValue", return a Decimal only value and use [ValidationPropertyAttribute("MoneyValue")], hopping RangeValidator validate "MoneyValue" instead of Textbox, not working. What did I miss? Help, Please. -- HipHopper Tag: Passing parameter to SQL Report Tag: 522168
  - 16
    - Missing Web log Entry's for file downloads Hi, I have been using the code (some of it has been removed for simplicity) below to allow authenticated (using ASP.NET membership database) users to get a file from their archive area. It seems to work fine, however I noticed that no web log entry is added when a successful download occurs (normally a 200 HTTP status code, however, if there is an authorization failure, it gets logged). I have a logging routine that logs a successful download to a database, but the W3SVC IIS log has nothing. The code below is contained in an .ashx file. One other thing to note, I have added MADAM to the web application, to allow for basic authentication (they might use WGET to download archives, instead of the web forms). Thanks. Public Class GetArchive : Implements IHttpHandler Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest Dim strFileName As String = String.Empty Dim blnTransmittingFile As Boolean = False Try context.Response.Buffer = True If context.User.Identity.IsAuthenticated = True Then strFileName = context.Request.QueryString("file") If String.IsNullOrEmpty(strFileName) = False Then strFileName = System.IO.Path.GetFileName(strFileName) context.Response.Clear() Dim objFileInfo As New System.IO.FileInfo(strFileName) Dim intFileSize As Long = 0 If objFileInfo IsNot Nothing Then intFileSize = objFileInfo.Length End If context.Response.StatusCode = 200 context.Response.ContentType = "application/zip" context.Response.AddHeader("Content-Disposition", "attachment; filename=" + strFileName) context.Response.AddHeader("Content-Length", intFileSize.ToString()) If context.Request.HttpMethod <> "HEAD" Then Dim dtStart As DateTime = Now() Dim dtFinish As DateTime Dim tsTimeTaken As TimeSpan context.Response.SuppressContent = False context.Response.Buffer = False context.Response.BufferOutput = False blnTransmittingFile = True context.Response.TransmitFile(strFileName, 0, -1) context.Response.Flush() context.Response.Close() dtFinish = Now() tsTimeTaken = dtFinish - dtStart EventLogger.LogDownloadEvent(strFileName, strUserName, tsTimeTaken.TotalSeconds) End If Else context.Response.Clear() context.Response.ContentType = "text/plain" context.Response.StatusCode = 404 context.Response.Write("File Not Found") End If End If Catch ex As Exception If blnTransmittingFile = False Then context.Response.Clear() context.Response.ClearContent() context.Response.ClearHeaders() context.Response.ContentType = "text/plain" End If context.Response.StatusCode = 403 context.Response.Write("Request failed [" + ex.ToString() + "]") EventLogger.LogDownloadEvent("Failed", ex.ToString()) End Try End Sub Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable Get Return False End Get End Property End Class Tag: Passing parameter to SQL Report Tag: 522167
  - 17
    - File IO question with a web application Hi I have a web application that uploads files to the server which is working. A minor issue is that if the file already exists I get the error file.doc already exists. Just wondering if there is a way to have it automatically replace the file and not produce the error? thanks. -- Paul G Software engineer. Tag: Passing parameter to SQL Report Tag: 522162
  - 18
    - Upload a file to a different site Hi all I have 2 Web sites (Applications). For the purposes of this question let's say they are to be on 2 different boxes in 2 completely different domains. My users are going to be moving around from page to page in Site1 and then they are going to need to upload a file. This file upload should be to Site2. I would prefer a solution in which... ... the user clicks a link/button labelled upload ... a panel opens up (embedded on the first page) ... the panel is in reality a frame pointing at a page on the second site ... this new page offers the upload control. ... the frame/panel shuts down after upload is complete. I am open to launching a new page/tab instead if needs be. There are 3 requirements 1.> The users should not have to navigate back to the first site after the upload. - The 2nd site should ideally vanish. Perhaps we can get them to close a tab or a Div. Not sure really 2.> The upload should only take up bandwidth between Site2 and the browser. - One previous solution *seemed to be* to access the webservice of Site2 from the server side of site1 which of course meant that Site1 was also taking a hit on bandwidth. 3.> When the user initially clicks the link to open the upload panel, the web page must Site1's serverside (I guess some sort of Ajax) in order to trip it into creating a token which must be used as a part of the URL to site2. I am not sure however, how to achieve this. Does it even make any sense? I'm kinda stuck of where to start here. Any help greatly appreciated. -- Ror Tag: Passing parameter to SQL Report Tag: 522160
  - 19
    - Question about loading usercontrols (I've been away from web app programming for a while. Most of my experience has been in 1.1. Now I'm using vb/Dot Net 2.0) Please explain a couple of things. First, I have a simple-minded usercontrol defined. No real code so far. Just a bunch of text boxes on a panel. I want to dynamically load one or more instances of the usercontrol onto the screen. Why is it that the command 'Me.Form.Controls.Add' will work with stock controls (like a textbox) but apparently not with usercontrols? (After a little bit of trial and error I found I could create usercontrols with the 'LoadControl' command. I think this is the first time I've heard of 'LoadControl'.) 2nd, in a basic web page, a control can be dynamically added with a call to the default 'form1.controls.add'. My current test page has a master page and I've found that 'form1' is not available. However 'Me.Form.Controls.Add()' seems to work the same. Are there any 'gotchas' here that I should be aware of? Tag: Passing parameter to SQL Report Tag: 522158
  - 20
    - restaurant table booking system asp.net Hi guys, i just thought id throw this one out here but i was wondering if anyone knows of where i would find an open source booking system project for asp.net ?? ive been asked by a client to develop one but heir budget is small so unless i can find one that can be tailored relatively cheaply il buy something off the shelf. if anyone knows of any good off the shelf packages for this functionality then please let me know also ?? the ideal system would be an asp.net one that i could tailor. any help on this appreciated thanks CG Tag: Passing parameter to SQL Report Tag: 522156
  - 21
    - Multiple ValidationGroups with Buttons and Validation Controls I have a page with a group of fields that need validated when any of several Buttons is clicked. There are also several specific fields that get validated for each Button along with these. Is there any way to do this, such as assigning multiple values to the ValidationGroup property? Thanks. Tag: Passing parameter to SQL Report Tag: 522153
  - 22
    - database / document search control Hi I'm lookin for a bit of advice regarding search controls. We currently have a number of tables in an SQL server database which our app can search. The code uses LIKE querying. We'd like to update that to a faster, more robust system of searching (perhaps using full test indexing). But we'd also like to add the ability to search documents stored on our shared drive at the same time. The obvious solution is to update our current search routines to search the sql full text index, and then add in code to query either Search Server or the Indexing Service. However, that's a lot of coding and testing time. Is there an asp.net search component that will give us this search functionality to query both the database and the indexing service? Or are we on the right track rolling our own? Thanks Dan Tag: Passing parameter to SQL Report Tag: 522150
  - 23
    - Parsing content from textboxes efficiently Hi there I=92m trying to come up with a smart way of parsing content from textboxes in C#. I have about 7-10 boxes with different content; dates, times, numbers and text that has to be parsed and inserted into my database. Of course the obvious solution is to make a lot of if=92s and parse each box one at the time with the properties I know and catch all exceptions on the way, if any, but does anyone has an idea of a smarter way of doing this? Thought about making a list of the boxes with content, so I don=92t have to waste time parsing the empty ones and catching exceptions. An example of how I'm parsing a Textbox containing a date: if (BeginTime.Text !=3D "__:__:__") { ad.DateTimeBegin =3D DateTime.ParseExact(BeginDate.Text, =20 CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern, null); } Regards Lasse Tag: Passing parameter to SQL Report Tag: 522147
  - 24
    - DataRow EndEdit and AcceptChanges I found this in MSDN: "The BeginEdit method is called implicitly when the user changes the value of a data-bound control; the EndEdit method is called implicitly when you invoke the AcceptChanges method for the DataTable object." But what about the other way around? If I call EndEdit is AcceptChanges invoked? Since trying some test code, it seems to be that way. I am still trying to understand what the connection is between RowState, BeginEdit and EndEdit, and DataRowVersion. Does calling EndEdit have influence on RowState, directly or indirectly? Tag: Passing parameter to SQL Report Tag: 522144
  - 25
    - Binding two dimensional arraylist to GridView? Hi, I have a two dimensional arraylist below, which I am trying to bind to a gridview. However, when I try and do this the gridview is being populated with what looks like property values i.e. Count, IsReadOnly etc. Any ideas how I can get it to bind to the gridview showing the correct values? Code below. private ArrayList ProcessEnumType(Type t) { ArrayList arrList = new ArrayList(); ArrayList arrString = new ArrayList(); ArrayList arrValue = new ArrayList(); foreach (var enumVal in Enum.GetValues(t)) { var name = Enum.Parse(t, enumVal.ToString()); arrValue.Add((int)name); arrString.Add(enumVal.ToString()); } arrList.Add(arrValue); arrList.Add(arrString); return arrList; } Appreciate the help. Tag: Passing parameter to SQL Report Tag: 522143
- Next
  - 1
    - Application_Start event not fires Hi All, I am working on an application which was upgraded from framework 2.0 to framework 3.5 using VS 2008. I have defined some application level objects in Global.asax.vb file in Application_Start section. Some times the Application_Start event does not fire and I got null application objects. This is very strange behavior as it was started few days ago otherwise every thing was running fine. I observed this behavior on my XP machine when I run the site directly from browser without using Visual Studio and even on production server which is running Windows Server 2003. It is very annoying issue; can anyone please help me out about figuring out this problem? Thanks a lot. Asif Tag: Passing parameter to SQL Report Tag: 522133
  - 2
    - How to catch exceptions? Actually, I'm interested in learning where the different types of exceptions are documented for a specific type of class, let us say for instance classes in the System.Net.Mail Namespace. Shouldn't the types be documented on the same page as the class, its members and properties? Tag: Passing parameter to SQL Report Tag: 522131
  - 3
    - To create an Excel Sheet using ASP.NET 2.0 with C# I could create MS Excel sheet using ASP.NET 2.0 with C# but it is not being created in some systems, following error occurs when the program compiles : Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. â?¢ To make more memory available, close workbooks or programs you no longer need. â?¢ To free disk space, delete files you no longer need from the disk you are saving to. Line of error it shows is at: workbook = workbooks.Add(Type.Missing); OS I tried : Windows 2003 Server,Windows XP (Service Pack 2) COM I added : MS-Excel 5.0, MS-Excel 10.0 dcomcnfg Setting : MS-Excel->Properties->Security->Customize->Edit->Add-> ASPNET->Put tick mark on Local Launch and Local Activation Tag: Passing parameter to SQL Report Tag: 522130
  - 4
    - can't catch DBConcurrencyException when using TableAdapter I have a TableDapter built from an Oracle Table. When i test for Concurrency by opening 2 sessions and edit the 2 at once the intial record record i update shows up and not the last one until i refresh too see the new record. But when i try doing this below to catch an excpetion no luck protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e) { //It keeps returning -1 Response.Write(e.AffectedRows.ToString()); if (e.Exception != null && e.Exception.InnerException != null) { if (e.Exception.InnerException is DBConcurrencyException) { Label1.Visible = true; e.ExceptionHandled = true; } } } What i understood is that AffectedRows need to return 0 for this to work but mine keeps returning -1. Any help Tag: Passing parameter to SQL Report Tag: 522129
  - 5
    - Displaying HTML inside a GridView Column - PLEASE HELP This is probably my second time using a GridView control and I cannot not figure out how to display HTML inside a datacolumn. Can somehow help me? I would be very surprised if it cannot be done. I want to display an image with a link to it in a data column For example: <a href='http://www.google.com'><img src='http://..../icon.jpg' alt='Google Icon' /></a> Thanks! Tag: Passing parameter to SQL Report Tag: 522116
  - 6
    - Relative URLs I need some help (and my apologies if this is not the right group) understanding how to properly form Relative URL's. I'm developing a site (Web Site, not a Web Application if that makes a difference) in VS 2005. The application is called OBS, and it's located C:\Inetpub\wwwroot\OBS. In IIS, it shows a Virtual Directory at that location, running an application "OBS", and with a Starting point "<Default Web Site>\OBS". When I specify relative URLs in links and Response.Redirect calls, I've been specifying it as "~/PageName.aspx", or whatever. Most of the time that works, but sometimes I will get a 404 Resource not found error saying that it could not locate the resource "/OBS/~/ PageName.aspx" I was under the impression that the "~" stood for the root, i.e., OBS. So why is it constructing the resource name that way? Also, I thought that "/PageName.aspx" should be equivalent to "~/ PageName.aspx", but it clearly is not, since that fails almost all the time. In one case (which seems to have stopped working that way now, for some unknown reason), the Redirect worked correctly when it was run from the Default page, but when it was run from a different page (still at the top level), it failed in the above manner. I seem to be able to get it work if I put the link in as "PageName.aspx", but I know that will break if I end up moving pages around to different directories, so I want to avoid that . Can anyone tell me anything that will shed some light on my obvious confusion? Thanks in advance for any help. Tag: Passing parameter to SQL Report Tag: 522114
  - 7
    - not loggin in behind iframes... i know that asp.net cannot work with frames... that it recognizes the frame as a single window... so far... no problem.. i redesigned a site, giving it a frame with ads all around, and an iframe in the middle with the login pages... but now, when i click to login, the page flashes, but there is no login... it keeps just like that... have anyone ever seen this??? tks, christiano. Tag: Passing parameter to SQL Report Tag: 522112
  - 8
    - Redundant Items in DD When binding a control to a datasource (SQL) using the configure data source or editing the SQL Query both VS2005 and 2008 have always shown duplicate (double) values in the controls list on all of my machines. It has now started showing three or four copies of each control in the dd, and sometimes does this in dd's within my application, even when I am returning unique values. The data source is brining back single items, but the dd duplicates them. This happens with all combinations of fixed and appended values. Does everyone always see double values, and if so why? Any clues to what may be causing this? There is no code to send. I just create a read-only SQL data source for a single field list-of-values table and attach it as the data source of the dd. Every time I postback an additional set of all values shows up. Any clues? Tag: Passing parameter to SQL Report Tag: 522104
  - 9
    - setting an html control to visable="true/false" there are times i want to turn a specific row in an html table off or hide it. I can set a <tr> control with an id and a runat="server", but how do i find it, then set it to Visable="False"? A panel will cause problems for the designer. is there another way? -- Share The Knowledge. I need all the help I can get and so do you! Tag: Passing parameter to SQL Report Tag: 522103
  - 10
    - What characters am I allowed to use when submitting fields? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C8ECDF.D9D2EB80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When signing in using the following generated password: +$cSB;!"q<y^I recieve the following error:A potentially dangerous = Request.Form value was detected from the client = (ctl00$cphContent$txtPassword=3D"+$cSB;!"q<y^").System.Web.HttpRequestVal= idationException What characters am I allowed to include in a value that will be = generated and submitted in a TextBox? When I generate something simple = (such as "testing" or "abc123") it gets submitted with no problem at = all, so I need to know what characters will cause this problem so that I = can modify my function for generating the String. Can anyone help me? = Thanks. ------=_NextPart_000_0006_01C8ECDF.D9D2EB80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>When signing in using the following generated = password:</DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D4><PRE = wrap=3D"">+$cSB;!"q<y^</PRE><PRE wrap=3D""><FONT face=3D"Times New = Roman" size=3D3>I recieve the following error:</FONT></PRE><PRE = wrap=3D""><FONT face=3D"Times New Roman" size=3D3><EM>A potentially = dangerous Request.Form value was detected from the client = (ctl00$cphContent$txtPassword=3D"+$cSB;!"q<y^").</EM></FONT></PRE></FO= NT></DIV> <DIV><FONT face=3DArial=20 size=3D2>System.Web.HttpRequestValidationException</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>What characters am I allowed to include = in a value=20 that will be generated and submitted in a TextBox? When I generate = something=20 simple (such as "testing" or "abc123") it gets submitted with no problem = at all,=20 so I need to know what characters will cause this problem so that I can = modify=20 my function for generating the String. Can anyone help me?=20 Thanks.</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C8ECDF.D9D2EB80-- Tag: Passing parameter to SQL Report Tag: 522100
  - 11
    - Ajax, changing text in a button, and button click problem Hi all, I'm using AJAX.NET and I've coded a page that changes the text of a button when a checkbox is clicked. The text changes from "Save" to "Keep Processing". The text change seems to work. However, when I then go to click on the button, I click once, and nothing happens. I click again, and get an error: "System.Web.HttpException: The state information is invalid for this page and might be corrupted. ---> System.Web.UI.ViewStateException: Invalid viewstate." A couple things that may be the problem: 1. I am using a content page which has a master page. 2. My checkbox and my button are inside an asp:multiview object. I'm attaching my code for your review. Relevant page code: <asp:MultiView ID="Views" runat="server" ActiveViewIndex="0"> <asp:View ID="Step1" runat="server"> <asp:CheckBox ID="chCheck1" runat="server" Text="Automatically Allocate Payment" AutoPostBack="true" Checked="true" /> <asp:updatepanel id="upSaveOrContinue" runat="server"> <triggers> <asp:asyncpostbacktrigger controlid="chCheck1" /> </triggers> <contenttemplate> <asp:Button ID="bnNext" runat="server" Text="Post Payment" /> </contenttemplate> </asp:updatepanel> </asp:View> </asp:MultiView> And the relevant cs code: void ckCheck1_CheckedChanged(object sender, EventArgs e) { if (ckAutoAllocate.Checked == true) bnNext.Text = "Post Payment"; else bnNext.Text = "Set Allocation"; } Tag: Passing parameter to SQL Report Tag: 522097
  - 12
    - GridView PageIndexChanged I want to call a JavaScript on PageIndexChanged event, how do I do that? Thank You Peter Tag: Passing parameter to SQL Report Tag: 522096
  - 13
    - Can't view designer VS2008, ASP.NET 3.5 web application. I create a basic web app and don't even make any changes, when I click the [Design] tab at the bottom of WebForm1.aspx markup the IDE hangs. Does anyone know what this could be? Thanks Pete Tag: Passing parameter to SQL Report Tag: 522092
  - 14
    - View asp.net site on a computer ? I have a roadrunner personal page internet site. I just found out it does not support ASP.NET. I've developed an asp.net site that I would like to show someone. I can't image this is possible but I have to ask to be sure. Is there any way I can send him something (maybe on a cd) that he can view on his XP computer. He does not have VSxxxx I'm sure. Who is a good isp that supports asp.net? Does ms publish list? thanks Tag: Passing parameter to SQL Report Tag: 522090
  - 15
    - changing asp:button text on rollover using ASP.NET/VB.NET 2.0 I can change the text color of an ASP Button object on mouse rollover/rollout by doing this (in page_load) btnMyButton.Attributes.Add("onmouseover", "this.style.color='Yellow'") btnMyButton.Attributes.Add("onmouseout", "this.style.color='White'") But how can I change the text on rollover? I don't understand the javascript DOM enough to know what to do. I did try: btnMyButton.Attributes.Add("onmouseover", "this.text='My New Text'") And Tried btnMyButton.Attributes.Add("onmouseover", "this.style.text='My New Text'") Of course, none of these do anything. TIA, Jim Tag: Passing parameter to SQL Report Tag: 522085
  - 16
    - can not add the SqlDataAdapter to the toolbox ??? Hi, In a webproject, I right-click in the toolbox and select 'Choose Items...' I select the SqlDataAdapter control in the listbox, then OK but the control is not added to the toolbox ??? it works with a WinForm application though. is this a normal behavior in VS.NET 2008 'cause this used to work in 2005 So, how can i add it ? thank you Chris Tag: Passing parameter to SQL Report Tag: 522080
  - 17
    - how to add webform-eventhandlers ?? Hi, in VS.NET 2008, how do I know what form-eventhandler exist? how can I add a form-eventhandler in the code-behind file apart from manually? cause when I select the properties of the webform, i don't see the lightning-bolt as is the case in WinForms in C#. any suggestion? thank you Chris Tag: Passing parameter to SQL Report Tag: 522077
  - 18
    - Getting Message: Error 1 Object '/173faa1a_b6b0_44e2_a2c0_3c7a5465 Hello, I'm using VS2008 and .Net 3.5 attempting to compile an ASP.Net project containing a large number of subdirectories and files. The Web Site will display the files as .pdf files. When I attempt to compile the project I get the following error message: Error 1 Object '/173faa1a_b6b0_44e2_a2c0_3c7a54656be4/rlw8v0xzdkx4qlij_tibu5p1_15.rem' has been disconnected or does not exist at the server. http://support.microsoft.com/kb/940700 But, it appears to be for .Net 2.0.... Will this help me? Thanks! Tom There is a support doc of: Tag: Passing parameter to SQL Report Tag: 522074
  - 19
    - Adding hidden image file data I want to somehow add a flag/bit to an image file when I've added a watermark (so I don't add another one). Is there some way of accessing the image file and setting some sort of flag? The image would be in jpeg format. Thanks in advance JJ Tag: Passing parameter to SQL Report Tag: 522066
  - 20
    - ht convert html to xml I am interested in passing a html or aspx or . . . page thru a process to create an xml file. Any help pointing me to some information on this is greatly appreciated. Tag: Passing parameter to SQL Report Tag: 522064
  - 21
    - Httphandler not working in visual studio web server? Hi all I have a simple httphandler : public class TextFileHandler : IHttpHandler { public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Write("Text file handler"); } public bool IsReusable { get { return false; } } } } and in my web,config I have registered this handler using the following: <add name="TextFileHandlerName" verb="*" path="*.txt" type="TestHttpHandlers.Usage.TextFileHandler" /> Now when I browse to any text file, I am expecting my handler to kick on and intercept the request. It doesnt happen when I run it under the built in Visual studio asp.net development server, but it works under IIS7 (the above code gets executed) Does anyone know ehy it doesnt work the built in the visual studio built in web server? Tag: Passing parameter to SQL Report Tag: 522063
  - 22
    - Paging to the next page always gives me the first page Hello, I have set the Allowpaging property to true in a standard DataGrid- control (System.Web.UI.WebControls). when run in the browser i get the first records in the first page, there are 5 pagesi n total, but when I click on the next page number, I always get the records of the first page ? how come? thank you Chris Tag: Passing parameter to SQL Report Tag: 522060
  - 23
    - Cannot initialize the data source for linked server Hi, I have this error when I run a stored procedure calling a linked server : System.Data.SqlClient.SqlException: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "linkedServerABC" The problem is that when I run the exact stored proc in SQL Server in the query editor it works well. So why ASP.Net on the same server can't execute this stored proc? Any idea? Thanks Stephane Tag: Passing parameter to SQL Report Tag: 522051
  - 24
    - How do I look up the attributes for the font tag? I have a anchor tag (<a...) and the text shows up dark. When I place the cursor (in IE) over it it brightens. I'd like it to be bright always and placed a font tag around it but when I looked at help to see if there was an appropriate attribute I couldn't find the help for the font tag! I used Filtered by Web Development. Two questions: 1) Can I lighten the text? 2)How do I look up the attributes for the font tag? Thanks Tag: Passing parameter to SQL Report Tag: 522045
  - 25
    - Sliverlight Streaming Hi, I need to build a Media Player using Silverlight/ASP.NET to stream data from a audio/video file on the server. Details: 1. Audio and Video files are separate. 2. Audio is WAV or VOX format. 3. Video is a custom format. Basically just a set of structure, containing compressed bitmaps and timing information, as to when to display the same during audio playback. My question is, Is it possible to read the audio/bitmaps, synchronize and stream it to the client. I dont want to convert the complete file to WMV. I understand the Sliverlight media player supports WMV, also I am aware that Windows Movie maker allow you to take Bitmaps and make a video with any audio playing at the background. I want to be able to do the encoding and streaming on the fly and deliver through Silverlight over ASP.NET. Is this possible????? Any ideas, suggestions, directions are most appreciated. Thanks, Matt. Tag: Passing parameter to SQL Report Tag: 522044

From Asp.Net v2 how can you pass a value to a SQL 2005 Report?

Re: Passing parameter to SQL Report by David

David
Fri Jul 25 08:51:42 CDT 2008

Are you talking about using a Reporting Services file in ASP.Net?

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup

"Robin9876" <robin9876@hotmail.com> wrote in message
news:b5162ecc-3b8d-4840-9e6a-4951a75ebcef@a21g2000prf.googlegroups.com...
> From Asp.Net v2 how can you pass a value to a SQL 2005 Report?

Top

Re: Passing parameter to SQL Report by Robin9876

Robin9876
Mon Jul 28 04:04:18 CDT 2008

Yes I am. I want to passing a value from the application which can
change at runtime.

On 25 Jul, 14:51, "David Wier" <d...@dw.com> wrote:
> Are you talking about using a Reporting Services file in ASP.Net?
>
> David Wierhttp://aspnet101.comhttp://iWritePro.com- One click PDF, convert .doc/.rtf/.txt to HTML with no
> bloated markup
>
> "Robin9876" <robin9...@hotmail.com> wrote in message
>
> news:b5162ecc-3b8d-4840-9e6a-4951a75ebcef@a21g2000prf.googlegroups.com...
>
> > From Asp.Net v2 how can you pass a value to a SQL 2005 Report?

Top