|
I would like to ask what is the best db system that I can use to store data(ex:MDB or SQL)?
and secondly could some one tell me how to use the .mdb system I whet through a lot websites but non of those sites have a clear coding.
I found this one: but this just writes the columns, is there a practical way to use mdb.(I want to be able to use .mdb to its fullest capacity)
 - any help is extremely appreciated -
ps:
can you also give me the codes to save data to db as well
(by the way I don't know anything about using db in vb .net)
------------------------------------------------------------------------
Try<br />
Dim ds As DataSet<br />
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;")<br />
'provider to be used when working with access database<br />
cn.Open()<br />
cmd = New OleDbCommand("select * from table1", cn)<br />
<br />
dr = cmd.ExecuteReader<br />
While dr.Read()<br />
TextBox1.Text = dr(0)<br />
TextBox2.Text = dr(1)<br />
TextBox3.Text = dr(2)<br />
' loading data into TextBoxes by column index<br />
End While<br />
ds = New DataSet<br />
D1.DataSource = ds.Tables<br />
Catch<br />
End Try<br />
dr.Close()<br />
cn.Close()
----------------------------------------------------------------------------
|
|
|
|
|
.mdb just means a microsoft access database which uses VB code behind it. SQL is a language to access data from a database such as SELECT * FROM TBL_CODEPROJECT. If your database is small Access is easier you don't have to code a lot for simple things. If you need a larger database then you can look at SQL Server (2003, 2005 or Express--which is free) to store your data then using something else (such as Access/VB, a .NET environment to access the data inside the database.
_________________________________________
You can't fix stupid, but you can medicate crazy.
|
|
|
|
|
thanks, can you give me the coding for both?
|
|
|
|
|
|
The old function:
Format(InputDateString, "00/00/00") would take in something like 032807 and return 03/28/07.
I cannot seem to reproduce this with:
InputDate = String.Format("MM/dd/yy", InputDateString)or
OutputDateString= InputDateString.ToString("MM/dd/yy")Am I even close to figuring this out? I am trying to avoid the VB6 functions as much as possible.
As for the Mid() = that would be like saying:
Mid(InputRecord, 99, 5) = ReplacementString Is there a replacement for this other than
InputRecord = InputRecord.Substring(0, 99) & ReplacementString & InputRecord.Substring(99, InputRecord - 99)
-- modified at 8:55 Wednesday 28th March, 2007
Referring to the Formatting piece, if I first convert the string to a numeric value then use:
ConvertedValue.ToString("00/00/00")Then it works great how come I cant seem to get it to do anything from the original string?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
1) For the mid function use Substring(startIndex(zero based), length)
Dim strOriginal As String = "My String"
Dim strSub As String = strOriginal.Substring(3, 2)'Returns "St"
|
|
|
|
|
I understand substring Im really asking about the replacement capability of the Mid function.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
The Mid function didn't do replacements. It just returned a substring from a string.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
If you perform the following function:
Mid(InputRecord, 99, 5) = ReplacementString It will indeed substring out the piece you dont want and replace it at the same time with the new string.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Odd. It's not documented to do that. Testing in VBA reveals that it will only replace the exact number of characters specified in the original span. Using a different length string will only get cut off.
The closest equivilent in the .NET Framework is String.Replace(). Strings are immutable so any changes you make are not reflected in the original string, but in a copy of the string.
Dim s As String = "This is a test..."
s = s.Replace("is", "was")
The original string "This is a test..." is dropped while the Replace method returns a new string with the changes made.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I've seen people utilize the Mid for that functionality though, and you're right it is a fixed length but that is the intention for where it is used, at least where I currently work. I decided to modify what the other poster said and just do InputRecord = InputRecord.Remove(99, 5).Insert(99, ChangedInputValue).
I am aware that the strings just create copies but this doesnt seem to be a large enough building scheme to utilize something else and like I said before I cant guarantee that the value at 99 for 5 is unique so a .Replace might have unforeseen consequences.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
It is documented, but there's the Mid function and the Mid statement. They are two completely different things.
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter, VB to C++ converter
Instant Python: C# to Python converter, VB to Python converter
|
|
|
|
|
Oh crap. You're right. Shows you hong long it's been since I've touched VB6.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sorry - did not read your post properly. Nothing I can think of that is as direct. You could use:
Dim s As String = "12345"
s = s.Remove(2, 2)
s = s.Insert(2, "xx") 'Returns "12xx5
I take it String.Replace(oldString, newString) is no good?
Hopefuly someone else posts with a better answer than mine...
|
|
|
|
|
Yes because I cant guarantee that the instance from 99 for 5 is unique.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Then you'll have to build the string back up using the available substring methods. The StringBuilder class would probably come in handy for that and save you from creating more String objects than is necessary.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hello all,
i wanted to have an application, which iclude a button, when clicking on it an existing word file will open in microsoft word.
I tried to add Microsoft Word 9.0 Object Library, from the COM in ADD REFERENCES, but the problem is that i dont have it in the references.
So whats the problem, any thing wrong in the .net i got? any thing wrong in the installation?
Any help is greatly appriciated ....
scorpion
|
|
|
|
|
do u have office 2003 or later installed?
|
|
|
|
|
Sorry for mis-mentioning, am using office 2003.
scorpion
-- modified at 9:34 Wednesday 28th March, 2007
|
|
|
|
|
Did you right-click References in Solution Explorer, Click Add Reference, and look under COM tab for "Microsoft Word 10.0 Object Library"
|
|
|
|
|
if you still dont find it you'll need to install The Office 2003 Primary Interop Assemblies (PIA) ull get them from the micrsoft website , just search for it...
|
|
|
|
|
Sir/Madam,
Can somebody please help me in generation the print preview of my crystal reports in vb.net 2005.
Thanks and regards
Pankaj
|
|
|
|
|
|
i have one doubt....,
see when we are opening a new project in .net,
one global.asax file will be create automatically
what the use of that one?,
there some session start and session end process will be go on
its possible to explain those things...,
any one knows about that share with me......,
Take care....,
Regards,
Magi
|
|
|
|
|
The Global.asax file is in the root application directory. While Visual Studio .NET automatically inserts it in all new ASP.NET projects, it's actually an optional file. It's okay to delete it—if you aren't using it. The .asax file extension signals that it's an application file rather than an ASP.NET file that uses aspx.
The ASP.NET page framework recognizes automatically any changes that are made to the Global.asax file. The framework reboots the application, which includes closing all browser sessions, flushes all state information, and restarts the application domain.
The Global.asax file, which is derived from the HttpApplication class, maintains a pool of HttpApplication objects, and assigns them to applications as needed. The Global.asax file contains the following events:
* Application_Init: Fired when an application initializes or is first called. It's invoked for all HttpApplication object instances.
* Application_Disposed: Fired just before an application is destroyed. This is the ideal location for cleaning up previously used resources.
* Application_Error: Fired when an unhandled exception is encountered within the application.
* Application_Start: Fired when the first instance of the HttpApplication class is created. It allows you to create objects that are accessible by all HttpApplication instances.
* Application_End: Fired when the last instance of an HttpApplication class is destroyed. It's fired only once during an application's lifetime.
* Application_BeginRequest: Fired when an application request is received. It's the first event fired for a request, which is often a page request (URL) that a user enters.
* Application_EndRequest: The last event fired for an application request.
* Application_PreRequestHandlerExecute: Fired before the ASP.NET page framework begins executing an event handler like a page or Web service.
* Application_PostRequestHandlerExecute: Fired when the ASP.NET page framework is finished executing an event handler.
* Applcation_PreSendRequestHeaders: Fired before the ASP.NET page framework sends HTTP headers to a requesting client (browser).
* Application_PreSendContent: Fired before the ASP.NET page framework sends content to a requesting client (browser).
* Application_AcquireRequestState: Fired when the ASP.NET page framework gets the current state (Session state) related to the current request.
* Application_ReleaseRequestState: Fired when the ASP.NET page framework completes execution of all event handlers. This results in all state modules to save their current state data.
* Application_ResolveRequestCache: Fired when the ASP.NET page framework completes an authorization request. It allows caching modules to serve the request from the cache, thus bypassing handler execution.
* Application_UpdateRequestCache: Fired when the ASP.NET page framework completes handler execution to allow caching modules to store responses to be used to handle subsequent requests.
* Application_AuthenticateRequest: Fired when the security module has established the current user's identity as valid. At this point, the user's credentials have been validated.
* Application_AuthorizeRequest: Fired when the security module has verified that a user can access resources.
* Session_Start: Fired when a new user visits the application Web site.
* Session_End: Fired when a user's session times out, ends, or they leave the application Web site.
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
