public static void GenerateDdlFirmasVeids(System.Web.UI.WebControls.DropDownList ddlControl, int intSelectedValue, string strLogin, string strPassword)
		{	
			SqlConnection sqlCnn = new SqlConnection();
			sqlCnn.ConnectionString = clsConnect.sqlConnectionString(strLogin, strPassword);

			SqlCommand sqlCmd = new SqlCommand("SELECT cuv_id, kods " + 
				"FROM cuv", sqlCnn);

			if (sqlCnn.State == ConnectionState.Open)
				sqlCnn.Close();

			sqlCnn.Open();
			try
			{
				SqlDataReader dr = null;

				ddlControl.Items.Clear();
				ListItem liControl = new ListItem();

				dr = sqlCmd.ExecuteReader();
				while (dr.Read())
				{
					liControl = new ListItem();
					liControl.Value = dr[ 0 ].ToString();
					liControl.Text = dr[ 1 ].ToString();
					if (Convert.ToInt32(dr[ 0 ]) == intSelectedValue)
					{
						liControl.Selected = true;
					}
					ddlControl.Items.Add(liControl);
				}
			}
			catch (Exception exc)
			{
				string a = exc.Message;
			}
			finally
			{
				sqlCnn.Close();
			}
		}