I have searched high and low and can only find some very bad documentation on how to properly save the data from a rich text editor to a SQL Server database. I am not working with personal profiles, I just want to understand how it is properly done, including how to properly escape said data.
View 2 RepliesI have a VB.Net 2008/Access 2007 app that I can�t get to display data in an organized way on a listview. The listview displays the data in the order that the data was entered in the products table. In the SQL statement that loads the listview I put ORDER BY SupplierTbl.CompanyName but it doesn't do it. The listview shows the data in the order that the records were entered in the database. So then I was going to settle for if I can get the listview sorted by clicking on the column header.If I can get that to work then that would be acceptable. So I then implemented the sort routine. The sort works and it doesn't.If you click on a column header then all the rows show the information nicely. The database has an OLE object column for storing images. Customer wants images stored in the database not file paths. When you click the listview the image displays in a picturebox.
The proper images display when the listview is clicked when I use the SQL statement below without the ORDER BY. But when I click on a column header and reorder the display it's no good. If you click on a row in the listview the wrong image is being displayed. It displays them in the order as they were in before the sort. All the other columns look good and are behaving except for the Image column. So that then makes me wonder if my original problem with the ORDER BY is directly related with the OLE object column. Is there something about this data type that I need to know to manipulate it in SQL? My reaction is that maybe since this column is resource heavy it goes by different rules. Can someone please tell me what I need to do to make the end result have some order? This is the SQL statement without the ORDER BY:
command.CommandText = "SELECT ProductTbl.ProductID, ProductTbl.PartNumber, " & _
" ProductTbl.AltPartNumber, ProductTbl.Description, ProductTbl.SupplierID, " & _
" SupplierTbl.SupplierID, SupplierTbl.CompanyName, ProductTbl.Category, " & _
[code]....
how do I sort a list properly so the numbers are truly in order?
BAD GOOD
1 1
10 2
11 3
[code]....
I'm trying to set the tab order on my form and no matter what I do, it doesn't relearn the new tab position after I change the index. It almost seems like the form is locked.
View 1 RepliesStore order status strings in program?How will this be in VB?[code]...
View 5 RepliesI'm trying to replace one character at a time in order to store its index, therefore if the replace is used all characters are changed and I cannot keep the index of all characters.
[code]...
I have been trying for 2 weeks now to get this program to work.I am using VBasic and MS Access 2007 in conjuntion with a software application.the Database has 2 fields
1) Text
2) OLE Object (.jpg)
when I try to preview the data inside the DataSet I can only get the text to come threw, but that isn't the problem...the problem is binding the data to a datasource and displaying the information.I cannot get the database to display the information in FIELD 2
I've looked in a few places but haven't had much luck in finding what I'm after.So I have a picturebox on my windows form and it has an image set to it, I also have a bunch of reference files that reference to a bunch of images.
Me.PictureBox1.Image = My.Resources.imgs.image1
That piece of code works.
Now, I tried to databind the picture box to a database so the images would load on the change of a combo box but that got confusing really fast so what I did was created a database and it holds all the image references such as "My.Resources.imgs.image1" but its stored as type varchar(50).
Connecting to the database and retreiving the strings is no problem, that works all fine.The problem is converting the string to the image reference, it doesn't work. I've tried type casting, I tried using imagelocation rather than image but I want to reference to the resources that is attached to the project.
[Code]...
Dim cn As New OleDbConnection
Dim sql As String
Dim da As OleDbDataAdapter
[code].....
I have a function that returns a list of account numbers as an Arraylist. I am trying to use each account as a command parameter in another sub routine to get more data about each account number. This only returns the data for the last account number in the arraylist. I need to use each account number, call the database, get the additional information and store ALL of the data into a Gridview (databind). Example: If I had 3 account numbers in my arraylist return 3 rows of data to the gridview. I am struggling with how to get ALL of the information for each value (account number) in the Arraylist. Can someone point me in the right direction?? I think this can be done but I am not certain if my approach is correct or not. Perhaps I need to create datatables that contain the additional information for each value passed via the arraylist.
Private Function ReturnMultAccts(ByVal strAcct) As ArrayList
Dim acctsDetail As New ArrayList
Dim dsn As String = Configurati
[code].....
how can i add the tinyMCE editor in my vb.net desktop application?
View 2 RepliesI have several <asp:TextBox TextMode="MultiLine"> elements on a page. On load, I populate them (through the VB code behind), and then turn them into TinyMCE editors (through the Query TinyMCE plugin). Each text box also has a button associated with it, with the purpose of submitting the text back to the code behind for insertion into a database.I discovered earlier that when the submit button is clicked, I have to "save" the contents of the editor to the text box, but that is not my problem. Even after I've done so, the edits are not showing up in the code behind.As I've mentioned, I'm using jQuery. Here is my click handler. Keep in mind that all buttons are submit buttons in ASP.NET, hence the submit class:
$('input.submit').live('click', function() {
tinyMCE.EditorManager.triggerSave();
});
[code]......
I'm trying to let my users make some HTML in FckEditor and save it to a file so it works as part of the app. I'm wanting it to overwrite the file.Here's my idea: (FckEditor is a HTML editor)
Use the ASP.net one on a webpage Connect with Web browser control vb.net on the Save button (integrated too web page not the FORM Simply <%Response.Write(Fckeditor1.Result)%> This will output the user's work.Then I need to monitor, maybe with an WebBrowser1_URLChange capture and download this page to hard disk and save to C:Test.html overwrite?
I'm working on an asp.net website written in vb. I embedded fdkeditor in my page, and it works fine. As it includes image-upload feature, which works fine as well, I need to limit the size of the file before it's been uploaded.
I wonder I couldn't find anyting satisfactory on web, it seems fckeditor's developers haven't ever thought about that.
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
I am using ASP.NET 2.0 with SQL Server 2005.
My page have a text box where TextMode="MultiLine"......see below
Now when I save this text in my database of course it does not save it with any HTML tags, and thus when i read that value from the database it comes back as 1 line such as....
But I want it to be dispayed just like the user typed it. Is there no out of box control that will do this for me rather than me using Ajax or jQuery?
I'm trying to make sure that I don't leave any loose ends open in my application and am concerned about a few but might get my answer from this one. I've "overriden" some functions so that way I can try and keep all the resources as clean and free as possible. So in this instance, I have a function called ExecuteReader which returns a DbDataReader as normal, but all I had to pass to it was a SQL string rather than recreating a DbCommand every time. I want to make sure that even though I'm unable to call dbCommand.Dispose() that it is actually doing so.
[code...]
In here, I set the _dbReader to what I'd get from the function and eventually I close the _dbReader. I do not close the connection as I don't open it each time I make a query. This is a SQLite database that only one user will be using at a time (small application with very very very little likeliness it will grow) so I didn't think it necessary to close and open the connection all the time. Maybe I'm wrong, not sure. Using it this way though, it is potentially ok for cleaning resources?
I am building a windows program that I need to link to add and pull information from an access 2007 database. I really so not want to use SQL if at all possible.
View 3 RepliesI am looping thorugh a datatable and and printing each row to the console and I keep on getting a dbnull error. I inserted an if statement in my loop to try and catch it, but I can't seem to get it to work.
[Code]...
I am looking for a code snippet which opens a image, creates a clone of this bitmap in memory disposes this opened image so that all handles are closed.
Usually we can open a bitmap using this[code...]
the following code however keeps the Image File locked until the application is running, any suggestions how to dispose it properly. (So that no handle is left open )
Things i already tried: use dispose method of bitmap <= doesnt work (need to write implementation)
Using Block also doesnt work.
how to properly connect to a MySQL database check if a login is valid.Basically i want someone to write me an example of how i connect to a MySQL database, check if username is correct, check if password is correct. If username and password is correct- it should return True as of boolean dim.
View 2 Replieshow to properly connect to a MySQL database check if a login is valid.Basically i want someone to write me an example of how i connect to a MySQL database, check if username is correct, check if password is correct. If username and password is correct- it should return True as of boolean dim.Otherwise it should return false.
View 1 RepliesI want to show default page in fckeditor on page load but but I am not able to this.[code]...
View 1 RepliesI have the following code to get the column names from my Microsoft Access database.THE PROBLEM is that the stupid thing orders it alphabetically for me. How do I get it to put the columns in order the way they are in the database?[code]I've also tried a different approach with a string array and for loop to "make it" go to the beginning, but proves my point that its stupid enough to order it for me.
View 3 RepliesI am creating an information access system. Here the notifications created by the admin will be visible to the user through a visual basic form and sql database. I need a maximum of 20 notifications and the last created notification should appear at the top in the form. Also when the 21st notification is created it should automatically delete the 1st and so on.
View 1 RepliesI have a program using the OleDbCommand to read an indexed Access database. [code]I notice that when step debugging the program, the file is not being read in correct order.Example: it will read the record with "B" in the D01 field before a record with "A" in the same field.The record with "B" is the second record in the database.I do note that all records in the database are read before exiting the loop, just not in any apparent order.
View 5 RepliesI am doing a small MS Access database based program, but I got one problem. Instead of loading the the rows like this (each nr is the count of the row):
"1,2,3,4,5,6,7,8,9,10", it loads it like this: 7,8,9,10,1,2,3,4,5,6
Here is my code for where it loads the data:
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" & Application.StartupPath & "\Filmer.mdb"
con.Open()
sql = "SELECT*FROM Film"
[Code] .....
I am looking to create an order reference which is something like this
PLC0000001
Where the 1 would be my order id
but lets say it gets to 100 would like
PLC0000100
In VB.NET how could I build up a string like where i know i.e.
the starting part = PLC
Ending part = Order ID
middle = fill in 0's
I am reading a record from a database into a datagridview.I have changed the column "ComputerAwareness" from a textbox column to a combobox column.This column is at the 21st position in the database but after changing it to a combobox in datagridview it is diplayed as the first column in the datagridview.How can I keep the position of this column same as in the database?I have googled a lot for the solution and tried all the possible ways but none seem to work.One of the ways I tried is in the code below.
Private Sub DisplayButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DisplayButton.Click
Dim cs As String = "Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=C:\Users
[Code].....
VB 2010 Express + MS Access 2003
today I successfully configured an interface to work with a test database I created in MS Access 2003. The database consists of only 8 records with 10 fields.
I used the basic built-ins with VB 2010 to build the interface in a simple form which shows only 6 of the 10 fields. It all seems to work well, that is the connection string built correctly, and I can run the program and view the individual records. My trouble is that when it goes to the 1st record it's actually the 3rd record in the database. And when I go to the last record it's actually the 2nd record in the database and the next to the last record is actually the first record in the database.
why the program seems to start at the 3 record and shifts the first two records to the end. All the records show up, it's just that they are somewhat out of order.