Problem In Saving Page Contents I.e; Textbox And Dropdownlist Values Please Help
Feb 29, 2008
Hi all,
please have a look of code i am unable to perform save operation on
the asp.net web page.
I ahve written a stored procedure. the same code works if all are
textboxes, but some of textbox replaced with dropdownlist box then
this save operation doesn't occurs. please let me know where is the
mistake in coding .
vb.net code :-
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As
EventArgs)
Dim employmentID As Integer =
Request.QueryString("employmentID")
Dim resourceID As Integer = Request.QueryString("resourceID")
Dim projectID As Integer = Request.QueryString("ProjectID")
Dim dbconsave As SqlConnection
dbconsave = New SqlConnection(HRISDBConnectionString)
Dim dbcomsave As New SqlCommand("sp_save_NewHireEmailnotify",
dbconsave)
dbcomsave.CommandType = CommandType.StoredProcedure
dbcomsave.Parameters.Add(New SqlParameter("employmentID",
SqlDbType.Int))
dbcomsave.Parameters("employmentID").Value = employmentID
dbcomsave.Parameters.Add(New SqlParameter("resourceID",
SqlDbType.Int))
dbcomsave.Parameters("resourceID").Value = resourceID
dbcomsave.Parameters.Add(New SqlParameter("ProjectID",
SqlDbType.Int))
dbcomsave.Parameters("ProjectID").Value = projectID
dbconsave.Open()
dbcomsave.Parameters.Add("@PreferredFirstName",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@PreferredFirstName").Value =
txtPreferredFirstName.Text.ToString()
dbcomsave.Parameters.Add("@PreferredLastName",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@PreferredLastName").Value =
txtPreferredLastName.Text.ToString()
dbcomsave.Parameters.Add("@CellPhone", SqlDbType.VarChar)
dbcomsave.Parameters.Item("@CellPhone").Value =
txtCellPhone.Text.ToString()
dbcomsave.Parameters.Add("@HomePhone", SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomePhone").Value =
txtHomePhone.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressLine1",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressLine1").Value =
txtHomeAddressLine1.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressLine2",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressLine2").Value =
txtHomeAddressLine2.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressState",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressState").Value =
txtHomeAddressState.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressCity",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressCity").Value =
txtHomeAddressCity.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressZIP", SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressZIP").Value =
txtHomeAddressZIP.Text.ToString()
dbcomsave.Parameters.Add("@HomeAddressCountry",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@HomeAddressCountry").Value =
txtHomeAddressCountry.Text.ToString()
dbcomsave.Parameters.Add("@ArrangementType",
SqlDbType.VarChar)
dbcomsave.Parameters.Item("@ArrangementType").Value =
ddlArrangementType.SelectedItem.ToString()
dbcomsave.Parameters.Add("@PracticeGroup", SqlDbType.VarChar)
dbcomsave.Parameters.Item("@PracticeGroup").Value =
ddlPracticeGroup.SelectedItem.ToString()
dbcomsave.Parameters.AddWithValue("@EquipmentNeeds",
txtEquipmentNeeds.Text.ToString())
Try
dbcomsave.ExecuteNonQuery()
lblMessage.Text = "Record saved successfully"
Catch ex As Exception
End Try
dbconsave.Close()
End Sub
==============================================================================
.aspx code :-
<table>
<tr>
<td >
<asp:Label
ID="lblPreferredFirstName" runat="server" Text="Name(Preferred First
Last) :" ForeColor="Blue"></asp:Label>
</td>
<td
<asp:TextBox
ID="txtPreferredFirstName" runat="server" Text="" BorderStyle="None"
></asp:TextBox>
<asp:TextBox
ID="txtPreferredLastName" runat="server" Text="" BorderStyle="none" ></
asp:TextBox>
</td>
</tr>
<tr>
<td >
<asp:Label ID="lblCellPhone"
runat="server" Text="CellPhone :" ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox ID="txtCellPhone"
runat="server" Text="" ></
asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label ID="lblHomePhone"
runat="server" Text="HomePhone :" ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox ID="txtHomePhone"
runat="server" Text="" ></
asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressLine1" runat="server" Text="HomeAddressLine1 :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressLine1" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressLine2" runat="server" Text="HomeAddressLine2 :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressLine2" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressState" runat="server" Text="HomeAddressState :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressState" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressCity" runat="server" Text="HomeAddressCity :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressCity" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressZIP" runat="server" Text="HomeAddressZIP :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressZIP" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblHomeAddressCountry" runat="server" Text="HomeAddressCountry :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:TextBox
ID="txtHomeAddressCountry" runat="server" Text="" ></asp:TextBox>
</
td>
</tr>
<tr>
<td >
<asp:Label ID="lblArrangement"
runat="server" Text="Arrangement :" ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:DropDownList
ID="ddlArrangementType" runat="server" Width="160px"
DataSourceID="ObjectDataSourceArrangementType"
DataTextField="ArrangementType" DataValueField="ArrangementType"
OnDataBound="ddlArrangementType_DataBound">
</
asp:DropDownList>
<%--<asp:TextBox
ID="txtArrangement" runat="server" Text="" ></asp:TextBox>--%>
</
td>
</tr>
<tr>
<td >
<asp:Label
ID="lblPracticeGroup" runat="server" Text="Practice Group :"
ForeColor="Blue"></asp:Label>
</td>
<td >
<asp:DropDownList
ID="ddlPracticeGroup" runat="server" Width="160px"
DataSourceID="ObjectDataSourcePracticeGroup"
DataTextField="PracticeGroup" DataValueField="PracticeGroup"
OnDataBound="ddlPracticeGroup_DataBound">
</
asp:DropDownList>
<%--<asp:TextBox
ID="txtPracticeGroup" runat="server" Text="" ></asp:TextBox> --
%>
</
td>
</tr></table>
please help me to solve the issue.
Thanks in advance
View 3 Replies
ADVERTISEMENT
Sep 18, 2006
HiI am using FormView, SQL 2005, VB 2005When I save the contents of Title and Area entry fields , I have lots of spaces added to the end.Title and Area are MultiLine Textboxes and database:varchar(100)I thought I had solved the issue using;TextBox Title = FormView1.FindControl("TitleTextBox") as TextBox;TextBox Area = FormView1.FindControl("AreaTextBox") as TextBox;TitleLenTrim = Title.Text.Trim().ToString();if (TitleLenTrim.Length > 100){TitleLenTrim = TitleLenTrim.Trim().Substring(0, 99);}string AreaLenTrim;AreaLenTrim = Area.Text.Trim().ToString();if (AreaLenTrim.Length > 100){AreaLenTrim = AreaLenTrim.Trim().ToString();} string insertSQL;insertSQL = "INSERT INTO Issue(";insertSQL += "ProjectID, TypeofEntryID, PriorityID ,Title, Area)";insertSQL += "VALUES ( '";insertSQL += ProjectID.Text.ToString() + "', '";insertSQL += EntryTypeID.Text.ToString() + "', '";insertSQL += PriorityID.Text.ToString() + "', '";insertSQL += TitleLenTrim.Trim().ToString() + "', '";insertSQL += AreaLenTrim.Trim().ToString() + "', '";Is there any other way I could remove spaces?Thanks in advance.
View 4 Replies
View Related
Feb 18, 2008
Thanks in advance for taking the tiemt o read this post:
I am workingon an application in vb.net 2008 and I have 5 drop down lists on my page.
I have code that worked in .net 2005 for my databind but would like to use new features in 08 to do this same thing.
Here is my 05 code how would I do this same things in 08?
Dim db As New DataIDataContext
Dim GlobalSQLstr As String
GlobalSQLstr = "select Orig_City, ecckt, typeflag, StrippedEcckt, CleanEcckt, ManualEcckt, Switch, Vendor, FP_ID, order_class, Line_type, id from goode2 where 1=1"
If (ddlOrigCity.SelectedValue <> "") Then
GlobalSQLstr &= "and Orig_City = '" & ddlOrigCity.SelectedValue & "'"
End If
If (ddlSwitch.SelectedValue <> "") Then
GlobalSQLstr &= "and switch = '" & ddlSwitch.SelectedValue & "'"
End If
If (ddlType.SelectedValue <> "") Then
GlobalSQLstr &= "and Order_Class = '" & ddlType.SelectedValue & "'"
End If
If (ddlFormatType.SelectedValue <> "9") Then
GlobalSQLstr &= "and typeflag = '" & ddlFormatType.SelectedValue & "'"
End If
If (ddlVendor.SelectedValue <> "") Then
GlobalSQLstr &= "and Vendor = '" & ddlVendor.SelectedValue & "'"
End IfDim AllSearch = From A In db.GoodEcckts2s
If (ddlErrorType.SelectedValue <> "0") Then
GlobalSQLstr &= "and ErrorType = '" & ddlErrorType.SelectedValue & "'"
End IfDim cmd As New SqlClient.SqlCommand
Dim rdr As SqlClient.SqlDataReaderWith cmd.Connection = New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString1").ConnectionString)
.CommandType = Data.CommandType.Text
.CommandText = GlobalSQLstr
.Connection.Open()
rdr = .ExecuteReaderMe.gvResults.DataSource = rdrMe.gvResults.DataBind()
.Connection.Close()
.Dispose()End With
View 4 Replies
View Related
Aug 5, 2006
Hey all,
I've been searching for a while and haven't really found an answer for what I'm trying to do. Here it all is and someone can tell me if I'm going in the wrong direction to solve this.
I have a textbox set to a parameter of "SearchString" and a DropDownList with the SelectedValue paramter of "FilterValue". The parameters work, I've tested that. So here is the problem.
I am trying to use the "FilterValue" to pick the field that the "SearchString" searches with a LIKE statement (e.g. SELECT * FROM dbo.Units WHERE (@FilterValue LIKE '%'+@SearchString+'%'))
This, I've found out, doesn't work. I have this setup with a DataLayer.vb in my App_Code directory handling the SQL calls, while the normal CodeBehind is in the typical "Default.vb" page.
I will post code later as I don't have access to it right now, but if anyone can explain how a filter like this would work I would appreciate it!
Thanks,
-Matthew
View 3 Replies
View Related
Nov 28, 2006
hello..i need your help to provide me the idea and code how to view the data from database based on search criteria from user's input?the user's may fill up textbox and choose a criteria from dropdownlist...i am so no idea how to code it since i am fairly new in asp.net
View 5 Replies
View Related
May 24, 2007
I want to add up the values in a couple of text boxes in another textbox. How do I refer to the textboxes?
fields!textbox1.value doesn't work..what does?
View 1 Replies
View Related
Oct 1, 2015
i need to display variables from one textbox to 2 or more tables in database, how do i do that?
View 2 Replies
View Related
Feb 13, 2007
Is this possible?, i hope it is:). Your help is very much appreciated.
View 2 Replies
View Related
Jan 26, 2007
My report has a group "order_no" and after each 1 there is a page break.... on each page I want a textbox which refers to the product column in the table...
How do I get the textbox to refer to the column on that page?
(I no to refer to the column in the table is:
=ReportItems("product").Value
But now that I have moved the textbox to the page header, it returns no value!!!
Thanks in advance
View 1 Replies
View Related
Feb 27, 2008
Hello all-
I have a situation where a textBox can span multiple pages. When this occurs I lose a label that I have at the top of the page, containing data from the dataset. The label is set to repeat on every page and works great with the exception of this case.
So my questions would be :
1) is it i possible to force the render of the a label (a textbox) in the case that a page break is due to an abhorrently long textbox value?
-OR-
2) is it possible to inject a field from my dataset into the page header?
Thanks-
Tristan
View 1 Replies
View Related
Dec 19, 2014
So I have the following column named String in a table:
<key>Children</key><integer>2</integer>
This of course can vary for the different records. What's the best way to replace the 2 with the contents of my variable with TSQL?
declare @children int
set @children = 4
I want to do something like this:
SELECT <key>Children</key><integer>@children</integer>
View 4 Replies
View Related
Sep 21, 2005
I have a text box that contains a memo field. It's located in the middle of the report page. If the data is too big to fit on the bottom half of the report, then it goes to the next page. This leaves a blank bottom half on the first / initial page. How can I get the textbox to split across pages and not go to a new page automatically?
View 3 Replies
View Related
Feb 18, 2008
hi,
please tell how to make able the asp.net page to upload a word file in sqlserver database and also retrieve it back
View 1 Replies
View Related
Jun 25, 2007
Hi All,I have come up against a wall which i cannot get over.I have an sql db where the date column is set as a varchar (i know, should have used datetime but this was done before my time and i've got to work with what is there). The majority of values are in the format dd/mm/yyyy. However, some values contain the word 'various'.I'm attempting to compare the date chosen on a c# .net page with the values in the db and also return all the 'various' values as well.I have accomplished casting the varchar to a datetime and then comparing to the selected date on the .net page. However, it errors when it comes across the 'various' entrant.Is there anyway to carry out a select statement comparing the start_date values in the db to the selected date on the .net page and also pull out all 'various' entrants at the same time without it erroring? i thought about replacing the 'various' to a date like '01/01/2010' so it doesn't stumble over the none recognised format, but am unsure of how to do it.This is how far i have got: casting the varchar column to datetime and comparing. SELECT * FROM table1 WHERE Cast(SUBSTRING(Start_Date,4,2) + '/' + SUBSTRING(Start_Date,1,2) + '/' +SUBSTRING(Start_Date,7,4) as datetime) '" + date + "'"Many thanks in advance!
View 7 Replies
View Related
Apr 15, 2007
Is there a way in rs to have a textbox more than the first value when it is dragged on the rs form when creating a report? currently when I drag a text box on the rs form, it only shows the first record on a page/form. There are twenty records on the table where the first value came from. How can I make so that twenty text boxes representing twenty records appear on twenty different pages. In other words, I am trying to build a report with a non - tabular structure that can repeat on different pages.
View 4 Replies
View Related
Feb 8, 2007
Is there a way to reference a value from a textbox in a matrix? In other words I want to pull the value in the textbox that is the column header into a cell in the matrix under certain conditions.
View 3 Replies
View Related
Aug 10, 2007
Hi All
2 post in a row first time in ages so i must be getting better but i get stuck on crappy little things like this hopefully
I have data in the following format
4.1399999999999997
4.2400000000000002
5.4800000000000004
5.1799999999999997
6.7699999999999996
i want to select the data as such
4.13
4.24
5.48
5.17
6.76
I keep chasing my tale on this one around and around any one got a simple idea i am missing, you would not believe how much time i have spent on this.
Cheers
Phil
View 15 Replies
View Related
Dec 13, 2006
Hi all,
As there is no support of check points at data flow component level, we are trying to implement this on our own. In the process of implementing we have to save values of certain user defined variables in to an xml file. To do this, we added a data flow task in the event handler OnTaskFailure. Now we want to save values of the variables in to an xml file in the data flow. Can you please suggest me how can we save values of variables in an event handler?
Cheers,
Gopi
View 1 Replies
View Related
Aug 6, 2007
Hi,
1. I have one combobox for supplierID, it displays 1,2,3...
Now i want to display the corresponing SupplierDescription in the textbox placed in the Page Header Section. If it is multiple selection then it has to be seperated by ',' (Comma).
Ex: IF i select 1,2,3 in the combobox then in the TextBox should look like
Suplliers: Ram, Don, Krish
Can you please help me in this
Thanks
Dinesh
View 5 Replies
View Related
Oct 6, 2007
the error message I get is
{"Object reference not set to an instance of an object."}
and it points to < Tickr As String = CType(FindControl("TickerTextbx"), TextBox).Text >
this is my code":
Protected Sub TickMastBtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TickMastBtn.Click
REM Collect variablesDim Tickr As String = CType(FindControl("TickerTextbx"), TextBox).Text
Dim Comp As String = CType(FindControl("CoTextbx"), TextBox).TextDim Exch As String = CType(FindControl("ExchTextbx"), TextBox).Text
REM Create connection and command objectsDim cn As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataVTRADE.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")Dim cmd As New SqlCommand
cmd.Connection = cn
REM Build our parameterized insert statementDim sql As New StringBuilder
sql.Append("INSERT INTO TickerMaster ")sql.Append("(Ticker,Company,Exchange,) ")sql.Append("VALUES (@Tickr,@Comp,@Exch,)")
cmd.CommandText = sql.ToString
REM Add parameter values to command
REM Parameters used to protect DB from SQL injection attacksWith cmd.Parameters
.Add("Tickr", SqlDbType.Int).Value = Tickr.Add("Comp", SqlDbType.VarChar).Value = Comp
.Add("Exch", SqlDbType.VarChar).Value = Exch
End With
REM Now execute the statement
cn.Open()
cmd.ExecuteNonQuery()
cn.Close()
End Sub
View 3 Replies
View Related
Mar 17, 2008
I want to have a FromDateTextBox and a ToDateTextBox where the user can enter in dates (most likely in mm/dd/yy format, although intelligently handing other formats might be a plus). Then I want to use these dates as the basis for a WHERE clause like:<some sql...> WHERE start_date BETWEEN 'FromDateTextBox.Text' AND 'ToDateTextBox.Text' (Note this WHERE clause will be used as the basis for an SqlDataSource FilterExpression). 1. I believe the date strings need to be in the format 'yyyy-mm-dd' to search SQL server is this correct?2. What's a decent way to convert the strings from the textboxes to the required format?3. How can I avoid an SQL injection attack?
View 4 Replies
View Related
Mar 23, 2006
Hi All,
I developed a report with some values in textboxes. I want the output not to wrap around to the next line but to be truncated if it is more that the size of the textbox. Is there any setting that i can do b/c values are going to the second line when their size is more like printing name and last name will cause last name to go to the second line ?
Thank you in advance.
View 5 Replies
View Related
Oct 25, 2006
Hi, it is few days I posted here my question, but received no answer. Maybe the problem is just my problem, maybe I put my question some strange way. OK, I try to put it again, more simply. I have few textboxes, their values I need to transport to database. I set SqlDataSource, parameters... and used SqlDataSource.Insert() method. I got NULL values in the database's record. So I tried find problem by using Microsoft's sample code from address http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.insert.aspx. After some changes I tried that code and everything went well, data were put into database. Next step was to separate code beside and structure of page to two separate files followed by new test. Good again, data were delivered to database. Next step: to use MasterPage, very simple, just with one ContentPlaceHolder. After this step the program stoped to deliver data to database and delivers only NULLs to new record. It is exactly the same problem which I have found in my application. The functionless code is here:http://forums.asp.net/thread/1437716.aspx I cannot find any answer this problem on forums worldwide. I cannot believe it is only my problem. I compared html code of two generated pages - with maserPage and without. There are differentions in code in ids' of input fields generated by NET.Framework:Without masterpage:<input name="NazevBox" type="text" id="NazevBox" /><span id="RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="CodeBox" type="text" id="CodeBox" /><span id="RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("Button1", "", true, "", "", false, false))" id="Button1" /> With masterpage:<input name="ctl00$Obsah$NazevBox" type="text" id="ctl00_Obsah_NazevBox" /><span id="ctl00_Obsah_RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="ctl00$Obsah$CodeBox" type="text" id="ctl00_Obsah_CodeBox" /><span id="ctl00_Obsah_RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="ctl00$Obsah$Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$Obsah$Button1", "", true, "", "", false, false))" id="ctl00_Obsah_Button1" />In second case ids' of input fields have different names, but I hope it is inner business of NET.Framework.There must be something I haven't noticed, maybe NET's bug, maybe my own. Thanks for any suggestion.
View 2 Replies
View Related
Jan 2, 2008
I have a field called "Owners", and it's a child to an "Activities" table.
An Activity can have on or more owners, and what I'd like to do is some how comma separate the values that come back if there are more than one owners.
I've tried a subreport, but because the row is colored and if another field, title, expands to a second row (b/c of the length) and the subreport has just one name, then the sub-report has some different color underneath due to it being smaller in height.
I'm kinda stuck on how to do this.
Thanks!
View 3 Replies
View Related
May 2, 2008
Hi Folks,
I have a task I wrote which does not always update the property value (as seen in the properties pane)
Basically, change something on the form, then update the task host property with:
this.taskHostValue.Properties["Duration"].SetValue(this.taskHostValue, Convert.ToInt32(spnDuration.Value));
Stepping through this, it does exactly what it is supposed to. Having a look at the property value, it confirms it has changed.
Reopening the UI and resetting all the controls returns the expected results.
The package however does not realise it has changed. There is no * next to the package name in the top tabs.
As long as the package thinks it is unchanged, SaveXML does not get called either so the tasks do not persist.
Changing the value on the properties pane works fine though.
The frustrating thing is this is slightly random. Slight in the sense that sometimes it works but most of the time it does not.
The sample code I used was the MS download IncrementTask (Which works BTW) so I can't see it as being a VS / SSIS bug but rather something I am / am not doing. 3 tasks I have written all behave the same. I have to "nudge" them before savign the package.
Any ideas what the problem might be?
TIA
Cheers,
Crispin
View 3 Replies
View Related
Dec 13, 2007
Hi Guys,
I am trying to automate a basic task using SQL Server 2005 Express.
Currently I have a query script that I run and then save the results as a CSV file. I need to do this on a daily basis and so I am looking to find out how best to go about this. There are a multitude of third party tools that claim to be able to do this - can anyone recommend this or enlighten me of the best way to set up this automation.
All ideas gratefully received!
View 1 Replies
View Related
Jun 11, 2007
Quote: Originally Posted by achoudry ps i am using sqlserver well, whaddya know, eh
do you realize you posted in the mysql forum?
i'm gonna move this thread to the sql server forum
View 12 Replies
View Related
Jun 4, 2007
Hello,
I'm trying to set textbox values when a report is rendered. Ideally I want to load all the required data for all my textboxes on my report in one dataset and have each of my textboxes query or lookup if you want that dataset to get the value I want.
Seems simple enough but I can't get it to work using Custom Report Code or any other ways. Can somebody give me any pointer regarding how I can achieve this?
Many thanks.
View 1 Replies
View Related
May 30, 2007
I've got an SSIS package that works fine. It does extracts from a foreign ODBC source and moves it to SQL Server. It has 3 variables, a customer ID, a fromDate and a toDate. Those variables are used to complete a SQL statement expression. So far so good.
I now want to provide a web interface in a web page that will enable the user to provide values for those variables. How can I execute my package passing the user's input?
Thanks for any advice.
Lou
View 3 Replies
View Related
Sep 3, 2007
Hi allI hv made a stored procedure which printsvarious messages using Print statement(shown in bold)------------------------------------------------------------------------------ .....if (@current_date<@ed) and (@current_date>@sd) begin print 'Date Lies Between Boundary Limits' select * from membership where uid=@uid end else begin if(@pipe=1) begin if(@plan_id=1) begin print 'Monthly Plan Activated' update membership set start_date=@opt_sd,end_date=DateAdd(M,1,@opt_sd),status=@opt,pipeline=0,user_option='',plan_id=null,download_limit=20 where uid=@uid select * from membership where uid=@uid end else begin print 'Weekly Plan Activated' update membership set start_date=@opt_sd,end_date=DateAdd(D,7,@opt_sd),status=@opt,pipeline=0,user_option='',plan_id=null,download_limit=10 where uid=@uid select * from membership where uid=@uid end end end --------------Now I want to retrieve the messages disp by these Print statements in my asp.net page where i m calling this stored proc.Pls suggest RegardsMunish
View 2 Replies
View Related
Jul 31, 2015
I'm looking for monitoring page file usage for SQL Server. Ultimately, I'm trying to prove that there is not a problem with a server and that it is not struggling with the workload, but someone has looked at page file usage and suggested there is a problem.
I've set up performance counters running from a separate server, but the counters relating to page file usage seem wildly inaccurate. E.g., I've got (_Total\% Usage), and (Total)\%Usage Peak), with Total Usage showing a constant value of 64, and the peak showing 92. I've also got Process (sqlservr)Page File Bytes and Page File Bytes Peak, which are showing values like 61,275,688,960 and hardly dropping below this.
If I look at Performance Monitor directly the values shown in here correlate with this, as shown in my first screenshot. However, if I look at resource monitor and look at disk activity, you can see that there is basically nothing going on (screenshot 2).
The server is more than equipped to deal with the workload, and looking at other counters for SQL there is no indication of problems, e.g. page life expectancy has a minimum value showing of 576,258, there is never less than 6GB of free RAM, SQL compilations are at a maximum of 5% of batch requests.
It is a physical server with 2x 8 core multi threaded CPUs, 64GB RAM with 58GB as the SQL server maximum. Hopefully this is enough info, but I'm happy to check anything else.
View 7 Replies
View Related
Dec 10, 2007
Hi ,
I am working on Sql server Reporting Services(Sql Server 2005),
i have designed a Report and deployed that report on Report Server, on this report i need to show the user selected values
in page header by using Parameters which i have already created in the Report.
There are 35 to 40 fields in the Front End(Asp.net2.0)
on passing all these values from front end Report is prompting for parameters which is not desired for my case even though i have made ShowParameterPrompts to false.
Thanks in advance
Srinivas Govada
View 1 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related