|
Using VB.Net - I have an Access database. I have created bindings for my textboxes including format and parse delegates. Will display the table fields just fine. Formats the data the way I want. Problem - addnew method does not work. Does not create a new record. Simply overwrites an existing one. What's the right way to add new records with formatted, databound text boxes? Is there an article or best tips you can suggest? I've already poured over this site for one.
Thanks in advance.
JDFA
|
|
|
|
|
Access can be quirky especially with autonumbers so that may be where your issue is
also are you calling <newdatarow> = <datatable>.new<datatable>Row (for strong typped tables)
or <newdatarow> = <datatable>.Rows.newrow (for weak types)
(this gets an appropo autonumber and inits all feilds in the new row with default values)
Befor calling <datatable>.rows.add(<newdatarow>)?
make sure your not specifing the index that the row is added at. let the framework do that.
Hope that helps,
Frank
hey...slang is the vernacular for the vernacular...wow
|
|
|
|
|
Thanks for getting back to me and giving me some things to think about.
I was using me.bindingcontext(<datasource>).addnew and got nowhere with it.
I also tried <dataset>.tables<"tablename">.addnew with no effect. It is an autonumbered table and I wasn't specifying the index. I take it that I want to create a new row, assign the values and then add it to the table.
Question - what is the parse function doing for me then? So far, it only seems to be affecting existing records that I want to edit. Part of my problem may be that I don't understand yet exactly how it is to be implemented.
Thanks a lot. Great site - Incredible info,generous experts.
|
|
|
|
|
Look into Parse and Format.
You use those to modify the on the data in and the out for presentation and storage.
IE: you have a DB that some yahoo created a collumn with "y","Y","n", and "n" in it.
you want to bind it to a checkbox. if the feild was a bit/Boolean, you could directly bind it with the datasource property or by using
me.checkbox.databindings.add(new binding(me.dataset1.<tablename>, "<feildname>", "Checked <or any="" other="" bindable="" property="">"))
...or somthing a lot like that.
as an aside You can do really neat things with lookup tables and comboboxes with this command by binding the display(human readable text feild) and value(the pk feild) members oif the combobox to teh lookup table, and then binding the selectedvalue property to teh real datatables fk feild into the lookup table.
I can't quote you the code to parse (to morph data from the UI to fit the database) and format(for the data coming out of the dataset into the UI), 'casuse I design my databases with some forthought, but basically you create events for the feild parse and format, and within those, you mutate back and forth.
Below are some assorted ramblings with a tip or two buried within them, mainly on binding context and currencymanagers. it isn't directly in your question but if you like check it out.
within your binding context are all your datasiource objects (datasets, dataviews, and datatables) each instance of which has a currency manager that points to and iterates through the datarows within. Currency managers are Great but theres a gotcha. you only get one per instance of a datasourceobject. thats Why I create dataviews to show the datatables in my datasets when I'm binding them. also no more than one control can be bound to a feild on a particular datasourceobject. but you can have multible views sitting atop the same datatable and bind two controls to the same feild but on the other view.
AS a result I always get my currency managers by using
dim thing as CurrencyManager = ctype(me.bindingcontext("<datasourceobject>"),currencymanger)
whenever I need one (and you can just use the whole expression instead of )
Now there are some advanced members to this lib that intellisense won't point out to you by default. I recomend that you disable "Hide Advanced Members" in teht Visual Studio options. My favorite is
ctype(me.bindingcontext("<datasourceobject>"),currencymanger).current.row("<feildname>")
to access the value in a row. not nesecarily the best form but it gets the job done.
have fun,
Frank
hey...slang is the vernacular for the vernacular...wow
|
|
|
|
|
hello
i want to disable only close button of the form and other two button should be enable please tell me how i can do this thing. plz tell me soon thanks
|
|
|
|
|
btnClose.enabled = false
Roy.
|
|
|
|
|
hi
try to use the closing event for your form
Private Sub Form1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing<br />
e.Cancel() = True ' this will stop the form closing <br />
End Sub
Tamimi - Code
|
|
|
|
|
HI guys, I'm a student and need some help with dates in VB.NET. What do I do to verify that date values are input correctly on a form? This includes the following: The day, month and year are entered separately; One cannot (obviously!) be born on day 0 of month 13, or on 29 February 2003. I've never worked with dates and don't know how to go about this. Can someone please help me here?
MichMar
|
|
|
|
|
With the day, month and year being inserted separately ... it can be easy to check.
some normal logic
You will ask the year first because of leap years and stuff.
Next the month will be enetered in
if EnteredMonth > 0 and EnteredMonth < 13 then<br />
'month is a correct month<br />
else<br />
'month is not correct<br />
end if
then when u know the month you can demine if the month has 30/31/28 or 29 days and the day can be checked to see if it falls in the bounds
here is just a basic layout that you can change to suit your variables ect .. i think that more than explains it how i would go about it
<br />
if year = leapyear then<br />
<br />
<br />
else ' not a leap year<br />
if month = 4 or month = 6 the 'all the months that have 30 days<br />
if enteredday > 0 and enteredday < 31 then<br />
'date is correct<br />
else <br />
'error <br />
end if<br />
end if<br />
<br />
if month = 5 or month = 3 then 'all the months that have 31 days<br />
if enteredday > 0 and enteredday < 32 then<br />
'date is correct<br />
else <br />
'error <br />
end if<br />
<br />
if month = 2 then 'month is feburary<br />
end if<br />
<br />
end if<br />
<br />
end if
|
|
|
|
|
use a datetimepicker control
GUERVEN
Truth or Consequence
|
|
|
|
|
hi there, I wonder if someone know an easy way to tarnish a given rgb color. (decrease the saturation)
I can't find working convertion algorithms between RGB <-> HSL
thanks in advance for your help !
|
|
|
|
|
Where did you look ? The one in the C# section in my article on HSL works fine.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
hi Christian,
it's a nice source you provided 
All I need is this, am I right ? :
HSL hsl = HSL.FromRGB(bytesSrc[2], bytesSrc[1], bytesSrc[0]);
hsl.Saturation *= factor;<br />
Color c = hsl.RGB;
Gonna try that ! thanks
|
|
|
|
|
Yep, that looks right.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
That works like a charm !!
I made a DLL with only your C# class HSL and then I typed this in VB.Net :
Dim dlg As New ColorDialog<br />
If dlg.ShowDialog() = DialogResult.OK Then<br />
Label1.BackColor = dlg.Color<br />
Dim theHsl As HSL.HSL = HSL.HSL.FromRGB(dlg.Color)<br />
theHsl.Saturation -= 0.6<br />
Label2.BackColor = Color.FromArgb(theHsl.RGB.ToArgb)<br />
End If
That's all I needed, problem solved !! thanks a lot
|
|
|
|
|
Hello.
I writing some vb ( using vb 6 ) application and in some place i need to show some window on the top of all other windows.
The other windows are working in different application and i don't have any connection with them.
How can i be sure that my window in really will be on top ? i always find some place that the other window show their windows on me - so my window is not on top.
Thanks for any help.
|
|
|
|
|
For the top of all window, You must open your window as modal window. In modal window, No window comes on top unless your window have been closed.
form1.show vbmodal
Kumar Prabhakar
|
|
|
|
|
I'm using Nemanja's Task Pane project and I have all the panels laid out the way I need them and I'd like to add click events to the items in each panel. Could someone tell me or show me how to do this?
Thanks,
Andy
P.S. It's way too much code to post here and I don't see how to attach a file here, so here's the link to Nemanja's project. http://www.codeproject.com/useritems/TaskPane_Source_Works.asp[^]
|
|
|
|
|
Hi,
I am developing a Multithreaded Application for Scanning using Black ICE Imaging SDK. In one Primary Thread I am scanning Images and saving them to collection. In Second Thread, I am doing Image processing on the scanned Image by taking it from Collection.
My Problem is the Primary thread is scanning Images, but in Secondary thread when I try to load it from temporary file or Collection, I am getting some Exceptions. The brief Code for this is given below:
Sub StartScan( )
BiTwain.Action = BITWAINLib.enumScanOperations.TWSTAT_BATCHSCAN
Dim thrd as Thread
Thrd=new Thread(AddressOf ProcessImage)
Thrs.Start()
End Sub
Sub BatchPageDone( )
BIDIBObj.SaveDIBInImageFormatExt("C:\Temp\” & TempCount & “.tif", hDib, 1,
BIDIBLib.enumFileFormats.imgffTiff,
BIDIBLib.enumCompressionModes.imgcmCcittG4, BIDIBLib.enumFillOrderModes.imgfoNormal,
False)
TempCollection.Add(("C:\Temp\” & TempCount & “.tif")
End Sub
Sub ProcessImage( )
While TempCollection.Count = 0
Thread.CurrentThread.Sleep(100)
End While
'Loading Image to Memory
'I am geting error at this point
Hdib=BITiffobj.LoadTiffIntoDIB(TempCollection.Item(0).ToString(), 0, False)
'Processing HDib
End Sub
When the Secondary thread try to Load the Image from file, I am getting two errors. While trying to load First time, the Exception is “Request Timed out”. When try to load second time, the exception is “Because this evaluation could cause side effects, it will not be executed until enabled by user.”
Thanx,
.Net Programmer, Software Engineer
|
|
|
|
|
Dim thrd as Thread
Thrd=new Thread(AddressOf ProcessImage)
Thrs.Start()
Is this your actual code? Should be Thrd.Start() instead of Thrs.Start()
|
|
|
|
|
Sorry, It's a typing mistake.
It is Thrd.Start()
.Net Programmer, Software Engineer
|
|
|
|
|
Visual Basic 2005 Express Edition:
This works, but, I need to get the .wav file from Resources:
My.Computer.Audio.Play("C:\Documents and Settings\Owner\My Documents\Visual Studio 2005\Projects\OrthoLabRx\OrthoLabRx\Resources\PodVwBy.wav")
I placed the .wav file in Resources, but, I can't seem to access it from there.
This does not work:
My.Computer.Audio.Play(My.Resources.PodVwBy)
It says "value of type 'System.IO.UnmangedMemoryStream' cannot be converted to 'String'.
This worked, but, instead of a click, it played a grinding noise:
Dim sndPing As New SoundPlayer(My.Resources.PodVwBy)
sndPing.Play()
My.Computer.Audio.Play(My.Resources.PodVwBy)
|
|
|
|
|
I have an application that I wrote that causes a variety of message boxes to come up. Can somone here help me with how to make the message box color change.
Thanks
|
|
|
|
|
What part of the message box change color ?
If you are talking about the actual form part i dont think you can do that... On the other hand you could create your own custom message box which you could do that with
|
|
|
|
|
How do you create a custom message box?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
