I came across this article:[URL] It is for SQl Server driven asp.net menus. It works great but it's in C# and I want it in VB.All of the code translates fine except one:
HttpRuntime.Cache.Insert(_cacheDependencyName, new object(), dependency,
Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, CacheItemPriority.NotRemovable,
new CacheItemRemovedCallback(OnSiteMapChanged));
I get the following error: "System.Web.Caching.CacheItemRemovedCallback is a delegate type and requires a single AddressOf expression as the only argument to the constructor". Putting in AddressOf(OnSiteMapChanged) doesn't fix it: it looks for the arguments of OnSiteMapChanged which are:Private Sub OnSiteMapChanged(ByVal key As String, ByVal item As Object, ByVal reason As CacheItemRemovedReason) Putting in them doesn;t fix it either.
I am trying to export some data from a SQL Express table to Access using VB.net. The data is correctly displayed in SQL as, for example, temperature with the small degree object and the letters F or C for Farenhiet or Celsius. The character is of course represented by ° = "°" in html code, which is what appears in my access tables.
How can I get the insert statements to correctly pass this symbol? I have thousands of records and this applies to maybe a hundred or so in each of a few hundred DB's I am running this conversion on.I read the data from a Gridview an .aspx .net web page and then use an insert query with an Access OLEDB connection.
im trying to write to an sql database. im inserting an image, as well as some other information. I am using the following code which works fine, as long as i do not add an extra column/variable "LOCATION" in to the mix and leave "
commented out. *this is undesireable as im trying to add extra criteria to be saved like LOCATION.
Try Dim st As New FileStream("\serverfolder1storage" & "pdftemplate.jpg", FileMode.Open, FileAccess.Read) Dim mbr As BinaryReader = New BinaryReader(st) Dim buffer(st.Length) As Byte
[code]....
i am trying to store the location e.g "c:file1.jpg" in the sql db. Can anyone reccomend a solution to this using OLEDB? ideally i need to add approx 4 more variables. e,g
Im getting an error with my insert statment "Syntax Error in INSERT INTO statement". I do not understand why. Im using global variables from form 1 and using them in form2 and trying to insert them from form2 into the database.
could someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog") End Sub
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
I have a csv file that I need to import into a sql table, this portion is working correctly. The code grabs the data, displays it in a datagridview and then imports it into the sql table. What I need to do is add an additional field that will automatically number itself by the amount of rows inserted at that perticaular moment. Let me explain a little clearer. The data I grab from the csv file is a day snapshot broken down to the hour. So lets use todays date 6/28/2010 will be broken down in the csv file like this:
I am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)" selectCommand as new oledb.command(strsql,strConn) selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
Public Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click Dim i As Integer
[Code].....
when i click the button, i get a error message saying "Syntax error in INSERT INTO statement". as far as i can tell, i have everything i need to insert a new row into the database, and i dont see why this problem is occuring.
item(0) is an autonumber key field, so that should make a new record by itself, and i have declared the input textboxes as the data() array
I am having trouble converting this Do Until loop to a Do While loop. Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click calculates and displays the average sales amount Const strPROMPT As String = _
I have the following in vb.net and need to convert it to c#. Seemed rather simple at first but I need to pass in the NamedObject variable as welll which is supported in vb.net but not in c#..
What are my options.
Here is the vb.net - notice the NamedObject
Public Property Datos(ByVal NamedObject As String) As T Get Return CType(HttpContext.Current.Session.Item(NamedObject ), T)
I am trying to convert an MP3 to a wav. The wav file is created, but I am having problems elsewhere. The label is displaying the wrong data("Cancel/Error") and the progressbar is doing nothing. I am using lame 3.98 .exe and a wrapper for the exe. I downloaded the LameShell project from codeproject. Here is a section of the wrapper class. This was originally for resampling a mp3 to mp3.
I'm developing a program to execute powershell from .net app. I found a sample but it uses c# so I'm changing the code to vb.net but I don't know how change the following line:
I found some code on preventing DOS attacks written by Omar Al Zabir thta I would really like to use on a website written in VB.NET.
The code is at the following link -[URL] but is in C# I tried to convert using variios different programs but there seems to be one line that keeps giving me problems.It's the line
var hit = (HitInfo)(context.Cache[key] ?? new HitInfo());
I am converting my project from VB6 to VB.net 3.5 and at one place i have declared private variable a() as variant and i am using some place as b =a(index,0) it will work in VB but gives me error in VB.Net the error is Number of Indices exceeds the number of dimensions of the indexed array.
It is a program on which logic programs can be developed, compiled and downloaded into Programmable Logic Controllers. It is fairly big and complicated and the resulting .exe file is about 2Mb. I need to develop the program further now, and would like to use VB.net. When I try loading the VB6 code into VB.net, it changes all the variables of type Integer and String into type Object. It then states all through the resulting code that the default values are not defined. I assume that if defined as Integer and String variables do not need a default value, it would assume them to be 0 and empty. Any ideas why the program changes the variable types during the converstion? All forms start with 'Option Explicit', so all variables are defined.
I am trying convert a macro for MSProject from VBA to VB to create an add-in. What I am struggling with is the code to set the values of fields on a windows form and how to actually display the form.
What I have so far is:
Dim objProj As Microsoft.Office.Interop.MSProject.Project Dim objTasks As Microsoft.Office.Interop.MSProject.Tasks Dim objTask As Microsoft.Office.Interop.MSProject.Task
the following is brief description of how my project works. GUI is used to collect information from User and validates.have got dll named control-class that pass input data from GUI to Business logic DLL.this dLL connect to the database and saves data.after that,it disconnected and takes the results to the control dll,then to GUI which interprets if the input data was successful or not.Is there a tool that can be used to convert VB6 GUI to .net web forms? am not familiar to vb.net.how do you create reference to vb6 dll or COM from vb.net?
I have read the threads on converting PNG to ICO format. I came up with the code below. This works, but it creates a black background where the PNG had a transparent background.[code]....
The _File variable above is a string that has the path to the PNG file.
I was put in a situation where I had to convert RC4 code from c# into vb I tried getting already made codes online but they did not seem to work as the currently c# one that I have. Maybe a professional will see the mistake I am making. Both codes give a different encrypted result.