I have added a dropdown in a column of my gridview control and it is binded to a table. What I need is when the user selects an item from the dropdown, it updates the row with other info. They are selecting an item number and I need the item description and price to be filled in for two other columns in the row. How can I do this on an event?
View 4 Repliesi have the following two questions:-
1. let say i have a table for ITEMS including (item id,item description id (FK to the ITEM Description tabe), item price,etc) and have ITEM Description look up table having (item descriptionid,item description),.
so what is better to use the ITEM DESCRIPTION look up table and store the item description id in the items table
or
to directly store the item description "Not the id" in the item table.
2. I am working on an MVC web application using LINQ, now if i want to modify the SQL server tables which i have created for example modify some of the foreign key properties will the effect be directly reflected on any new inserted or deleted records or i have to create a new LINQ to SQL class?
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc? if so, how?
View 3 RepliesI have a MVC dropdown list (Html.DropDownList) with list of Movies populated. I want to retrieve both Title(value field), Description(Text field) when I perform the form Submit. I can access the Title(value field), but I can't access the description. My code sample is below.
[Code]....
public string CinemaName { get; set; }
Im 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'm building an application, my client wants me to create new control using AJAX. This control should look like thisThis control includes price(dolars and cents) and when user clicks on specific price(suppose 95 dolars and 33 cents) this price should jump inside to textboxs(one for dolars and one for cents)Does anybody have a clue how to implement this control creation??
View 4 Replies<asp:FormView ID="FormView1" runat="server" DataKeyNames="productnum"
DataSourceID="EDS_Product">
<ItemTemplate>
<div class="ContentHead"><%# Eval("name") %></div><br />
<table border="0">
<tr><td style="vertical-align: top;">
<img src='images/big/<%# Eval("image") %>' border="0" alt='<%# Eval("name") %>' /></td>
<td style="vertical-align: top"><%# Eval("description") %>
<br /><br /><br /></td></tr></table>
<span class="price"><b>Your Price:</b> <%# Eval("price", "{0:c}")%><br /><span class="number"><b>Number:</b> <%# Eval("number") %>
</span><br /><a href='AddToCart.aspx?productnum=<%# Eval("productnum") %>'>
<span class="ProductListItem"><b>Add To Cart<b></font></span></a>
</ItemTemplate>
</asp:FormView
this is from the product details page and the description goes in a straight line always - i want to make the description a box and have lenght of 30 characters every line -- i want to modify the description not to be in a straight line
I have in my database the News Table which consist of => Id, Title, txt . I need to be able to get a description text from the whole text which exist in txt Field , but without any codes like <...> , just a pure text !! how can I do this?
View 3 RepliesIn gridview boundedField, some Departments are listed like:
CIT
Customer Change Mind
Customer Issues
Logistics
Regional Engineering
Regional Sales
Can I change the order like:
Regional Sales
Regional Engineering
CIT
Logistics
Customer Issues
Customer Change Mind
I mean to say the list will not be on Asc or Desc. May I change order as per my own list order?
I've got a tough one (at least for me!). I have a gridview control which is actually from ComponentOne but most is the same as the normal gridview. It has a feature that lets me move columns around so they are in different order. I want to be able to click a button and see the order of these columns and which ones are visible. This is to be used for a custom report I am generating.
Does anyone know how to find out what columns are visible and in what order? I'm doing it in VB coding for asp.net.
I have seen code for adding columns at runtime but here is another scenario for you. I am using a SQLDatasource control for my gridview. And the data returned can have different columns based on the filter meaning one time I may have a column A1, A2, A3 and another time I may have A2, A3, A4. Is there any way I can look at the columns when it is binded at the beginning and add the columns first?
I really need to use the SQLDatasource though because I am connecting to an AS400 and it is using a connection already made in the webconfig and do not know any other way. I do if it was MSSQL server but not this.
I am trying to build a program that will have 3 DetailsView side by side but I want to have an empty textbox next to each field....
I cant seem to be able to get a column in between and I don't see a way to add a column to the detailsView only a field
Here is what I want it to look like
DetailsView:
Field Name Value I want to add
Color Red MyTextBox
My program is reading a textfile from the users computer using text field parser and creating a data table then I am using the details view to display that data vertically rather then horizontally.
So instead of
Address City state
I can go
Address
City
State
I have a simple gridview control on .aspx page. It has one combo box in the gridview control and rest of the columns in the gridview control are all bound controls.
When the user picks something from combo box, I should multiply the number (picked from the combo box) with other number in the same row (meaning in a different column on the same row). I want to do all this in server controls not thru JQuery or Javascript.
Basically my problem is I am able to read data from unbound combo box control in the grid. But I should be able to read the contents of another bound column in the same row and perform multiplication between those two fields.
Code:
<asp:GridView ID="GridViewActuals" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="gl_number"
onrowcommand="GridViewActuals_RowCommand" Height="285px"
onrowdatabound="GridViewActuals_RowDataBound"
onrowupdated="GridViewActuals_RowUpdated"
Font-Names="Verdana" onrowupdating="GridViewActuals_RowUpdating1">
[Code] ....
I am trying to set come columns to invisible after all of the rows are binded but I'm having trouble. I'm hiding columns that have empty data which I save in a session variable. This works fine. Then I tried changing the columns visible property using the ColumnByName routine in the DataBound but that must be the wrong event because I do not think the columns exist yet.
The columns are autogenerated btw.
Where can I set the columns properties after it has binded? Can i do this before the columns are autogenerated the the screen itself?
In gridview [ID] and [ProdName] is BoundField and [ThumbNail] is TemplateField.. I use the code below but the image still doesn't show..
Code:
DataTable oTable = new DataTable("ItemList");
oTable.Columns.Add("ID", System.Type.GetType("System.Int32"));
oTable.Columns.Add("ProdName", System.Type.GetType("System.String"));
oTable.Columns.Add("ThumbNail", System.Type.GetType("System.String"));
[Code] .....
I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?
View 2 RepliesI have a gridview that I am loading from a stored procedure. I need to be able to hide certain columns and change the column names. Since it is loading with stored procedure the columns aren't listed in the gridview->edit columns properties.
View 1 RepliesI am trying to use the AjaxControlToolkit in Visual Studio 2008.
I download the current binary package 40412 for .NET 3.5 (and have also tried previous binary package 30930 for .NET 3.5). I extract the contents. I start a new web site. I add a new tab and point it at the extracted AjaxControlToolkit dll. I select an item [Editor] from the list of new Tools and plonk it on a webpage - my bin folder is then updated with a whole host of new dlls.
Unfortunately when I click 'start debugging' to test item on the website I am presented with a pop up box titled "Find source" requesting the location of file "ScriptObjectBuilder.cs"
Original location given is i.e. for previous 30930 release - "C:UsersswaltherProjectsAspNetAjaxReleases30930AjaxControlToolkitSourceAjaxControlToolkitExtenderBaseScriptObjectBuilder.cs"
Note: I googled this problem and another programmer stated that when he got this problem he pointed this "Find Source" dialog at the ScriptObjectBuilder.cs file taken from the corresponding source package and found it still didn't work.
I am on Visual Studio 2008 SP1 as required.
I'm using Visual Studio 2008 version 3.5. I have a dropDownList with over 800 names. The user wants to be able to type in it and select the name. I have seen this functionality in Telerik combobox but do not have license. How this functionality can be accoplished?
View 20 RepliesI have a textbox added in an item template so I can enter data. But when I press enter in a textbox it caused the page to postback and I lose the data entered. I can tab through fine but why does Enter cause a postback? Can I disable this?
View 1 RepliesI'm new at ASP.NET. I'm trying to follow the first video tutorial in this link (Web Forms): [URL]. I see the guy using the same IDE as I use. He goes to File > New Project. I do not have the NEW PROJECT item in the FILE tab. Therefore I cannot follow the steps. I do not have the templates either for MVC or Web Forms
Using: .NET framework 3.5
I am using Visual Studio 2008 Professional Edition. I googled for the same, it says u might not have selected crystal reports feature while installation of vs. I am sure that i had selected installtion type = Full/Complete.
So has it anything to do with vs service pack etc. I dont have VS 2008 SP1, but VS 2008. Or wud be better if we can add crystal report component explicitly. (kinda standalone installer for crystal reports and then it will automatically merge with VS.)
Visual Studio 2008 doesn't have item templates for ASP.NET Mobile Web Forms (which were previously available in Visual Studio 2003).What about VS2010? Same lack?
View 1 Repliesi am making relation between two datatables and m getting this error
in this ds.Tables(0).Columns("In_ID") datatype is string
ds.Tables(1).Columns("row_id") datatype is integer
how i do the type casting here to make dataset relation
ds.Relations.Add("Rel_1", ds.Tables(0).Columns("In_ID"), ds.Tables(1).Columns("row_id"), True)
I am using Visual Studio 2010 and have a full version of SQL Server 2008 (not SQL Server Express 2008). I would like to be able to use the database that I created in Sql Server 2008 (not sql server 2008 express) but when I go to app_code -> Add Item and select SQL Server I get the following error message:
"Connections to SQL Server database files (.mdf) requires Sql Server 2005 Express or Sql Server 2008 Express to be installed an running on the local computer ..."
Do I really need to have sql server 2008 express installed on my local computer when I already have the full blown version of Sql Server 2008 installed on my local computer.