Home Discussion Discuss: About RoseIndia.net

  • vprOYZdTzbGloriane July 3, 2011 at 9:07 AM

    Now thatÂ?s stulbe! Great to hear from you.

  • doubt in asp.netsudhir June 14, 2012 at 9:26 PM

    using System; using System.Data; using System.Data.SqlClient; using System.Configuration; // here we are providing bussiness logic for the current application public class BussinessLogicLayer { SqlConnection cn; SqlCommand cmd; SqlDataReader dr; public BussinessLogicLayer() { string cs; cs = ConfigurationManager.ConnectionStrings["SSDCS"].ConnectionString; cn = new SqlConnection(cs); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.Text; } public SqlDataReader GetAllUsers() { cmd.CommandText = "select * from SSDUsers"; if (cn.State == ConnectionState.Closed) cn.Open(); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //closing connection reader return dr; } public bool IsUserExists(string uname) { cmd.CommandText = string.Format("select count (*) from SSDUsers where Username={0}", uname); //For checking the table is present or not if (cn.State == ConnectionState.Closed) cn.Open(); //for opening the connection int count = int.Parse(cmd.ExecuteScalar().ToString()); //execute scalar method return objects that's why we are using parsing cn.Close(); if (count > 0) return true; else return false; } public bool validateuser(string uname, string pwd) { cmd.CommandText = string.Format("select count(*) from SSDUsers where Username{0},Password={1}", uname, pwd); if (cn.State == ConnectionState.Closed) cn.Open(); int count = int.Parse(cmd.ExecuteScalar().ToString()); cn.Close(); if (count > 0) return true; else return false; } public bool AddUser(string uname, string pwd) { cmd.CommandText = string.Format("insert into SSDUsers values Username={0},Password={1}", uname, pwd); //String.Formt Replaces each format item in a specified string with the text equivalent of a corresponding object's value. if (cn.State == ConnectionState.Closed) cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } public bool ChangePassword(string uname, string opwd, string npwd) { if (validateuser(uname, opwd) == true) cmd.CommandText = string.Format("Update SSDUsers set Password={0} where Username={1}", npwd, uname); if (cn.State == ConnectionState.Closed) { cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } else { return false; } } public bool RemoveUser(string uname) { if (IsUserExists(uname) == true) { cmd.CommandText = string.Format("delete from SSDUsers where UserName={0}", uname); if (cn.State == ConnectionState.Closed) { cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } else { return false; } } } }

  • iphone trainingmanish jaiswal September 25, 2012 at 8:45 PM

    are u provide any training for iphone technology?? if yes then tell me all about this like new batch, timing, fee structure??

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
General

Advertising On RoseIndia.net
Advertising On RoseIndia.net This website is providing tutorials.... Thank you for your interest in advertising on Roseindia.net Site. The RoseIndia.net web site was first published in year 2000. It was started with java 

Programming Tutorials

About RoseIndia.net
About RoseIndia.Net RoseIndia.Net  is global services company that understands businesses and aims to deliver value... At RoseIndia.Net with Technical proficiency and expertise, we cohesively 

Software Services

RoseIndia.net Privacy Policy
RoseIndia.net Privacy Policy The following statements describes the privacy practices for RoseIndia.net: * We do not collect any personal information from... to provide advertisements about goods and services likely to be of greater 

Training

Why roseindia.net
Why roseindia.net       Roseindia.net is the only organization that provides the free online training to the beginners as well as the experienced professionals. Generally other 

Submit-Tutorials

Submit Tutorials - Submitting Tutorials at RoseIndia.net
; Submitting Tutorials at RoseIndia.net is very easy. We welcome all members... on RoseIndia.net, you are always welcome to display your tutorial on our site. Your tutorial... tutorials on RoseIndia.net (if your tutorial is good). Tutorials Submission 

General

Web Site promotion services at roseindia.net
Welcome to RoseIndia.net Web Promotion Company Our Web site services will help you get listed in major search engines and directory of the world. Our own site traffic comes from the major search 

