What Is The Difference Between Activator.CreateInstance And New Operator
Jan 5, 2010What is the difference between Activator.CreateInstance and new operator
View 2 RepliesWhat is the difference between Activator.CreateInstance and new operator
View 2 RepliesExternal.dll
IMyClass NewCreated = (IMyClass)Activator.CreateInstance(Namespace.MyClass).UnWrap();
Asp.Net WebSite
App_Code
Namespace.MyClass.cs
Bin
External.dll
Is that even posible? I have tried, a lot of posible combinations, like:
Assembly.GetCallingAssembly().CreateInstance("Namespace.MyClass")
Activator.CreateInstance(AppDomain.CurrentDomain,"Namespace","Namespace.MyClass")
Assembly.GetExecutingAssembly().CreateInstance("Namespace.MyClass")
i need to use the like operator in a linq queryfor this:
timb = time.Timbratures.Include("Anagrafica_Dipendente")
.Where(p => p.Anagrafica_Dipendente.Cognome + " " + p.Anagrafica_Dipendente.Nome like "%ci%");
I recently found out about the andAlso operator, and I understood that it will only evaluate the right condition if the left is true, I thought this could help tidy my code so replaced nested ifs with AndAlso.
Private ds As DataSet
-----------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ds = nothing
If Not ds.Tables(0) Is Nothing AndAlso ds.Tables(0).Rows.Count > 0 Then
end if
end sub
I deliberately set my ds to nothing to replicate a database error and it gave me an object reference error.
I need to use a field of 64 bits (32 is not long enough). I used the following page to see the effects of bit shifting when using the Int64 data type:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ Page Language="VB" WarningLevel="1" Explicit="true" Strict="true" %>
<script language="VB" runat="server">
private sub do_test()
dim bit_no as Integer
dim info as Int64
' Show min value as binary ...
info = Int64.MinValue
response.write( String.Format( "Int64.MinValue = {0}<br>", info ) )
response.write( String.Format( "Int64.MinValue (binary) = {0}<br>", Convert.ToString( info, 2 ) ) )
response.write( "<br>" )
' Show max value as binary ...
info = Int64.MaxValue
response.write( String.Format( "Int64.MaxValue = {0}<br>", info ) )
response.write( String.Format( "Int64.MaxValue (binary) = {0}<br>", Convert.ToString( info, 2 ) ) )
response.write( "<br>" )
response.write( "Bit Shift Test" )
response.write( "<br>" )
for bit_no = 0 to 63
info = 1 << bit_no
response.write( String.Format( "1 << {0} = {1}<br>", bit_no, info ) )
next
end sub
</script>
<html>
<body>
<% do_test() %>
</body>
</html>
The output of the page is:
Int64.MinValue = -9223372036854775808
Int64.MinValue (binary) = 1000000000000000000000000000000000000000000000000000000000000000
Int64.MaxValue = 9223372036854775807
Int64.MaxValue (binary) = 111111111111111111111111111111111111111111111111111111111111111
Bit Shift Test
1 << 0 = 1
1 << 1 = 2
1 << 2 = 4
1 << 3 = 8
1 << 4 = 16
1 << 5 = 32
1 << 6 = 64
1 << 7 = 128
1 << 8 = 256
1 << 9 = 512
1 << 10 = 1024
1 << 11 = 2048
1 << 12 = 4096
1 << 13 = 8192
1 << 14 = 16384
1 << 15 = 32768
1 << 16 = 65536
1 << 17 = 131072
1 << 18 = 262144
1 << 19 = 524288
1 << 20 = 1048576
1 << 21 = 2097152
1 << 22 = 4194304
1 << 23 = 8388608
1 << 24 = 16777216
1 << 25 = 33554432
1 << 26 = 67108864
1 << 27 = 134217728
1 << 28 = 268435456
1 << 29 = 536870912
1 << 30 = 1073741824
1 << 31 = -2147483648
1 << 32 = 1
1 << 33 = 2
1 << 34 = 4
1 << 35 = 8
1 << 36 = 16
1 << 37 = 32
1 << 38 = 64
1 << 39 = 128
1 << 40 = 256
1 << 41 = 512
1 << 42 = 1024
1 << 43 = 2048
1 << 44 = 4096
1 << 45 = 8192
1 << 46 = 16384
1 << 47 = 32768
1 << 48 = 65536
1 << 49 = 131072
1 << 50 = 262144
1 << 51 = 524288
1 << 52 = 1048576
1 << 53 = 2097152
1 << 54 = 4194304
1 << 55 = 8388608
1 << 56 = 16777216
1 << 57 = 33554432
1 << 58 = 67108864
1 << 59 = 134217728
1 << 60 = 268435456
1 << 61 = 536870912
1 << 62 = 1073741824
1 << 63 = -2147483648
Obviously, the bit shift operator seems to be wrapping?? !! How can I obtain the result shown below using VB / ASP.Net -- is it even possible???
1 << 0 = 1
1 << 1 = 2
1 << 2 = 4
1 << 3 = 8
1 << 4 = 16
1 << 5 = 32
1 << 6 = 64
1 << 7 = 128
1 << 8 = 256
1 << 9 = 512
1 << 10 = 1024
1 << 11 = 2048
1 << 12 = 4096
1 << 13 = 8192
1 << 14 = 16384
1 << 15 = 32768
1 << 16 = 65536
1 << 17 = 131072
1 << 18 = 262144
1 << 19 = 524288
1 << 20 = 1048576
1 << 21 = 2097152
1 << 22 = 4194304
1 << 23 = 8388608
1 << 24 = 16777216
1 << 25 = 33554432
1 << 26 = 67108864
1 << 27 = 134217728
1 << 28 = 268435456
1 << 29 = 536870912
1 << 30 = 1073741824
1 << 31 = 2147483648
1 << 32 = 4294967296
1 << 33 = 8589934592
1 << 34 = 17179869184
1 << 35 = 34359738368
1 << 36 = 68719476736
1 << 37 = 137438953472
1 << 38 = 274877906944
1 << 39 = 549755813888
1 << 40 = 1099511627776
1 << 41 = 2199023255552
1 << 42 = 4398046511104
1 << 43 = 8796093022208
1 << 44 = 17592186044416
1 << 45 = 35184372088832
1 << 46 = 70368744177664
1 << 47 = 140737488355328
1 << 48 = 281474976710656
1 << 49 = 562949953421312
1 << 50 = 1125899906842620
1 << 51 = 2251799813685250
1 << 52 = 4503599627370500
1 << 53 = 9007199254740990
1 << 54 = 18014398509482000
1 << 55 = 36028797018964000
1 << 56 = 72057594037927900
1 << 57 = 144115188075856000
1 << 58 = 288230376151712000
1 << 59 = 576460752303423000
1 << 60 = 1152921504606850000
1 << 61 = 2305843009213690000
1 << 62 = 4611686018427390000
1 << 63 = 9223372036854780000
i have arrylist of many variables(dynamic)sayar_GR2=[1,5,8,50,77,11] and is is dynamicand i have this query
[Code]....
i want to get result when condition meet any id(1 or 5 or 8 or 50 or 77 or 11)so result will be 6 rowshow can i make this
is it possible to implement operator over loading in Web services in .net
View 2 RepliesI wanted to update IsValid=1 if FirstName is not null or LastName is not null, for this I wrote a below query
UPDATE USER_TABLE
SET ISVALID=1
WHERE FIRSTNAME IS NOT NULL OR LASTNAME IS NOT NULL
But this does not work properly, it will update all recordscould I know how to alter my query to my purpose
Why the following code produces the error? The query operator 'ElementAtOrDefault' is not supported
Dim Im = (From view In Db.Views Where _
view.Pass = txtCode.Text _
Select New With {.Id = view.UniqueID.ToString}_
[code]...
i am looking for a solution using IN-Operator with LINQ TO SQL. I have found many examples after searching but no exemple which is using a Textbox.In my Textbox i put my ids 2,4,6,7,9 and after clicking the button, it have to show me my Records. But it does not.The error-message shwos me a wrong format.Ausnahmedetails: System.FormatException: Die Eingabezeichenfolge hat das falsche Format.
Zeile 5: Dim result As String = ""
Zeile 6: Dim intText As String = Me.tbKursid.Text
>>>>>>>> Zeile 7: Dim myText() As Integer = {Convert.ToInt32(intText)}
Zeile 8: Dim db As New seminarDataContext
Zeile 9: Dim daten = From c In db.vSchluessel _
If i use Dim myText() As Integer = {1,4,5,6} then it runs without problems. What is wrong?
[Code]....
[Code]....
WebSecurity.Login Operator '==' erro?
I have a local collection of record Id's (integers).I need to retrieve records that have every one of their child records' ids in that local collection.
Here is my query:
public List<int> OwnerIds { get; private set; }
...
filteredPatches = from p in filteredPatches
where OwnerIds.All(o => p.PatchesOwners.Select(x => x.OwnerId).Contains(o))
select p;
[code]...
I am getting this error:Local sequence cannot be used in Linq to SQL mplementation of query operators except the Contains() operator.I understand that.All() isn't supported by Linq to SQL, but is there a way to do what I am trying to do?
Error 10 Operator '*' cannot be applied to operands of type 'string' and 'int'
Show Error
Line 85: v1.Text = Convert.ToString(y[0]) + "صوت";.
Line 86: h1.Text = Convert.ToString(Convert.ToInt32((y[0] / tx) * 100));
Line 857: Image1.Width = Convert.ToInt32(h1.Text * 2);
Line 88: v2.Text = Convert.ToString(y[1]) + "صوت";
Line 89: h2.Text = Convert.ToString(Convert.ToInt32((y[1] / tx) * 100));
[Code]....
I am using ternary operator in Eval,
code is
<%# (Convert.ToInt32(Eval("Url").ToString()).Length > 0) ? "No" : "Yes" %>'
its getting an error that tags are not formed properly.
Here is the code:
Code:
Dim intusercount As Integer = 0
Using connection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Using command As New SqlCommand("SELECT [ID] FROM [Members] WHERE [Username]=@Username AND [Password]=@Password", connection)
command.Parameters.Add("@Username", Data.SqlDbType.VarChar).Value = TextBox1.Text
command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
connection.Open()
intusercount = command.ExecuteScalar
connection.Close()
If intusercount > 0 Then
MsgBox("Good")
Else
MsgBox("Bad")
End If
End Using
End Using
Error:
The data types text and varchar are incompatible in the equal to operator.
Source Error:
Quote:
Line 11: command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
Line 12: connection.Open()
Line 13: intusercount = command.ExecuteScalar
Line 14: connection.Close()
Line 15: If intusercount > 0 Then
Stack:
Code:
[SqlException (0x80131904): The data types text and varchar are incompatible in the equal to operator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
_Default.Button1_Click(Object sender, EventArgs e) in C:UsersUserDocumentsVisual Studio 2010WebSitesWebSite13Default.aspx.vb:13
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
Database:
I am trying to insert data from a booking reservation into my database.
MySQL = "Insert into [RestaurantSteakHouse].[dbo].[reservation]([customerid],[reservationdate],[noofguests],[notes],[tableid]) values (" & id & ",'" + Session("ReservationDate") + "'," & Session("Noofguests") & ",'" + Session("Notes") + "','" + Session("TableId")
+ "');select @@identity"
Operator '&' is not defined for string "Insert into [RestaurantSteakHous" and type 'ListItem'.
I have a linq to sql query where I have to perform union two set of records.
And I do not have equal number of fields, so added the null
eg my psuedo code is
[code]....
after googling some hours I came to understand that it is bug in 3.5 framework.
Now I want to retrieve the result.
How do I do thatI tried framing into two seperate iqueryable
var a= first query
var b =second query
ilist result =a.union b
This too results in the same error.
im using MS-Access database, i tried to add some data to the database from C#. the column datatype is Memo.
From front-end, the user type some text on HTML editor that content to be add to this column, if i enter minimal text then data is adding fine but, if enter 2 or 3page content then im getting error as
[code]....
I have a Excel user application which has a user form (named 'Registo') that displays criteria and an image that has been entered in it's corresponding spreadsheet. This works the way it should. There's also the ability to search the spreadsheet via a form (by clicking 'Pesquisar' button) this opens a search form. However, I having a bit of a problem with it. When I try to search for something it basically doesn't do anything at all. It just sits there. So I tried to debug it and I think I'm having a problem with either the JET db engine or somethign with teh query or maybe I don't have the correct reference.
View 2 RepliesError Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='. /bioskop/pesan.asp, line 13
[Code]....
i am new to asp.net i am trying to develop an asp.net application i,e registration form in asp.net as user interface and ms access 2007 database as backend.i am trying to make aconnection to ms access 2007 db and save the data entered by the user in asp.net application.
i have saved my access db 2007 file in 'D drive' and my code in application is:
[code]....
I am trying to use Operator class to ConcatenateObject in my Class file of ClassLibrary. I have imported namespace of Microsoft.Visualbasic but still Operator class is not recognized. [URL] If I am trying to use add reference of Microsoft.VisualBasic.dll system say that it is already automatically adeed.
View 6 RepliesThe issue is two fold in my ASP.NET Web Application. I need to use a custom Distinct() via LINQ to SQL, and then assign thevar as a DataSource to a GridView.
If I use the custom Distinct that implements IEqualityComparer,I get "Unsupported overload used for query operator 'Distinct'" exception. but if i somehow get past this, i get "The data source does not support server-side data paging" exception on GridView.DataBind(). here is the code:
[Code]....
And here is the IEqualityComparer:
[Code]....
With this code I get Unsupported overload used for query operator 'Distinct'. BUT! if I change the code to
[Code]....
, I get System.NotSupportedException: The data source does not support server-side data paging
I would like to use an eval stmt to return a true/false for the visible property of a HyperLinkField. IF clientComment exists, I would like it to return True, if clientComment is null or "", then would like it to return False.
By default I noticed it already will not show the hyperlink if clientComment is Null, however the bug I'm running into is if the client enters a comment but then later deletes it so it's not null but blank, or "", in which case the HyperLinkField will incorrectly display. Here's my attempt so far but I'm obviously hitting a wall:
Visible='<%# Eval("clientComment")==Null or =="",False) %>'
How to use ternary operator in this condition
if (drSiteDetail["sitetype"].ToString() == "Local")
rdbType.SelectedIndex = 0;
else
rdbType.SelectedIndex = 1;