Re: database problem in vb.net - ASP.NET Discussion Boards

prabhu dot net3-Aug-06 19:18

3-Aug-06 19:18

whenever we establish connection to database through "coding"
we have to generate set of the objects properties for "update","delete"and "insert" commands.But before that we have to initialize and set the primary key.my question is why we set the primary key by coding? because primary key is set while creating a database itself.so what is the need of set again?

coding makes me interesting in dot net

Re: about primary key

kiran kumar[Intelligroup]3-Aug-06 20:26

kiran kumar[Intelligroup]

3-Aug-06 20:26

i think here you are setting primary key for dataset tables bcz this tables will be updated as it is into database so we need same structure

how we will show the number of visitors of particular site in asp.ne with c# [modified]

bijeshsoft3-Aug-06 19:05

bijeshsoft

3-Aug-06 19:05

How we will show the number of visitors of particular site in asp.net with c#.when server is shutdown and then again restarted,it must show countinuity.I mean due to server problem,it must not begin from 0 .Actually i declared variable under Application_start in global.asax and it is incremented under Session_start.It works well but when server shutdown it again start from 0

bijesh

-- modified at 1:12 Friday 4th August, 2006

Re: how we will count the number of visitors of particular site in asp.ne with c#

_AK_3-Aug-06 19:14

_AK_

3-Aug-06 19:14

You can use database for that purpose.

Best Regards,
Apurva Kaushal

Re: how we will count the number of visitors of particular site in asp.ne with c#

Amit Agarrwal4-Aug-06 22:43

Amit Agarrwal

4-Aug-06 22:43

hi apurva

aavesh again,

I'm making a project in asp.net with vb,i have a page named as IndividualProperty.aspx.

I'm showing the listing of all the property one after it in the page.when any user select any property such as he select "abc" property, when he click on this Property the IndividualPropertypage will be called.that is ok.

but i want to change the URL from www.xyz.com/IndividualPropertypage.aspx to www.xyz.com/abc.com

meanwhile whatever the property he select property name must be replace the page name in the URL.

How is it possible,plz tell me thanx

Re: how we will count the number of visitors of particular site in asp.ne with c#

_AK_6-Aug-06 19:07

_AK_

6-Aug-06 19:07

In this case you have to rewrite the URL. You through this article this will be be of great help for you.
http://www.codeproject.com/aspnet/URLRewriter.asp

Best Regards,
Apurva Kaushal

database problem in vb.net

amaneet3-Aug-06 17:45

amaneet

3-Aug-06 17:45

Sir,
Can i programically calculate how to find the no of tables in the database.
Please help.

Re: database problem in vb.net

psamy3-Aug-06 19:56

psamy

3-Aug-06 19:56

use this query

select * from sys.all_objects where type_desc='USER_TABLE'

Re: database problem in vb.net

thomas_joyee3-Aug-06 20:19

thomas_joyee

3-Aug-06 20:19

If your database is Microsoft SQL Server 2000. Use this query

SELECT COUNT (TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

Thomas

Re: database problem in vb.net

_AK_3-Aug-06 20:32

_AK_

3-Aug-06 20:32

But this gives number of tables + 1. Smile | :)

Best Regards,
Apurva Kaushal

Active directory entry can't be found

AndrewNPDC3-Aug-06 16:52

AndrewNPDC

3-Aug-06 16:52

Hi,

I have a web app that searches AD to get Windows user details. The code for this is in a class that I either access directly from my web page or via a web service. It works when accessed from the web page but not via the web service.

This is the error I get when the web service attempts to run the code:

Server was unable to process request. --> The specified domain either does not exist or could not be contacted.

The code I'm using looks like this:

DirectoryEntry entryRoot = new DirectoryEntry("LDAP://RootDSE");<br />
			string domain = entryRoot.Properties["defaultNamingContext"][0].ToString();<br />
<br />
<br />
			DirectoryEntry searchRoot = new DirectoryEntry(@"LDAP://"+domain);  // ADS user/password<br />
			DirectorySearcher search = new DirectorySearcher(searchRoot);

The failure occurs at: string domain = entryRoot.Properties["defaultNamingContext"][0].ToString();

Any light that is shed on this issue will be greatly appreciated. Thanks in advance.

Arrogance and ignorance go hand in hand - Metallica

How to assign roles to users

Xiaoming Qian3-Aug-06 16:12

Xiaoming Qian

3-Aug-06 16:12

The following is my Web.config file

<br />
<location path="admin"><br />
  <system.web><br />
    <authorization><br />
      <allow roles="Admin" /><br />
      <deny users="*" /><br />
    </authorization><br />
  </system.web><br />
</location><br />

But in FormsAuthentications mechanism,I can't find how to and when to assign "Admin" role to Authenticate users.
Can anyone help me? Any idea will be appropriate.

Re: How to assign roles to users

minhpc_bk3-Aug-06 16:29

minhpc_bk

3-Aug-06 16:29

If you are using the ASP.NET 1.1, Heath's article[^] can help you tackle your question. If it's the version 2, you can see Managing Authorization Using ASP.NET Roles [^]

urgently required help

Mairy3-Aug-06 14:32

Mairy

3-Aug-06 14:32

hello all of you,

plz tell me...
i want to initialize the messenger object and constructor must be called only once. so where should i define the object, either in Page_Load() or in Page_Init().

plz clear me the difference between these methods.

Re: urgently required help

minhpc_bk3-Aug-06 15:21

minhpc_bk

3-Aug-06 15:21