Training

Current Running Projects on roseindia.net
Current Running Projects on roseindia.net       Project Title College Alumini Registration and Display System Patient Registration and appointment booking system SS7 real message 

PHP Questions

How can we extract string 'roseindia.net ' from a string http://deepak@roseindia. net using regular expression of php?
How can we extract string 'roseindia.net ' from a string http://deepak@roseindia. net using regular expression of php?   How can we extract string 'roseindia.net ' from a string http://deepak@roseindia. net using regular 

General

Roseindia.net Place to Get Cheap Linux cds in India!!
 

General

RoseIndia.net Is Your On-Line Linux & xBSD CD Distribution Source
 

General

RoseIndia.net Is Your On-Line Linux & xBSD CD Distribution Source
 

Struts-Tutorials

Struts Resources
Struts Resources    RoseIndia.Net.... There are many resources to gain knowledge or discuss about the struts framework. You can... forum etc.  At RoseIndia.net Struts Resource page you will find 

Jobs

Jobs at Rose India
Jobs at Rose India       Roseindia.net is one of the well-known Internet based solution providers in India. With a sole aim to meet all the technical assistance of the growing 

Jobs

Jobs at Rose India
Jobs at Rose India       Roseindia.net is one of the well-known Internet based solution providers in India. With a sole aim to meet all the technical assistance of the growing 

Software Services

Web Designing
that roseindia.net provides with global quality in minimal charges. For running.... RoseIndia.net fulfills all the above conditions with efficiency. It provides... Designing and Web Designing. RoseIndia.net is expert in designing user-friendly 

Blog

JSF Architecture
also uses the MVC pattern. ?JSF Architecture? article in roseindia.net explains the architecture of a JSF application. Read about the topic at JSF 

Hosting Tutorial

Web Hosting Glossary
Web Hosting RoseIndia.net's web hosting resource is top web hosting resource on the net. RoseIndia.net web hosting resource offers hundreds of excellent...; In this directory you will find details about web hosting, dedicated hosting servers 

Hosting Tutorial

Web Hosting
 

General

Java Help Center
Java Help Center       Welcome to Java help Center service of RoseIndia.net, a renowned Java tutorial website that provides you the latest and up 

Programming Tutorials

Designing your web sites
 

Java-Tutorials

Java util package Examples
 

Spring Framework

Roseindia Spring Tutorial
easily. At roseindia.net you will find plenty of spring tutorials for beginners as well as for developers, who are willing to learn more about spring framework.... Spring tutorials at roseindia.net are framed by a group of highly experienced 

Hibernate-Tutorials

Hibernate Video Tutorial
Roseindia.net provides you the best Hibernate video tutorials embedded with simple examples that make them very easy for the learners to understand and learn the basics of hibernate as well as advance hibernate. Hibernate, which 

General

Free JSP, Free EJB and Free Servlets Hosting Servers
Free JSP, Free EJB and Free Servlets Hosting Servers   Web roseindia.net    Other Free Hosting Services  

JSTL

JSTL Tutorials and Online Training
 

Jobs

Jobs at Rose India
 

Ajax Examples

Developing responsive Ajax based Applications with ajax technologies
; Web Ajax Frameworks Read about Ajax Web Frameworks.   

General

Roseindia Tutorials
Roseindia.net website Tutorials brings you the best tutorials for different... by visiting http://roseindia.net/ to get instant solution to your queries with the help...://roseindia.net/, where you can find large number of tutorials Java Tutorials 

Servlets

Servlet Tutorials
tutorials at Roseindia.net cover comprehensive topics of servlet, which.... Roseindia.net servlet tutorials are made by group of highly experienced java... APIs. For more about Java Servlets related articles please read the follwing 

Web Hosting Tutorial

Complete Webhosting Guide, Search Web hosts, Find Plans
; Types of Hosting Services In this article we will learn about 

DMCA.com