|
hi all,
i m working on a vb.net project. i have used SQL SERVER 7.0 as backend.To save an information into database i used varchar datatype that has 8000 length, i m in trouble coz a particular data field has more than 50000 char.
how to save this field into data base.
what should i do????
Please suggest me any logic to storing it.
hi this ajay bharti
|
|
|
|
|
Try using a datatype of TEXT. Read up on it in the MSDN online help.
...Steve
|
|
|
|
|
Three options.
1) You chamge the datatype in something else (i.e. a text) or if you can't
2) You split the data into 7 fields each 8000 char or if you can't
3) You store your data in a different position (i.e. a file or another DB) and you put in your fied a reference to that information or....
4) ..I don't know!
|
|
|
|
|
Hi,
Can anyone please give me the code snippet in vb6 to check if MDAC is present on a machine and the MDAC version number if it is present.
Right now i have a code that checks the ADO version.
Here is the code:
Option Explicit
Function GetAdoVersion() As String
'Returns an empty string if ADO is not installed
Dim o As Object
On Error Resume Next
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then
GetAdoVersion = o.Version
Label1.Caption = "ADO Version = " & o.Version
Else
Label1.Caption = "ADO is not installed"
End If
End Function
Private Sub Form_Load()
Call GetAdoVersion
End Sub
Are ADO version and MDAC version the same always?
Thanks in advance,
Sarah
-- modified at 6:12 Thursday 24th November, 2005
|
|
|
|
|
It's not that simple. No ADO and MDAC versions are NOT always the same. Various applications can install differing versions on their own, without installing the complete MDAC package.
There is no reliable way to determine whcih version your using. Component Checker[^] will scan your machine to determine which version of MDAC your machine has installed, or the closest match. It'll show you what pieces are missing and what's installed, as well as the version information for each .DLL.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Ok.Thanks for taking the time to reply.
-- modified at 0:34 Saturday 26th November, 2005
|
|
|
|
|
|
I really cannot get into the DB story. Anyway this is what it happens.
I'm running VS2005 and MS SQL Server Express. I created a DB under the SQL server and it works. I filled the data manually (right click on the table and see table data) and it works.
At application start I load data into a dataset with the autocreated tableadabter fill method:
Dim ta As New RF_MapDataSetTableAdapters.VeicoliTableAdapter<br />
ta.Fill(dbVeicoli)
and it works beacuse the dataset contains the test rows I inserted manually.
Now I have a form to create a new record .. not directly linked but on the OK command click I:
Dim mVehicle As RF_MapDataSet.VeicoliRow<br />
'<br />
mvehicle = dbVeicoli.NewVeicoliRow<br />
mvehicle.ID = CreateID()<br />
mvehicle.Nome = txtNome.Text<br />
...and all the other fields...<br />
dbVeicoli.AddVeicoliRow(mvehicle)
And it works, in the sense that the dataset contains the new row and it's showed somewhere else in the app..... now on the main form closing I want to save the DB and according to documentation it should be very easy:
Dim ta As New RF_MapDataSetTableAdapters.VeicoliTableAdapter<br />
ta.Update(dbVeicoli)
Unfortunately it isn't beacuse the DB has still only the original, manually entered, records. Where do I go wrong?
I tried also another way. Rather than updating the dataset, I tried to create new records directly in the DB with this code:
Dim ta As New RF_MapDataSetTableAdapters.VeicoliTableAdapter<br />
'<br />
ta.Insert(CreateID(), txtNome.Text, txtModello.Text, _<br />
txtTipo.Text, txtAnno.Text, txtColore.Text, _<br />
txtTarga.Text, dtpInizio.Value, dtpFine.Value, _<br />
cmbDispositivo.SelectedIndex.ToString, _<br />
1, txtVoce.Text, txtDati.Text, dtpCreazione.Value, _<br />
txtLineaDati.Text, txtLineaSMS.Text, _<br />
txtLineaVoce.Text, Now, "", "", 0, 0, "", "", "", "", _<br />
"", "", 0, "")
but then again the DB is immaculate as before. It comes without saying that I get no exceptions ... so the code seems to work correctly with the DB.
What am I missing?
|
|
|
|
|
Hi all, how do I group radio buttons on a Windows Form without using a group box. I dont want the border effect that the group box has because its a yes/no radio button which comes after a question.
Thanks,
|
|
|
|
|
Use another container like a panel I guess will do the job....
|
|
|
|
|
i want to make a system which is when i key in the matrix number at client side than, the statistic will increase follow how many number are enter. only the admin can view this statistic. How to make this?? how to connect client and admin??
|
|
|
|
|
We 'heard' you the first time
Don't expect an immediate answer to your question. This board is monitored by volunteers - not paid staff.
For more information about getting an answer see this post:
How to get an answer to your question[^]
...Steve
|
|
|
|
|
i want to make a system which is when i key in the matrix number at client side than, the statistic will increase follow how many number are enter. only the admin can view this statistic. How to make this?? how to connect client and admin??
|
|
|
|
|
|
hello can you help me.. its very urgent..
|
|
|
|
|
is there anybody that know how to connect, when i enter matrik no at client side then at the admin side the statistic graph will increase everytime i enter the number. only admin can see this statistic.. please anybody know?
|
|
|
|
|
There is no need to post your question 4 times.
There are a number of ways to do what you want to do, but without knowing your skill level I can't provide you with any help. If you had a specific question I could probably easily help.
Completely and utterly guessing here.
Create a client side record set, when the client changes the grid or what ever update the database.
On the admin side, randomly pool the database for changes. Update the ui as needed.
That’s about the simplest way that I can think of off the top of my head.
The technologies you will need to know are VB and ADO, should be very easy…
And what is a Matrik? Could it be Matrix? For a "Matrix" you will need a grid of one sort or another, VB has two or three that are fairly easy to work with. When you get stuck feel free to ask a specific question.
RiNaZaiNoN wrote: when i enter matrik no at client side
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
-- modified at 5:02 Thursday 24th November, 2005
|
|
|
|
|
Using the PerformanceCounter-Processor Time get the right reading when it's used with intel pentuim but it double the reading when it is used with intel pentuim HT?
why??
...Militiaware
|
|
|
|
|
Read up on HyperThreading technology from www.intel.com[^].
Basically, an HT processor is (almost) equivalent to two.
...Steve
|
|
|
|
|
how could i know if doc or txt file is a Unicode or not?
thnx
Militiaware
|
|
|
|
|
With all due respect, I think you need to spend a little more time doing some basic research of your own.
...Steve
|
|
|
|
|
counting the words in a file (txt, rtf, doc) after loading it to a RichTextBox differ than the counter in the MSWord...sometimes more, sometimes less...trying with many files...
with getting notice that the file type as a Rich Text Box Stream Type (ex: PlainText, UnicodePlainText or RichText)..
so, why this problem????!!!
i need help
Militiaware
|
|
|
|
|
Simple - they use different algorithms to determine the number of words. Choose one app and stick with it otherwise you're comparing apples with oranges.
...Steve
|
|
|
|
|
i'm sorry Mr. Pullan
but how two algorithms solve one problem and each of them give diffrent answer...
one of them should be right!
Thanx Steve
Militiaware
|
|
|
|
|
They are both right in their own way.
They count words differently from each other. There are many control codes in a Word document which are only interpreted correctly by Word itself. Any other program may consider the control characters themselves to be words or beginning of words or ending of words or garbage etc...
The only way to get a consistent answer is to use the application from which the file was created in the first place.
...Steve
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
