Delete Button Problem

Apr 3, 2008

Can someone please help with my problem.  I have a button that should delete a record using a SP, the SP works fine but I’m getting this error message when I load the page“CS0118: 'System.Web.HttpRequest.QueryString' is a 'property' but is used like a 'method'â€?  - “ptimesheetid.Value = Request.QueryString("timesheetid");â€? 
Please find the code for my button below, any help will be greatly appreciated.

 protected void DelTS(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection();
objConn.ConnectionString = "Data Source=SQL03;Password=rdbx1;User ID=rdbx1;Initial Catalog=pronet_ts";
objConn.Open();
System.Data.SqlClient.SqlCommand objCmd = new System.Data.SqlClient.SqlCommand("delete_timesheets", objConn);
objCmd.CommandType = System.Data.CommandType.StoredProcedure;
System.Data.SqlClient.SqlParameter ptimesheetid = objCmd.Parameters.Add("@timesheetid", System.Data.SqlDbType.Int);

ptimesheetid.Value = Request.QueryString("timesheetid");

objCmd.ExecuteNonQuery();

objConn.Close();



}
 

View 3 Replies


ADVERTISEMENT

SQL Server 2008 :: Maintenance Plan Delete History Trying To Delete Wrong Files

Sep 11, 2015

I have some simple files but they are failing because the delete history task is failing as it is looking for files in a non existent directory.

It is looking for files in C:Program FilesMicrosoft SQL ServerMSSQL10_50.INSTANCEMSSQLLog whereas it should be looking in C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLog

how I can get this corrected so I can get the Maintenance Plans to run correctly.

I have tried deleting and recreating the Plan but to no avail

View 0 Replies View Related

Master Data Services :: Hard Delete All Soft Delete Records (members) In Database

May 19, 2012

I am using Master Data Service for couple of months now. I can load, update, merge and soft delete data in MDS. Occasionally we even have to hard delete data from MDS. If we keep on soft deleting records in a MDS table eventually there will be huge number of soft deleted records. Is there an easy way to hard delete all the soft deleted records from all MDS tables in a specific Model.

View 18 Replies View Related

Copy And Delete Table With Foreign Key References(...,...) On Delete Cascade?

Oct 23, 2004

Hello:
Need some serious help with this one...

Background:
Am working on completing an ORM that can not only handles CRUD actions -- but that can also updates the structure of a table transparently when the class defs change. Reason for this is that I can't get the SQL scripts that would work for updating a software on SqlServer to be portable to other DBMS systems. Doing it by code, rather than SQL batch has a chance of making cross-platform, updateable, software...

Anyway, because it needs to be cross-DBMS capable, the constraints are that the system used must work for the lowest common denominator....ie, a 'recipe' of steps that will work on all DBMS's.

The Problem:
There might be simpler ways to do this with SqlServer (all ears :-) - just in case I can't make it cross platform right now) but, with simplistic DBMS's (SqlLite, etc) there is no way to ALTER table once formed: one has to COPY the Table to a new TMP name, adding a Column in the process, then delete the original, then rename the TMP to the original name.

This appears possible in SqlServer too --...as long as there are no CASCADE operations.
Truncate table doesn't seem to be the solution, nor drop, as they all seem to trigger a Cascade delete in the Foreign Table.

So -- please correct me if I am wrong here -- it appears that the operations would be
along the lines of:
a) Remove the Foreign Key references
b) Copy the table structure, and make a new temp table, adding the column
c) Copy the data over
d) Add the FK relations, that used to be in the first table, to the new table
e) Delete the original
f) Done?

The questions are:
a) How does one alter a table to REMOVE the Foreign Key References part, if it has no 'name'.
b) Anyone know of a good clean way to get, and save these constraints to reapply them to the new table. Hopefully with some cross platform ADO.NET solution? GetSchema etc appears to me to be very dbms dependant?
c) ANY and all tips on things I might run into later that I have not mentioned, are also greatly appreciated.

Thanks!
Sky

View 1 Replies View Related

SQL - Cascading Delete, Or Delete Trigger, Maintaining Referential Integrity - PLEASE HELP ME!!!

Nov 13, 2006

I am having great difficulty with cascading deletes, delete triggers and referential integrity.

The database is in First Normal Form.

I have some tables that are child tables with two foreign keyes to two different parent tables, for example:

Table A
/
Table B Table C
/
Table D

