bind_ddl.cs

Help Desk Pro has three different interfaces for all three domains of users, providing them with the

using System;
using System.Data;
using System.Data.SqlClient ;

namespace Final_Project_Alpha
{
	/// <summary>
	/// Summary description for Bind_ddl.
	/// </summary>
	public class Bind_ddl
	{
		
		connect objconn = new connect();
		public Bind_ddl()
		{
			//
			// TODO: Add constructor logic here
			//
		}



		public DataSet Bind_all(string str)
		{
			DataSet ds;
			SqlDataAdapter da;
				
			try
			{
				ds = new DataSet();
				da = new SqlDataAdapter(str, objconn.conn());
				da.Fill(ds);
				return ds;
				
			}
			catch (Exception ex)
			{
				Console.Write(ex.Message);
				ds= null;
				return ds;
			}

		}
		
		
		public DataSet Bind_userAcc(string str)
		{
			DataSet ds2;
			SqlDataAdapter da2;
				
			try
			{
				ds2 = new DataSet();
				da2 = new SqlDataAdapter(str, objconn.conn2());
				da2.Fill(ds2);
				return ds2;
				
			}
			catch (Exception ex)
			{
				Console.Write(ex.Message);
				ds2= null;
				return ds2;
			}

		}
	}
}