ASP.NET

isql="Insert Into students(id,first_name,last_name,major) values (@fname,@id,@lname,@major)"	idbcomm=new odbccommand(isql,dbconn)	idbcomm.Parameters.Add( "@fname",fname.text)    idbcomm.Parameters.Add( "@id",id.Text)    idbcomm.Parameters.Add( "@lname",lname.Text)    idbcomm.Parameters.Add( "@major",major.Text)	idbcomm.ExecuteNonQuery()

isql="Insert Into students(id,first_name,last_name,major) values (@fname,@id,@lname,@major)"
idbcomm=new odbccommand(isql,dbconn)	
idbcomm.Parameters.Add( "@fname",fname.text)    
idbcomm.Parameters.Add( "@id",id.Text)    
idbcomm.Parameters.Add( "@lname",lname.Text)    
idbcomm.Parameters.Add( "@major",major.Text)	
idbcomm.ExecuteNonQuery()

paresh_sarjani wrote:

m nt getting error

bt records r nt inserted in table

SmtpException<br />
Failure sending mail.

System.Net.Mail.SmtpClient email = new System.Net.Mail.SmtpClient();
email.Host = "smtp.gmail.com";
email.Port = 465 ;
............
............

Parwej Ahamad wrote:

which one you are using ?

Parwej Ahamad wrote:

Are you logged on any IM ?

protected void Page_Load(object sender, EventArgs e)
    {
        string server;
        server = "localhost";
            // Specify the file to be attached and sent.
            // This example assumes that a file named Data.xls exists in the
            // current working directory.
            string file = "data.xls";
            file = Server.MapPath("~/data.xls");
            // Create a message and set up the recipients.
            MailMessage message = new MailMessage(
               "apurvkolte@live.com",
               "apurvkolte@gmail.com",
               "Quarterly data report.",
               "See the attached spreadsheet.");

            // Create  the file attachment for this e-mail message.
            Attachment data = new Attachment(file, MediaTypeNames.Application.Octet);
            // Add time stamp information for the file.
            ContentDisposition disposition = data.ContentDisposition;
            disposition.CreationDate = System.IO.File.GetCreationTime(file);
            disposition.ModificationDate = System.IO.File.GetLastWriteTime(file);
            disposition.ReadDate = System.IO.File.GetLastAccessTime(file);
            // Add the file attachment to this e-mail message.
            message.Attachments.Add(data);
            //Send the message.
            SmtpClient client = new SmtpClient();
            client.Host = "smtp.gmail.com";
            client.Port = 465;
            // Add credentials if the SMTP server requires them.
            client.Credentials = CredentialCache.DefaultNetworkCredentials;
            client.Send(message);
            // Display the values in the ContentDisposition for the attachment.
            ContentDisposition cd = data.ContentDisposition;
            Console.WriteLine("Content disposition");
            Console.WriteLine(cd.ToString());
            Console.WriteLine("File {0}", cd.FileName);
            Console.WriteLine("Size {0}", cd.Size);
            Console.WriteLine("Creation {0}", cd.CreationDate);
            Console.WriteLine("Modification {0}", cd.ModificationDate);
            Console.WriteLine("Read {0}", cd.ReadDate);
            Console.WriteLine("Inline {0}", cd.Inline);
            Console.WriteLine("Parameters: {0}", cd.Parameters.Count);
            foreach (DictionaryEntry d in cd.Parameters)
            {
                Console.WriteLine("{0} = {1}", d.Key, d.Value);
            }
            data.Dispose();
       

    }