So if I try to turn on cascading deletes for A/B, A/C, B/D and C/D relationships, I get an error that I cannot have cascading delete because it would create multiple cascade paths. I do understand why this is happening. If I delete a row in Table A, I want it to delete child rows in Table B and table C, and then child rows in table D as well. But if I delete a row in Table C, I want it to delete child rows in Table D, and if I delete a row in Table B, I want it to also delete child rows in Table D.

SQL sees this as cyclical, because if I delete a row in table A, both table B and table C would try to delete their child rows in table D.

Ok, so I thought, no biggie, I'll just use delete triggers. So I created delete triggers that will delete child rows in table B and table C when deleting a row in table A. Then I created triggers in both Table B and Table C that would delete child rows in Table D.

When I try to delete a row in table A, B or C, I get the error "Delete Statement Conflicted with COLUMN REFERENCE". This does not make sense to me, can anyone explain? I have a trigger in place that should be deleting the child rows before it attempts to delete the parent row...isn't that the whole point of delete triggers?????

This is an example of my delete trigger:

CREATE TRIGGER [DeleteA] ON A
FOR DELETE
AS
Delete from B where MeetingID = ID;
Delete from C where MeetingID = ID;

And then Table B and C both have delete triggers to delete child rows in table D. But it never gets to that point, none of the triggers execute because the above error happens first.

So if I then go into the relationships, and deselect the option for "Enforce relationship for INSERTs and UPDATEs" these triggers all work just fine. Only problem is that now I have no referential integrity and I can simply create unrestrained child rows that do not reference actual foreign keys in the parent table.

So the question is, how do I maintain referential integrity and also have the database delete child rows, keeping in mind that the cascading deletes will not work because of the multiple cascade paths (which are certainly required).

Hope this makes sense...
Thanks,
Josh


View 6 Replies View Related

Delete Syntax To Delete A Record From One Table If A Matching Value Isn't Found In Another

Nov 17, 2006

I'm trying to clean up a database design and I'm in a situation to where two tables need a FK but since it didn't exist before there are orphaned records.

Tables are:

Brokers and it's PK is BID

The 2nd table is Broker_Rates which also has a BID table.

I'm trying to figure out a t-sql statement that will parse through all the recrods in the Broker_Rates table and delete the record if there isn't a match for the BID record in the brokers table.

I know this isn't correct syntax but should hopefully clear up what I'm asking

DELETE FROM Broker_Rates

WHERE (Broker_Rates.BID <> Broker.BID)

Thanks

View 6 Replies View Related

SQL && C# Help On A Button Click!!!

Mar 7, 2008

Hey Guys,
I'm not sure if anyone can help me with this but I am trying to achieve the following:
I have a row (In this case it is information on a fix) and on a button click I am trying to get it to "archive" it.  At the moment I have it so that it it takes the current information and adds it to the archive table adding an archive date.  The thing that I am struggling with is incrementing the version number. So, I need it to (in these steps I think) - Look for existance of the other entires of that ID, look for the version number that is related to the newest date of those knowledgeIDs and then add 1 to it.  If that knowledgeID doesnt exist then add it as one.
My current code is below:
Thanks in Advance =)
C# Codeprotected void Page_Load(object sender, EventArgs e)
{UserName = (string)Session["UserName"];
Label4.Text = UserName + " Is Current Logged In";UserType = (string)Session["UserType"];if ((Session["UserName"] != null) & (UserType == "Helpdesk"))
{Response.Redirect("Accessrights.aspx");
}else if (Session["UserName"] == null)
{Response.Redirect("Login.aspx");
}
FixName = "default";Description = "default";File = "default";
ADate = myCalendar.TodaysDate.ToShortDateString();
AddDate = Convert.ToDateTime(ADate);myConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\inetpub\wwwroot\HOF\App_Data\HOF.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";
}protected void Button1_Click(object sender, EventArgs e)
{SqlConnection myConnection = new SqlConnection(myConnectionString);
try
{
FixName = TextBox1.Text;
 SqlCommand myCommand = new SqlCommand("select * from Knowledge WHERE FixName like '%" + FixName + "%'", myConnection);
myConnection.Open();SqlDataReader myReader = myCommand.ExecuteReader();if (myReader.HasRows)
{while (myReader.Read())
{
TextBox1.Text = myReader["FixName"].ToString();TextBox2.Text = myReader["Description"].ToString();
File = myReader["Location"].ToString();if (File != null)
{
TextBox3.Text = File;
}
else
{TextBox3.Text = "There is no script avaliable";
}KnowledgeID = myReader["KnowledgeID"].ToString();Add = myReader["DateAdded"].ToString();
}
myConnection.Close();
}
else
{TextBox1.Text = FixName + "Does not Exist. Please try again.";
}
}catch (Exception ex)
{
myConnection.Close();
}
try
Description = TextBox2.Text;File = Convert.ToString(FileUpload1.FileName);if (CheckBox1.Checked == true)
{SAPPS = "True";
}
else
{SAPPS = "False";
}
{SqlCommand mycommand2 = new SqlCommand("INSERT INTO Knowledge (FixName, Description, Location, DateAdded, DateArchived, Version, KnowledgeID) SET ('" + FixName + "','" + Description + "','" + File + "','" + Add + "','"+AddDate+"','" + SAPPS + "','"+I NEED A VALUE HERE+"','"+KnowledgeID+"')", myConnection);SqlDataAdapter myDataAdapter = new SqlDataAdapter(mycommand2);
sa = mycommand.ExecuteNonQuery();
myConnection.Close();
}catch (Exception ex)
{
myConnection.Close();
}
}
 

