|
|
SqlDataSource1.SelectCommand = "Select columns from TableName";<br />
GridView1.DataSourceID = SqlDataSource1.ID;<br />
GridView1.DataBind();
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
|
No problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Why you delete the Message ?
cheers,
Abhijit
|
|
|
|
|
And I am courious to know why he/she deleted message.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
he dont want to share with others his question. lame
awek
Programmer
Subang Jaya,Selangor, Malaysia
|
|
|
|
|
Yes, it seems.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
hello ,
i have question ,
suppose i have to create a web site and i want my web site resolution automatically set for every computer. each computer has diffrent resolution. how i set it?
and
i have developed a web application using asp.net.Its working in normal screen 600x800. But it doesn;t work in LAPTOP(1024X728). I can get only part of screen. Anyone can help me out.
Regards
rameez
|
|
|
|
|
all the sizes of forms and tables and some controls u show in form should mention in percentage wise.
Ex : declare width : 100% instead of declaring width : 700px
this will work for u for all the resolution types.
Pradeep Reddy
|
|
|
|
|
i have user following Function
function validate()<br />
{<br />
<br />
if(window.parent.location != null)<br />
{<br />
window.close();<br />
opener.location="login.aspx";<br />
} <br />
}
I have Login page , HomePage. ExceptionPage, Application Page. if Exception page comes inside a popup , its redirect to login page , but when comes it in a main windows, it follwing function does not work, it try to close the windows , thoug it parents is null.
please help.
cheers,
Abhijit
|
|
|
|
|
I have solved this problem.
cheers,
Abhijit
|
|
|
|
|
i have 2 table in sqlserver. i want do this command
insert into dabirestan (amuzeshgah) values (select amuzeshgah from dabirestan1)
i want fill the record of table dabirestan1 to table dabirestan
i want write a query. how is my query cammand. do any body know?
|
|
|
|
|
Post it into SQL Forum .you will get better answer. this is asp.net forum
cheers,
Abhijit
|
|
|
|
|
Are there any free tools to use to backup the database on my server and put the backup copy on another computer on the same network??
Does sql server 2000 have these kinda programs or plugins??
I also have a problem when I try to access sql server 2000 from the server. I need assign a username and password on the enterprise manager and query analyzer so that no one can open them from the server..how can I do that??
|
|
|
|
|
Nada Adel wrote: and put the backup copy on another computer on the same network
You can use DTS to transfer data from one server to another. You can do this via enterprise manager.
Nada Adel wrote: I need assign a username and password on the enterprise manager and query analyzer so that no one can open them from the server..how can I do that??
You want to assign user name and password for database ? You can create users and permissions from the enterprise manager.
BTW, this has nothing to do with ASP.NET. Please don't cross post. This post should be in SQL forum.
|
|
|
|
|
I know how to create a username and passwords on the databases. what I meant was how to set username and passwords on the programs themselves like when I user opens the enterprise manager he is prompted to enter username and password..
|
|
|
|
|
AFAIK, when a server instance is expanded from the left tree in the enterprise manager, it asks for user credentials if it is set.
|
|
|
|
|
Yes, but I don't know how to set them?
Can u please tell me in details??
|
|
|
|
|
Sorry, I don't have SQL server 2000 installed
|
|
|
|
|
thanks anyway...glad you helped
|
|
|
|
|
How can I get rid of this message when I try to copy a database file that runs on sql server 2000??
I searched and I found that if I used ctrl alt delete and ended the sql server processes, I should copy the file but the problem is that I need to copy these files from a server so I'm afraid if I ended these processes, users of the wesite site including the database might lose data..How can I solve this?
|
|
|
|
|
Yeah, if you stop SQL service instance, users accessing it will get error. Why don't you take a backup of the database ?
|
|
|
|
|
yes, I need to know how can I take a backup of the database and save it on another computer and then access it from another computer??
|
|
|
|
|
stop sqlserver first and then u copy dbfile in some other place. with out stoping sqlserver u can not copy .mdf and .ldf files.
Pradeep Reddy
|
|
|
|