Robby
Moderators
-
Posts
3848 -
Joined
-
Last visited
Content Type
Profiles
Forums
Blogs
Events
Articles
Resources
Downloads
Gallery
Everything posted by Robby
-
The following allows pdf, txt and zip (for example) Dim UpFile As HttpPostedFile = FileBrowser.PostedFile If ValidateUploadFileType(UpFile.ContentType.ToString) Then 'valid else 'not valid end if Private Function ValidateUploadFileType(ByVal txt As String) As Boolean If txt.IndexOf("text/plain") > -1 OrElse txt.IndexOf("x-zip") > -1 OrElse txt.IndexOf("pdf") > -1 Then Return True Else Return False End If End Function
-
using one database to update another
Robby
replied to
mr relaxo's topic in
Database / XML / Reporting
Create 2 seperate connection objects, one for each provider. Read the no_in_stock into a variable from Access then update the appropriate column in mySql. -
You can store the questions in a database, perhaps table1 with a column each for IDNumber (1-200), Question, Answer. And table2 would be Categories holding the range of questions that fall into that category. Do you have a layout in mind? Datagrid, textboxes etc...
-
Changing Connectionstring Datasource??????
Robby
replied to
Duckjibe's topic in
Database / XML / Reporting
what is 'Data_Connection' ? -
Would it not be better if you save the 10,000 lines of text in to local text file, then upload that file to the server, parse it and update its content to the database?
-
If you have already extrcted the phone number into its' own array dimension, then use that field/dimension to do your sort.
-
In case you're interested: Here are the products that shipped those DLLs... http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=271718 http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=271719
-
This would be very complex (not difficult, just complex), you can use Regular Expressions to pin-point where each occurance of a 10 digit set of numbers are (i.e. nnn-nnn-nnnn). Load each line into a 2 dim array with the second element holding the starting positon of the phone number, then maybe do a bubble-sort. At the top of my head this makes sense to me, perhaps someone can come up with something better.
-
Also, is '123 ab street 555-555-5555' all stored in one element/line/field as one continous string?
-
You need to include a second ' with each single quote... Dim x As String = "hello. How're you there ? " Dim s As String = x.Replace("'", "''") MessageBox.Show(s) 'Don't worry it will go into the DB as one single quote.
-
Datagrid sorting and connection to Access
Robby
replied to
ses41's topic in
Database / XML / Reporting
The index is there so you can iterate from 0 to count, you cannot use the index in any collection as a Key. The reason that the grid is not sorted as it is in Access is that Access knows which column is the PK column, you must explicitly tell the grid which column holds the PK (Primary Key). -
Datagrid sorting and connection to Access
Robby
replied to
ses41's topic in
Database / XML / Reporting
1) The index number of a control is supposed to work this way, the index is the location of each element, just like an array. Imagine if you were to loop from lowerBound(0) to upperBound (10) but the data was re-sorted, that would be a mess. 2) You should be including an 'Order By' in your sql statement if you want a specific sort order. 3) You would need a Reference guide then, I don't know of any. MSDN/F1 usually has info like this. -
Darkznet, It seems that you may not know in advance which sentence you want to extract, or even what that sentence may be, is this correct? Anyway, try this. Dim x As String = "hello . How are you there*I am Leanord*This world is beautiful" Dim a() As String = x.Split("*"c) Dim i As Integer For i = 0 To a.GetUpperBound(0) MessageBox.Show(a(i)) Next End Sub
-
How does the business logic handle a blank address?
-
My reason to get up in the morning is to write more code. :) I get a sense of accomplishment on each section of meaningful code, I don't need to wait for the end because sometimes the end is nowhere in sight with large scale projects. Wyrd, you started a thread a few weeks ago about programming being artistry or a mechanical process, well, I'll say it again... artistry. :)
-
Since the checkboxes are getting their values from a database, then on postback they are getting the same values (from the DB). What you need to do is not reload the checkboxes if IsPostBack is True.
-
Hypnotic, hypnotize, mesmerize, to put under a spell. :)
-
What does your attemped code look like?
-
or Controlchars.newline
-
you can work with SP in Access, you just cannot view them. Take a look ...http://www.devcity.net/net/article.aspx?alias=msaccess_sp2
-
Heiko, I'm glad your avatar is working, so now you can put us under your woowowwoowwwooo spell.
-
This type of practice is usually frowned upon.
-
Orbity and Wyrd: I changed your settings so the system has you as Last Visted 07/21. In other words you should get more than one page in the resultset so as to test this mystery out.
