|
If you are using visual basic 2003 then you can use the following statement
I think the styanx for hidding a column is like this.
datatable.columns(0).columnmapping = Hidden
|
|
|
|
|
Hello,
Thanks for indicating the way. Actual code is
tblMaster.Columns("Id").ColumnMapping = MappingType.Hidden
tblMaster.Columns("IsBillable").ColumnMapping = MappingType.Hidden
where "tblMaster" is datatable, it does work and seems to be correct way of doing this.
Now I am trying to see how the hidden columns will be updated when foreign key values change due to change in name/description of foreign key or when a new record is added.
I will post the concerned code when I check it thoroughly.
thanks once again.
thanks,
Madhav
|
|
|
|
|
infotools wrote: While displaying contents of a datatable / dataview in a datagrid, I wish to suppress some columns (foreign keys, few admin fields) which user is not concerned with.
You could build a query and only select the columns that you want to display using that query, before you bind the datatable to the grid, i.e:
SELECT column1, column2, ... FROM [tableName] WHERE ...
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
When the User Logs on, make sure his UserGroup is stored in a session variable i.e.
Session("AccessGroup") = row("vchAccessGroupName")
Then in the OnItemDatabound event for the datagrid:
If Session("AccessGroup") <> "Admin" Then
e.Item.Cells(x).Visible = False //////x being the index of the column in the html
End If
That's all really. Hope this helps.
|
|
|
|
|
Hi, i currently using VB.NET and RichTextBox for coding HTML, but how can i display design, do you have any library, please help me.
Thanks
Socheat
|
|
|
|
|
Do you mean design as in tables and images etc?
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
Yes, i mean like that
Socheat
|
|
|
|
|
Well, I'm not really sure how to do something like that with a Rich text box. I suppose you could use the web browser control? That way it will be able to display web pages in your application, without the need for loads and loads of code.
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
Hiya,
I was just wondering if there was a way of stopping a form from loading when the application starts in vb.net, and instead using the code in a seperate vb module?
Thanks, any help will be greatly appreciated,
Lloyd A.
Lloyd J. Atkinson
|
|
|
|
|
I believe your choices of startup are form or sub main. what do you want to happen?
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
|
|
|
|
|
Well basically I just want the application to start up, run through the code and without needing a form. I've tried many different ways but I just cant figure it out.
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
Hi,
if you build a "Console App" it gets started from a DOS prompt and will interact inside
the console; if double-clicked it will open its own console.
if you builw a "Windows App" it by default creates and opens a Form, because Visual Studio
includes a "Application.Run(new Form1())" in your main code; if you just use
"Application.Run()" then no form is created/shown.
Hence: choose Windows App, and omit the form.
|
|
|
|
|
I am taking over an application that consists of using ASP.NET and VB.NET. There are alot of hardcoded values in this application. What are the best practices and where is the best place to store these hardcoded values to get them out of the code?
Thanks in advance for you help.
|
|
|
|
|
caalock wrote: the best place to store these hardcoded values to get them out of the code?
With care. When you pull out hardcoded values and place them in the form of constants at the beginning of your code, make sure when you replace it in the code body, that it is indeed the same value. For example, if you have '1' hardcoded in your code, and in one case it works for '1', and you have to change it in the future, to say, '2', it may break something else.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
HI...
If it is a Database application then u can keep in a table...
U can also have them in a text file and read from there as in the case of configuration files
Good Luck
|
|
|
|
|
Hi,
you should put your constants where they belong, i.e. give them exactly the scope they
need. Examples:
- if you need the same constant a couple of times inside a single method, and never
outside it, then it deserves to become a named const at the top of that method;
- if you need the same constant a couple of times inside a single class, and never
outside it, then make it a const class member;
- if your constant is needed in more than one class, put it in some class, and let
the others refer it; never define the same constant more than once.
- if your constant is a general one, put it in a general-purpose class (see Math.Pi).
In all cases, try to give your constants meaningful names.
BTW: there is no need to use constants for numbers that can never change whatever happens;
if you want to iterate the elements of an array, go from 0 to Length-1, and don't make
that 0 a const int ZERO=0 !!
|
|
|
|
|
i had worket vb.net project.i am using msaccess database.how to give print in the form. plz give the sample code
advance thanks for your valuable replay
thanks & regords
velan
|
|
|
|
|
velan wrote: plz give the sample code
No. People around here tend not to do other people's work for them.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
velan wrote: i had worket vb.net project.i am using msaccess database.how to give print in the form. plz give the sample code
advance thanks for your valuable replay
So are you trying to print the Form itself (screenshot type thing), or are you trying to get the data from the MS Access Database into a Print Document, build a report, and then print it out (or is it something completely different)?
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
Drop a MCL Form Print Component[^] on your form and set the settings for where and how you want the constituent parts (labels, text boxes, check boxes, etc. etc.) to print - then call the .Print method and it will print.
|
|
|
|
|
I need to read the value that is present at a specific address.
any Ideas?
thx in advance
BiG RaLpH
|
|
|
|
|
You can't just read any old address in the machine. Windows memory and process protections won't let you. When an application runs, it thinks it's the only application in the entire system. Each process get's it's own 2GB address space, so theres lots of room to play, even if the machine doesn't actually have 2GB of RAM in it.
If each process has its own address space, each process can be sitting in the same range of addresses. So how are you going to get one process to read another processes address space??
You have to Open the other process and read it, kind of like a file. But, not any user can open another process. You have to have admin rights to do this. For a C# example (can be converted to VB.NET), check out this article[^].
|
|
|
|
|
I agree with Dave. I suppose if it is too difficult to do something like that in VB.Net, you could write something in the Assembly language?
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
I have to be able to detirmn how many weeks there are in a given year.
I'v searched the internet (google) and articles and forums here and found 2 links
http://konsulent.sandelien.no/VB_help/Week/ISO8601_VB.htm[^]
http://www.codeproject.com/KB/selection/MonthCalendar.aspx[^]
however these seem to suggest that there is no easy way to do this and also that there is no way I can simply pass the weeksystem and firstdayofweek alone and it will work
I can't believe that this isn't possible since it is in vba (access)
format(date,"ww",firstdayofweek,weeksystem) will return the correct number from the given date (if you give the date 31/12/2007 you'll get the number of weeks in 2007)
anyone know how I would go about this or do I really have to do it like the links suggest and make such a function for every weeksystem
any help will be appriciated
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
Try the DateDiff function.
Private Function getNumberOfWeeks(ByVal year As Integer) As Long
Dim d1 As Date = New Date(year, 1, 1)
Dim d2 As Date = New Date(Year, 12, 31)
Return DateDiff("w", d1, d2, FirstDayOfWeek.Monday)
End Function
Volker Weichert
|
|
|
|