Re: How to attach a DB to SQL Server ? - ASP.NET Discussion Boards

how to adapt the image width to a computer screen width

Seraph_summer16-Aug-09 6:28

16-Aug-09 6:28

I want to display an image with its width to the computer screen width.

anyone can give me one hint how to do?

thank you.

Re: how to adapt the image width to a computer screen width

Abhishek Sur16-Aug-09 6:37

Abhishek Sur

16-Aug-09 6:37

use javascript screen.width / screen.height .

you can set img.width and img.height Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: how to adapt the image width to a computer screen width

Seraph_summer16-Aug-09 8:07

Seraph_summer

16-Aug-09 8:07

thanks, but I do not know how to embed javascript into ASP.net
can you give me one example for this?

Re: how to adapt the image width to a computer screen width

Abhishek Sur16-Aug-09 9:25

Abhishek Sur

16-Aug-09 9:25

<script type="text/javascript">
function initialise()
{
     var imgcontrol = document.getElementByID('yourimgid');
     imgcontrol.style.width = '100%'
     ...
     ...
}

</script>

<body onload="initialise();">
...

do like this in your designer. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: how to adapt the image width to a computer screen width

Seraph_summer16-Aug-09 10:25

Seraph_summer

16-Aug-09 10:25

thanks!
this may be so called Ajax application in ASP.net.

Re: how to adapt the image width to a computer screen width

Abhishek Sur16-Aug-09 10:31

Abhishek Sur

16-Aug-09 10:31

Nopes dear.. Big Grin | :-D

AJAX is Asynchronous Javascript and XML. Well, AJAX relates to XMLHttpRequest Object present in Javascript API which can call to the server. Just like you postback to get data from the server, if you dont want to postback but call the server from your client using Javascript, you can use XMLHttpObject. To get more knowledge about AJAX try AJAX W3Schools [^] tutorial. Rose | [Rose]

This is simple JavaScript fix in the client side. Cool | :cool:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

How to attach a DB to SQL Server ?

comp_j16-Aug-09 5:41

comp_j

16-Aug-09 5:41

Hello,

Im using this following softwares:
VS 2008 & Microsoft SQL Server 2005

I want to attach my database to SQL Server. How can I do this(Without using wizard) ?

TIA

Re: How to attach a DB to SQL Server ?

Abhijit Jana16-Aug-09 5:51

Abhijit Jana

16-Aug-09 5:51

comp_j wrote:
Im using this following softwares:
VS 2008 & Microsoft SQL Server 2005

I want to attach my database to SQL Server. How can I do this(Without using wizard) ?

How does it related with ASP.NET ? If you have to ask it on General DB Forum.

comp_j wrote:
How can I do this(Without using wizard) ?

Why you want to avoid Wizard ? Do you want to do it programmatically.?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: How to attach a DB to SQL Server ?

comp_j16-Aug-09 7:31

comp_j

16-Aug-09 7:31

Abhijit Jana wrote:
Why you want to avoid Wizard ?

Because I want to run my project on a system that just have SQL Server engine and .NET Freamwork.

Abhijit Jana wrote:
Do you want to do it programmatically.?

yes, I do.

Re: How to attach a DB to SQL Server ?

Abhishek Sur16-Aug-09 10:10

Abhishek Sur

16-Aug-09 10:10

Connect to master Database using your .NET object. Then run the stored procedure below :

EXEC sp_attach_db @dbname = 'dbname', 
     @filename1 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname.mdf', 
     @filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname_log.LDF'

Please replace the path to the existing mdf and ldf files.

You can also create using

CREATE DATABASE [dbname] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname_log.LDF' )
 FOR ATTACH
GO

command

Hope you can do this now.

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

checking a radio button programmatically

mbams16-Aug-09 4:36

mbams

16-Aug-09 4:36

Am currently working on my end of semester project (online examination system )where questions are to be obtained from a database,cached on a dataset and store the dataset in session object(of the global asax file).questions are read from this session variable and displayed on a form on its form load event.this form has 3 buttons that can enable a user to navigate to the next question,previuos question(s) and another to intentionally end the exam.whenever a user clicks on the back button of the form to access a previously answered question,the previous question is shown but the radio button that was checked as the answer is not checked.Any idea on how can i maintain the checked status for the previously answered questions?

Re: checking a radio button programmatically

Not Active16-Aug-09 5:30

Not Active

16-Aug-09 5:30