View 2 Replies View Related

Web Form Button ?

Sep 24, 2004

I need to make a query to a SQLserver db passing values from a dropdownlist and two text boxes as my criteria. Now if nothing is selected and the button is pressed, I would like to return everything that is part of my Select statement. I am having trouble making my sql statement work.

Im sending you my code as an attachment. I've put * around the area i really need help with.

Even if you could just point me in the right direction as to where to look for a good web forms book using VB.NET and ASP.NET I would really appreciate it.

Thanks,

Jose
AIM- RangerBud249
Yahoo- RangerBud249


Imports System.Data.OLEDB
Imports System.Data
Imports System.Data.SqlClient
Public Class Test
Inherits System.Web.UI.Page
Public dbConn As SqlConnection
Public da As SqlDataAdapter
Protected WithEvents txtStart As System.Web.UI.WebControls.TextBox
Protected WithEvents txtEnd As System.Web.UI.WebControls.TextBox
Protected WithEvents Calendar1 As System.Web.UI.WebControls.Calendar
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents img_cal1 As System.Web.UI.WebControls.ImageButton
Protected WithEvents img_cal2 As System.Web.UI.WebControls.ImageButton
Public ds As DataSet

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'the TailNumber is the first thing that will load
If Not Page.IsPostBack Then
lstAircraft.DataSource = GetAircraft() 'this function will load the Tail Numbers
lstAircraft.DataValueField = "TailNumber"
lstAircraft.DataTextField = "TailNumber"
lstAircraft.DataBind()
End If
End Sub

Function GetAircraft() As System.Data.DataSet
'this function will load the Tail Numbers
Dim connectionString As String = "connection info"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT [Aircraft].[TailNumber] FROM [Aircraft]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)

Return dataSet
End Function

******************************************************************************************************************
this is the area I really need help with

Sub btm_Submit_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim connectionString As String = "connection info"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
dbConnection.Open()
dbConnection.Close()
Dim selection As String
Dim startTime As String
Dim landingTime As String
Dim flights As String

Dim selString As String = "SSELECT AircraftID, fromLocation, startTime, toLocation, landingTime, ID, Filename, VSU, local_1 FROM Flights, tbl_FileNames, tbl_VSU"

Dim commandString As String = "SELECT [Flights].AircraftID, [Flights].fromLocation, [Flights].startTime, [Flights].toLocation, [Flights].landingTime, [tbl_FileNames].ID, [tbl_FileNames].Filename, [tbl_FileNames].VSU, [tbl_FileNames].local_1 FROM Flights, tbl_FileNames, tbl_VSU"

selection = "where " & Me.lstAircraft.SelectedValue.ToString & " " & startTime = Me.txtStart.Text & " " & Me.txtEnd.Text = landingTime & " " & [Flights].[ID] = [tbl_VSU].[flight_id]) AND [tbl_VSU].[filename_id] = [tbl_FileNames].[ID]"
If Me.txtStart.Text <> "" Then
selString = selString & selection
End If
Session("SelStr") = selString

Dim dbCommand As New OleDbCommand(commandString, dbConnection)

DataGrid1.DataSource = GetFlights(lstAircraft.SelectedValue)
DataGrid1.DataBind()
End Sub
*********************************************************************************************************************

