|
How do i use a Session in a XXXX.vb class (Not a XX.aspx class)?
|
|
|
|
|
You need to pass the Session object through to the middle tier, if you have no choice but to do that. Passing the value down makes more sense.
Christian Graus - C++ MVP
|
|
|
|
|
I am working with some National Wetlands Inventory data that has lots of codes specifying the details of that region. Since the codes are so complex there is an online source that will let you enter a code and then return what it means. However, there are hundreds of code combos so I want to be able to put a list together in excel or access and have a program go through the list and update the worksheet or table with the info from the website.
The website however does not pass the code in the address so I don't thinks it's a simple paste in the code to the address situation. I need to have the program enter the code in the correct textbox, submit the form, and then parse the results (returned in an html table).
Here's the catch I have done some vb, vba, and website development but I have never done something like this. Does anyone have a suggestion on how to do this? Or, sample code of a similar project?
I know that some websites really HATE this, but I am checking with the host before starting the project. I don't foresee any problems though as they put this together so that people could get this information.
- Justin
|
|
|
|
|
Kinda confused on what your try to accomplish here. Your trying to update tables or worksheets with information your retrieving from a website?
|
|
|
|
|
Hi
I use a pannel control to contain my owner controls ,
but the problem is when the user view more than control , then panel controls count is increase by nature ,
then when the user hit the link of the control more than one , i succeded to prenvent him from viewing the control again but i want that control bring to the front of all other , and how can i get certain control from all controls which contains on Panel contol
I'm sorry for all friends , it's the first steps on VB.Net 2003 and my question is many , but i have'nt any resorece like this site ,
jooooo
|
|
|
|
|
You can access the controls by name, or by index, on the Controls collection.
Christian Graus - C++ MVP
|
|
|
|
|
I tried alot Graus , without good result
i can't access the control on the controls collectoin by name
by index is allowed but the index is changed and i can't get the control new index , by name will be so easy but how ?????????????????????
untell now i spen 3 hours withount good result
jooooo
|
|
|
|
|
To access by name, just use the name, you don't need the controls collection.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi!
I have a datagrid filled with a dataset table.
I would like to know if it is possible to hide a one of the datagrid column?
thanks!
Hugo
|
|
|
|
|
Hey hlortie,
To answer your question, you want to access the .Visible property of the DataGridView.Columns("ColumnName") object. So if your dataGridView is called "dgvProducts", and your column is called "Amount", you could effectively hide it by writing the following:
dgvProducts.Columns("Amount").Visible = False
Hope that helps!
Jonathan Sampson
www.SampsonResume.com
|
|
|
|
|
I've found the way to do it:
'Assign style to datagrid
tStyle.MappingName = datagrid.DataMember
datagrid.TableStyles.Add(tStyle)
'Hide column
datagrid.TableStyles("Table_name").GridColumnStyles("column_name").Width = 0
|
|
|
|
|
The way I told you will work as well, and is actually the way you're supposed to do it. Your way allows people the option to widen the width, and see the information you were hiding.
May I suggest you hide the column if you sincerely want to hide it. Setting the width to 0 is not hiding it.
Jonathan Sampson
www.SampsonResume.com
|
|
|
|
|
Is there some way that I can detect if a user starts up an application? I'd like to build a monitoring tool that is always running in the background and detects when specific applications are started so that I can log the usage of the applications.
Thanks for any suggestions.
Regards
Tom
|
|
|
|
|
You can build a windows service that starts a timer which on each tick will check the process list, and log whatever u want to log.
A probably better way to do it is through WMI, you will need to create a callback on WMI when a process starts, that way whenever a process starts, WMI will execute the registered callback.
|
|
|
|
|
|
Sorry for sending blank message
the problem is I'm designing a dataform which is liked with sql server 2000 table , on the table i have tree or more choices and I want the user to choose only one of them ,
how can i Binding data to the radiobutton ,
thanks for all
jooooo
|
|
|
|
|
I am getting an invalid column error from oracle from the following code: I checked the columns and they are ok, any ideas ???
"Select A1.PART_CODE, A1.PO_NUMBER, A1.PO_LINE_NUMBER, A3.RECEIVED_DATE " & _
"from FINPROD.POP_LINES A1, FINPROD.GOODS_RECEIVED_LINES A2, FINPROD.GOODS_RECEIVED_HEADERS " & _
"WHERE A1.PART_CODE = sq(txtBox1.text) " & _
"AND A1.PO_NUMBER = A2.PO_NUMBER " & _
"AND A1.PO_LINE_NUMBER = A2.PO_LINE_NUMBER " & _
"AND A2.GRN_NUMBER = A3.GRN_NUMBER " & _
"ORDER BY A3.RECEIVED_DATE"
silver-gray
|
|
|
|
|
The database is not aware of your text fields. You have to put the value from the text field in the query, not the name of the text field.
---
b { font-weight: normal; }
|
|
|
|
|
There are 3 different table involved here. The table A1 will return many rows since it is the purchase order line items table. the other will return one for each of the rows in A1.
I don't understand your reply. This is a select command were the data in txtBNox1.text is the only field that has enterable data in.
Please explain your reply.
Thanks
silver-gray
|
|
|
|
|
The text is converted via the following function
Public Function SQ(ByVal Textin As String) As String
SQ = "'" & Replace(Textin, "'", "''") & "'"
End Function
silver-gray
|
|
|
|
|
The database is not aware of your function either.
You have placed the function call and the reference to the text box inside the string, that means that it's not code, it's just a part of the string. The string will be sent just as it is to the database, and the database couldn't do anything with it even if it did understand what it was, as it doesn't have access to either your function or your text box.
---
b { font-weight: normal; }
|
|
|
|
|
Thank you. Now I understand
Thanks
silver-gray
|
|
|
|
|
Hi,
Can anyone let me know how can I restrict special character like ', " to be entered by the user in the text box?
Thank you,
Regards,
Deepa
|
|
|
|
|
You could handle the TextChanged event, look for the special characters and strip them out.
|
|
|
|
|
Hi
You could try handling the Textbox.TextChanged Event and check the last character for the characters you want to ignore and remove it if it's illegal.
Kevin
|
|
|
|