mbams wrote:
Any idea on how can i maintain the checked status for the previously answered questions?

So you don't record and persist the answers they provided to the questions?

only two letters away from being an asset

Re: checking a radio button programmatically

Abhishek Sur16-Aug-09 6:33

Abhishek Sur

16-Aug-09 6:33

mbams wrote:
store the dataset in session object

First of all, dont do this. Why do you have to set an Entire detaset in session, rather you store in database and get when required.

mbams wrote:
whenever a user clicks on the back button of the form to access a previously answered question

Well, in your case, as I said, always store user's input to the database. Use <a href=nextpage.aspx> to ensure everything to be in the history. If you really require the back functionality you should use <a > tag.

Hope you are getting me. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Connecting to Oracle Database.

srikantha_nagaraj16-Aug-09 1:35

srikantha_nagaraj

16-Aug-09 1:35

Please tell me the namespaces used to connect to Oracle Database in Asp.net.

Re: Connecting to Oracle Database.

Not Active16-Aug-09 5:31

Not Active

16-Aug-09 5:31

Google broken? Try Bing.

only two letters away from being an asset

Re: Connecting to Oracle Database.

Abhishek Sur16-Aug-09 6:28

Abhishek Sur

16-Aug-09 6:28

Use

OracleClient classes.

System.Data.OracleClient Namespace allows you to connect to Oracle Database.

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: Connecting to Oracle Database.

srikantha_nagaraj16-Aug-09 16:54

srikantha_nagaraj

16-Aug-09 16:54

I am not able to use this namespace. For connecting to Oracle should i have any add on or any assembly?

Re: Connecting to Oracle Database.

Abhijit Jana16-Aug-09 18:17

Abhijit Jana

16-Aug-09 18:17

Yes, you have to download it from here
http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Connecting to Oracle Database.

Abhishek Sur16-Aug-09 22:31

Abhishek Sur

16-Aug-09 22:31

Yes .. OracleClient.dll

It is installed with .NET framework.

Otherwise you can connect through OleDb classes, but I recommend to use Oracle Specific ones in OracleClient.dll. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

update xml in real time from database

leon8516-Aug-09 0:43

leon85

16-Aug-09 0:43

Im newer in XML coding. Any expert can guide me on how to generate and update xml in real time from database when there any changes is table data.

Re: update xml in real time from database

Abhishek Sur16-Aug-09 6:14

Abhishek Sur

16-Aug-09 6:14

Use CLR Triggers to write an XML to a specific location.

Hope this is what you want.
Check this if you want http://www.codeproject.com/script/Forums/KB/database/ClrStoredProcedure.aspx[^]

Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: update xml in real time from database

leon8516-Aug-09 17:45

leon85

16-Aug-09 17:45

The page not more exist already. However 10s very much.

Sending Mail Problem

pampam11015-Aug-09 20:52

pampam110

15-Aug-09 20:52

This is my code to send an email! but it didnt work

private void SendMail(string from, string body)
    {
      
        string mailservername = "mail.myURL.com";
        string subject = "Contact Us FeedBack";
        MailMessage message = new MailMessage(from,"info@mowjelectric.com",subject,body);
        SmtpClient mailclient = new SmtpClient();
        mailclient.Host = mailservername;              
        mailclient.Send(message);   
        message.Dispose();      
    }

and I manipulate ASP.NET Configuraton. and change SMTP Server name to : "mail.myURL.com"
Any Idea? Smile | :)

[]D @ []v[] []D @ []v[]

Re: Sending Mail Problem

Abhijit Jana15-Aug-09 21:02

Abhijit Jana

15-Aug-09 21:02

pampam110 wrote:
but it didnt work

What do you mean by didn't work? Are you getting any error ? If yes, then what ?

pampam110 wrote:
string mailservername = "mail.myURL.com";

pampam110 wrote:
mailclient.Host = mailservername;

Does you SMTP server configure properly ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Sending Mail Problem

pampam11015-Aug-09 21:19

pampam110

15-Aug-09 21:19

Abhijit Jana wrote:
What do you mean by didn't work? Are you getting any error ? If yes, then what ?

No Error. I mean This Code didnt send any email Frown | :(

Abhijit Jana wrote:
Does you SMTP server configure properly ?

How Can i Configure it? I talk to where i buy Host and Domain, But they didnt help me. Hmmm | :|

[]D @ []v[] []D @ []v[]

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