ASP.NET

Re: How to attach a DB to SQL Server ?

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.

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

checking a radio button programmatically

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.

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

Connecting to Oracle Database.

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.

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.

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

Abhishek Sur16-Aug-09 6:28

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.

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?

Abhijit Jana16-Aug-09 18:17

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.

Abhishek Sur16-Aug-09 22:31

update xml in real time from database

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.

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

Re: update xml in real time from database

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.

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

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[]

Abhijit Jana15-Aug-09 21:02

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

pampam11015-Aug-09 21:19

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[]

Abhijit Jana15-Aug-09 21:35

15-Aug-09 21:35

If you are using SMTP Server of any web hosting site, I guess they can only help you to do it. Or Read some manual for that hosting site.

pampam110 wrote:
I talk to where i buy Host and Domain, But they didnt help me

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

pampam11015-Aug-09 21:51

15-Aug-09 21:51

Thanks for your help!
I Check My Mail Box at http://mail.myURL.com/
"mail.myURL.com" is it my SMTP Server ? and another question is how can find my SMTP Server except Read Manual for this hosting site? Confused | :confused:

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

Parwej Ahamad15-Aug-09 22:00

Parwej Ahamad

15-Aug-09 22:00

Try to find out with Provider if there mails are persisting in mail queue or not. OR is there any exception are raising in your application.

Parwej Ahamad
http://parwej.wordpress.com/

mrcooll15-Aug-09 22:31

mrcooll

15-Aug-09 22:31

you need to contact u r host and ask them about email settings.
u can try to set SmtpServer property to '127.0.0.1'

pampam11015-Aug-09 23:57

15-Aug-09 23:57

my website is : www.mowjelectric.com
and my smtp is : mail.mowjelectric.com!

private void SendMail(string from, string body)
    {
        string mailservername = "mail.mowjelectric.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();      
    }

Can u take a look in my code? Thanks!

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

Abhishek Sur16-Aug-09 6:26