ASP.NET

Re: Datagrid Customization

17-Dec-06 1:18

Thanks for your reply. can u give a small example if u don't mind Smile | :)

Estarta

Pradipta Basu17-Dec-06 9:20

Pradipta Basu

17-Dec-06 9:20

Hope this code will help
Let the datagrid be dg.

<br />
foreach(DataGridItem dgItem in dg.Items)<br />
	for(int i = 0; i < dg.Columns.Count; i++)<br />
	{<br />
		TableCell tc = dgItem.Cells[i];<br />
                //do the coding with table cell<br />
	}<br />

Pradipta Basu

Re: Datagrid Customization

MoeInsairat18-Dec-06 2:06

18-Dec-06 2:06

Thanks alot Smile | :)

Estarta

Web Config File

varshavmane16-Dec-06 3:37

varshavmane

16-Dec-06 3:37

Can we have more than one Web Config file in a single Application.If yes then how do we go about the same.

Thanks in advance.

GaryWoodfine 16-Dec-06 3:45

16-Dec-06 3:45

no,

Kind Regards,
Gary

varshavmane16-Dec-06 3:58

varshavmane

16-Dec-06 3:58

Actually today I gave an Interview where this question was asked,I said the same answer but the person who was taking interview said that u can do it just check it???

GaryWoodfine 17-Dec-06 2:14

17-Dec-06 2:14

Well I wouldn't have got the job either!

I have never used more than one web.config file in an application.
never seen the need to.

Kind Regards,
Gary

Pradipta Basu16-Dec-06 9:10

Pradipta Basu

16-Dec-06 9:10

We can have multiple web.config file for an application. If we divide our project into different folders, then each of the folders can have different web.config files apart from the web.config in the root.

When we access pages in a particular folder, it that folder contains a web.config file, setting there will have more priority that that of the root, ie., if you override a setting of the root web.config in the folder's web.config, the latter one will be used for the pages in that particular folder.

you can read this artile
Using Forms Authentication in ASP.NET, Part 2

Pradipta Basu

Nitin198117-Dec-06 19:31

Nitin1981

17-Dec-06 19:31

Yes We can have more than one web.config file. But each folder can have only web.config file. Lower level takes precedence over higher ones like web.cofig takes over machine.config. But you can configure higher web.config's setting in such a way that it cant be overriden also.

Don't Quit

varshavmane17-Dec-06 20:46

varshavmane

17-Dec-06 20:46

Thanks for reply.Actually can we do it in .NET Version 1.1??

Pradipta Basu18-Dec-06 9:51

Pradipta Basu

18-Dec-06 9:51

Yes we can

Pradipta Basu

dayakar_dn18-Dec-06 2:13

dayakar_dn

18-Dec-06 2:13

hi,
We can have more than one web.config files in the same project but we should give different names.

eg First.Config
Second.config

MoeInsairat16-Dec-06 0:08

16-Dec-06 0:08

hey guys

pi have an application.. and i wanna add new user to a database but i want to check if the usernameis already exist in the database.
how can i do it right ?

thanks Smile | :)

Estarta

GaryWoodfine 16-Dec-06 2:02

16-Dec-06 2:02

use a sql query to check if the name exists in the DB

Kind Regards,
Gary

MoeInsairat16-Dec-06 2:11

16-Dec-06 2:11

Thanks for the reply man.. i have an sql statmenent and its not the problem how can can i handel this when the 'admin' wanna add new user lets say..
when he click 'SUBMIT' it should tells him that the username is in use.
i'll show u a sample if u don't mind

conn.Open();
cmd = new SqlCommand ("select schoolid from users where userid= " + Session["UserID"],conn);
string SchoolID= cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("AddStudent",conn);
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter Name = new SqlParameter("@Name",this.TextBox5.Text);
SqlParameter Username = new SqlParameter("@Username",this.TextBox6.Text);
SqlParameter Password = new SqlParameter("@Password",this.TextBox7.Text);
SqlParameter School = new SqlParameter("@SchoolID",SchoolID);
SqlParameter ParentID = new SqlParameter("@ParentID",ParentDWL.SelectedItem.Value.ToString());
SqlParameter Address = new SqlParameter("@Address",this.TextBox9.Text);
SqlParameter LevelID = new SqlParameter("@LevelID",int.Parse(this.DropDownList2.SelectedItem.Value));
cmd.Parameters.Add(Name);
cmd.Parameters.Add(Username);
cmd.Parameters.Add(Password);
cmd.Parameters.Add(School);
cmd.Parameters.Add(ParentID);
cmd.Parameters.Add(Address);
cmd.Parameters.Add(LevelID);
int i=cmd.ExecuteNonQuery();

Estarta

GaryWoodfine 16-Dec-06 2:17

16-Dec-06 2:17

Whats the code like in your AddStudent Stored Procedure ?

If you're using a stored proc to do the add it would make sense to do a test in the stored proc if the user name exists, if it does then send a notification back to the application that the user name already exists and that the transaction could not be completed

Kind Regards,
Gary

MoeInsairat16-Dec-06 2:20

16-Dec-06 2:20

well thats cool
i will send you the stored procedure code Smile | :)

thanks

CREATE PROCEDURE AddStudent
@Name varchar(20),
@Username varchar(20),
@Password varchar(20),
@SchoolID int,
@ParentID int,
@Address varchar(20),
@LevelID int

as
insert into users values (3,@Name,@Username,@Password,@SchoolID,@ParentID,@Address,@LevelID,NULL)
GO

Estarta

GaryWoodfine 16-Dec-06 2:32

16-Dec-06 2:32

CREATE PROCEDURE AddStudent
@Name varchar(20),
@Username varchar(20),
@Password varchar(20),
@SchoolID int,
@ParentID int,
@Address varchar(20),
@LevelID int

as

Declare @ExistUser varchar(20)
SELECT @ExistUser = Username from users where username = @username
IF(@ExistUser is Null)
Begin
insert into users values
(3,@Name,@Username,@Password,@SchoolID,@ParentID,@Address,@LevelID,NULL)
end

GO

This is something rough for you to use and give you an idea of what to do.
You'll have to elaborate a bit more on this

Kind Regards,
Gary

MoeInsairat16-Dec-06 2:55

16-Dec-06 2:55

It worked, i dont know how to thank you!!

Where can i elaborate on this. ?

Estarta

GaryWoodfine 17-Dec-06 2:08

17-Dec-06 2:08

Well you can think about passing back a FAILED or SUCCEEDED values back,

wrap it up in a transaction, there are thousands of possibilities, but you'll find out about them more as you progress.

Kind Regards,
Gary

MoeInsairat16-Dec-06 2:35