i need to find, string or boolean from database..
that is, i have a table i need to check that is string or boolean? to assigne other vairable?
using some extensions methods?
I have a page that has been working for sometime and now getting this error..
String was not recognized as a valid Boolean.
Im was working on a How-To document of the pages for our VP and now i cant get to page 2 to continue the document.
I have recently added 2 new radiobuttonlists(rel and relst) and im sure its one of them thats causing the issue. But sicne i cant debug not sure which one is failing. Here is my insert code and the error is occuring on the Line 376:
cmd.ExecuteNonQuery();
The fields for the radiobuttons are all setup as BIT in SQL. They all have default values of 0. They are all setup NOT TO ALLOW NULLS.
[Code]....
Im trying to test my extension method that converts a list of strings in a string comma separated:
public static class Extensions
{
public static string ToCommaString<T>(this IList<T> input)
{
StringBuilder sb = new StringBuilder();
foreach (T value in input)
{
sb.Append(value);
sb.Append(",");
}
return sb.ToString();
}
public void TestExtension()
{
IList test=new List<string>();
//test.ToCommaString doesnt appear
}
}
The issue is that in the method TestExtension i cant use ToCommaString method. Do you know what's happening?
Could i make available for all my web application this extension method registering in web.config or something similar?
I'm using Postgresql/Npgsql in my asp.net application, so I can't use LINQ to SQL. I implemented the following method of User class:
[Code]...
error "ObjectDataSource 'ObjectDataSourceCaseDetails' could not find a non-generic method". I have an update method and my ObjectDataSource is hooked up to the method in my BLL. review my code below
[Code]....
[Code]....
I try to update the detailview control. got this error messsage.
ObjectDataSource 'odsDetail' could not find a non-generic method 'Update' that has parameters: hospitalID, hospitalName, taxID, address1, address2, city, state, zip.
[Code]....
here's my edit function
[Code]....
At times when we access session["key"].To String() it gives exception as when session is expired and session variable is accessed. So I am in for extension method on object so that I could do it as session["key"].getString() so that every time I don't have to do Convert.ToString (session["key"])Other way solutions are also appreciable.
View 5 RepliesInside my repeater I'm calling an extension method like so:
[Code]....
he above is giving me an "Object not set to an instance of a object" exception inside the extension method. If I comment the above expression out, it works fine, and the items are binded wtih no problems.
I need to insert a Boolean value into an SQL Server datatable. I'm having a problem with what I'm trying. I don't see the option for a Boolean data type in SQL Server so I used Binary(1). Is this the right data type for storing Boolean in SQL Server?
The lines:
cmd.Parameters.Add(New SqlParameter("@Active", SqlDbType.Binary, 1))
cmd.Parameters("@Active").Value = False
generate the following error on the execute command:
InvalidCastException: Invalid cast from 'System.Boolean' to 'System.Byte[]'
Is there an example somewhere that covers how to store a boolean in an SQL Server table?
I have a DetailsView control about a store products.
When I hit the "Edit" button of the DetailsView control, I want to bind a DropDownList to list products categories and select the current product category in it.
I used the method "ModeChanged" to select the current product category like this:
[Code]....
the FindControl method DOES NOT find the "ddlCategory" (returns null) although it's present in the EditTemplateField.
I'm thinking to use "DropDownList's PreRender" event for doing the purpose I aim, but I want to know what is wrong!
I have an SqlDataSource, which is filtered by two RadioButtonLists. The markup is as follows:
[Code]....
In my code-behind I add the filterexpression when the radiobuttonlists are changed
[Code]....
My problem is that while it works fine when changing the RadioButtonListProducts the filtering works nicely, there is a problem with the RadioButtonListStatus, that filters on the Boolean column, 'Godkendt'. It works nicely if its set to 'Alle' (No filtering on that parameter) but when set to anything else, no records are shown. I suppose the problem is in the filterexpression
[Code]....
I have defined some binary bit columns in an SQL database table to indicate yes/no conditions, but I don't know how to set or reset them. I tried to use "profile.Volunteer = 0;" C# code in an event handler to reset a voluntary state for the Profile table of members, but what I got back was an error message that said, "Constant value '0' cannot be converted to a bool'. So, if a '0' cannot be used to reset a boolean value, what can be used?
View 2 RepliesIt is possible to convert string to boolean?If it is plz give me example
View 2 RepliesFeatureEvents.bit_Activate = Convert.ToBoolean(collection["bit_Activate"]);
bit_Activate is checkbox ,how would i convert it to boolean above,collection is coming from the formcollection variable
I have the following code that works fine:
[code]....
I am getting an error msg when attempting to update a record from asp.net into a SQL database. The only boolean value being updated is:
cmdAddUser.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit));
cmdAddUser.Parameters["@Active"].Value =
Convert.ToBoolean(cbAddUserActiveUser.Checked);
The datatype for @Active in the database is "bit".
i saw the extension method code but i could not understand what it is and what is the utilities of extension method.
View 3 RepliesI am using Tuple class in WCF Service. When i add reference to my web project I get Tuple class. Now i want to add an extension method to Tuple<> class in my service which will be accessible in my Web project.
View 1 RepliesI want to ask, does adding extension methods to datatypes works in the same way as Microsoft's methods or do they have any limitaion.
This is relevant to experienced programmers who had find some limitations while using them.
I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI recently found out about C# extension methods and wrote this one:
/// <summary>
/// Short-hand for setting the data source and binding it.
/// </summary>
/// <param name="me">The control to set and bind the data source of.</param>
/// <param name="dataSource">The data source.</param>
public static void BindTo(this DataBoundControl me, IEnumerable dataSource)
{
me.DataSource = dataSource;
me.DataBind();
}
What do you guys think? Is this a reasonable extension method to use in a professional ASP.NET project?
I have the following Extension Method
Imports System.Runtime.CompilerServices
Namespace Extensions
Public Module IntegerExtensions
<Extension()>
Public Function ToCommaDeliminatedNumber(ByVal int As Integer) As String
Dim _input As String = int.ToString
Select Case int
Case Is > 99999 : Return _input.Remove(_input.Length - 3) & "k"
Case Is > 9999 : Return Math.Round(Double.Parse(int / 1000), 1).ToString & "k"
Case Is > 999 : Return String.Format("{0:N0}", int)
Case Else : Return _input
End Select
End Function
End Module
End Namespace
And in one of my classes I'm using user.Reputation.ToCommaDeliminatedNumber I am importing the Extensions Namespace into the Class, but the error I'm getting is...'ToCommaDeliminatedNumber' is not a member of 'Integer?'. I do have other Extension Methods for Strings and Dates that work exactly as expected... I'm just at a loss on this one.
I know there is a ListBoxFor extension method among the ASP.NET MVC Html helper extension methods, but I always thought that a checkbox list is more user-friendly than a list box.
There was a very convenient CheckBoxList control in good old WebForms, but obviously that is out of the picture now. The question is, why is there no way in ASP.NET MVC to create a check box list? How can I write my own extension method that creates a check box list and behaves in a similar way ListBoxFor behaves?
I have an ObjectDataSource that I want to perform updates using a business entity i.e. Type="Object"). Since the values for the entity are within a user control, I have stored a reference to the control in Session and in the updating event, set the new instance to the value of the entity from the user contol property (which also pulls values from the form viaother properties of the control):
Protected Sub MasterDataSource_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs) Handles MasterDataSource.Updating
Dim entity As New Login()
Dim accountControl As AccountInfo = TryCast(Session("AccountCtrl"), AccountInfo)
entity = accountControl.Entity
e.InputParameters.Add("entity", entity)
End Sub
And here's the markup for the datasource:
<asp:ObjectDataSource ID="MasterDataSource" runat="server" EnableCaching="true" CacheDuration="10"
SelectMethod="SelectAll" UpdateMethod="Update" TypeName="Data.DAL.LoginDAL">
</asp:ObjectDataSource>
My question is, how can I get the update method to pass this entity to the update method in my BLL class? It seems the Update method requires an ID or reference to the original object to use in determining whether any changes have taken place, but I don't really want to do this. In other words, I just want to use the Update event on my ObjectDataSource to pass my entity to the method ("Update") I set as a property and then let this business method handle the update of the data. Shown below, is the BLL update method I want to call:
Public Overloads Function Update(ByVal entity As Login)
If entity Is Nothing Then
Throw New ArgumentNullException("entity")
End If
MyBase.Update("UpdateLogin", entity.Username, entity.Password, entity.FirstName, entity.LastName, entity.Role, entity.Region, _
entity.Email, entity.Title, entity.TierID, entity.Street, entity.City, entity.State, entity.Zip, entity.Mobile, entity.Phone, entity.Fax)
End Function
When I try to call this as it stands now, I get an error: ObjectDataSource 'MasterDataSource' could not find a non-generic method 'Update' that has parameters: ID, entity. Previously, I'd set up a long list of parameters of basic data types (string, int, boolean), but this is rather cumbersome and I was hoping to use an entity for this (FYI, I also got the same type of error when I tried this approach, but with the ID as the
last parameter in the list). Perhaps what I'm doing here is atypical to how the ODS is normally used?? Has anyone done something like this successfully?
I am stuck with the database row level security model that my predecessor has implemented on this project. I am trying to make an extension method for my linq to sql classes to make it easier to filter rows of data in my linq queries. The problem I am facing is that I need to somehow tell it how to access the primary key value of the object in the where clause. I get errors about DynamicInvoke(object[]) cant be converted to SQL. Here is a sample of what I am working with:
[Code]....
How do I do this?
