Sql - Dealing With A Varbinary Field?
Jun 10, 2009
A partner of ours is making a call to a web service that includes a parameter called token. Token is the result of an MD5 hash of two numbers, and helps us authenticate that the user using our partners system. Our partner asks the user for two strings, concatenates them, runs them through MD5, and then calls our web service. The result of the MD5 is the token, and it is submitted to us as a string.
We store valid tokens in a DB - since we use the SQL Server to compute the tokens on our end, SQL seemed to be happiest storing the tokens as a varbinary, which is its native result for an MD5 computation.
We have two pieces of code that attempt to do the same thing - run a select query that pulls out a value based on the token submitted. One uses a dynamic query (which is a problem), but it works. The other one attempts to do the same thing in a parameterized (safer) fashion, it does not work - it is unable to locate the token.
Here's the two competing attempts. First, the parameterized version which fails:
byteArrayToken = System.Text.UnicodeEncoding.Unicode.GetBytes(stringToken)
scSelectThing.CommandText = "select thing from tokenstable where token=@token"
Dim param As SqlParameter = scSelectThing.Parameters.Add("@token",
[Code].....
View 1 Replies
ADVERTISEMENT
Aug 3, 2009
I'm trying to test a varbinary(max) field to see if it's null. I'm trying to figure out if it's a null or not in the select statement, hoping to avoid having to do this locally for every row of the returned dataset. This is the SQL I'm using,
[Code]....
View 1 Replies
Oct 13, 2010
I use a VARBINARY(MAX) column, because I have no idea what is going to be put into it. All I know is that as of this point in time, the data will be one of many traditional data types(Integer, String, DateTime, etc.)I also have another column that is meant to indicate the DataType so the .NET application can handle the data and validate input accordingly.Right now, for testing, I have a DataType table in my database that stores the "supported" datatypes for the VARBINARY column, and a foreign key linking to the column meant to indicate the DataType. This works perfectly, but it feels akward.
View 2 Replies
Jun 5, 2012
When I try to query an entity that has a varbinary field in it I am getting error:"The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities."
Here is my query:
Dim query = From entity In db.Entity
Where entity.Id= Id
Select entity.VarBinaryField
[code]....
The error gets generated when I check that the query isNot nothing.
View 1 Replies
Oct 7, 2009
I wanted code to convert the varbinry to pdf and save it on Clients machine.
View 4 Replies
Apr 3, 2010
I am writing a small app that reads in a .pdf file using the below parser to a Varbinary(Max) column in a sql table[code]....
View 1 Replies
Jan 25, 2011
I have a problem which I have not been able to find an answer to in months. I store word doc resumes as varbinary(max). I can retrieve the resumes based on a full-text search no problem. But the resumes are retrieved as word documents in a .ashx file with the following code. I really need to implement hit highlighting on the site so that users can see if the returned resume is a good fit or not.
I don't think this can be done from an .ashx file, so I think I need to be able to open the resume as html in an aspx page and maybe use javascript to do the hit highlighting or perhaps return the text only content of the word document somehow and manipulate the text before display with html tags.
[Code]...
View 1 Replies
Nov 10, 2011
I've found solutions to determine the length of an audio file using WMPLib.WindowsMediaPlayer (which seems quite ugly), by using a physical file path, but nothing to determine the duration of an audio file stored in a VARBINARY field (SQL Server 2008 R2).I'm using .Net WebForms. Maybe it'd be a better idea to do this client side with jQuery, but what if I only want to expose some controls to the web browser based off of the duration?
View 1 Replies
Jan 4, 2011
I am using VISUAL BASIC 2010, SQL Server 2008. I need to update a Table with SQlDbType Varbinary. Just for sake of Murphy loving me I gave it Varbinary(100) - while max. field lenght is 20 Non Ascii Characters on the UI Side.User is changing data in a form, data gets encrypted (into a Byte Array) then sent to the BL of the program, the business logic talks to SQL Server and fields in the Table are updated nicely with new binary values.
A problem arises however with a field that is allowed NULL values in the data table. I can retrieve NULL values from the Database and assign them the "Nothing" value. (User Interface shows a nice blank field). Once the user however changes that empty field(containing "Nothing" as value) with any data then my cmdSql.ExecuteNonquery reports no changes. (rowsaffected = 0)
I strongly suspect that I am making a mistake in the parameters of the SQlCommand of the OldFullname value, but as I said I am staring myself blind. Please review my code below and tell me where I am making that mistake...
FYI: OldFullname can't be "Nothing", and its current field is SQL NULL. All fields (except UserId) are Varbinary. Update succeeds as long as OldFullname SQL field contains data - only not when it is NULL. I don't want to set a standard value on the column (NULL or such).
Public Function SaveToDatabase(ByVal OldUser As blProgramAccess.userEncrypted, ByVal NewUser As blProgramAccess.userEncrypted) As Boolean
Dim bSaved As Boolean[code]....
View 6 Replies
Jul 5, 2009
I recently found myself in a thread deling with convertions from decimal number to fractions... Being a bit too brusk and dismissing the idea at first.I have now implemented a structure based on code frm Javelia whithc can be seen in this thread.Solitare also proveided code that I eventually understood and was working.[URL]...it a step longer and developed a structure that can also implement calculating with fractions... My first try is also posted in the tread above...
The implimentation is far from perfect, as it does not deal with POW of fractions.. So if anybody has some ideas on hoe to do this with squer root and all pleas let me know and Ill update the code..
[Code]...
View 7 Replies
Apr 19, 2012
So I am making a file crypter so that I can encrypt my VB.NET Application that I am making so that people can't decompile it. I had made this in C# and am transfering it to VB.NET, Everything worked fine in C# but once I had re-written the code in VB.NET i get this error inside of my RC4 Encryption method:
'Arithmetic operation resulted in an overflow.'
The error is occuring here:
Dim t As Int64 = (s(i) + s(j)) Mod 256
This is the same code above in c#:
int t = (s[i] + s[j]) % 256;
Is there anyway to make that calculation with it erroring? And why does it work in C# but not VB.NET?
View 2 Replies
Jan 6, 2012
I have a function called Modify. It is delcared like so:Public Function Modify(Of SIMType As {New, DAOBase})(ByVal obj As DAOBase) As Boolean
You can see that this function is generic. It takes as a paramer a object that is a DAOBase or subclasses of DAOBase.Inside the modify function there is a call like so:
DAOToGP(obj)This is where the polymorphism comes into play. There are four or so subclasses I have created of DAOBase. I have written a DAOToGP() for each of these types. So in the Modify() function, when it calls the DAOToGP(obj), polymorphism should kick in and it should call the correct implementation of DAOToGP() depending on the type that I pass into Modify().
However, I get the following error:Error 20 Overload resolution failed because no accessible 'DAOToGP' can be called without a narrowing conversion:'Public Shared Function DAOToGP(distributor As Distributors) As Microsoft.Dynamics.GP.Vendor': Argument matching parameter 'distributor' narrows from 'SierraLib.DAOBase' to 'IMS.Distributors'.'Public Shared Function DAOToGP(product As Products) As Microsoft.Dynamics.GP.SalesItem': Argument matching parameter 'product' narrows from 'SierraLib.DAOBase' to 'IMS.Products'. C:Usersdvargo.SIERRAWOWIRESDocumentsVisual Studio 2010ProjectsSIMDev_2SIMIMSDVSIMLibGPGPSIMRunnerRunnersRunnerBase.vb 66 39 IMS
I am kind of at a loss here. I am not sure why it cant figure out which function to call.
View 2 Replies
Aug 23, 2011
my code works fine in JavaScript but doesn't work correctly in Firefox or safari and wondering why. What I'm doing is I have a loop going through each element and depending on the variable inside a text box just want to alert something. Like i said earlier this code works fine in IE. Here is the code below:
Here is an example of text box:
<asp:TextBox ID="txtMac" runat="server" req="yes" errMessage="Mac"/>
for (a = 0; a < theForm.elements.length; a++) {
if (theForm.elements[a].type == "text" && theForm.elements[a].req == "yes") {
alert("Made it here")
}
}
View 5 Replies
Jul 19, 2011
Problem dealing with apostrophe in filter?
View 5 Replies
Sep 21, 2009
I've been messing around with prime numbers for a while now, but I now want to use massive numbers, say a few million digits in length. Is there a way of storing and performing mathematical functions with such large numbers? Is it even possible on my home computer? I read on another old thread, something about a big number library, but the links he gave are now dead.
View 4 Replies
Jul 30, 2009
I have a website and say a user comes along and fills out the form with bogus data. Then after he fills it out, he enters another one and another one and another one of bogus data. He's basically just trying to clog up the data base.
How is the best way to combat this? Would it make sense to when they submit the data track the IP address?
View 4 Replies
Jan 6, 2010
I sure this has been asked more then once... New to vb.net and I have been experimenting with a datetimepicker and how it looks at and deals with time. What I am trying to do is to add up my time (not worried about the date at all). I have it figured out and can get it to work so long as I do not go over 24 hours... and that is where my issue comes into play.
How do I display my total time in hours once it has gotten over 24 hours ( I do not want days.. just hours) for instance, a 40 hour work week, not 1 day and 16 hours.
[Code]...
View 2 Replies
Feb 9, 2010
Some tables I am dealing with have null values and are throwing errors. So far ive tried a few solutions to deal with the nulls with no success.Here are the code samples from my efforts so far;
If (r("datemodified").Equals(DBNull.Value)) Then
datemodified = String.Empty
Else[code]....
i have ran the query and it is working ok (i.e all the cols exist)
View 2 Replies
Jan 12, 2012
Dim myreader As SqlDataReader = cmd.ExecuteReader
'read information from the database and give the values to the arguments(column_1, and column_2)
While myreader.Read
column_1 = myreader.GetString(1)
column_2 = myreader.GetString(2)
.....
I get an error when the data returned from myreader.GetString(2) is NULL. How do I check for nulls before assigning column_2 a value?
View 3 Replies
Feb 1, 2010
Is there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
View 15 Replies
Jul 8, 2010
Some tables I am dealing with have null values and are throwing errors. So far ive tried a few solutions to deal with the nulls with no success.
Here are the code samples from my efforts so far;
If (r("datemodified").Equals(DBNull.Value)) Then
datemodified = String.Empty
[code].....
View 1 Replies
Nov 20, 2009
Is it possible to translate the following C# code into VB.NET, using VB 9.0?
delegate Stream StreamOpenerDelegate(String name);
void Exec1()
{
WorkMethod( x => File.OpenRead(x));
[CODE]...
Can I do something like this?:
Private Delegate Function StreamOpenerDelegate(ByVal name As String) As Stream
Private Sub WorkMethod(ByVal d As StreamOpenerDelegate)
''
End Sub
[CODE]...
I'm trying to write some documentation, but I don't know VB syntax. Often I use Reflector to translate it, but I'm not sure it's working in this case. I'm also not clear on where I would need line continuation characters. In VB9, it's not possible to have multi-line lambdas (or Sub lambdas, which I did not ask about). In VB9, all lambdas return a value, and must be a single expression. This changes in VB10. VB10 will allow the above syntax, but VB9 will not. In VB9, if the logic involves multiple code lines, it must not be a lambda; you must put it into a named Function and reference it explicitly.
Like this:
Private Delegate Function StreamOpenerDelegate(ByVal name As String) As Stream
Private Sub WorkMethod(ByVal d As StreamOpenerDelegate)
''
End Sub
[CODE]...
View 1 Replies
Sep 20, 2010
I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
[Code]...
View 8 Replies
Oct 24, 2009
1. I having a project dealing with MsAccess database.
2. Currently the project connect the db using table adapter/data adapter method.
3. When I called a Me.SubjectCourseTableAdapter.Fill(Me.ProgrammingDataSet.Subject_Course) at frmCourse, it return me error message "System. NullReferenceException was unhandled Message="Object reference not set to an instance of an object.""
4. This line of code is just the same at frmA. Wonder why it will cause error at frmB.Besides, which is the better way to connect access? data adapter or ado.net?
View 3 Replies
Mar 12, 2012
I want a method of dealing with very, very, very big numbers (potentially a million digits). It is very cumbersome to deal with very big numbers in VB, would another language perhaps be better for that?
View 10 Replies
Jan 14, 2010
I have a main form which contains a few buttons...some of those buttons open up smaller forms...there is also a button for each of those smaller forms, which should let me bring the chosen form to the front and give it focus...basically like the tabs in your task bar let you switch between which program you are using...but I'm having trouble with this...I need to click the button 2 times before the form I want comes to the front...the first click removes focus from the currently activated form the second click then moves the form I want to the front.I need this to happen in one click..I[code] figured out the exact cause of the problem.it's due to the fact that the first click doesn't actually take effect since the child form has focus...so the first click actually just transfers focus to the main form...the second click does what it should.I knew it was going to be extremely obvious.so the question now becomes...how can I overcome this if that is possible at all...I know I've seen applications where I can still activate functions of the parent form in one click even if I have a child form open and focused.And it's basically what I need...it does what I want and lets me switch between child forms in one click...but it stuffs up the entire look of my parent form...the layout and colors get wacky...the transparency of certain things don't seem to work and my background image is gone..
View 7 Replies
Jan 30, 2012
Suppose I have two events:
Public Sub Control1Updated() Handles control1.TextChanged
control2.Text = SomeFunction(control1.Text)
End Sub
[code]....
Basically the pairs of {control1.Text, control2.Text} and {control2.Text, control1.Text} should be the same. If control1.Text is changed to let's say "a" then control2.Text is ALWAYS "b". If control2.Text is changed to "b" then control1.Text is ALWAYS "a". How do I achieve this with events without going into an infinite loop? [the best I can think of is to make a check if the other control.Text is already the desired value].
View 1 Replies
Jul 28, 2010
Does anyone else wrestle with getting VB.NET Linq code formatted the way they want it in Visual Studio? What are some tricks you have for how do you deal with it? I know that Visual Studio lets you uncheck the option for "Pretty listing (reformatting) of code", but most of the time it's a really handy setting to keep on. And with a team of developers who could have other settings, that's not really a viable solution. So my questions are:How have you dealt with formatting multiline Linq statements in VB without fighting with Visual Studio's code formatting?Is there a particular style guide for Linq in VB.NET that is recommended? Something that is readable, and that Visual Studio likes without the reformatting nightmares? My original question may not have had the clarity I desired. Here's a more concrete example. [code]
Everything is all nicely formatted and lined up, but any changes to the query result in Visual Studio borking the formatting and only an immediate CTRL-Z will stop it. Which is fine if there's a standard way that VS would like to see multiline Linq formatted, but if not, then the constant reformatting VS tries makes no sense. I'm trying to see if I missed some standard or how others in the community deal with this effectively. (BTW - using tabs instead of spaces for indents.
View 2 Replies
Apr 7, 2009
I'm using VB.NET 2005 trying to create a options form that lets you select the serial port to use I'm using:
HTML Code:
Sub GetSerialPortNames()
' Show all available COM ports.
For Each sp As String In My.Computer.Ports.SerialPortNames
Serial_list.Items.Add(sp)
Next
End Sub
To create a list of ports this works then using
[Code] .....
View 1 Replies
Oct 3, 2010
I addressed a meeting and used the following....she worked there for 17 years.I was corrected later that it should have been 16 years.I argued that the first year of this persons employment was 1966 and her last years work was 1982. Therefore 17 years.Does someone have an articulate mathmatic reasoning that explains dealing with inclusive numbers.
View 12 Replies