Hi there,
What is the messenger object? Why do you want its constructor to be called only once? Depending on what you need then you can choose the right event to initialize the object, or maybe both events are all your options. You can read more about this in ASP.NET Page Life Cycle Overview [^]

Btw, "urgently required help" is not a good subject at all, the title should be something that best describes your issue just in a few words.

Problems after uploading Site with Login Control

cellcon3-Aug-06 12:00

cellcon

3-Aug-06 12:00

Hello!

I have a big problem. Since three days I am searching for an answer without finding any functional hint.

I created a website with Visual Studio 2005 Professional. On the page I used the Login Control from Microsoft.

So far everything works fine on my Computer.

After uploading to my Windows 2003 Standard Server I only get the following Message:

An attempt to attach an auto-named database for file
c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or
specified file cannot be opened, or it is located on UNC share.

I even installed Visual Web Developer Express Edition on my Sever and it works in the Debug Modus but not with my IIS 5.2.

Please tell me what I am doing wrong.

Thank you very much!!!

What I have done so far:
1) I installed SQL Server Express Edition on my Server.
2) I created a virtual directory.
3) I uploaded my complete website, including the App_Data directory.
4) A lot of things that did not help any further.

Re: Problems after uploading Site with Login Control

minhpc_bk3-Aug-06 15:29

minhpc_bk

3-Aug-06 15:29

Clickety[^]

CheckListBox & List Box

widget13-Aug-06 9:31

widget1

3-Aug-06 9:31

Ok I have set up a checklistbox and then an arrow button to move each selection over to the next listbox when asked - What I want is to allow the user to change the order of the displayed list. I need to reindex the second list box inthe order that they are sent over by the arrow button but can't figure out the syntax:

I have this:
lbOutcomes1.Items.Clear()
Dim chkListOutcomesItem As ListItem
Dim x As Integer = 1
For Each chkListOutcomesItem In chkListOutcomes.Items
If chkListOutcomesItem.Selected = True Then
Me.lbOutcomes1.Items.Add(chkListOutcomesItem.Text)
'Me.lbOutcomes1.SelectedIndex = x
End If
x = x + 1
Next

But it chokes on the commented out line - how do I accomplish what I am trying to do - I want the user to arrange the order of this sentences - this order will be saved back into my database and the table headers that will generated will appear int he order they selected. I need to figure this out ASAP as they want to roll out this sytem and I need to be able to allow column selection and moving them around.

Thx, Tammy Smile | :)

How to include Text file with ASP.NET

DFrag3-Aug-06 9:05

DFrag

3-Aug-06 9:05

Hi, I use VS2003 asp.net 1.1 C#
I am working on bilingual website and I would like to use by exemple 2 files like career_fr.txt and career_en.txt that I will include in my html code based on the language. In html we use to write and works fine but when i want to switch the language it comes a problem for me.
I know that we can use .resx (ressource file) and that's what I do for short sentence or label. By using files.txt or files.inc that I can access based on language will be easier to edit for the non programmer.

Any suggestion will be wellcome.

Thanks for help,

Davy

Re: How to include Text file with ASP.NET

minhpc_bk3-Aug-06 15:37

minhpc_bk

3-Aug-06 15:37

IMHO, there are a couple of options that you may consider to include a text file in the ASP.NET:
+ Place a container such as Label, Literal ... controls in the web page, and dynamically load the text file based on the selected language and assign the content to the container.
+ Create a web user control and include it it the web page instead of the #include syntax.

Re: How to include Text file with ASP.NET

DFrag7-Aug-06 12:39

DFrag

7-Aug-06 12:39

Hi minhpc_bk,
Thanks for your suggestion.

Based on it I Resolved my problem with some little variances. I put a label on the web page and in C# side I created an object streamReader, I read my txt file and I assigned it to my label. In the C# code I switched between french and english based on what the user choose.

Thanks again

Davy

How do I handle the space (gap) between panels in a <td>?

Slow Learner3-Aug-06 8:29

Slow Learner

3-Aug-06 8:29

Hello there,
I have built as .aspx page. I have a situation to create 4 panels in
a . Based on the selection of a drop down I need to display
the corresponding panel in that table cell. Every thing works fine but
I see a lot of space in the table cell that was occupied by the other
panels though they are being hidden.

Can any one help me how to remove the space ? I dont' know how to use
style sheets or even do not if the the DIV functions works and how to
use it.

Here is a sample table code snippet with panels inside the table cells
for you to simple put some code to show me.

drop down selection

<asp:panel1>
<asp:panel2>
<asp:panel3>
<asp:panel4>

Any inputs are greatly appreciated.

Thanks
-L

Re: How do I handle the space (gap) between panels in a <td>?

Ennis Ray Lynch, Jr.3-Aug-06 8:30

Ennis Ray Lynch, Jr.

3-Aug-06 8:30

Learn how to use style sheets and divs. You already knew the answer!

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: How do I handle the space (gap) between panels in a <td>?

Slow Learner3-Aug-06 10:01

Slow Learner

3-Aug-06 10:01

I need a starting point. I appreciate your encouragement and thats how we learn.

Thanks
-L

Changing the Page Title at runtime

RizShiney3-Aug-06 7:45

RizShiney

3-Aug-06 7:45

Hi,

Can any1 plz tell me how to change the title of an aspx page at runtime using ASP.NET.I dont want to hardcore the title but depending upon the login id, i want the title of the page to be changed at runtime.
Urgent help is needed.
Thanks,

Riz

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.