I am trying to add a bit field with a default value of false to an existing table using VWD 2010 Express. With the allow nulls checkbox turned off and no data in the table, any value I attempt to enter into the default value box (0,(0), ((0)), False) all produce an error when exiting the field. What's the secret?
View 13 RepliesI have a SQL Server table with a number of fields that are defined with the "Float" data type. I'm running a simple query to retrieve the data from this table and use it to populate a Data Table in my C#.net application.
I just discovered that the data type of the Data Table fields is Double, not Float as I expected. As such, when I store a value like 0.157 it ends up getting stored like this: 0.15700000524520874
I'm aware that such extra "noise" occurs when such a conversion occurs. My major question has to do with why .Net didn't set the Data Type to Float (ie. Single) when the table was first populated?
I am new to .NET and MVC, so this is most likely a simple question: How can I have a default value appear for an Html.TextBox or TextArea field, for example if the code is currently - <%=Html.TextBox("ApplyToFax", Model.Competition.ApplyToFax, New With {.class = "regular", .maxlength = "50"})%>. I am looking to have a default fax number appear in the box when the page loads, for example (999) 999-9999.
View 5 Replies.NET newbie. I know there has to be a way to do this.I have a details view with it's default mode set to Insert. This is to be used as a form for users to enter records into a database. For two of the fields, I want to pre-populate the field with information. Specifically, I have a vb script with a few functions to query Active Directory to return the user's name based upon their user id. This script works fine.I call the functions for the user name like this:
<InsertItemTemplate>
<asp:TextBox ID="txtUserID" runat="server" Text='<%#CurrentUID() %>'></asp:TextBox>
</InsertItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtUserName" runat="server" Text='<%# GetUserName(CurrentUID()) %>'></asp:TextBox>
</InsertItemTemplate>
When the page loads, this populates the text boxes with the user id and the user name.But when the form is submitted, the values in the text boxes are not inserted in to the database.How can I set default values for the fields when the values come from functions?
This may be a simple question but here it goes. I have an insert form that captures the current date of entry. What I would like to do is not cause the user to enter or select the current date but have it display on page load and capture to the field in the table on submit.I am rather new to ASP and am using Visual Web Studio 2008.
View 4 RepliesI have this code setup currently:
TreeView tree;
TreeNodeBinding treeNodeBinding = new TreeNodeBinding();
treeNodeBinding.TextField = "Name";
treeNodeBinding.DataMember = "Address";
treeNodeBinding.ValueField = "Zip";
treeNodeBinding.ToolTipField = "FileName1";
tree.DataBindings.Add(treeNodeBinding);
tree.DataSourceID = "Customers";
tree.DataBind();
The datasource (XML) may or may not have an optional attribute called IsPremium. If it exists, then I have to add custom business logic that determines what the treeNodeBinding.ToolTipField is going to be. The custom business logic will generate a string which needs to be set as the value of the ToolTipField.
My web-based app allows users to override values in certain textboxes. If they don't override the value, the system will display (and use) a default.
I would like to support a scenario where the user has overridden the value, but now wants to revert back to the system default value, but doesn't know what value to enter. I would like to provide an intuitive UI for causing the system to revert the field's value back to its default.
Fields occur both on edit forms (where space is plentiful), as well as on edit grids (where space is scarce).
Requiring the user to clear the field is not an option, as sometimes the user's override is an empty value. Would rather not use a keystroke, like Ctrl-Z or ESC.
Best thing I can think of is the user hovers over the field and a popup displays giving the user the option to use the system default. I could use the same popup to capture/display a comment related to the override.
So question from a Newbie !So I have a web page with a Details View component for Inserting data into a table.One of the fields is a date/time which I want to be now().SO I guess there are 2 ways of doing it - either I populate the date/time field in the form with a variable that represent now() and make it Read Only so the user can't change it or I somehow make a hidden variable (ie not displayed in the form) that writes a date/time of now() into the database whenever an INSERT takes place.What is the best way and how do I do either of them ? How do I make one of the fields in the INSERT form of the Details View a preset variable ?
View 10 RepliesI have GridView with template column binded to some field. In edit mode I would like to set default value to this field when it is not initialized (this is time value and I would like to set it to default 8:00 - this prevent user from entering this value) - how to do this?
View 4 RepliesI have just a form with several text boxes and two buttons one with next and anothe with previoues i have writtern code
<form id="Info" method="post" runat="server" defaultbutton="btnNext">
</form>
very first when the page loads the focus willl be on the next button, when i try to enter the text in the text box, focus changes from the next to the previous button (Previous button is the first button i have).
Is that possible? The reason why am doing this is because I need to parse that variable into a an JQuery function so I wanted JQuery to read that field. Can I Assign that value in base class or I have to do it within default.aspx pageload method?
View 1 RepliesWhen i created a simple site via Matrix which adopts Razor technology by default, i found site automatically display "default.cshtml" if started through "http://localhost:xxxx/bread/" ; however i hadn't set "default.cshtml" as "default document" for this site, even i seek in the "applicationhost.config" i just find
<defaultDocument enabled="true">
<files>
<add value="Default.htm" />
<add value="Default.asp" />
<add value="index.htm" />
<add value="index.html" />
<add value="iisstart.htm" />
<add value="default.aspx" />
</files>
</defaultDocument>
which apparently hasn't "...cshtml" yet. So I am wondering now why in this case the web server actively sets "default.cshtml" as default start page ?
is it possible to change the default date values accepted by sql server to dd,mm,yyyy instead of the default mm,dd,yyyy?
View 3 RepliesI have one asp.net application using Sql server as back end.. in sql server database i have one table which consist two fields.. ItemName and RateI have one notepad file which consist around 700 ItemName with Rate..
So how to get this ItemName and Rate in my Table...
i need to set a default value for a column of date
i need when the column dont get a date automatic set 1/1/1900 for it.
i am trying to filter data as is. the default value for showing any record if no value enter into textbox does not show all?
[Code]....
I have 2 instances of SQL Express installed:
SQL 2005 -> .SQLEXPRESS
SQL 2008 R2 -> .SQL2008
I have Visual Studio 2010 configured to use .SQL2008 by default in Tools->Options->Database Tools. In Server Explorer, it tells me that it's connecting to the database via 2008.
However, when I run an ASP.NET sample I downloaded (that has it's own ASPNETDB.MDB file), I get a version error (612 vs. 655). I understand that means it's connecting to the 2005 instance instead of the 2008 instance.
How can I make it connect to the 2008 instance? The web.config file has no connection strings, so everything is default.
I have a simple asp.net web page that contain a table with about 5 TR and each row have 2 TD .. in the page load I get user data ( 5 property ) and view them in this page the following are first 2 rows :
[code]....
I always used <asp:Label to set value by code but i always notice that label converted in runtime to span so i decided to user span by making him runat=server to be accessed by code, so Which is better to use asp:label or span with runat=server?
I hope you can answer the following question for me. I have a server with win 2008 installed and a simple asp.net application that is successfully sending a email through System.Net.Mail.Smtpclient("localhost").Now my 1st question is, how exactly is this mail sent if there is no Default Smtp Virtual Server installed?Next question...I get an error when I try to send an email that is larger than around 4MB. I know this is to do with the limit that is specified on the server but where is this limit set?
Third Question...fter installing a new Smtp Virtual Server #1 in the IIS6 console, I am able to see and change the file size limit on email but I cannot work out for the life of me how to send emails from my asp.net application through this smtp virtual server.Obviously the best fix for me would be to work out where the default smtp server is and how to manage it rather than installing another one and then trying to route all applications through this new virtual server.When I think I set it all up correctly I get the old "Mailbox unavailable. The server response was: 5.7.1 Unable to relay for (email address)", ie I have given my new virtual smtp server a unique ip and port number and changed the Smtp E-mail page within IIS to point to this new server.
I have a column in my .mdf file with the 'uniqueidentifier' datatype. I would like to have it set by SQL Server Express automatically. There are articles on the web that recommend using one of the following commands as the default value:NEWID()NEWSEQUENTIALID()I put this in VS 2010 column properties of my table, in Default Value or Binding. The first command works fine but the second turns out showing an error message 'error validating the default for column xxxx'Any advice on this? I'm I missing much using the first command?
View 6 Replieshow do I stop the default website from trying to connect to sql server?The web.config has no connection strings but yet I get "network related or instance specific error occurred while establishing a connection to sql server".i do not want to connect to sql server, have not told it to connect to sql server.
View 2 RepliesI want to know how to make IIS as default web server on machine instaead of built cassini web server..
View 5 RepliesI'm trying to execute a simple insert statement with the GUID and timestamp populated by default from the server. I have both of their default values set as (newid()) and (getutcdate()) respectively in SQL server. However, I receive the error when I try and execute the command "Insert Error: column name or number of supplied values does not match table definition". How do I construct my sql insert so my id and timestamp columns use their default values as assigned in sql server?
[Code]....
if there is a way to determine if the default document has been served using .net? I thought perhaps something would be available in the server variables, but I can't seem to find anything that distinguishes between [URL] and [URL]
View 3 RepliesI want to make my column unique identifier as well as the indexer.I used autoincrement property but when we delete specific row then the below rows are not in order like
if we have
1
2---delete 2nd row
3
then it will be
1
3
but i want the o/p as
1
2----3rd row is now 2nd row
Is there any way like 'Default value or Binding=Row_Number()' something??