You are here:

C#/Database Connectivity

Advertisement

Expert: Hosnieh [Sara] - 2/20/2010


Question
would you please send me the code of database connectivity with SQL server to my email.

or give me the way to done it

Answer
Hello,
I don't have your email address but this can be a sample

 private SqlConnection sqlcon;
     public int  SelectFromDB()
       {

           string SqlCommandText = "select * from tablename";

             sqlcon = new SqlConnection("server=.\sqlexpress;initial catalog=DBname;User ID=usernameForThatDB;password=PasswordfortahtDB");//.\sqlexpress; your instance sqlname
           SqlCommand cmd = new SqlCommand(SqlCommandText, sqlcon);

           try
           {
               sqlcon.Open();
               int a=Convert.ToInt32(cmd.ExecuteScalar());
               sqlcon.Close();
               return a;

           }
           catch (Exception ex)
           {
              
               return -2;
           }
           finally
           {
               cmd.Dispose();
               sqlcon.Close();
               if (sqlcon != null)
                   sqlcon.Dispose();
           }
       }  

C#

All Answers

Answers by Expert:

Ask Experts

Volunteer

Hosnieh [Sara]

Expertise

Questions which I can answers: 1- Programming (C#.net, Vb.net, javascript, HTML) more Web applications 2- CSS 3-Databases (Ms SQL server -all versions) 4-OS (workstation and servers (windows)) 5- MS office 6- General problems in computer software I cannot answer other kinds of questions which I did not mention here.

Experience

my CV: http://iran-americamarket.com/Contact.aspx I have more than 8 years Experience in IT field. my core skills are : • Asp.net Developer (Portal, Dynamic websites ,e-commercial websites) • Visual studio.net 2003,2005,2008 (VB.net , C#.net , AJAX.net) • O.O programming (n-tier Architecture) • Database (SQL server 2000-2005, Oracle9i, Ms Access) , TSQL, Stored procedures, Triggers • IIS 5-6 , SSL (Installation and configuration SSL) , Network(TCP/IP ,Active directory , DHCP, … ), Windows 2000-2003 Server Configuration and administration • UML (usecase diagram, class diagram) , Microsoft Project • Graphics Design( Photoshop , Flash ) • JavaScript , CSS, DHTML, XML • Hardware (physical installation, configuration , and driver installation) • Ms Office all versions (Ms word, Ms Access, Ms Excel, Ms Outlook , Ms FrontPage, and etc) • OS (Windows –Linux) and VMware • Network Monitoring (Solarwinds) • Computer Teacher, English Teacher • MATLAB (simulations and computation projects)

Organizations
-

Publications
Translation Experience English to Farsi • Use brain scan to predict when people will buy products . May 2008 (Published in AI Magazine) – Medicine , AI • Totally tubular motors _Tomorrow automation technology : March 2008 (Published in AI Magazine) – AI , Mechanic, Industry • Improving PLC compatibility and function flexibility: March 2008 (Published in AI Magazine) – AI , Robotics , Industry • Make packaging lines more flexible: January 2008 (Published in AI Magazine) – AI , Robotics , Industry • Personal CNC : December 2007 (Published in AI Magazine) – AI , Medical , Industry • Multipurpose optical tools Characterize as MEMS: December 2007 (Published in AI Magazine)- optical physics • Managing Innovation: November 2007 (Published in AI Magazine) – IT Management • Calculating the total value of ownership (TVO):October 2007 (Published in San-ate Hooshmand Magazine) -IT and Economics

Education/Credentials
I am currently student and doing my Master in Computer Network Engineering

Awards and Honors
- Poster about new methods of management in Organization( Entrepreneurship ) - 2007

Past/Present Clients
-

©2012 About.com, a part of The New York Times Company. All rights reserved.