If Condition Checking Two Control Values?
May 12, 2010How to write an if condition, to check to see. only one can have value not both at the same time.
txtResubmitNoDays.Text or cpuResubmitDate.PostedDate.ToString
How to write an if condition, to check to see. only one can have value not both at the same time.
txtResubmitNoDays.Text or cpuResubmitDate.PostedDate.ToString
In Global I have the following code that redirects the page to use HTTPS. I also have a SPROC that adds a record when a user visits a page. When a user visits a page, the SPROC is adding a record for the HTTP and then another record using the HTTPS. I'm not sure how to handle just adding one record. Is there something to add to the SPROC that will delete one of the records or should I do a code behind on an aspx page that executes the SPROC "IF" the page starts with HTTPS? HOw would I set up the condition to check for the HTTPS?
[Code]....
i am trying to create a temporary table as like an existing table.
create table #tmp AS ( select Table1.* from Table1 where Table1.column name in (select Table2.column name from Table2 where conditions) )
But it is showing Error...
protected void rptNavigation_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e){
if (!((e.Item.ItemType == ListItemType.AlternatingItem) || (e.Item.ItemType == ListItemType.Item)))
{return;
}string Name = string.Empty;
if (IsDBNull(e.Item.DataItem["FullName"])) {
Name = String.Empty;}
else {Name = (string)(e.Item.DataItem["FullName"]);}
Literal ltlLiteral = (Literal)(e.Item.FindControl("ltlLiteral"));
ltlLiteral.Text = Name.ToString();
I get error for IsDbNull - Error 1 The name 'IsDBNull' does not exist in the current context. What's the best way to check for null values returned from db? also I get errors on both lines where (e.Item.FindControl(ltlLiteral")); is present ERror: Cannot apply indexing with [] to an expression of type 'object'
I would like to know the fastest/easiest way to check if a CheckBoxList control has any checked items or not, I'm talking about an entire checkbox list as a whole, not a single checkbox.
View 1 RepliesI want to know which fields were edited in a form in the Edit Action. I have a Log field in a table named "someTable" which I wish to add the change to, along with the Username of the current user. This is a simple implementation:
[Code]....
Can someone tell me where I am going wrong, because the getChangedAttributes function always returns an empty list (assuming because "backupTable" and "form" contain the same values? But shouldn't they be different?
I'm using C# and SQL Server. I have one gridview which contain 3 columns "ID, COMPLETED (either yes or no), BY (adminID that completed)" and adminID can be null.
If user selected "yes" in COMPLETED column then how can I make sure that adminID in BY column is NOT empty or adminID entered is EXIST in database.
I want to store Values in two table in database..
For Ex.
table 1-- Resi
if Resi is clicked then the values are stored in resi_db and then it will also get store in the HEG01_db table in database..
table 2-- NonResi
if NonResi is clicked then the values are stored in NonResi_db and then it will also get store in the HEG01_db table in database..
Is there a cleaner way to check for a null value comming from the database?
Right now i am doing this
[Code]....
There has to be a better what than doing this on every row which could possibly be null
I have a checkboxlist (cblTeamMates) with a sqldatasource (sqlTeamMates) that has 3 columns (ID, FullName and Status ). The datavaluefield and datatextfield for cblTeamMates is "FullName" and the 2 status values possible are "Available" and "Absent". How do I go about, in the page load event, checking all the names (FullName) whose Status is "Available"?
View 3 RepliesI need to modify the results (NULL) to reflect '0.00'.
My query statement is giving me an error at the CASE level.
[code]...
I have a .net 3.5 application in c# with sql server 2008 at back end. The application is about assigning jobs to supervisors and then these supervisors have to write remarks about the job progress from time to time. There are two tables ; a JobAssign table with JobOrderNo and Supervisor columns, and a JobUpdate table with jobOrderNo,Date And Remarks(nvarchar) column.
When a supervisor is assinged a job he is sent an email but sometimes the supervisors do not write remarks about a job for some time. i want a stored procedure through which if the remarks of a job are not written for say 5 days an email is sent to the supervisor to do so? in my job update table there are multiple entries for a job so the stored procedure will have to check the Top Remarks Date for each jobOrderNo. then compare it to today date if the difference is difference is 5 days then send email. i have read posts on sending email through job scheduler but i'm new to stored procedure so have no idea how to write such.
I'm trying to make a .Net, c# application for online creating surveys. I have a few types of questions, and than I dynamicly put labels, combos, textboxes ... on the form. Up to this point, I somehow managed to get. Than, on click on add button, I write down the responses in html format using stringBuffer and append function. Example.
public string RetOptionalQuestion(string seq_numm, string question, string answersOpt)
{
StringBuilder _output = new StringBuilder();
[code]...
I have a checkboxlist control and a button control in a popup forum. The button is diabled initially. I want to enable the button as soon as the user checks or unchecks any of the items for the first time in the checkboxlist.
<asp:CheckBoxList ID="CheckBox1" runat="server"></asp:CheckBoxList>
<asp:Button ID="SaveButton" runat="server" Test="Save" Enabled="false" OnClick="SaveButton_Click"/>
How to achieve this functionality ?
In my asp.net+vb web with access database in a gridview i used the following code
Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
If (e.Row.DataItem("TEN") > 24) Then
e.Row.ForeColor = Drawing.Color.Red
[Code] ....
The above code is working in my sqldatabase web but not working in access database web...
Is there any difference in using the following for checking for an empty control.
If txtBox1.text.tostring isnot string.empty then
vs.
If txtBox1.text.tostring <> string.empty
vs.
If txtBox1.tetxt.tostring <> "" then
I am creating a custom control and had a thought before I began. My control relies on the jQuery library to work. What if the user already has a version of the library already on their page. Will this effect anything? If my version is newer / older and my control will only work with that version of the libaray, what should I do?
View 1 RepliesI get an error using [Code]....
View 6 RepliesI have a tab container with 10 tabs each with unique id on a hyperlink click i need to make some tabs visible true false,in hyperlink I am passing a query string param
if the param="Y" param = Request.QueryString["type"];
if (param == "Y") {
for (int tc = 0; tc <= TabContainer1.Tabs.Count - 1; tc++) {
if (TabContainer1.Tabs[tc].ID == "Y") {
TabContainer1.Tabs[tc].Visible = true;
} else {
TabContainer1.Tabs[tc].Visible = false:
} } }
I have the above condition but on this click the tab container is not at all visible but without any parameter passing the tab container is visible.
Looking for recommendations for a control which make can do spell checking for various languages.
View 3 RepliesI am using a dropdownlist in a gridview which contains 3 valuesappleorangebanana
apple will be displayed as default valueif i select orange and banana the dropdownlist list should be disable or hidden but the selected value must be displayed
protected void btnsubmit_Click(object sender, EventArgs e)
{
foreach (GridViewRow gr in GridView1.Rows)
{
[Code].....
I am using a DetailsView control to allow for updating a user record. Is there a way to check if the values are actually updated/changed when the update link is clicked. I know there are users, who would click the update button rather than the "Canel" even if there are no changes to the record. So, how do I check if any value has been updated when the update link is clicked. The DetailsView uses a SqlDataSource to populate the DetailsView.
View 4 RepliesI am trying to figure out a way to change the color of the text display in a label control or span inside a user control. The text needs to be displayed in a different colour based on the value returned.
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name").ToString()=="Flying Bats" ? "Display the text in green" : "Display the text in red" %> '/>
The text value would be one of the two. The font color needs to be ether red or green based on whats been returned.I cannot figure out how to do it.
i am using template field display image based on condition in table field. i have field name verify i used to store yes or no value if it is yes then display image else noting to display in gridview
View 1 RepliesI have a datagrid control, the first column is Revno, currently presenting info in linkbutton. i want to do a condition based on another field docid, which gets true or false value from database. if true then present Revno in linkbutton otherwise show the revbnno just as a label., thatway users does'nt have ability to clickit.
<ItemTemplate>
<asp:LinkButton ID="lblRevision" runat="server" CssClass="Textboxes" Text='<%# DataBinder.Eval(Container.DataItem, "RevNo")%>' CommandName="FileDownloadRecord"></asp:LinkButton>
</ItemTemplate>
this docid field has flag true or false.
if true meaning show the revno as LinkButton, otherwise show the revno as label.
GetDocdetail(DataBinder.Eval(Container.DataItem, "Docid")
on the codebehind side i can use this function.
Public Function GetDocdetail(ByVal DocID As boolean) As String
If DocID = "true" Then
Else
End If
End Function