Hello,I have a gridview bound to a sqldatasource control. I have an emptydatatemplate setup. In the selecting event, I make sure that an actual select has been performed (and not on null data); however, I have cancelselectonnullparameters set to true to stop it, because initially it will be null.However, the selecting event runs, even when I cancel it, the emptydatatemplate shows up. How do I prevent that from occuring?
I have canceled a update statement that was running against a very large table. Now it is attempting to rollback all of the changes. Is there any way to cancel this? The table contains test data I would just like to drop it and recreate it, however I am getting an error when I attempt to drop the table because it is attempting a rollback.
I've execute a wrong sql request from an ETL. This request is inserting lots of rows in a table. I want to cancel that process, is it possible to do this? If yes, how can I cancel that request?
Is it possible to stop a query from running if a condition is not met?
I have a stored procedure that returns some email addresses. A condition is that a load of new data should have happened in the current month.
If a load of new data hasn't happened I want the stored procedure to stop and return an error message instead of returning the email addresses.
I have a variable that finds the maximum data load date and I thought I could use an IF... ELSE... to check if new data had been loaded. Like this:
DECLARE @MaxLoadDate as date = (select max(load_date) from #table) IF @MaxLoadDate<Dateadd(month, Datediff(month, 0, Getdate()), 0) --First Day of Current Month <Something here to kill the query> ELSE SELECT email_address FROM... etc
I've tried a couple of things like PRINT 'Error', and SET NO EXEC ON, but the query seems to happily carry on past the IF condition and return the email addresses. I know that data hasn't been loaded this month, so it should fail.
I have a SQL Server 2005 Compact Edition database that synchronizes with a SQL Server 2005 Standard database via merge replication.
The problem I have is when I cancel a synchronization, the database is left in such a state that I cannot add any new records. I dug around a bit and have found that in the INFORMATION_SCHEMA.COLUMNS view, AUTOINC_MAX has been incorrectly set to the same value as AUTOINC_MIN for the primary keys, which explains the 'out of range' error I get in my program when running off such a database.
In contrast, a non-corrupted database has AUTOINC_MAX set to AUTOINC_MIN + 999, presumably because of my subscriber identity range of 1000.
If this is the only thing that has gone wrong, all I need to do is programmatically set the AUTOINC_MAX values to AUTOINC_MIN + 999, however I can't find out where to do this (and INFORMATION_SCHEMA.COLUMNS is a view so it can't be updated obviously.)
I have also heard that 'compacting' the database may help, but I don't know how to do this either!
I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.
I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.
I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).
So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
I get an error when trying to install the SQL Native Client. It says it cannot find the installation package and to use a valid copy of 'sqlncli.msi'. I've downloaded the Express setup twice and get the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced Server. I am trying to test my installation and setup procedures. This is not a production setup, just install testing and documentation. I have allocated only 272MB to the VMWare session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
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(); } }
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
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?
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:
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.
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.
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.
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?
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....
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.
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
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.
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.
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>
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);
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)
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.
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.
