|
A perfectly reasonable answer. Downvote countered.
|
|
|
|
|
I have this gridview in asp.net where the data shown comes from a stored procedure
my stored procedure has this query:
AS BEGIN
SELECT vw_AppInfo.ID, vw_AppInfo.FIRST_NAME, vw_AppInfo.MIDDLE_NAME, vw_AppInfo.LAST_NAME, vw_AppInfo.EXTN,
vw_AppScore.ADMISSION_SCORE
FROM vw_AppInfo
RIGHT JOIN vw_AppScore ON vw_AppInfo.ID = vw_AppScore.ID
WHERE vw_AppInfo.REMARKS = 'ACCEPTED'
END
and this is my gridview:
<asp:gridview id="gvGrade" runat="server" allowpaging="True" allowsorting="True" autogeneratecolumns="False" cellpadding="4" datasourceid="SqlDataSource1" forecolor="#333333" gridlines="None" pagesize="30" width="900px">
<alternatingrowstyle backcolor="White">
<columns>
<asp:boundfield datafield="ID" headertext="ID" sortexpression="ID" readonly="true">
<asp:boundfield datafield="FIRST_NAME" headertext="FIRST_NAME" sortexpression="FIRST_NAME" readonly="true">
<asp:boundfield datafield="MIDDLE_NAME" headertext="MIDDLE_NAME" sortexpression="MIDDLE_NAME" readonly="true">
<asp:boundfield datafield="LAST_NAME" headertext="LAST_NAME" sortexpression="LAST_NAME" readonly="true">
<asp:boundfield datafield="EXTN" headertext="EXTN" sortexpression="EXTN" readonly="true">
<asp:boundfield datafield="ADMISSION_SCORE" headertext="SCORE" sortexpression="ADMISSION_SCORE">
<editrowstyle backcolor="#7C6F57">
<footerstyle backcolor="#1C5E55" font-bold="True" forecolor="White">
<headerstyle backcolor="#1C5E55" font-bold="True" forecolor="White">
<pagerstyle backcolor="#666666" forecolor="White" horizontalalign="Center">
<rowstyle backcolor="#E3EAEB">
<selectedrowstyle backcolor="#C5BBAF" font-bold="True" forecolor="#333333">
<sortedascendingcellstyle backcolor="#F8FAFA">
<sortedascendingheaderstyle backcolor="#246B61">
<sorteddescendingcellstyle backcolor="#D4DFE1">
<sorteddescendingheaderstyle backcolor="#15524A">
what I need is that only the Admission_Score/Score column can be edited. I tried using the commandfield but the "update" does not work.
|
|
|
|
|
|
I am using Report Viewer control to display reports in my ASP.NET application. And I am using Server Report from the reporting server services. The reports are displaying fine as expected. But the problem is some reports have active links in them which when clicked redirects to another report. But the reporting server services can be accessed inside the firewall only. But my asp.net application can be accessed from any where. SO my question is how to handle those links i.e how can I display the redirection reports even in the Report Viewer control. Is there any way to manipulate the links programatically, so that they will be displayed on the report viewer.
Hai,
sorry for such a worst framing of my question. I will try now to elaborate it.
1. I have a reporting server installed in my private network. So I can access the reports on the reporting service only inside my private network.
2. Now I am designing a web APP which needs to display some of the existing reports which are already deployed on the reporting services.
3. For That I am using ReportViewer Control in ASP.Net webforms. And I am using Server Report mode which actually uses the the reports already deployed on the reporting server.
4. But the problem is some of my reports have links in it. When we click those links it will redirect to another report that was deployed on the reporting server. So even when I use reportviewer control to view the existing report , the link actaully redirects me to use reporting service URL.
5. As we are using the WEB APP outside the private network, the link actually cant be accessed because the reporting server is accessible only inside the network.
6. Now My question is how can I actually handle those links in such a way that when user clicks on them, they needs to be displayed on yet another reportviewer control rather than redirecting to the reporting server URL. IS there anyway I can manipulate the URL using Code.
|
|
|
|
|
Does my question make sense to anybody. If not please let me know I will elaborate it. Any body please answer it, I have googled so much, but did not find any solution for this.
|
|
|
|
|
You need to be patient, people answer questions in their own time. Many of the members here have full time jobs already.
|
|
|
|
|
Kandepu Rajesh wrote: The reports are displaying fine as expected. But the problem is some reports have active links in them which when clicked redirects to another report.
Kandepu Rajesh wrote: But the reporting server services can be accessed inside the firewall only.
Kandepu Rajesh wrote: But my asp.net application can be accessed from any where
Question:
Kandepu Rajesh wrote: how can I display the redirection reports even in the Report Viewer control. Is there any way to manipulate the links programatically, so that they will be displayed on the report viewer.
[EDIT]
Your either change the link on the server side before the HTML is rendered
Or change the link on the client side in the DOM, using JQuery or just plain Javascript.
If you just want to change the server name, that's pretty easy.
So your saying that not all the reports are report viewer?,
Or you want to swap out the current report for the other report on the same page without a post back when the link is clicked?
You didn't post code showing how the link is generated, or a sample link of now and what you really want it to be. So I can't really offer a precise solution.
You should probably rethink your question, with the pinpointed problem your facing, and not a general overview of the program.
I really wanted to just hit the cancel button on this question, but I tried to help out.
I'm going to take a hit on this with vote downs, and probably delete my post here.
|
|
|
|
|
Hai,
sorry for such a worst framing of my question. I will try now to elaborate it.
1. I have a reporting server installed in my private network. So I can access the reports on the reporting service only inside my private network.
2. Now I am designing a web APP which needs to display some of the existing reports which are already deployed on the reporting services.
3. For That I am using ReportViewer Control in ASP.Net webforms. And I am using Server Report mode which actually uses the the reports already deployed on the reporting server.
4. But the problem is some of my reports have links in it. When we click those links it will redirect to another report that was deployed on the reporting server. So even when I use reportviewer control to view the existing report , the link actaully redirects me to use reporting service URL.
5. As we are using the WEB APP outside the private network, the link actually cant be accessed because the reporting server is accessible only inside the network.
6. Now My question is how can I actually handle those links in such a way that when user clicks on them, they needs to be displayed on yet another reportviewer control rather than redirecting to the reporting server URL. IS there anyway I can manipulate the URL using Code.
|
|
|
|
|
What kind of report server is it? This one
https://msdn.microsoft.com/en-us/library/ms157231.aspx[^]
I think that was poor planning on whoever created the report server and the reports in them.
Guess your just calling a report from the report server, and the report server generates the links in the report.
I would have to see the HTML in the browser, to inspect the format, and then decide what to do.
You could write a JQuery script to load when the dom is ready, and find all the A elements, and loop and inspect to finds the ones you want to change, and change the href attribute value.
If the web server and report server are on the same network, and the reports work, but the access links are different to the public, you should be able to change the links in the report server so all can access it, and the reports generate a new link.
You still didn't give samples of the links, you could just fix the DNS record for it.
But why is this your problem? Your a programer that write code, makes web sites. Unless your the one that made the report server and all the reports.
Maybe this will help
http://stackoverflow.com/questions/12607920/how-to-open-ssrs-report-from-asp-web-page-using-report-viewer[^]
|
|
|
|
|
Hello Experts,
I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
"Interop" dlls are just .net wrappers around COM objects that allow your .net code to use the underlying COM objects. For the code to function after being deployed, the COM object the interop is a wrapper for needs to exist, so in your case those objects are provided by Excel, so Excel needs to be installed on the server.
Legal and license issues aside, you're not going to get this working reliable (if at all) and it isn't supported by Microsoft. Look to another way of generating excel files like Open XML, Adpose, the excel odbc driver, DocX etc.
|
|
|
|
|
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
There are various ways to create Excel spreadsheets on the server without using Office interop. For example:
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks Richard
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
Yes, so don't use interop.
|
|
|
|
|
sweet and simple Thank you.
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
I use it on Windows Apps, when you turn visibility on, Excel loads, and you can watch the spreadsheet build, and then you can save it.
It's pretty slow, until you start optimizing your code.
So ya, don't use it on a server. But that's how it works.
|
|
|
|
|
|
there are two textbox and i want to perform a search operation on a button click. but the problem is that i am not able to fetch data.
what will be the select query for this.(DB IS MS ACCESS)
my query is like
qry="select * from emp where date_logged between #"+textbox1.text+"# and #"+textbox2.text+"#";
|
|
|
|
|
What is in textbox1.text and textbox2.text? Are you using unambiguous date text like "3 march 2015" or "3 march 2015 00:00:00"? Is "date_logged" a Date field?
As an aside your code is open to sql injection attacks.
|
|
|
|
|
Use & instead of + and also use TextBox1.Value instead of Textbox1.Text
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
using (OleDbConnection connection = new OleDbConnection("-YOUR CONNECTION STRING HERE-"))
using (OleDbCommand command = new OleDbCommand("SELECT * FROM emp WHERE date_logged Between ? And ?"))
{
command.Parameters.AddWithValue("StartDate", textbox1.Text);
command.Parameters.AddWithValue("EndDate" ,textbox2.Text);
...
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
thank you guys i will keep that in mind next time.
but I am not able to access data using text box.text. I am using date like mm/dd/yyyy(6/17/2013) format and same is stored in ms access db?
|
|
|
|
|
If you're storing the date as text, then you won't be able to compare it to any other date - for example, the string "6/2/1901" is greater than the string "6/19/2015".
Store your data using a proper data type - Access has a datetime type which you should be using:
Microsoft Access Data Types[^]
If you're already storing the dates as datetime, then you'll need to convert the parameter values to DateTime. For example:
command.Parameters.AddWithValue("StartDate", Convert.ToDateTime(textbox1.Text));
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Using between is not very accurate.
Lets Say you select
01/01/2000 and 01/31/2000
Between will give you
01/02/2000 to 01/30/2000
So you use
WHERE Date >= @StartDate AND Date <= @StopDate
|
|
|
|
|
thank you guys. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