Function GetFlights(ByVal ID As Integer) As System.Data.DataSet
Dim connectionString As String = "connection info"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT [Flights].[toLocation], [Flights].[startTime], [tbl_FileNames].[ID], [Flig" & _
"hts].[fromLocation], [tbl_FileNames].[filename], [tbl_FileNames].[Local_1], [Fli" & _
"ghts].[AircraftID], [Flights].[landingTime], [tbl_FileNames].[VSU] FROM [Flights" & _
"], [tbl_FileNames], [tbl_VSU] WHERE (([Flights].[ID] = [tbl_VSU].[flight_id]) AN" & _
"D ([tbl_VSU].[filename_id] = [tbl_FileNames].[ID]))"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)

Return dataSet
End Function

Private Sub img_cal1_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles img_cal1.Click
'this will make the calendar for start visible when clicked and not visible if clicked again
Session("Cal1") = True
Session("Cal2") = False
Me.Calendar1.Visible = True
End Sub


Private Sub img_cal2_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles img_cal2.Click
'this will make the calendar for end visible when clicked and not visible if clicked again
Session("Cal2") = True
Session("Cal1") = False
Me.Calendar1.Visible = True

End Sub

Private Sub Calendar1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Calendar1.SelectionChanged
'this will put the date selected in my text box as a short date
If Session("Cal1") = True Then
txtStart.Text = Calendar1.SelectedDate.ToShortDateString
Session("Cal1") = False
ElseIf Session("Cal2") = True Then
txtEnd.Text = Calendar1.SelectedDate.ToShortDateString
Session("Cal2") = False
End If
Me.Calendar1.Visible = False

End Sub


End Class

View 1 Replies View Related

Back Button

Jun 2, 2008

Hello.
When I'm useing a report in reportViewer I have a "back button" in the the viewer which let me go back to my parent report after jumping to another report.

I wanted to make a bigger button like that on the report so I tried to simulate it by creating my own textback and use a javascript to go back one page.

This doesn't work since the javascript doesn't work as well as the built in bottun.
Is there a way to simulate this button any way?

Thanks.

View 2 Replies View Related

Where's The Start Button?

Jan 30, 2008



I just installed and registered SQL Server Express but I don't see any shortcuts or Start -> Programs links. I found the new folder it created C:Program FilesMicrosoft SQL ServerMSSQL.2 and I tried to run this file:

C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlservr.exe


Nothing happens. Nada. Do I have to restart my computer?

PS: Is there a QuickStart tutorial on using its Reporting Services?

View 5 Replies View Related

Click Button?

Oct 15, 2007



Hi everyone, Im using SSRS 2000 and I was wondering is there a way to create a click button??? I have 2 reports linked with hyperlinks but I wanted to make it look more presentable. So, instead of just clicking on the words, I want them to click the button.

Thanks in advance,

Abner

View 3 Replies View Related

Print Button

Feb 1, 2006

Print button is disabled for some users. Don't know why it is doing so? Works fine for most of the users in the same group.

Any help is much appreciated.



SQL SERVER Reporting Services 2000

Win XP

View 10 Replies View Related

Radio Button

Dec 27, 2006

Hi,

I have one report,in my report i need to display parameters like this:

one radio button :Age and another radio button is Age Ranges

For the Age,I have to dispaly like two text boxes named 'From' and 'To'

For the Age Ranges,I have to display one drop down list contains values :20s,30s ..

In Reporting Services,Putting the Radio button is not possible,i think,If possible how to achive this.

Other workaround is i think Multivalued parameter which displays the Age and Age ranges

When we click on Age we need to display 2 textboxes

When we select Age Ranges we have to display Drop down list

If we select both :both 2 text boxes and drop down list.

Putting multi valued parameters for this requirement is not good and this is not the multi valued parameter concept.Please clarify me whether iam correct or not.

Thanks in advance



View 5 Replies View Related

Print Button

Aug 8, 2006

I have a web application with a stand alone report. When I put the ReportViewer in the webform I can see every reports in the project. The problem is that I can't see the print report button...

If I indicate that the report is a "Server Report" instead a local report the Print Report appear, but a need a "Local Report" not a "Server Report" How can i solve that.

Thank you.

View 3 Replies View Related

Search Button

Apr 14, 2008



Hi There,

I wanted to add a search button to my report where by it would only be visible after the report was run by the user and then the user could search on a particular field(Called Synopsis) for a value, ex QREF12345. I don't want the user to enter QREF, just the number. How could this be coded?? Also, are there any good sites available with code snippetts available?

