How do I restrict the number of input fields in the form to match the size of the columns? Table Columns Reads:
state: Type Char; Length: 2
zip: Type: char; Length: 5
Phone: Type: char; Length: 12
Fax: Type: char; Length: 12
Email: Type: nvarchar; Length: 256
BoundField Reads:
[Code]....
I'd like to add a description field to an application that can be as long as several lines (or even paragraphs) or as short as a one-liner.Instead of taking up a lot of screen real estate or have scroll bars, it would be preferable to have the textbox grow based on its input.
On IE6 adding Style="overflow-y:visible" accomplishes this nicely (both on display of read only, and if we are in edit mode).
However, it has no effect on Firefox, or IE7 for that matter.
What i am trying to achieve is that there are 7 columns in my db table. one is primary key and rest 6 are integer columns. Now my application will allow user to input 6 values. I want to compare 6 values entered by user to those 6 integer columns and if in any row 3 or more columns match user's input Primary key of that table is returned..
I have tried using queries, cursor, nested loops and i am still unable to achieve my results..
DB Table Structure.. I am inputting 2,3,7,11,45,65. Number of returned rows should be 5. eg..
UID A1 A2 A3 A4 A5 A6
-----------------------
1 2 3 4 5 6 7
2 2 3 4 55 56 57
3 65 11 45 66 67 68
4 45 7 11 99 98 97
5 7 7 7 7 7 7
6 7 7 7 7 7 7
7 8 8 8 8 8 8
8 8 8 8 8 8 8
9 45 45 0 3 1 2
10 65 7 4 0 0 0
IDs returned should be 1,3,4,9,10
I have the following stored procedure and if I execute this on our SQL analyser it returns the record no problem what so ever. BUT if I execute this through ASP.NET (I am using EntitySpace objects) to generate this query into data table and it saying that: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns."
I've discussed this with EntitySpace team and they said it's query issue? We are stuck with this issue and any guidance or hints that will be good.
The environment that we use:
.NET 4
EntitySpace 2010
SQL Server 2005 Database
ALTER PROCEDURE [dbo].[rpt_CPRRespondListReport]
(
@SurveyID INT
)
AS
BEGIN
SET NOCOUNT ON;
[Code]....
Scenario: I have a form with 3 input fields (text1, text2, text3). Is there a method to capture these fields in the aspx file of a second webform? I think you have to use someting like <%= %> but I'm not sure.Idon't want to use the code behind file because the number of input fields is dynamic
View 5 RepliesI am trying to add row in DataTable CartDT using row[], which is a string array.
DataTable CartDT = new DataTable();
public void DataTableColumn()
{
CartDT.Columns.Add("Product_Name", typeof(string));
CartDT.Columns.Add("Product_ID", typeof(string));
CartDT.Columns.Add("ItemQTY", typeof(string));
CartDT.Columns.Add("Price", typeof(string));
CartDT.Columns.Add("TotalPrice", typeof(string));
[CODE]..
Now when I execute it, it gives the error that "Input array is longer than the number of columns in this table" The array row[] has exactly 5 elements in it & also DataTable CartDT has also 5 columns. Now i am not able to find exactly where i am wrong.
I have a forum like page ( vBulletin like page). There are mainly two columns involved. User and Decription. The page looks like this
User Description
-----------------------------------------
userpic Subject
username Description
Download link
-----------------------------------------
user pic Subject
username Description
-----------------------------------------
user pic Subject
username Description
-----------------------------------------
In it , userpic, username, subject and descriptions are to be repeated every time. I used listview for this.. But the column 'download link' is to be used at once only in the first post ( of thread author). So, how can I achieve this. I am using asp.net 3.5 and sql server 2005.
I added requiredvalidator to validate the input field in hte detailviews control. the only probably problem is error message shows up when form popup. I only want to show the error message after I click on the submit button. here's my code.
<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/main.Master"
CodeBehind="WebForm4.aspx.vb" Inherits="hospital.WebForm4" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:GridView ID="gvList" runat="server" DataKeyNames="taxID" DataSourceID="odsList"
EnableModelValidation="True">
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
<asp:DetailsView ID="dvDetail" runat="server" DataSourceID="odsDetail" EnableModelValidation="True"
Height="50px" Width="125px" DefaultMode="Edit">
</asp:DetailsView>
<asp:ObjectDataSource ID="odsList" runat="server" SelectMethod="GetHospitals" TypeName="hospital.Hospital">
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="odsDetail" runat="server" SelectMethod="GetHospitalsByTaxID"
TypeName="hospital.Hospital" UpdateMethod="Update">
<SelectParameters>
<asp:ControlParameter ControlID="gvList" Name="taxID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:ControlParameter ControlID="dvDetail" Name="nTaxID" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="dvDetail" Name="sHospitalName" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="dvDetail" Name="sAddress1" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="dvDetail" Name="sAddress2" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="dvDetail" Name="sCity" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="dvDetail" Name="sState" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="dvDetail" Name="sZip" PropertyName="SelectedValue"
Type="String" />
</UpdateParameters>
</asp:ObjectDataSource>
<asp:LinkButton ID="lbnSave" runat="server">Save</asp:LinkButton>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:ModalPopupExtender ID="upAdd_ModalPopupExtender" runat="server" TargetControlID="btnAdd"
PopupControlID="pnlAdd" BackgroundCssClass="modalBackground" OkControlID="btnOk"
CancelControlID="btnClose">
</asp:ModalPopupExtender>
<asp:Button ID="btnAdd" runat="server" Text="Add" />
<asp:Panel ID="pnlAdd" runat="server" CssClass="modalPopup">
<asp:UpdatePanel ID="upAdd" runat="server" UpdateMode="Conditional">
<ContentTemplate>
sdfsdfsdfsdfsdf
<asp:FormView ID="FormView1" runat="server" DataSourceID="odSrcHospital" DefaultMode="Insert">
<InsertItemTemplate>
<table>
<tr>
<td>
taxid
</td>
<td>
<asp:TextBox ID="tbxTaxID" runat="server" Text='<%# Bind("nTaxID") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvTaxID" runat="server" ControlToValidate="tbxTaxID"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
h name
</td>
<td>
<asp:TextBox ID="tbxName" runat="server" Text='<%# Bind("sHospitalName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvHospitalName" runat="server" ControlToValidate="tbxName"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
add1
</td>
<td>
<asp:TextBox ID="tbxAdd" runat="server" Text='<%# Bind("sAddress1") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddress" runat="server" ControlToValidate="tbxAdd"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
add2
</td>
<td>
<asp:TextBox ID="tbxAdd2" runat="server" Text='<%# Bind("sAddress2") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAddress2" runat="server" ControlToValidate="tbxAdd2"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
city
</td>
<td>
<asp:TextBox ID="tbxCity" runat="server" Text='<%# Bind("sCity") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvCity" runat="server" ControlToValidate="tbxCity"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
state
</td>
<td>
<asp:TextBox ID="tbxState" runat="server" Text='<%# Bind("sState") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvState" runat="server" ControlToValidate="tbxState"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
zip
</td>
<td>
<asp:TextBox ID="tbxZip" runat="server" Text='<%# Bind("sZip") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvZip" runat="server" ControlToValidate="tbxZip"
ErrorMessage="Required" Display="Static" SetFocusOnError="true" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="submit" Text="submit" runat="server" CommandName="Insert" />
</td>
</tr>
</table>
</InsertItemTemplate>
</asp:FormView>
<br />
<br />
<asp:Button ID="btnOk" runat="server" Text="Ok" />
<asp:Button ID="btnClose" runat="server" Text="Close Me" />
</ContentTemplate>
</asp:UpdatePanel>
</asp:Panel>
<asp:ObjectDataSource ID="odSrcHospital" TypeName="hospital.Hospital" SelectMethod="GetHospitals"
runat="server" DeleteMethod="Delete" InsertMethod="Update" UpdateMethod="Update">
<DeleteParameters>
<asp:ControlParameter Direction="Input" DefaultValue="0" ControlID="grdHospital"
Name="taxID" />
</DeleteParameters>
<InsertParameters>
<asp:FormParameter FormField="tbxTaxID" Name="nTaxID" Direction="Input" />
<asp:FormParameter FormField="tbxName" Name="sHospitalName" Direction="Input" Type="String" />
<asp:FormParameter FormField="tbxAdd" Name="sAddress1" Direction="Input" Type="String" />
<asp:FormParameter FormField="tbxAdd2" Name="sAddress2" Direction="Input" Type="String" />
<asp:FormParameter FormField="tbxCity" Name="sCity" Direction="Input" Type="String" />
<asp:FormParameter FormField="tbxState" Name="sState" Direction="Input" Type="String" />
<asp:FormParameter FormField="tbxZip" Name="sZip" Direction="Input" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="nTaxID" Type="Int32" />
<asp:Parameter Name="sHospitalName" Type="String" />
<asp:Parameter Name="sAddress1" Type="String" />
<asp:Parameter Name="sAddress2" Type="String" />
<asp:Parameter Name="sCity" Type="String" />
<asp:Parameter Name="sState" Type="String" />
<asp:Parameter Name="sZip" Type="String" />
</UpdateParameters>
</asp:ObjectDataSource>
</asp:Content>
I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me? I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview. I have more than 1 data to input. Do i need to use loop to bind?
View 7 RepliesI work on C# .My input file look likes :
d00 d04 WinMain
d00 d04 lpCmdLine: '/UNREGSERVER'
d00 d04 Run
d00 d04
lpCmdLine: '/UNREGSERVER'
d00 d04 nCmdShow: 10
d00 d04 leaving WinMain
[code]....
If i use the multi delimited than error shows.How to use the multi delimited.If i run the code to to load the text file given in above show the bellow error
Input array is longer than the number of columns in this table.
i have a gridview with textbox for change the target value, how to set the textbox only number for input?
heres my code:
[code]...
What would be the best way to handle the following scenario? I have an application where depending on what type of proceeding is selected, only certain input fields should be visible.
There are 33 proceeding types and 14 input fields in total
First case, make one big form with all of the fields and have a dropdown with proceeding type which depending on what is selected, makes certain fields visible?
I have a details veiw and when you open it there are far too many fields so it ends up disappearing off the screen. I would like to split the view into two columns, and I tried to add a DIV with css class halfaway down the details view but it dosen't like divs being there. Is there a way round it? You can do it with FormView but i prefer DetailsView
View 4 RepliesI want to put an input table on a web page using ASP.NET. The input table has 3 columns: date, quantity, and price. The number of rows is variable, depending on user input. The code behind will read the data and perform the necessary calculations. The data will not go into a database. It would be nice to have some client-side or server-side validation for the data, such as required fields and range checking.
Which control(s) in Visual Studio 2008 will perform what I want to do?
I have 3 tables as follows:
1 - Members containing the following fields:
MemberID int
MemberName
2 - Companies containing the following:
CompanyID int
CompanyName
CompanyType (S=Supplier, R=Retailer, C=Competitor)
3 - Member_Company_Link containing the following:
MemberID int
CompanyID int
The Company table contains any Company with a potential relationship to a "Member". For example:
Companyabc = C (Competitor)
Companyxyz = S (Supplier)
When a new Member record is entered, the user selects from two dropdowns: CompanyType (Supplier, Retailer,Competitor); and CompanyName. The CompanyName dropdown is populated depending on the value selected for CompanyType so if the user selects "Supplier" for CompanyType then only those Companies with a CompanyType of "S" for Supplier will be listed in the CompanyName dropdown.
The use can enter up to 10 CompanyType/CompanyName combinations. When the record is saved, these CompanyType/CompanyName combinations are saved in the Member_Company_Link table. One record for each CompanyType/CompanyName combination is entered in the table.
The problem I'm having is in the retrieval process. I have a "search" screen in which users can select certain criteria to list Members by and one of them is CompanyName. For example they want to see all Member records with "company xyz" as a Supplier and/or "companyabc" as a Competitor. Because each Member can have multiple Supplier and/or Comptitor records I can't figure out how to loop through them to match on the value entered by the user. If Member1 has 5 corresponding records in theMember_Company_Link file and 4 of them contain Companies that are Competitors (Competitor1, Competitor2, Competitor3 and Competitor4) and the search criteria is to find records containing "Competitor3" how can I loop through the values in the Member_Company_Link file for each MemberID to see if there is a match for "Competitor3"?
I know this post is too long and most of you will have ignored it by now but I'm hoping someone will have a clue because I've already spent more than a day trying to figure it out. It seems I have to store multiple values in an array but I have no clue how to do this.
My datasource is an ado data table that I have convert to a new data table so that each row in the original table is now a column with 1 row in my new table. I then bind the new datatable and create dynamic template fields with a text box where I bind the values. My problem is, when I try and retrieve the values changed by the user in the rowcommand event, the template columns no longer exists.
Does anyone know how i can retrieve these values? I've read over and over that you have to rebind the grid on each postback when you use dynamic templates, but I'm not sure how to do that and retrieve the values entered in the text boxes on the client side.
[Code]....
In my gridview I have a datetime columns and couple of decimal number columns. Lets say I have a datetime value like this 19.03.2011 00:00:00 and I want it to seem like 19.03.2011. And I would like 2 decimal digits only. How can I achieve this?
View 2 RepliesIm developing an ASP Web application and have a Gridview which I have set as follows:-
[Code]....
At this point alls good.
I have a field in the selected table that returns an integer which relates to a Table on a Seperate Database.
Is it possible, when the grid is being filled to check a fields value and set anothers columns value depending on the vale?
ie First Row Column 1 value is 1 so set Column 2 to "Sunny"
Second Row Column 1 value is 2 so set Column 2 to "Cloudy"
I have a Gridview with 12 columns, Jan, Feb...Dec.
I have a textbox value that could be 1, 2,...12
I want if textbox value is 7, then column Aug-Dec in Gridview is editable when in update mode and the column in Jan-Jul is not updatable (eg make it label instead of textbox).
How can I do this ?
How to calculate input values by each row in gridview ?
Example input quantity is 10, then generate the serial number for each row quantity is 1
Actual expect result
I have a web form that is a Purchase Order. It requires the user to enter a few dates and their personal information as well as picking stock to add to the po. The problem is after the user has entered all their data then then goto add stock and they are taken to a stock listing page, when they return to their form all the data the previously entered (name, department etc) has gone and they have to re enter it. How can I ensure that onces the user has entered this data, it stays there until the form is submitted or reset?
View 3 RepliesI have 65 columns in the grid, if the columns are reduced to 20 then the speed when accessing from client is more or less similar to that accessing from web browser. Does it mean that all this performance issue is due to the data only ???
View 1 RepliesCurrently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
I have the following .ashx page that takes some query string parameters and returns a bitmap with the specified text written on it. The problem I have is that I am currently just manually setting the initial size of the bitmap at 100 X 100 when what I really want is to have the bitmap be just big enough to include all the text that was written to it. How can I do this?
[Code]....
I have an e-mail field, and a confirm e-mail field. I need to validate both of them to make sure their values match.
Is there a way to add a rule to match those two fields?