I have my code output a gridview with all the data with an option to select records. I'm trying to make a code which would allow me to select a record, and then print this record using a specific Report stored in MS Access.
I've located the code to print the Report it self, but it prints ether all the records or a range.
i have design a web application having suppliers table using SqlDatasource..
i have a master page in my design and other form are bound to a context menu..
Now i have displayed the records in the gridview..all i wanted is after i select a record in the gridview it will display the selected record in detailview from another aspx form..
i was able to create the link to another aspx form but the data that it display is the first data from the gridview not the data that i select.
i have created a report in ms access and now i want to display that record in my asp.net website i use vb.net
View 1 RepliesI have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
When I try to insert a record the Filing Date and Report Time fields are always blank in the database.
View 5 RepliesI have an acess db which has primal key ID - Customer, and personal data of the customer .
In another db OR the same, to have the username and login of the customers.
I want to make a login form so if u/n & pass of a customer is correct, to have access to modify (insert, delete, update) his data of the db - his ID's only.
I have an Access DB that generates reports for my users based on the month from a SQL table. In February my team leads didn't run the report and now it only shows data for the month of April. I have tried to play with the date code to pull just the February data but with no luck, I know this is a simple change but I can't figure it out.
[Code]....
i have maked a form which is saving used detail . how we can print the same record after saving. i have maked a report viewer which is print the data when we give the date and name. but i want print report currenty which saved.
i need i have a print button in form so i need when i click them it should print the current record which is i saved currently.
I am having grid view with check boxes, If user selectes multiple rows Iwould like to print all the selected rows page by page means first row in first page second row as second page how can I do this
View 1 RepliesI have seen a lot of things on the net on this but nothing seems to work. I have a GridView with name and other information on files stored in a database but also on a Server. I display the gridview with the files and the user selects the file to delete (row) by hitting the command field for Delete. I have an event on the gridview for code behind. Here I want to access the file name for the row selected, to be able to include it in the File.Delete statement.
Even before this I want to display the selected file name in a label back to the web page. I have tried everything including findcontrol selectedValue, etc. Nothing is working. I either get complier error, or nothing is displayed in label. If I let it go the the File.Delete step I get access error becasue there is no file name. HELP. here is screen shot of the gridview. Ignore the download button for now. That is my next headache to figure out. So based on the screen shot I want the value of log_doc from the gridview. It is in a column called file_name
File ID
File Name
Log
Upload Date
Uploaded By
Download
Delete
3
i have gride view and there are three dropDownList in every row in grideview,i want get selected value from every DropDownList,and pass the values to storeprocedure in sql,I dont know how pass value every row, to store procedure,and StoreProcedure get 3 value.
View 1 RepliesMy Company registered in certain services on the Web and are relying on the company's Ip to use these services, Director asked me to allow some staff to enter these sites from outside the company,after authorized staff enter to comany's site, How could they use the company's Ip to allow them to browse services sites ? Do I need to use a method such as proxy sites like youtube proxy? or there is another way?How do I do this in asp.net?
View 10 RepliesMy Company registered in certain services on the Web and are relying on the company's IP to use these services, Director asked me to allow some staff to enter these sites from outside the company, after authorized staff enter to comany's site. How could they use the company's IP to allow them to browse services sites? Do I need to use a method such as proxy sites like youtube proxy? or there is another way?How do I do this in asp.net?
View 2 RepliesI have parent gridview5 and nested child gridview6 within it. The page is working as expected and formatted as i need it now.. I added a select button to the child gridview6 and when i click on it i get an error: {"Object reference not set to an instance of an object."}
I found examples of using the find control, but within the parent gridview.. and i use that fine with other controls.. but cant figure out the right combination of finding the selected row for the nested gridview so that i can display a modalpopup.
I made a project to use the access membership provider from [URL] and it works. But I need to edit my database but when I configure my database, I cannot see the tabel, I can only see the queries in mdb file. when I select the field from query, I am unable to update it. My code is as follows:
[Code]....
I have to display data (names) in a random order on the website. The data is stored in a MS Access database. The names must be displayed in a GridView and DataList in different places. I have created a query in MS Access "zorder: Rnd([MarinaAccommodation]![ID])" which works fine in MS Access giving me a different order each time.
The problem is that when I try run it on the website the order remains the same, it does not change each time the page is loaded.
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I am unable to access the data in the gridview's selected row. I have done this lots of times but must be forgetting something.
Here is my gridview:
[Code]....
[Code]....
[Code]....
I want to hide some of the columns of the gridview before printing.
For example gridview contains customerid,city and postal code.
Now i want to show city and postal code during printing.
So how can i achieve this?
I am getting below error while generating report using crystal report:
Error in File C:WindowsTEMP
epEnquiry {095737EB-07B4-437D-9E86-85780B7417B0}.rpt:
Access to report file denied. Another program may be using it.
For this i did google and found some solutions but still its not working:
what i tried:
-given full access to aspnet and network services on my root directory and reports folder and then restarted iis.
OS:windows server 2008(64)
vs2008 application.
but still getting same error.
I want to print report based on GridView checkbox. If 3 rows has been choosed, should be 3 reports. My code is like this...
protected void btn_Print_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
try
{
foreach (GridViewRow gvr in grdRV.Rows)
{
RadioButton rbID = (RadioButton)gvr.FindControl("rbID") as RadioButton;
if (rbID != null && rbID.Checked)
{
string sID = grdRV.DataKeys[gvr.RowIndex].Value.ToString().Trim();
if (rbl_Print.SelectedValue == "0")
{
SMTP(sID);
}
else if (rbl_Print.SelectedValue == "1")
{
Material(sID);
}
}
}
}
catch (Exception ex)
{
Session["error"] = ex.Message;
Response.Redirect("MessageBoard.aspx");
}
}
}
private void Material(string sID)
{
string querystring = "../pmis/Reports/RptRFQMatV.aspx?RFQNo=" + lblRFQNo.Text.ToString() + "&ID=" + sID;
Random r = new Random();
string Script = "";
Script += "<script language=JavaScript id='PopupWindow'>";
Script += "confirmWin = window.open(' " + querystring + "','" + r.Next() + "','scrollbars=yes,resizable=1, width=960,height=500,left=50,top=130,status');";
Script += "confirmWin.Setfocus()</script>";
//ClientScript.RegisterStartupScript(typeof(string), "PopupScript", "PopupWindow");
if (!ClientScript.IsClientScriptBlockRegistered("PopupWindow"))
ClientScript.RegisterClientScriptBlock(typeof(string), "PopupWindow", Script);
}
Currently this code can print report the last row only
I'm building a website that just allow each person in my office to access the page from their own PC placed at the office only. It looks like I need to identify a client from within the codes on the ASP.net web server. How can I do this?
View 2 RepliesHow to Print RDLC Report without print preview on Client Side in ASP.Net ...
View 1 RepliesIs it possible to print SSRS 2008 remote rdl reports on asp.net web page to a default printer without showing the print dialog?
View 1 RepliesHow to print a microsoft report without using the builtin print button? or print an export version ( .PDF)?
View 3 Replies