Thanks,

Rhonda

View 1 Replies View Related

Reset-button

Nov 15, 2006

I want a reset-button which clear my formular....

I have the following code in mypage.aspx.vb:

Sub Reset(ByVal sender As Object, ByVal e As System.EventArgs)

Me.Server.Transfer("Mypage.aspx") 'reloads the page without postback?

End Sub

And a button on mypage.aspx:

<asp:Button ID="Button2" OnClick="Reset" runat="server" Text="Rensa" />



But when I click the button....the validation-controls executes before...so instead for "clearing" the page (reload it without postback) the validation-messages shows that I have forgott to write in som textboxes....

What should I do?

View 1 Replies View Related

OK Button Not Working...

Sep 29, 2005

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

View 16 Replies View Related

Changing The Source Wth A Button

Feb 4, 2007

Hi,
I have this Gridview in which I show attendees to a course (per course)
In the same gridview I want to be able (by clicking a button) to show all attendees to all courses simply by leaving out a part of the SQL;
WHERE Eventid = @eventid (resulting in all attendees no matter what course)
In other words how can I alter the selectcommand of the SQLDataSource?
Seems simple, but can't hack it.
Thanks in advance,
Lx 

View 3 Replies View Related

How To Assign SQL Query To Button In Asp.net 2.0

May 24, 2007

Hi
                  My webpage contain three dropdown box and one button. One dropdown to choose hospital_id, second dropdown to choose project_id and third dropdown to choose version_no .After choosing these three and when the button is clicked i want to run this sql query
INSERT INTO  version(project_id,hospital_id,date_created,comments) SELECT project_id,hospital_id,date_created,comments FROM version where version_no=@version_no and project_id=@project_id and hospital_id=@hospital_id.
Just i need the code in asp.net 2.0 , VB , when the button is clicked the above query should run and the parameters (values) should take from dropdown box.
Could anyone please send the solution for the above problem.

View 1 Replies View Related

Executing SQL With A Button Click.

Dec 25, 2007

I feel like it must be easy and I'm missing something.  Maybe I'm going the wrong way about it too.  Basically I've written an append query that needs parameters, but I have no idea how to actually execute it.  I'm coming from building apps in MS Access where all of this is really easy.  I'm really enjoying learning some things, and did my first MS SQL trigger event tonight, which worked great.  I though using a trigger may be an option here, but I need to control the "when" of this append a little more carefully and can't rely on an automated event. I can manually execute the query and it works, but have a button I could press on a form, with the queries on that form would be ideal.  I'm basically moving partial data from one table to another. Any help?  Again, this seems like it "should" be easy, but I'm not finding info on it.  Please talk slowly, as again, I'm coming from Access. 

View 5 Replies View Related

SqlDataSource, GridView && A Button

Jan 12, 2008

hi .. i have a SqlDataSource, GridView & a Button ..  i want to increase the condition in the "SelectCommand" below by one everytime i click the button .. i mean to be like that ID < 8 instead of ID < 7
so, the GridView will show 7 ID's instead of 6 .. and it will increase everytime i hit the button<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:connectionstring %>"
SelectCommand="SELECT * FROM [table1] WHERE ID < 7">
</asp:SqlDataSource>
 

View 4 Replies View Related

Permissions / Apply Button

Aug 20, 1999

Is anyone else having trouble with the Apply button under the permissions tab?
I can change permissions, click apply, the changes are shown, but when I access the database, the changes arn't made. If I close the permissions windows and re open the changes arn't made.

