|
No takers for this one? 
|
|
|
|
|
Hi, how can i insert an image into a datalist please?? Thanks alot
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
If you want the image as the item in the datalist then you can use item template in datalist for that purpose.
Best Regards,
Apurva Kaushal
|
|
|
|
|
hi, how can i insert data from a database(ms access) to a datagrid. I want to choose the columns but. Because all i know is how to bind it all with the database. But i dont know how to choose the coloumns you want to be shown in the datagrid.
Thanks for any help...
Regards,
Adrian
www.buyproducts.co.nr
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
Hey.. you can go to the datagrid.. right click choose PROPERTY BUILDER.
then go to columns, u can see a check on the 'Create columns automaticlly at run time'
remove it and add Bound Column and make sure to put appropriate data field.
Estarta
|
|
|
|
|
Hey guys, how can i have the access to all the cells in the datagrid, is it like the 2 dimensional array ?
i know i can reach cell 1 and 2 and so on but wat about the cells behind it.
Estarta
|
|
|
|
|
you can always count the number of cells in a datagrid.
so you can iterate through them.
Pradipta Basu
|
|
|
|
|
Thanks for your reply. can u give a small example if u don't mind 
Estarta
|
|
|
|
|
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 />
}<br />
Pradipta Basu
|
|
|
|
|
Thanks alot
Estarta
|
|
|
|
|
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.
|
|
|
|
|
|
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???
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Thanks for reply.Actually can we do it in .NET Version 1.1??
|
|
|
|
|
|
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
|
|
|
|
|
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
Estarta
|
|
|
|
|
use a sql query to check if the name exists in the DB
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
well thats cool
i will send you the stored procedure code 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
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
