|
Locking a record is just about never a good idea, and in your case, you don't need to do this. If you have to update a column, all you have to do is execute a single SQL statement. Say you want to reduce a value by 5:
UPDATE tableName
SET columnName = columnName - 5
WHERE someRecordId = someIdValue
|
|
|
|
|
hi
am working on a project of a school that has many hostels. looking out for someone that will give me a code that will automatically select a hostel from a list of hostels and give it to the client filling the form. am using VB 6.0 fr this particular project
thanks
Daser solomon
Nigeria
Helping someone is simply helping oneself
|
|
|
|
|
What exactly do you want here is what I understand:
You're client logs in (or something) then you want a hostel that is pecificly for that client to be displayed.
If this is the case you'll have to keep track of wich hostel is 'linked' to wich client (you can do this in you're db if you use one)
then it is only a mater of selecting the right hostel from the list (wich I presume is gathered from a db) and this can be done in de sql string with an ID or something like it.
if ofcourse it doesn't matter wich hostel you give to the client (random one) look at the function random and give you're hostels an numeric id that way you can easly select one.
|
|
|
|
|
a tanks
i agree with this:
if ofcourse it doesn't matter wich hostel you give to the client (random one) look at the function random and give you're hostels an numeric id that way you can easly select one.
i have a thought question from your answer. is it that you are going to put those hostel in an array? if it is write then can u plz help me with a little code that will take care of that case
helping someone is automatically helping self
|
|
|
|
|
Public Class Form1<br />
Dim l As New List(Of hostels)<br />
Private Sub RibbonDropDownButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RibbonDropDownButton1.Click<br />
Dim i As Integer<br />
Dim r As New Random<br />
i = r.Next(0, 10)<br />
For Each h As hostels In l<br />
If h.id = i Then<br />
MessageBox.Show(h.name)<br />
End If<br />
Next<br />
End Sub<br />
<br />
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
Dim i As Integer<br />
For i = 0 To 10 'just to fill the list with some values<br />
l.Add(New hostels(i, "test" & i))<br />
i += 1<br />
Next<br />
End Sub<br />
End Class<br />
<br />
<br />
Public Class hostels<br />
Dim iid As Integer<br />
Dim sname As String<br />
Public Property id() As Integer<br />
Get<br />
Return iid<br />
End Get<br />
Set(ByVal value As Integer)<br />
iid = value<br />
End Set<br />
End Property<br />
Public Property name() As String<br />
Get<br />
Return sname<br />
End Get<br />
Set(ByVal value As String)<br />
sname = value<br />
End Set<br />
End Property<br />
Public Sub New(ByVal iid As Integer, ByVal sname As String)<br />
Me.id = iid<br />
Me.name = sname<br />
End Sub<br />
End Class
as I said: very simpel one
if you work with a db you'l have to fill the list with what you extract from you're db
depending on wich version you use of vb you might have to use an 2 dimansial array instead of a list
hope this helps you on you'r way
|
|
|
|
|
tanks dude
i will have to test it. i will give you credit as soon as am done
helping someone is simply helping self
|
|
|
|
|
hello all
how to call php web services in vb.net,if any web server configuration required for that,please help.
|
|
|
|
|
If the web service you're talking about follows standards, all you need to do is add a web reference to it. Double-click MyProject in the Solution Explorer, click on the References tab, then click on the little downward facing triangle on the Add button and pick "Web Reference..." Type in the URL for the web service and click Go. If the web service comes back good, you can click Add Reference. Then you can create an instance of the web service just like you do any other object.
Dim myService As New WebServiceName
|
|
|
|
|
i have done all this thinks but my problem is when i want to access the function of this PHP web service it through transport connection problem , is any configuration required for apache server to access
|
|
|
|
|
one more thing is that whenever i check this web service with soap UI it return HTML Fragment instead of XML Fragment,please help
hope u understand my prob
thanks
|
|
|
|
|
Well, you're kind of out of luck as far as I know. I've never seen a web serive return HTML instead of XML.
|
|
|
|
|
Hi,
I have a form which is MdiContainer.
But I want to write in a database all the controls from this form and I see all the controls but if a control is System.Windows.Forms.MdiClient I can't see the name of this control.
please help.
thanks.
|
|
|
|
|
I don't know why but this seems to be correct
possible work around: give the name of the form in in the tag property and then access the tag property to know the name of the form
|
|
|
|
|
That's because it doesn't have one. You can assign one if you want, not that it'll do you any good. Since an MdiParent form can have one, and only one, MdiClient control on it.
|
|
|
|
|
do you mean all the 'controls' of the mdicontainer or all the 'forms' of the mdicontainer that are open (I can't imagane you mean controls because if you use controls in a mdicontainer they will always be ontop (even on top of any form that you put in it)).
if you mean forms like I think you do use the work around since you can't access the name if its in the container
|
|
|
|
|
thanks for your help.
I resolved the problem.
|
|
|
|
|
Hi all,
I can able to fetch a single data from Sql and display it in the Excel sheet using Macro, this is the code.
I am getting in the Text Box:
sno = TextBox1.Text
When i am clicking the Ok button:
Query = "Select sname,scity from smaster where snum='" & sno & "'"
Set QueryRs = oConn.Execute(Query)
Sheet1.Cells(1, 1) = QueryRs("sname")
Sheet.Cells(1, 2) = QueryRs("scity")
Result:
Name, city displayed in the Excel sheet1
Now my problem is how to fetch multiple data and display (like how to use loop in it)
waiting for timely help
Tech_spidy
|
|
|
|
|
dim rst as dao.recordset
dim query as string
query = "select sname,scity from smaster"
set rst = oconn.execute(query)
dim i as integer
i = 1
do while not rst.eof
Sheet1.Cells(i, 2) = QueryRs("sname")
Sheet.Cells(i, 1) = QueryRs("scity")
i +=1
loop
I think this will work (haven't tested it dough)
|
|
|
|
|
Hi Guys,
I have a form that have a form that has a combobox, textbox and 2 button.
textbox:IDNo, Time in and time out
combobox:Team member
button1:lates
button2:overtime
Now, when I select on the team member combobox, it displays the team members idno, time in and out.
when you press the late button.
I used 2nd form for it with a datagrid. That displays all the lates of that team member.
The problem is i used this code to the 2nd form.
sql3 = "Select IDNO,DATE, ARRIVAL, DEPARTURE, TIMEDEDUC, REMARKS from LATES where IDNO =" & "'" & txtidno.Text & "'"
Dim cmd As New OleDbCommand(sql3, conn)
da.SelectCommand = cmd
da.Fill(ds, "late")
conn.Close()
since there is no textbox on the 2nd form it has wiggles.
How can I solve this im kinda lost......
Thanks.
|
|
|
|
|
there are several ways to solve this:
1) make a property iIDNo (or something), make this property public and then in the 2nd form you can acces it like this: form1.iIDNo
2) make a contstructor with a parmeter (new(iidno as integer))on the 2nd form, when you click on the button you call the 2nd form with the parameter: dim frm as new form2(txtidno.text) in the contructor you then initialize a local variable wich you can use in the sql string
3) same as 2) but in stead of giving a string or integer with the constructor you just give you're form1 with it (new (ffrm as form)) on the click: dim frm as new form2(me)) in the constructor you then initialize a local variable (private frm as form) and 'fill' it frm=ffrm
then you can access you're textbox by: ffrm.txtidno.text
hope this helps
|
|
|
|
|
i want to create active x control for imageviewer using scroll bar with picture box for zoom and moving the image in vb.net
help pls
sathish
|
|
|
|
|
|
|
Hi Guys,
I have a database that stores time for example an attendance record.
The problem is when I displayed it to the datagrid those columns containing
time, show as dates on the datagrid. Why is that?
Hope you can help me with this. Thanks a lot.
-- modified at 5:12 Monday 16th July, 2007
|
|
|
|
|
Because a time cannot exist in the database without a date. Really, all you have to do is format the column to show only the time value. The date part, usually Jan 1 of some year, can be ignored.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