Will SP1 fix this?(it's not listed in the fix text file)

View 2 Replies View Related

How To Add Record Thru Command Button In Adp.

Feb 21, 2005

Hi,

In access database project where my tables are linked from MSSQL server, how can I add record from the FORM itself using command button. Bcz it is not like mdb files in access that you can just drag a command button onto the form and take an action like add, delete, print or find rec. I just came to know it from immediate window using following SQL line;

Docmd.RunSql "Insert........

This is ok but how it could be done thru a command button on FORM.

Thanks in advance.

With kind regards,
Ashfaque

View 4 Replies View Related

BIDS Undo Button

Apr 9, 2008

How come Undo button does not work? Thanks.

View 2 Replies View Related

SQL Reporting - Print Button

May 2, 2008

Hi,
I am having a problem when a user presses the print button from the SQL Reporting web interface. When the print button is pressed, it hangs and spikes the CPU until the worker process (w3wp.exe) is killed. This process and the SQL Server process (sqlservr.exe) take all of the CPU.

The only thing I've found that sounds similar is the following discussion:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1813950&SiteID=17

If I follow the discussion in this thread and turn off the configuration option for 'SET NOCOUNT', the it works fine. The thing I'm trying to figure out, is this a bug that was fixed so that the print button will now function whether the flag is on or off. I also need to verify that this is a valid solution to the problem if it is not a fixed bug. I'd also like some information on why this is a problem if someone knows.

Thanks,
Keith J

View 6 Replies View Related

Button To Hide Objects

Feb 1, 2008



Hello Folks,

Sorry to have to ask this as it may be easier than what I'm thinking.

I have a menu down the left side of my main report. Previously this menu navigated to their associated reports, however I'm sampling the idea of having all the reports as subreports in the mainreport, then clicking a button on my menu to only show the subreport I'm interested, and hide the rest. They're layered on top of each other so it looks like I'm navigating to a new page, even though I'm not.

I've set up parameters to control the visibility of each subreport object which works when the parameter value is changed manually, however, I don't know how to create a button (textbox) to change the value of that parameter (or in this case, all the parameters that control the visibility of the objects). I don't want to have to use the integrated UI to change the parameter directly, although I know this would probably work.

Quick summary :

User clicks 'Server Details' Button
ServerDetails.rdl subreport is set to visible
DriveDetails.rdl subreport is set to invisible
DatabaseDetails.rdl subreport is set to invisible

I realise I'll probably have to code a refresh in IF I can get the above to work

Many thanks for any help!

Cheers, Jode

Edit : This is in RS 2005

View 4 Replies View Related

Adding Button In Report

Apr 27, 2007

I would like to know whether there is any way to add a button in report. I have 3 report parameters. On clicking the button, the current values of the reports are to be obtained and saved in database i.e saving the report configuration. I will use this saved configuration to form the url and view report directly.



Thanks,

Pradeep

View 3 Replies View Related

DataBinding To Radio Button

Apr 27, 2006

I have a windows form containing some text boxes and radio buttons bount to an SQL Server database, with code like the following:

this.tbBorrowerLastName.DataBindings.Add (new Binding("Text", dsData.Tables["Results"],"BorrowerLastName"();

this.rbMale.DataBindings.Add(new Binding("Checked", dsData.Tables["Results"],"Male"))

If I add a new row and try to move there using the code below, nothing happens (neither movement to a new position nor error message), unless I remove the radio button bindings. (The same thing occurs if I attempt to move to any record that has a null value in the database field for a radio button).

myLastRow = dsData.Tables["Results"].NewRow();

dsData.Tables["Results"].Rows.Add(myLastRow);

I attempt to move by changing the value of the position property of the BindingContext object.

How can I retain the radio button bindings and still be able to add and move to a new row?

Any help would be appreciated.

View 1 Replies View Related

Add A Print Button To A Report

Feb 28, 2008



How do i add a print button to my report? Do i have to use ASP.NET?
(I dont know .NET)
Is there anyother way?

Thanks

View 7 Replies View Related

Radio Button And Datatype

Nov 26, 2007

Hi.
Am creating a database in SQLEXPRESS 2005 and have two fields male and female. In my form(vb 2005) i will assignin these to fields to a radio button. In designing the database which datatype should i use for the male and female field?
Thanks

View 4 Replies View Related

How To Add Link In A Report As A Button?

Dec 21, 2006

Hi,

I want to add a link in a report, possibly a url link or a link to other report. One way of doing this is to go to properties of textbox and then update the jump to option.

But how to do this through a click of a button, inside the report?

I am having Microsoft Visual Studio 2005, designer's version.

thanks

View 1 Replies View Related

Report Builder Button

Jan 3, 2006

We've installed SQLServer 2005 and are trying to use Report
Builder.  But we only see the Report Builder button if we're
currently logged onto the machine that's running RS.

My understanding is that anybody with a role of Content Manager should
be able to see this, but nothing we do with the role assignments seems
to help.

We've installed on XP and Win2003 machines and this behavior is consistent.



Any ideas?

TIA,

Jim

View 3 Replies View Related

Search In Button Click

Jun 29, 2007

i have to search through differene controls (textboxes,dropdownlist,checkboxes,radiobutton) in an Asp.Net page usingC#.

can anybody tell me how to write the code of searching in button_click.

using dynamic query or stored procedure.



all replies are welcome.

Thanx in advance.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved