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>&nbsp;&nbsp;

                                        <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

How Can I Avoid Lots Of Spaces Being Added To The End When Saving Contents Of A Textbox

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

Building Dynamic Query Based On Dropdownlist Contents

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

Using DropDownList And TextBox To Filter Results...

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

Search For Database Using Textbox And Dropdownlist

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

How To Refer To Report Textbox Values In Another Textbox

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

DB Engine :: Saving Data From One Textbox To 2 Tables?

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

Who Knows How To Generate A Contents Page Consisting Of Sub Reports?

Feb 13, 2007

Is this possible?, i hope it is:). Your help is very much appreciated.

View 2 Replies View Related

Textbox In Every Page

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

Page Break With A Large Textbox...

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

T-SQL (SS2K8) :: Replacing String Values With Contents Of Variable

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

Textbox Goes To New Page And Doesn't Split Across Pages If Height Is Too Big

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

Saving A Word File In Sql Server From ASP.NET Page

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

Checking Contents Of Column And Replacing Contents If First Character Is A Letter

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

Getting Textbox To Show All Values

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

Referencing Textbox Values

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

Saving Values

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

Saving Values Of A Variable

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

SSRS Report Multiple Values In TextBox

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

Need Help Inserting Data Into Table With Sql Insert Into Using Textbox Values

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

Use TextBox Values In WHERE Clause To Perform Date Search?

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

Where Can I Find Wrapping Or Truncating Property Of Values In A Textbox!

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

Inserting TextBox Values To Database Using SqlDataSource.Insert Method

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(&quot;Button1&quot;, &quot;&quot;, true, &quot;&quot;, &quot;&quot;, 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(&quot;ctl00$Obsah$Button1&quot;, &quot;&quot;, true, &quot;&quot;, &quot;&quot;, 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

Show Multiple Values In Single Textbox Comma Separated

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

Custom Task Not Updating Property Values Or Saving.

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

Automating A Query And The Saving Saving Of Subsequent Results

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

Page 2 - Deletion Of Duplicate Values

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

&"Lookup&" Values In Textbox

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

Passing Values For Variables To An SSIS Package From C#/ ASP.NET Page.

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

Retrieving Values From Print Statemens In Stored Proc In Sql Into Asp.net Page

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

SQL 2012 :: Tracking Page File Usage - Values Appear Incorrect

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

How To Show The User Selected Values In Page Header By Using Parameters Which I Have Already Created In The Report

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

Reporting Services :: All Record Are Displaying On One Page - How To Display Page By Page

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







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