ASP.NET

Getting a particular field from a database

14-May-06 23:22

You can add the setup and deployment project to your solution in Visual Studio. It might be a little extra work for some of this - You can create your own custom installers for anything that doesn't have built in support.

You can also look at InstallShield[^] itself, if that is your preference.

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

alee15.10.8814-May-06 22:24

alee15.10.88

14-May-06 22:24

Hi all,

I am doing a website with asp.net and I would like to know how to get a particular field from a database.
After that the user log ins, I need to know if the user is a student or a teacher by checking the occupation that is saved in the table Userlogins in the Database. I tried to do something like the following but unfortunately it did not work

//ds is the typed Data Set
//UserloginsDataTable is the table where the occupation is saved
//Occupation is the name of the column

if(ds.UserloginsDataTable[0].Occupation.ToString().ToUpper() == "STUDENT")
{
}

Can anyone tell me if I am doing it right and if yes why isn't it working

Thanks a lot guys

Colin Angus Mackay14-May-06 22:38

14-May-06 22:38

alee15.10.88 wrote:
I tried to do something like the following but unfortunately it did not work

alee15.10.88 wrote:
Can anyone tell me if I am doing it right and if yes why isn't it working

What do you mean by "not working" what are the symptoms? Do you get a compiler error? A runtime error? What?

alee15.10.8815-May-06 6:42

alee15.10.88

15-May-06 6:42

Actually it's working... but it isn't logging on with any accounts i'm trying with. The underneath is the code I have in the button submit

string occupation = (UHandler.UserLogIns.Rows[0]["Occupation"].ToString().ToUpper());
if(occupation == "STUDENT")
{
Session["userID"] = txtUsername.Text;
Response.Redirect("UsersViewProfile.aspx");
}

The problem is that I do not have a row filter which returns that 1 particular row, so it's searching in the first row where the occupation of that row is Teacher.

Did you understand me now?

Colin Angus Mackay15-May-06 7:31

15-May-06 7:31

alee15.10.88 wrote:
Actually it's working... but it isn't logging on with any accounts i'm trying with.

In other words it is not working due to a logic error.

alee15.10.88 wrote:
The problem is that I do not have a row filter which returns that 1 particular row, so it's searching in the first row where the occupation of that row is Teacher.

Why are you returning so many rows? If you only need one row what are the rest for? Do you only need one column value as well?

If you do need all these rows why not search for the row that you want? (Or is that what you are really asking for?)

Sorry, I'm still not sure how to help you, but the answers to the questions above may help get to the answer.

alee15.10.8815-May-06 8:05

alee15.10.88

15-May-06 8:05

I'm sorry that I'm not explaining well. But actually that's what I want... to search that particular row by using a row filter. any idea?

ptvce15-May-06 0:13

ptvce

15-May-06 0:13

i think if u write the table name u should not write the table[0];

u can write:
ds.tabel[0].row[1][2].tostring() == "student";
1 is the num of ur row and 2 is the num of ur column

Kanjinghat15-May-06 20:53

Kanjinghat

15-May-06 20:53

//ds is the typed Data Set
//UserloginsDataTable is the table where the occupation is saved
//Occupation is the name of the column

try this one

if(ds.Tables["UserloginsDataTable"].Select("Occupation=Student").Length>0)
{

}

ds.Tables["UserloginsDataTable"].Select("Occupation=Student") will return a datarow array. and if the array length is<1 then ther are no records else records exixts.

hope this helps you.

Ramesh.Kanjinghat

code behind file

amaneet14-May-06 21:53

amaneet

14-May-06 21:53

Sir,

I want to know something about code behind file.

Thanks
amaneet brar

Re: code behind file

Colin Angus Mackay14-May-06 22:35

Datagrid demo on VS2005 or ASP.NET 2.0

14-May-06 22:35

amaneet wrote:
I want to know something about code behind file.

Okay, here's something: The code behind file is created automatically by Visual Studio when you create an ASPX page.

If this is not what you are looking for then you could, perhaps, ask a more specific question rather than make a vague declaration.

Re: code behind file

_AK_14-May-06 22:37

_AK_

14-May-06 22:37

Hi,
Go through this link probably this will help you.
http://www.4guysfromrolla.com/webtech/100500-1.2.shtml
also search in google.

Best Regards,
Apurva Kaushal

datalist in asp.net 1.1

amaneet14-May-06 21:13

amaneet

14-May-06 21:13

Sir,
I am displaying images in the image control in datalist .All the code is written in html.Now when i find that the image is portrait, the dimensions of image control is 100,100 and when i find the image is landscape the dimensions are 100,500.

Sir, The height and width of image control will also be mentioned in html file like Now the problem is i have to apply the conditions that when the image is portrait the height and width of image control is this.and when landscape it is this.

<item template="">

I want to apply the condition for every picture.When i find the picture is landscape ihe code should become

Please help me

Thanks and regards
Amaneet Brar

FREETEXTTABLE

TheEagle14-May-06 21:07

TheEagle

14-May-06 21:07

Hi..

I have used Full-Text Search in a stored procedure with English words whithout any problems..But when i use it with Arabic words it gives me THE Error:

Server: Msg 7619, Level 16, State 1, Procedure SearchProject, Line 19
Execution of a full-text operation failed. A clause of the query contained only ignored words.

The stored procedure :

