|
Sorry, I was thinking of a DataGridView. Creating it in Design View or at Run-Time use your table adapter to customize your SQL to format the date for you. So, if you customize the SQL in the adapter this DataSet will mimic the output of the adapter and pass the format into you DataGrid.
Select convert(varchar, DateColumnName, 1) as [MyDate] from MyDBTable -- 11/21/06<br />
Select convert(varchar, DateColumnName, 101) as [MyDate] from MyDBTable -- 11/21/2006
Refernce for T-SQL Convert[^]
|
|
|
|
|
Thanks AreJay,
I will give that a try, thanks for the link.
Steve
|
|
|
|
|
in the aspx page a button and a text box is placed.
When i enter an integer in the textbox and press the button,then i should get the number of textboxes that i have entered in the textbox.
please help me out
tirumal
|
|
|
|
|
tirumal1231 wrote:
When i enter an integer in the textbox and press the button,then i should get the number of textboxes that i have entered in the textbox.
How have you entered textboxes into a textbox ? Or do you mean the text you enterd ? What do you mean by 'get' ? In just the code behind ? A message box ? A Label ?
This sounds like homework to me, it's certainly a trivial task. What have you done already ?
Christian Graus - C++ MVP
|
|
|
|
|
hello Christian Graus
when i enter the integer value in the textbox and click the button.i should get the number of textboxes that i entered in the textbox.
1)Initially i called a function called loadtextboxes, as follows :
Sub loadtextboxes(ByVal val As Integer)
For Each tb In val
TextBox(tb = New TextBox())
tb.ID = i
Next
End Sub
i don't know how we can produce textboxes dynamically by clicking the button.
This is not a homework.
It's for automating the project.So please kindly help me
thank you 
tirumal
|
|
|
|
|
Oh, I see.
The Textboxes can be added to the controls collection on the page, but if you want to position them, you need some sort of PlaceHolder ( or similar control ) to contain them. Then you can just create textboxes with new, set their properties, and add them as child controls, to the Controls collection of the Placeholder.
Inserting them in a table, or adding some CSS would help you to lay them out nicely.
The other trick is, they need to be added to the page very early in the life cycle, if you want viewstate from those controls.
Sorry, I thought you wanted the page to report back the number, which would obvioulsy be a homework assignment
Christian Graus - C++ MVP
|
|
|
|
|
thank you christian graus,
for your valuable suggestion.I thought of placing them in a table and then...
now you suggested me placeholder.and the other thought is we can declare a textbox and add the code even for the design part as follows:
tb(i) = New TextBox()
tb(i).ID = "Tirumal" & i
tb(i).Width = Unit.Pixel(50)
tb(i).BorderWidth = Unit.Pixel(50)
Me.Controls.Add(tb(i))
ok.Anyway i will use the placeholder.
Thanks again.
tirumal
|
|
|
|
|
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 ,
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
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; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
