|
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.
|
|
|
|
|
What you mean is format the column to show only time on the database? right?
|
|
|
|
|
You don't format the date/time in the database. Formatting is done in the user interface for your application.
|
|
|
|
|
|
When you create your columns for the DataGridView, you simply specify the format string for the DefaultCellStyle:
DataGridView1.Columns("MyColumnName").DefaultCellStyle.Format = "M/d/yyyy"
or, using the culture-specific short date format for the current thread:
DataGridView1.Columns("MyColumnName").DefaultCellStyle.Format = "d"
All you have to do is Google for "datagridview format date[^]". There's lots of examples out there.
|
|
|
|
|