CREATE PROCEDURE SearchProject
(
@SearchString nvarchar(500),
@CultureName nvarchar(50),
@HowManyResults int OUTPUT
)
AS
CREATE TABLE #SearchTable
(
FieldNO int,
ProjectNO int,
ProjectName nvarchar(200),
ProjectDescription nvarchar(1000),
ProjectImage nvarchar(1000),
CultureID int
)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,@SearchString) AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID(@CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
ProjectField_Locale AS FL,
FREETEXTTABLE(ProjectField_Locale,*,@SearchString) AS FT2
WHERE FL.FieldNO=P.FieldNO
AND FL.FieldCultureID=FT2.[KEY]
AND PL.ProjectNO=P.ProjectNO
AND PL.CultureID=dbo.GetCultureID(@CultureName)
AND FL.CultureID=dbo.GetCultureID(@CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
Feature_Locale AS PFEA,
ProjectFeature AS FP,
Feature AS F,
FREETEXTTABLE(Feature_Locale,*,@SearchString) AS FT3
WHERE FT3.[KEY]=PFEA.FeatureCultureID
AND FP.ProjectNO=P.ProjectNO
AND FP.FeatureNO=PFEA.FeatureNO
AND PL.ProjectNO=P.ProjectNO
AND F.FeatureNO=PFEA.FeatureNO
AND PFEA.CultureID=dbo.GetCultureID(@CultureName)
AND PL.CultureID=dbo.GetCultureID(@CultureName)

SELECT @HowManyResults=COUNT(DISTINCT ProjectNO) FROM #SearchTable
SELECT DISTINCT * FROM #SearchTable
RETURN
GO

I called the stored procedure using the following(in the Query Analayzer) :

USE nabeel1eagle
DECLARE @HowManyResults int
EXEC SearchProject 'ملفات','ar-SA',@HowManyResults OUTPUT

but when I use the previous code directly(without calling the stored procedure using EXEC) in the Query Analyzer it works fine.Like the following (part of the code)code:

SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,'ملفات') AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID('ar-SA')

Could any one help and tell me how to solve this problem?

"I am too late but i will never give up"

Aayush Singh14-May-06 20:53

Aayush Singh

14-May-06 20:53

I want to see datagrid demo on latest realesed VS2005 or Asp.net. If any body have reply me.

Re: Datagrid demo on VS2005 or ASP.NET 2.0

minhpc_bk15-May-06 0:00

WebCustomControl, create events

15-May-06 0:00

Get the sample code from the site[^], then run in VS 2005. The ASP.NET 2.0 with VS 2005 supports backward compatibility, so if you have the sample code with datagrid running on the ASP.NET 1.x, then it should be working fine with the version 2.0. Or do you mean the GridView[^] control which is the successor of the datagrid control.

Piovra_14-May-06 19:54

Piovra_

14-May-06 19:54

I have created a new WebControlLibrary. What i would like is to create a mouse hover event on the control but i have no idea how to achieve this behaviour. Is it possible to create mouse events on a custom control and how would it be done ?

Re: WebCustomControl, create events

minhpc_bk14-May-06 20:43

Re: WebCustomControl, create events

14-May-06 20:43

What does your custom control look like? What does it do? How do you want to use the mouse events with your custom control? Basically, you can simply attach the mouse events to the Attribute collection of a child control of the custom control, if you are developing a composite control. If you create a rendered control, you can manage to do that in the overriden Render method. You can see the MSDN[^] for more information.

Piovra_14-May-06 23:50

Piovra_

14-May-06 23:50

Well the control doesn't look like anything yet. It's just a new WebControlLibrary, i have set the backcolor so i can see it in the webpage, what i would like is when i hover the mouse over the control the event is triggered.

Re: WebCustomControl, create events

minhpc_bk15-May-06 16:09

Repeater changing my name attributes

15-May-06 16:09

Piovra_ wrote:
It's just a new WebControlLibrary, i have set the backcolor so i can see it in the webpage, what i would like is when i hover the mouse over the control the event is triggered.

Do you mean it's just a default control added to the project when you create a new web control library? When you hover the mouse over the control, you want the event to be triggered, so do you mean the onmouseover event or a custom event defined in the control. If it is simply the onmouseover event, you can add the onmouseover="alert();" to the control declaration on the web page.

eggie514-May-06 19:49

eggie5

14-May-06 19:49

Why does the repeater always change the name attributes of my checkboxes???? What the crap? how do I stop this? It keeps making them unique whent they should be identical..

/\ |_ E X E GG

minhpc_bk14-May-06 20:05

14-May-06 20:05

Alex,
In the ASP.NET, any control should always be uniquely identified, so by default the id of the control within the scope of a naming container contains the id of its container. In the case of the repeater, the id of the checkboxes contains the id of the RepeaterItem, and the ASP.NET automatically does that for you. If you want this thing not to happen to the checkboxes, you may consider using the html checkbox input element which is not marked with the runat="server".

eggie514-May-06 20:06

eggie5

14-May-06 20:06

oh the runat is doing it, thanks.

/\ |_ E X E GG

eggie514-May-06 20:13

eggie5

14-May-06 20:13

Actually, I'm kinda confused. So, I'll just keep my checkbox as runat=server.

But I'm confused on how I can access the checkbox from my code behind file....

Any tips?

/\ |_ E X E GG

minhpc_bk14-May-06 20:27