If I store the maxium unsigned value as a bigint in mysqlm it does not fit in an int64. Is there anyway of making the int64 unsigned. Mysql BigInt has an unsiged value of 18446744073709551615.
If not I can make my sql column signed, as it not a number value but binary value I am storing, but I was just wondering if it was possible
we are in the process of upgrading our crappy cms system and the new assemblies have changed from int to int64. I'm running into a problem when trying to build now. here is one excerpt of code that is causing a problem.
IDictionary<int, string> aliases
= new UrlAliasApi().GetUrlAliasesByType(
Company.DataLayer.Enumeration.UrlAliasType.Recipe);
foreach (ContentBase recipe in mergedResultset)
{
// if alias exists, overwrite quicklink!
string alias;
if (aliases.TryGetValue(recipe.Id, out alias))
{
recipe.QuickLink = alias;
}
}
The error is
Error 323 The best overloaded method match for 'System.Collections.Generic.IDictionary.TryGetValue(int, out string)' has some invalid arguments Its referring to recipe.Id which is an Int64 value.
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
Is there a way to use RangeValidator for large numbers (Int64 range)?
View 1 Repliesthis code is giving me error:
error in converting datatype nvarchar to bigint this is my table values:
@customer_first_name nvarchar(50),
@customer_last_name nvarchar(50),
@customer_address nvarchar(max),
@gender nchar(10),
@date_of_birth datetime,
@customer_email_id varchar(50),
@customer_occuption varchar(50),
@customer_phone_number Bigint,
@nominee_name nchar(50),
@customer_id nvarchar(50),
@account_type nvarchar(50),
@account_number nvarchar(50),
@transfer_access_code nvarchar(50),
@account_balance Bigint,
@pin_code BigInt,
@nationality nvarchar(50),
@password nvarchar(50)
lblAmount.Text = HFamount .Value ;
int balamount = Convert.ToInt32(lblAmount.Text);
int Cpincode = Convert.ToInt32(txtpincode.Text);
long phone = Convert.ToInt64(txtphone.Text);
string cust_id = CUSTOMER_ID_GENERATOR();
string strconstring = ConfigurationManager.ConnectionStrings["ONLINE_BANKING2_ConnectionString"].ConnectionString;
SqlConnection mycon = new SqlConnection(strconstring);
mycon.Open();
SqlCommand cmdRegister= new SqlCommand(sqlquery,mycon);
cmdRegister.Parameters.Add(new SqlParameter("@customer_first_name",txtcustname.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_last_name",txtcustlastname.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_address",txtAddress.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@gender", rbtngender.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@date_of_birth", txtDOB.Text));
cmdRegister.Parameters.Add(new SqlParameter("@customer_email_id", txtemail.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_occuption", txtcustoccupation.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_phone_number", phone));
cmdRegister.Parameters.Add(new SqlParameter("@nominee_name", txtnominee.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_id", cust_id));
cmdRegister.Parameters.Add(new SqlParameter("@account_type", accType.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@account_number", ACCOUNT_NUMBER_GENERATOR()));
cmdRegister.Parameters.Add(new SqlParameter("@transfer_access_code",Transfer_code()));
cmdRegister.Parameters.Add(new SqlParameter("@account_balance", balamount));
cmdRegister.Parameters.Add(new SqlParameter("@pin_code", Cpincode));
cmdRegister.Parameters.Add(new SqlParameter("@nationality", DropCountry.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@password",txtpasswd2.Text.ToString()));
cmdRegister.ExecuteNonQuery();
mycon.Close();
Yes..i know this is ASP.NEt forums but the SQL server doubt i will be going to ask is related to ASP.NET
I have a table 'a' in my database where i store User information - each time they visit the website a new record is added
so in a high traffic website - the information will be collectively huge(i dont care about this as i have too much of disk space)
but the problem here is with the primary key - I want a datatype of the primary key which should never end Bigint can store some zillions of records but it finally ends... how will i be able to accomplish it.
This is the code i have used to get LocationID from database with MerchantID. I am getting an exception from Fill dataset part. The error is Error converting data type varchar to bigint.
public DataSet getLocationID(long MerchantID)
{
//long LOCID = null;
try
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@merchantID",MerchantID)
};
string strCommandText = "Select LocationID from Merchant_Location where MerchantID ='@merchantID' order by LocationID ASC";
Debug.WriteLine(strCommandText);
DataSet pds = new DataSet();
SqlHelper.FillDataset(DbConnString, System.Data.CommandType.Text, strCommandText, pds, new string[] { "LocID" }, parameters);
return pds;
}
catch (Exception ex)
{
//LogError("Error Occurred When Retrieving LocationID: " + MerchantID.ToString(), ex);
return null;
}
}
Im using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'
when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?
[Code].....
I'm getting the following error base on dropdownlist selectindexchanged: error converting data type nvarchar to bigint
Below is my dropdownlist code:
Protected Sub ddlTaxName_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ddlTaxName.SelectedIndexChanged
Dim strConnString As String = ConfigurationManager.ConnectionStrings("BytConnectionString").ConnectionString()
Dim strQuery As String = "select TaxName, [Rate(%)] from Sale_Tax where" & " TaxID = @TaxID"
Dim con As New SqlConnection(strConnString)
[Code] .....
I have a website having an aunthentication system. When I am setting my website on IIS 6 the code is absolutly working fine. But when i configure the website on IIS 7 (Windows 2008 server) it is showing me the above error. I am using a stored procedure for it
View 3 Repliesi want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesI have a web site which uses one SQL database but the hosting company is very slow sometimes and I got database timeout, login and similar errors. Can I implement my code to use two databases simultaneously? I have stored procedures and the data is updated periodically.
EDIT:
Simply: When dbDefault is down and inaccessible I need to use dbSecondary so the web app keeps running. Ant these two databases must be always same.
EDIT:
Some errors:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
i've learnt that you can create an auto-complete application using XML file, and XMLhttpRequest (JS, JS DOM).I was wondering if you can achieve the same thing using an .net application and some database info.Thinking about it, you might have to use AJAX to perform real-time auto-complete... But still, i dont know if it's possible that way.Aside of that, assuming that there is a .net solution, how professional site builders usually do that?
View 2 RepliesHow do we code common functions for SELECT, INSERT, DELETE & UPDATE operations in Data Access Layer(Using ADO.NET ), If we have many tables in our database?
which is better hard coded DAL or using in-build database handling techniques?
I am having 2 databases namely ach and cart and i am having tables namelt Register and Invoice i would like to add a field in to those 2 tables . Like if i enter a value like some ccyyxxyxyxa this should be saved in the 2 tables...
View 3 RepliesProblem with ExecuteNonquery
View 15 Repliesif i have field datetime = 2010-09-08 11:31:59.123
2010-09-08 17:42:08.737 2010-09-09 9:42:08.737
how can i group by only date? Eg: 2010-09-08 = 2 record 2010-09-09 = 10 record currently when i use group by datetime.. because of the time differece, so it show out all the row.
I am using PL/SQL Developer. I have an view "MEDPRO_MULTIPLE_ID". Suppose If I want to see the columns inside the view. What Command Should I use.
View 5 RepliesI already have an existing sdf file that is used in a windows application by looking at the current programs folder to find it. I want to use this same database (a copy of it) on an ASP .Net website so won't be hosted in a sql server anywhere want's to be accessed directly, is this possible?
View 1 RepliesI am also having the same problem while establishing a connection in mysql and asp.net..So how do i solve it...
View 5 Replieshow we can use oracle 10g in asp.net 3.5 using toad
View 1 Repliesi want to tranfer a xml string variable to DB2 store procedure. And then, i will open xml to get data to insert into tables . If in sqlserver i user OPENXML,.. But in DB2 i am a newmember. How can i do it in DB2 store procedure.
View 2 RepliesI just moved to a new 2008 64 Bit Server. We are using MySQL, now also the 64 Bit version. Now I found out that there is a 64 Bit ODCB Driver, but not an 64 Bit Net/Connector.
Is that an issue or is the .NET Connector by default 32 and 64 Bit?
As the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?
View 1 RepliesI'm passing several variables thru the URL and want to use them in several SQL Queries that I want in my asp page. For example one of the (hypotetichal) is client_id and i want to use it in a query to gather other information.
View 1 Replies
